Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Project Pro Forma (NHC template)
PROJECT SUMMARY Development: Owner: Location: County: Total Units: Units by Bedroom Size Efficiency 1 Bedroom 2 Bedroom 3 Bedroom 4 Bedroom 5+ Bedroom Total Operating Budget Gross Rent Potential Other Income Vacancy Adjusted Gross Income Operating Expenses Net Operating Income Debt Service Debt & Cash Flow Over Time Year 1 Operating Margin Year 5 Operating Margin Year 10 Operating Margin Year 15 Operating Maring Development Costs Predevelopment & Feasibility Building & Property Acquisition Construction Costs Professional Services Carrying & Construction Financing Costs Permanent Financing & Syndication Reserves Construction & Bridge Loan Interest Developer Fee Total Development Costs Sources Total Sources Surplus/(Gap) Pierson Pointe Townhome Wilmington Realtors Foundation New Hanover County 1 0 0 1 0 0 0 1 Annual 0 0 56831 -56831 -1 -1 -1 -1 Units by Income Target 0.3 0.4 0.5 0.6 0.8 1.2 Total Per Unit 0 0 56831 -56831 Year 1 Net Cash Flow Year 5 Net Cash Flow Year 10 Net Cash Flow Year 15 Net Cash Flow Total 102500 535000 8680900 26000 0 0 0 0 1681992 11026392 Total 0 0 0 0 0 0 0 0 0 -11026392 0 0 0 0 1 0 1 Long-Term Trending Assumptions Combined Vacancy Rate: Rent Inflation: Expense Inflation: Administration Maintenance Operating Escrows & Reserves Per Unit 102500 535000 8680900 26000 0 0 0 0 1681992 11026392 Per Unit 0 0 0 0 0 0 0 0 0 -11026392 % of TDC 9.29587847049153E-03 4.85199510411021E-02 0.78728381867795 2.35797892910029E-03 0 0 0 0 0.152542372881356 1 % of TDC 0 0 0 0 0 0 0 0 0 -1 Units by Structure Type Single Family Duplex Triplex Fourplex Townhome Apartment Condo Other Total -56831 -65214.8796 -77454.8195 -91992.0284 True 0 0 0 0 1 0 0 0 1 0.12 0.02 0.035 0.035 0.035 0.035 -56831 -65214.8796 -77454.8195 -91992.0284 Units 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 Units 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 REVENUE PROJECTIONS Address 6221-6229 Carolina Beach Rd Total Units Other Income Miscellaneous & Interest Laundry Carports Tenant Charges (late fees, nonsufficient funds, etc) Other Totals Unit 1 1 Structure Type Townhome Bedrooms 2 Baths 2 Total Sq Footage Monthly 0 Sq Ft 1500 1500 Annually 0 0 0 0 0 0 Income Target 0.8 Utility Allowance 0 Monthly Rent Potential Annual Rent Potential Proposed Contract Rent 0 0 0 0 Gross Rent 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Max Rent Allowed 0 Rent Acceptable? Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 ANNUAL OPERATING BUDGET REVENUE Gross Rent Potential Other Revenue Subtotal Combined Vacancy Factor Adjusted Income TOTAL OPERATING EXPENSES Administrative Costs Advertising Management Legal/Partnership Accounting/Audit Compliance Monitoring Other Subtotal Maintenance Preventative Maintenance Unit Turns Exterminating Grounds Other Subtotal Operating Elevator Project Paid Fuel Common Electricity Water/Sewer Gas Trash Removal Payroll Payroll Taxes & Fringes Other Subtotal Escrows & Reserves Insurance Real Estate Taxes Other Taxes Replacement Reserve Other: Subtotal Total Operating Expenses Net Operating Income MORTGAGE Debt Coverage Ratio Max Mortgage Pmt Amortization (years) Interest Rate Projected Mortgage ACTUAL Mortgage Override Mortgage Payment Cash Flow Operating Margin 0.12 Annual 0 0 0 0 0 Annual Total Annual 0 0 0 0 0 0 0 Annual 0 0 0 0 0 0 Annual 0 0 0 0 0 0 55000 0 0 55000 Annual 1831 0 0 0 0 1831 56831 -56831 1.5 -37887.3333 20 0.075 -391919.6194 0 0 Annual -56831 -1 Per Unit 0 0 0 0 0 Per Unit Total Per Unit 0 0 0 0 0 0 0 Per Unit 0 0 0 0 0 0 Per Unit 0 0 0 0 0 0 55000 0 0 55000 Per Unit 1831 0 0 0 0 1831 56831 -56831 -37887.3333 -391919.6194 0 Per Unit -56831 % of Revenue Override 55000 1831 Unit Address Unit # Structure Type Bedrooms Itemized Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 6221-6229 Carolina Beach Rd 1 Townhome 2 Salary for Campaign Director Foundation Insurance 2 0 0 0 0 3 0 0 0 0 4 0 0 0 0 5 0 0 0 0 6 0 0 0 0 7 0 0 0 0 8 0 0 0 0 9 0 0 0 0 10 0 0 0 0 11 0 0 0 0 12 0 0 0 0 13 0 0 0 0 14 0 0 0 0 15 0 0 0 0 16 0 0 0 0 17 0 0 0 0 18 0 0 0 0 19 0 0 0 0 20 0 0 0 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Operating Cash Flow Projection REVENUE Gross Income Potential Vacancy Factor Net Income Per Unit OPERATING EXPENSES Administration Maintenance Operating Escrows & Reserves Total Operating Expenses Per Unit Net Operating Income Per Unit Debt Service Debt Coverage Ratio Operating Margin CASH FLOW Per Unit Operating Deficit Reserve Analysis Starting Balance Annual Operating Deficit Interest Earned on Reserve Ending Balance 0.12 Inflator 0.02 Inflator 0.035 0.035 0.035 0.035 0 Year 1 0 0 0 0 0 0 55000 1831 56831 56831 -56831 -56831 0 n/a -1 -56831 -56831 1607162.5971 -56831 0 1550331.5971 Year 2 0 0 0 0 0 0 56925 1895.085 58820.085 58820.085 -58820.085 -58820.085 0 n/a -1 -58820.085 -58820.085 1550331.5971 -58820.085 0 1491511.5121 Year 3 0 0 0 0 0 0 58917.375 1961.413 60878.788 60878.788 -60878.788 -60878.788 0 n/a -1 -60878.788 -60878.788 1491511.5121 -60878.788 0 1430632.7242 Year 4 0 0 0 0 0 0 60979.4831 2030.0624 63009.5456 63009.5456 -63009.5456 -63009.5456 0 n/a -1 -63009.5456 -63009.5456 1430632.7242 -63009.5456 0 1367623.1786 Year 5 0 0 0 0 0 0 63113.765 2101.1146 65214.8796 65214.8796 -65214.8796 -65214.8796 0 n/a -1 -65214.8796 -65214.8796 1367623.1786 -65214.8796 0 1302408.299 Year 6 0 0 0 0 0 0 65322.7468 2174.6536 67497.4004 67497.4004 -67497.4004 -67497.4004 0 n/a -1 -67497.4004 -67497.4004 1302408.299 -67497.4004 0 1234910.8985 Year 7 0 0 0 0 0 0 67609.0429 2250.7665 69859.8095 69859.8095 -69859.8095 -69859.8095 0 n/a -1 -69859.8095 -69859.8095 1234910.8985 -69859.8095 0 1165051.0891 Year 8 0 0 0 0 0 0 69975.3595 2329.5433 72304.9028 72304.9028 -72304.9028 -72304.9028 0 n/a -1 -72304.9028 -72304.9028 1165051.0891 -72304.9028 0 1092746.1863 Year 9 0 0 0 0 0 0 72424.497 2411.0773 74835.5744 74835.5744 -74835.5744 -74835.5744 0 n/a -1 -74835.5744 -74835.5744 1092746.1863 -74835.5744 0 1017910.6119 Year 10 0 0 0 0 0 0 74959.3544 2495.4651 77454.8195 77454.8195 -77454.8195 -77454.8195 0 n/a -1 -77454.8195 -77454.8195 1017910.6119 -77454.8195 0 940455.7924 Year 11 0 0 0 0 0 0 77582.9318 2582.8063 80165.7382 80165.7382 -80165.7382 -80165.7382 0 n/a -1 -80165.7382 -80165.7382 940455.7924 -80165.7382 0 860290.0543 Year 12 0 0 0 0 0 0 80298.3344 2673.2046 82971.539 82971.539 -82971.539 -82971.539 0 n/a -1 -82971.539 -82971.539 860290.0543 -82971.539 0 777318.5153 Year 13 0 0 0 0 0 0 83108.7762 2766.7667 85875.5429 85875.5429 -85875.5429 -85875.5429 0 n/a -1 -85875.5429 -85875.5429 777318.5153 -85875.5429 0 691442.9724 Year 14 0 0 0 0 0 0 86017.5833 2863.6035 88881.1869 88881.1869 -88881.1869 -88881.1869 0 n/a -1 -88881.1869 -88881.1869 691442.9724 -88881.1869 0 602561.7855 Year 15 0 0 0 0 0 0 89028.1987 2963.8297 91992.0284 91992.0284 -91992.0284 -91992.0284 0 n/a -1 -91992.0284 -91992.0284 602561.7855 -91992.0284 0 510569.7571 Year 16 0 0 0 0 0 0 92144.1857 3067.5637 95211.7494 95211.7494 -95211.7494 -95211.7494 0 n/a -1 -95211.7494 -95211.7494 510569.7571 -95211.7494 0 415358.0077 Year 17 0 0 0 0 0 0 95369.2322 3174.9284 98544.1606 98544.1606 -98544.1606 -98544.1606 0 n/a -1 -98544.1606 -98544.1606 415358.0077 -98544.1606 0 316813.8471 Year 18 0 0 0 0 0 0 98707.1553 3286.0509 101993.2063 101993.2063 -101993.2063 -101993.2063 0 n/a -1 -101993.2063 -101993.2063 316813.8471 -101993.2063 0 214820.6408 Year 19 0 0 0 0 0 0 102161.9058 3401.0627 105562.9685 105562.9685 -105562.9685 -105562.9685 0 n/a -1 -105562.9685 -105562.9685 214820.6408 -105562.9685 0 109257.6724 Year 20 0 0 0 0 0 0 105737.5725 3520.0999 109257.6724 109257.6724 -109257.6724 -109257.6724 0 n/a -1 -109257.6724 -109257.6724 109257.6724 -109257.6724 0 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 DEVELOPMENT BUDGET Predevelopment & Feasibility Appraiser Architect & Engineer Environmental Reviews & Reports (Phase I, Phase II, etc) Market Analysis Preliminary Title Search Survey Consultant Application Fees Other: Building & Property Acquisition Land Closing Costs @ Acquisition Misc Construction Costs Base Construction Costs Permits, Impact/Tap Fees Landscaping Appliance Package Other: Contractor General Conditions (calc on Base) Contractor Overhead Contractor Profit CONSTRUCTION CONTINGENCY Professional Services Legal Title & Recording Cost Certification Marketing /Advertising Carrying & Construction Financing Costs Inspection & Draw Fees Points & Bank Fees Builder's Risk Insurance Property Insurance Real Estate Taxes Interim/Capitalized Operating Costs Permanent Financing & Syndication Points & Bank Fees Title & Recording Partnership & Organization Expense Legal (including tax opinion) Other Reserves Rent Up Reserves Operating Reserves Deficit Reserve (as calculated by 20 Year Projection) Replacement Reserves Other Construction & Bridge Loan Interest Developer Fee TOTAL DEVELOPMENT COSTS (TDC): 5787.2667 0.18 per sq. ft. /Hard & Soft Costs 0 0 0 0.1 Subtotal Hard & Soft Costs Total Predevelopment: Total Acquisition: / hard cost / hard cost / hard cost / hard cost Total Construction: Total Professional Fees: Total Carrying Costs: Total Permanent Financing & Syndication: Total Reserves: 9344400 Project Totals 0 80000 2500 0 0 20000 0 0 0 102500 535000 0 0 535000 8678400 2500 0 0 0 0 0 0 0 8680900 4000 0 0 26000 26000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1681992 11026392 Per Unit 0 80000 2500 0 0 20000 0 0 0 102500 535000 0 0 535000 8678400 2500 0 0 0 0 0 0 0 8680900 4000 0 0 26000 26000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1681992 11026392 Override 80000 2500 20000 535000 8678400 2500 4000 26000 Unit Addresss Unit # Structure Type Bedrooms Itemized Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 6221-6229 Carolina Beach Rd 1 Townhome 2 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0 0 5 0 0 0 0 0 0 0 0 0 6 0 0 0 0 0 0 0 0 0 7 0 0 0 0 0 0 0 0 0 8 0 0 0 0 0 0 0 0 0 9 0 0 0 0 0 0 0 0 0 10 0 0 0 0 0 0 0 0 0 11 0 0 0 0 0 0 0 0 0 12 0 0 0 0 0 0 0 0 13 0 0 0 0 0 0 0 0 14 0 0 0 0 0 0 0 0 15 0 0 0 0 0 0 0 0 16 0 0 0 0 0 0 0 0 17 0 0 0 0 0 0 0 0 18 0 0 0 0 0 0 0 0 19 0 0 0 0 0 0 0 0 20 0 0 0 0 0 0 0 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 PROJECT DEVELOPMENT CASH FLOW USES OF FUNDS Predevelopment & Feasibility Acquisition Construction Professional Services Carrying & Construction Financing Permanent Financing & Syndication Reserves Developer Fee SUB-TOTAL USES SOURCES OF FUNDS Prior Month Ending Cash SUB-TOTAL SOURCES Construction Loan Construction Loan Calculation Construction Loan Draw TOTAL SOURCES Paydown Calculation Construction Loan Paydown TOTAL USES Ending Cash CONSTRUCTION LOAN INT & BALANCES Draw (Loan Payoff) Construction Loan Interest Loan Balance Total Budget 102500 535000 8680900 26000 0 0 0 1681992 11026392 0 0 0 0 0 0 0 0 0 0 0.07 0 Month 1 0 0 0 0 0 0 0 0 0 0 Month 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Month 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Month 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Month 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Month 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Month 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Month 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Month 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Month 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Month 11 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Month 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Month 13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Month 14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Month 15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Month 16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Month 17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Month 18 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Month 19 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Month 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Month 21 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Month 22 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Month 23 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Month 24 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total 0 Trial Balance Under Under Under Under Balanced Balanced Balanced Under Balanced Balanced Balanced Balanced Balanced Balanced Balanced Balanced Variance 102500 535000 8680900 26000 0 0 0 1681992 0 0 0 0 0 0 0 0