Question
You and your friend are analyzing a potential duplex (i.e. two attached dwelling units) rental investment. After completing your research, you arrive at the following
You and your friend are analyzing a potential duplex (i.e. two attached dwelling units) rental investment. After completing your research, you arrive at the following cash flow forecast:
What is the Internal Rate of Return on this investment? Show the exact Excel formula you would use in the specific spreadsheet shown above (noting the columns and rows as labeled) to calculate the IRR.
Your friend reports that they came across an alternative condominium with a 30% Internal Rate of Return over the same three-year investment period (much higher than the one you found above). You both agree you only have enough time and energy to take on one of the projects.
Based on the information provided, can you determine which project will be the better investment? If so, which one? If not, why not?
Step by Step Solution
3.48 Rating (151 Votes )
There are 3 Steps involved in it
Step: 1
The internal rate of return IRR metric estimates the annualized rate of return that an investment is going to yield Unlike the MoM the IRR is considered to be timeweighted because it accounts for the ...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