Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please insert answer in the highlighted area. Please also include the cell formula in the explanation for better understanding. TranscribedText: Start 1 IN 5 6

Please insert answer in the highlighted area. Please also include the cell formula in the explanation for better understanding.

image
TranscribedText: Start 1 IN 5 6 7 8 TV Key Assumptions Construction cost ($) 1,300,000 Loan ($) 450,000 Loan interest rate 7.0% Loan term (yrs.) 8 Hangar space (sq.ft.) 22.000 Rent ($/sq.ft. per month) 1.45 Rent inflator 2.2% Operating Costs ($/yr.) 124,000 Cost inflator 2.2% Tax rate 21.0% Discount rate 8.0% Depreciation year ($) 34.000 Cash Flows Rent Income 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

Key Assumptions Construction cost ($) 1,300,000 Loan ($) 450,000 Loan interest rate 7.0% Loan term (yrs.) Hangar space (sq.ft.) 22,000 Rent ($/sq.ft. per month) 1.45 Rent inflator 2.2% Operating Costs ($/yr.) 124,000 Cost inflator 2.2% Tax rate 21.0% Discount rate 8.0% Depreciation/year ($) 34,000 Start 1 2 3 4 5 6 7 8 TV Cash Flows Rent Income 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial management theory and practice

Authors: Eugene F. Brigham and Michael C. Ehrhardt

12th Edition

978-0030243998, 30243998, 324422695, 978-0324422696

More Books

Students also viewed these Finance questions