Start $1.00 23456 89 10 TV Key Assumptions Construction cost ($) Loan ($) 1,000,000 500,000 Loan interest rate Loan term (yrs.) Hangar space (sq.ft.) Rent ($/sq.ft. per month) 4.8% 22,000 1.30 Rent...


Start<br>$1.00<br>23456<br>89 10 TV<br>Key Assumptions<br>Construction cost ($)<br>Loan ($)<br>1,000,000<br>500,000<br>Loan interest rate<br>Loan term (yrs.)<br>Hangar space (sq.ft.)<br>Rent ($/sq.ft. per month)<br>4.8%<br>22,000<br>1.30<br>Rent inflator<br>2.0%<br>Operating Costs ($/yr.)<br>140.000<br>Cost inflator<br>2.0%<br>Tax rate<br>21.0%<br>Discount rate<br>6.5%<br>Depreciation/year ($)<br>20,000<br>Cash Flows<br>Rent Income<br>Rent Income = Square Footage x S1/sq.ft x 12 months<br>minus: Operating Costs<br>minus: Interest<br>minus: Depreciation<br>= Taxable Income<br>minus: Taxes<br>= Net Income<br>minus: Principal<br>= Net Operating Cash Flow<br>minus: Cash Outlay at Start<br>plus: Depreciation<br>Total Cash Flows<br>NPV<br>IRR<br>Note: Tax shields are the tax gains from expensing interest and depreciation. The formula is interest or depreciation expense times the tax rate<br>

Extracted text: Start $1.00 23456 89 10 TV Key Assumptions Construction cost ($) Loan ($) 1,000,000 500,000 Loan interest rate Loan term (yrs.) Hangar space (sq.ft.) Rent ($/sq.ft. per month) 4.8% 22,000 1.30 Rent inflator 2.0% Operating Costs ($/yr.) 140.000 Cost inflator 2.0% Tax rate 21.0% Discount rate 6.5% Depreciation/year ($) 20,000 Cash Flows Rent Income Rent Income = Square Footage x S1/sq.ft x 12 months minus: Operating Costs minus: Interest minus: Depreciation = Taxable Income minus: Taxes = Net Income minus: Principal = Net Operating Cash Flow minus: Cash Outlay at Start plus: Depreciation Total Cash Flows NPV IRR Note: Tax shields are the tax gains from expensing interest and depreciation. The formula is interest or depreciation expense times the tax rate

Jun 10, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here