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.
Click here to get this CRE Glossary in an eBook (PDF) format.