Note: this is a guest post from Michael Belasco, a co-founder of the real estate financial modeling, careers, and education website: AdventuresinCRE.com.

Numeric example of internal rate of return for a commercial real estate project

A numeric example showing 5 years of cash flow and initial capital contribution, and deriving the internal rate of return (IRR)

The internal rate of return is one of the most commonly used metrics to value real estate investment opportunities. Simply put, the IRR is the target percent an investor is expected to earn over the life of the investment if the investment performs as projected. To explain formulaically, the IRR is the discount rate applied to a cash flow stream so that the cash flow stream discounted back to the present is exactly equal to the money required to invest at the time of investment. An example of how it works is shown below:

In this example, the investor is projected to earn a 15% IRR over the life of the investment.

Although the IRR is a very important metric to use, it does not tell the complete story and should be one of many metrics to use when considering a potential real estate investment.

A numeric example of internal rate of return (IRR) in table form

A table showing two different projects with identical IRR over a 10 year horizon but different overall profitability.

To illustrate the limitations of solely depending on the IRR, examine the difference between the two cash flows below that both have the same initial investment of $4MM, a hold period of 10 years, and an IRR of 12%.

Upon examining the table, it becomes clear that the IRR alone will tell us nothing about actual periodic payments or total profitability. There can be an almost infinite variability in cash flow streams and total profit that will equal a 12% IRR. For example, Cash Flow 1 has very little annual cash payouts relative to the amount invested, but a large payout in Year 10 and Cash Flow 2 has much higher annual payments, but the payout in Year 10 is barely half of the payout for Cash Flow 1. We can also see that IRR says nothing about total profitability as Cash Flow 1 has almost $2.5MM more in total profit.

To further elaborate on the limitations of over depending on the IRR, let’s assume an investor has $5MM to invest into commercial real estate. Our investor would preferably like to receive a decent annual return from the property in addition to realizing a decent profit from the property appreciation when he exits. He would like to hit a 10-15% IRR, depending on the deal and is willing to consider all opportunities. He reaches out to a reputable broker to help source the deal. The broker sends him two offering memorandums with the following opportunities and information:

Deal 1 – Office Opportunity

Equity Needed: $5MM
Hold Period: 5 Years
IRR: 15%
Developer/Operator: Very Experienced
Description: Great opportunity to reposition an office asset in a great market.

Deal 2 – Retail Opportunity

Equity Needed: $5MM
Hold Period: 10 Years
IRR: 11%
Developer/Operator: Very Experienced
Description: Great opportunity to reposition a retail property in a great market

Just based off this information alone, it appears that the office deal would be the clear winner. All things considered equal, it appears our investor is going to get a higher return on his investment and in half the time. The IRR comparison clearly shows this and in addition, he has confidence in the developer/operator because he’s heard of them and knows they are very experienced.

Feeling good about the opportunity at a high level, the investor opens the OM and is greeted with slick pictures and a summary page with the following table and cash flow:

Internal Rate of Return Illustration

Various return metrics alongside the internal rate of return

5 years of distributions

One of the things he immediately notices is that the average annual yield is surprisingly low at 2.3% meaning that the main impact driving the 15% IRR must be coming from significant appreciation and sale of the property. Looking at the cash flow further confirms this. He sees that Year 1 cash flow has a 0.2% return and in subsequent years the cash flow is growing by a significant amount. Now he can assume with strong confidence and without looking further into the OM that this is an opportunistic deal and the sponsor is most likely looking to purchase an almost vacant office building, possibly do some renovations and hope to lease up the entire building in years 4 and 5 and exit with a stabilized and much more valuable building. The IRR alone could not give him this information and could not really give him a level of understanding about the risk involved. This deal is risky. Now, although still at a high level, the additional metrics and annual cash flow information gave him much more to work with. He is still considering the deal because he has a lot of confidence in both the operator and the market, but realizes that it may not be the right one for him.

A little unsure now, he decides to look at the other project, although a little less enthusiastic about the IRR. Upon opening the second OM, he sees the following table and cash flow:

The summary cash flow and additional valuation metrics immediately reveal a lot more about the opportunity. Although the IRR is much lower, he is happy with the attractive annual yield that averages 7.8%. This deal appears to be much more stable and much less risky than Deal 1. He can assume this because there is a steady cash flow stream with a solid annual return and a moderate to very good property appreciation assumption that seems appropriate for a building in decent shape over the ten-year hold (4% – 5% annual appreciation. Year 10 total cash flow = exit price + operating income). However, one cause for concern should be Year 4 cash flow, which most likely indicates a major tenant or multiple tenants’ vacating. This will be something that needs to be better understood by our investor.

Further consideration when comparing the two deals should be to look at the total profit. The equity multiple is a quick way to see how much you’ve earned over your initial investment. Deal 1 has a 1.99x multiple meaning that our investor could almost double his money if all goes well and in Deal 2, there is a 2.33X equity multiple. As a result, Deal 2 earns an additional $2.6MM of profit compared to Deal 1, but Deal 2 requires a 10-year commitment compared to 5 years for Deal 1.

Is the additional 5 years, supposed less risk, and additional $2.6MM of potential profit a better proposition for our investor? He will need to think about this and many other issues as he continues his due diligence.

Wrap Up

Although still at a high level, our investor now has a much better understanding of the two deals he has been presented with. It should be clear now that the IRR, although an extremely valuable and useful metric to help measure profitability, is not great at directly conveying risk, cash flow profile, and absolute profitability; and should be used in combination with the other metrics mentioned here, as well as others to value real estate opportunities.

About the Author

Michael Belasco is a co-founder of the real estate financial modeling, careers, and education website: AdventuresinCRE.com.

A Note from EquityMultiple

This article does a nice job illustrating the limitations of IRR when employed as the sole return metric in evaluating a potential investment. Since IRR takes into account the time value of money, it’s an excellent place to start – but be sure to also consider equity multiple, average annual cash yield, and your own preference regarding hold period and cash flow.

Back to Insights