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?

Answer rating: 100% (QA)

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 ... View the full answer