IRR (Internal Rate of Return)
A metric that annualizes the rate of return for a range of cash flows and estimates the profitability of an investment.
In most cases, IRR will give you a large result.
The textbook formula for IRR is:
Discount rate at which Initial Cash Outflows = PV of all future cash flows.
To calculate IRR in MS Excel, there’s the straightforward IRR/ XIRR formula. Outside of Excel, you can extrapolate a few probable rates and figure out the exact IRR by a trial and error method.
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.