|
XI. SAMPLE BUT-FOR ANALYSIS
<br />
<br /> Mortgage
<br /> Equity
<br />Tax Rebate Financing
<br />TOTAL SOURCES
<br />
<br /> Land
<br /> Site Work
<br /> Soil Correction
<br /> Demolition
<br /> Relocation
<br />Subtotal Land Costs
<br />
<br /> Construction
<br /> Finish Manufacturing
<br />Subtotal Construction Costs
<br />
<br /> Soft Costs
<br /> Taxes
<br />Finance Fees
<br />Project Manager
<br />Developer Fee
<br />Contingency
<br />Subtotal Soft Costs
<br />
<br />TOTAL USES
<br />
<br />Rent-Space 1
<br />Rent-Space 2
<br />Rent-Space 3
<br /> Other
<br />
<br />Mortgage
<br />
<br /> Net Income
<br />Total Return on Equity
<br />
<br /> WITH NO
<br />TAX REBATE FINANCING
<br />
<br /> WITH
<br />TAX REBATE FINANCING
<br />
<br />SOURCES AND USES SOURCES AND USES
<br />
<br /> SOURCES SOURCES
<br /> 9,600,000 8,667,000
<br /> 2,400,000 2,400,00
<br /> 0 933,000
<br /> 12,000,000 12,000,000
<br />
<br /> USES USES
<br />
<br />1,500,000
<br />300,000
<br />468,000
<br />100,000
<br />65,000
<br />2,433,000
<br />
<br />6,750,000
<br /> 250,000
<br />7,000,000
<br />
<br />350,000
<br />35,000
<br />850,000
<br />542,000
<br />540,000
<br />250,000
<br />2,567,000
<br />
<br />1,500,000
<br />300,000
<br />468,000
<br />100,000
<br />65,000
<br />2,433,000
<br />
<br />6,750,0OO
<br /> 250,000
<br />7,000,000
<br />
<br />350,000
<br />35,000
<br />850,000
<br />542,000
<br />540,000
<br />250,000
<br />2,567,000
<br />
<br /> 12,000,000 12,000,000
<br />Income Statement Income Statement
<br />
<br />Sq. Ft. PerSq. Ft.
<br />100,000 $8.00 800,000
<br />25,000 $8.50 212,500
<br />25,000 $9.00 225,000
<br />o $o.oo o
<br /> 1,237,500
<br />
<br /> 20 Term
<br />9.00% Interest
<br />9,600,000 Principal
<br />
<br />1,051,646
<br />
<br />Sq. Ft. Per Sq. Ft.
<br />100,000 $8.00 800,000
<br />25,000 $8.50 212,500
<br />25,000 $9.00 225,000
<br />o $o.oo o
<br /> 1,237,500
<br />
<br /> 20 Term
<br />9.00% Interest
<br />8,667,000 Principal
<br />
<br />949,439
<br />
<br />185,854 288,061
<br />7.74% 12.00%
<br />
<br />15
<br />
<br />
<br />
|