Evaluating Real Estate with IRR: The True Profitability Beyond Yield

Yield Alone Cannot Determine Investment Quality

Surface yield and net yield are widely used to evaluate real estate investment profitability. However, these metrics have significant limitations.

Yield is simply annual income at a given point divided by the property price, and it fails to account for:

• Revenue fluctuations over the investment period: Rent declines, vacancy rate changes, repair costs
• Gain or loss at sale: Capital gains or capital losses
• Time value of money: 1 million yen today is not the same as 1 million yen in 10 years

The metric that can comprehensively evaluate all of these is IRR (Internal Rate of Return).

What Is IRR?

IRR is a metric that calculates the annualized average return of an investment by considering all cash flows over the entire investment period (rental income, expenses, sale proceeds, etc.).

More precisely, IRR is "the discount rate at which the NPV (Net Present Value) of an investment equals zero." In other words, it is the rate at which the capital invested equals the present value of all future cash flows.

Understanding Through a Simple Example

Suppose you invest 10 million yen in a property, receive 1 million yen in annual cash flow for 5 years, and sell for 10 million yen after 5 years.

Simply calculated, this looks like a 10% annual return. Indeed, the IRR is approximately 10%.

Now, what if for the same 10 million yen investment, you receive 500,000 yen annually for 5 years and sell for 12 million yen after 5 years?

Looking at annual rental income alone, the yield is 5%, but when you include the 2 million yen capital gain in the total return calculation, the IRR comes to approximately 8.4%. A property with a 5% yield could actually be quite attractive on an IRR basis.

Why IRR Matters

Enables Investment Comparison

When comparing an older apartment building with an 8% surface yield against a newer condominium with a 5% surface yield, yield alone makes the older building look superior.

However, the older building may face larger rent declines, higher repair costs, and significant price depreciation at sale. Meanwhile, the newer condominium may maintain stable rents and command a relatively high sale price.

Comparing via IRR allows you to evaluate total returns over the entire investment period on an equal footing, enabling more accurate investment decisions.

Useful for Determining Sale Timing

Even for the same property, the IRR differs between selling after 5 years versus 10 years. By simulating IRR, you can identify the most efficient timing for sale.

Evaluates Leverage Effect

By calculating equity IRR (IRR on your own capital), you can accurately assess the leverage effect of using financing. This is also useful when comparing different financing scenarios to determine the optimal loan strategy.

How to Calculate IRR

Calculation Steps

IRR is calculated as follows:

1. Determine the initial investment amount

This is the total investment including the property price plus acquisition costs (brokerage fees, registration costs, real estate acquisition tax, etc.). When using financing, use your equity (own capital) as the base.

2. Estimate annual cash flows

Calculate after-tax cash flow for each year. This is rental income minus operating expenses and loan repayments. Factor in rent declines and repair costs year by year.

3. Estimate cash flow at sale

This is the net proceeds from sale: selling price minus brokerage fees, capital gains tax, and remaining loan balance.

4. Calculate the IRR

Line up the initial investment (negative cash flow), annual cash flows, and the final year's sale cash flow, and solve for IRR.

Calculation Tools

While IRR is difficult to calculate by hand, the following tools make it easy:

• Excel / Google Sheets: Use the IRR function (=IRR(cell range))
• Real estate investment simulation tools

Excel calculation example:

| Cell | Content | Amount | |------|---------|--------| | A1 | Initial investment (equity) | -5 million yen | | A2 | Year 1 after-tax CF | 400,000 yen | | A3 | Year 2 after-tax CF | 380,000 yen | | A4 | Year 3 after-tax CF | 360,000 yen | | A5 | Year 4 after-tax CF | 340,000 yen | | A6 | Year 5 CF + net sale proceeds | 5.32 million yen |

=IRR(A1:A6) calculates the annual IRR.

IRR Benchmarks

What constitutes a "good" or "bad" IRR depends on investor goals and market conditions, but the following general benchmarks are useful:

• IRR below 5%: May lack appeal compared to other investments (e.g., index funds)
• IRR 5-8%: Standard range. A stable investment
• IRR 8-12%: Good range. Worth actively considering
• IRR above 12%: Excellent. But verify that assumptions are not overly optimistic

However, IRR varies significantly based on assumptions (rent decline rate, vacancy rate, sale price, etc.). Even if IRR is high under optimistic assumptions, an investment is risky if it turns negative under pessimistic scenarios. Evaluate using the three-scenario analysis explained in how to build a cash flow simulation.

Limitations and Caveats of IRR

Heavily Dependent on Assumptions

Since IRR is calculated based on projections of future cash flows, results change significantly depending on the assumptions used. The assumed sale price has a particularly large impact on IRR, so it is recommended to estimate sale prices conservatively.

Does Not Consider Investment Scale

IRR is a rate-based metric and does not account for the size of the investment. An IRR of 15% on a 1 million yen investment yields only 150,000 yen annually. An IRR of 7% on a 30 million yen investment yields 2.1 million yen annually. Consider actual cash flow amounts alongside IRR.

Assumes Reinvestment

IRR assumes that cash flows received during the investment period are reinvested at the same rate as the IRR. In practice, such reinvestment may not be possible. Understand this limitation and use IRR as a reference metric.

Summary

IRR (Internal Rate of Return) is a powerful tool for evaluating total returns on real estate investments. It visualizes "profitability over the entire investment period" that surface yields cannot reveal, enabling fair comparison of different property types and investment scenarios.

When making real estate investment decisions, make it a habit to evaluate comprehensively using IRR, which includes gains or losses at sale, rather than relying solely on surface yield or cash flow. The IRR function in Excel or Google Sheets makes the calculation straightforward.

However, remember that IRR is highly dependent on assumptions. Confirm that IRR remains positive not only under optimistic scenarios but also under conservative ones before making investment decisions.