Question
The table below contains the completed investment analysis for a certain property. Using the information in the table, What is the internal rate of return
The table below contains the completed investment analysis for a certain property. Using the information in the table, What is the internal rate of return of the before-tax levered cash flows if the property is sold at the end of the 5th year?.
Purchase Price | $25 million | ||||
Loan Amount | 70% of purchase price | ||||
Interest Rate | 6% per year with monthly payments and compounding | ||||
Amortization | 25 years | ||||
Year | |||||
1 | 2 | 3 | 4 | 5 | |
Net Operating Income | $2,000,000 | $2,100,000 | $2,205,000 | $2,315,250 | $2,431,013 |
Before-Tax Cash Flow | $566,967 | $662,967 | $763,767 | $869,607 | $980,739 |
After-Tax Cash Flow | $425,225 | $497,225 | $572,825 | $652,205 | $735,554 |
Future Selling Price | $32,413,500 | ||||
Net Sale Proceeds | $29,172,150 | ||||
Before-Tax Equity Reversion | $13,434,035 | ||||
After-Tax Equity Reversion | $10,075,526 |
| a. 11.08% |
| b. 20.32% |
| c. 13.28% |
| d. 37.24% |
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