Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please show all Excel formulas. Closeups. 2. Apache's real estate department is considering buying a hangar and leasing it out to private jet operators. They
Please show all Excel formulas. Closeups. 2. Apache's real estate department is considering buying a hangar and leasing it out to private jet operators. They ask you to calculate the NPV and IRR of the investment and have given you the data below. Assume that the hangar is sold in year 25 and that the mortgage runs 25 years. Item Inflator Value 1,910 1,015,000 10% Square Footage Property Price ($) Down Payment Interest Rate Closing Costs at Start Broker Fee in Year 25 Yearly Property Appreciation Rent/ sq. ft/Inflator Op. Costs/ year ($) Inflator Tax Rate Depreciation/ year ($) 3.9% 8.00 5.0% 1.5% 3.00 11,640 21.0% 4,524 1.0% 1.0% E An NH heres the Operatorius com Tool Casheee E An NH heres the Operatorius com Tool Casheee 1 Key Assumptions Square footage Property price Closing costs at Broker fer in your Property Value Mortgage Blanc Operating Assumptions Op. In Cash Flows Rent Income Det hesh plus Desild plus Sale Property is year Total Cube ERR N7889 Note Twilds the tas in front or depreciation. The more 2 - Thes ate . thaale 2. Apache's real estate department is considering buying a hangar and leasing it out to private jet operators. They ask you to calculate the NPV and IRR of the investment and have given you the data below. Assume that the hangar is sold in year 25 and that the mortgage runs 25 years. Item Inflator Value 1,910 1,015,000 10% Square Footage Property Price ($) Down Payment Interest Rate Closing Costs at Start Broker Fee in Year 25 Yearly Property Appreciation Rent/ sq. ft/Inflator Op. Costs/ year ($) Inflator Tax Rate Depreciation/ year ($) 3.9% 8.00 5.0% 1.5% 3.00 11,640 21.0% 4,524 1.0% 1.0% E An NH heres the Operatorius com Tool Casheee E An NH heres the Operatorius com Tool Casheee 1 Key Assumptions Square footage Property price Closing costs at Broker fer in your Property Value Mortgage Blanc Operating Assumptions Op. In Cash Flows Rent Income Det hesh plus Desild plus Sale Property is year Total Cube ERR N7889 Note Twilds the tas in front or depreciation. The more 2 - Thes ate . thaale
Please show all Excel formulas.
Closeups.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started