Internal Rate of Return
The discount rate at which the net present value of an investment is equal to zero. The internal rate of return is a time value of money metric, representing the true annual rate of earnings on an investment. In real estate practice, IRR is used together with other return metrics such as equity multiple, cash-on-cash return, and average rate of return to compare real estate investments and make investment decisions.
Unlevered IRR or unleveraged IRR is the internal rate of return of a string of cash flows without financing.
Levered IRR or leveraged IRR is the internal rate of return of a string of cash flows with financing included.
The Internal Rate of Return is arrived at by using the same formula used to calculate net present value (NPV), but by setting net present value to zero and solving for discount rate r. In Excel, IRR can be calculated by using the IRR(), XIRR(), or MIRR functions.
Putting ‘Internal Rate of Return (IRR)’ in Context
Horizon Institutional Partners launched Horizon Real Estate Fund IV (HREF IV), a €1.5 billion closed-end fund, a decade ago. The fund was exclusively focused on acquiring and developing data centers across Europe, targeting key markets such as London, Frankfurt, Amsterdam, and Paris. As the fund nears its conclusion, Portfolio Manager Sarah Mitchell calculates the portfolio IRR, a critical metric for evaluating the fund’s performance against its original target IRR of 14%.
The Context
HREF IV deployed capital strategically across 13 data center projects, including 10 acquisitions and 3 ground-up developments. The projects were chosen for their proximity to major internet exchanges and strong demand for cloud infrastructure. Over its 10-year life, the fund generated consistent operational cash flows and exited with a bulk sale of all assets in Year 10.
Cash Flow Timeline
| Year | Cash Flow Type | Amount (€M) |
|---|---|---|
| 1 | Equity Contribution | -750.00 |
| 2 | Equity Contribution | -750.00 |
| 3 | Net Cash Flow (Operations) | 100.00 |
| 4 | Net Cash Flow (Operations) | 110.00 |
| 5 | Net Cash Flow (Operations) | 121.00 |
| 6 | Net Cash Flow (Operations) | 133.10 |
| 7 | Net Cash Flow (Operations) | 146.41 |
| 8 | Net Cash Flow (Operations) | 161.05 |
| 9 | Net Cash Flow (Operations) | 177.16 |
| 10 | Net Cash Flow (Operations) | 194.87 |
| 10 | Sale Proceeds (Net of Costs) | 2,200.00 |
Performance Metrics
- Total Net Distributions:
- Operational Cash Flows: €1,143.59 million
- Sale Proceeds: €2,200 million
- Total Distributions: €3,343.59 million
- Equity Multiple:
- Formula: Equity Multiple = Total Distributions / Total Equity Contributions
- Equity Multiple = €3,343.59 million / €1,500 million ≈ 2.23x
- IRR:
- Using the updated cash flow timeline and the XIRR function in Excel, the portfolio IRR was calculated as 15.1%, exceeding the original target IRR of 14%.
Insights and Implications
- Operational Revenue Growth: Annual operational cash flows increased by 10% year over year, reflecting the growing demand for data storage and premium pricing in Europe’s key data center markets.
- Favorable Exit Conditions: The sale of assets in Year 10 occurred during a highly favorable market environment, with increased institutional interest in data centers driving competitive pricing.
- Outperformance: The fund outperformed its initial targets, delivering a 15.1% IRR and a 2.23x equity multiple. These results highlight effective asset management and the strength of the data center sector during the investment period.
Lessons Learned
- Sector Focus: Specializing in a high-growth asset class allowed the fund to capitalize on market trends and achieve superior returns.
- Timing and Execution: The fund’s ability to exit at the peak of market demand underscores the importance of timing in closed-end fund strategies.
- Transparent Metrics: Metrics like IRR and equity multiple provided a clear picture of the fund’s success and enhanced investor confidence.
Market Context
The fund’s performance benefited from:
- Technological Advancements: The growing reliance on cloud services, artificial intelligence, and IoT fueled demand for data centers.
- Strategic Locations: Investments in major European data center hubs ensured strong tenant demand and rental growth.
- Institutional Appetite: The increasing institutional focus on data center assets contributed to favorable sale conditions.
Key Takeaways for Investors
HREF IV’s success demonstrates the potential of sector-focused investment strategies, particularly in rapidly growing niches like data centers. The fund’s strong returns will likely enhance investor confidence and support Horizon Institutional Partners’ future fundraising efforts.
Frequently Asked Questions about Internal Rate of Return (IRR) in Real Estate Investing
What is the Internal Rate of Return (IRR)?
The Internal Rate of Return (IRR) is the discount rate at which the net present value (NPV) of an investment equals zero. It represents the true annualized return earned on an investment over time, incorporating the time value of money.
How is IRR used in real estate investment analysis?
IRR is used to compare investment opportunities, evaluate performance against target returns, and measure time-adjusted profitability. It’s often considered alongside equity multiple, cash-on-cash return, and average rate of return.
What is the difference between unlevered IRR and levered IRR?
Unlevered IRR: Calculated using cash flows without debt (pure property-level return).
Levered IRR: Includes financing, using cash flows after debt service.
Levered IRR typically reflects higher potential returns and greater risk due to leverage.
How was IRR applied in Horizon Real Estate Fund IV (HREF IV)?
HREF IV used IRR to evaluate overall fund performance across 13 data center projects over 10 years. The fund exceeded its 14% target IRR, achieving a 15.1% portfolio IRR using Excel’s XIRR function.
What were the fund’s cash flows and final sale value?
Equity Contributions: €1.5 billion over Years 1–2
Operational Cash Flows: €1,143.59 million over Years 3–10
Sale Proceeds: €2.2 billion in Year 10
Total Distributions: €3.343 billion
What was the calculated equity multiple?
Equity Multiple = Total Distributions / Total Equity Contributions
€3,343.59M / €1,500M = 2.23x, meaning investors more than doubled their invested capital.
What factors helped HREF IV achieve a 15.1% IRR?
Strong operational growth: 10% annual increase in operating cash flows
Favorable market exit: Timed bulk sale during peak demand for data centers
Strategic asset selection: Focused on internet exchange hubs with high tenant demand
How is IRR calculated in Excel?
IRR is calculated using Excel functions such as:
IRR() – Assumes equal time intervals
XIRR() – Uses exact dates for cash flows
MIRR() – Adjusts for reinvestment assumptions
Why is IRR important to institutional investors?
IRR is a key performance metric for institutional investors to evaluate whether a fund met or exceeded its target returns. It supports capital allocation decisions and impacts future fundraising success.
Click here to get this CRE Glossary in an eBook (PDF) format.