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.
Frequently Asked Questions about Internal Rate of Return (IRR)
What is the Internal Rate of Return (IRR)?
IRR is a metric that annualizes the rate of return for a range of cash flows and estimates the profitability of an investment. It is defined as the discount rate at which the present value of all future cash flows equals the initial investment, resulting in a net present value (NPV) of zero.
How do you calculate IRR in Excel?
You can use the IRR() or XIRR() functions in Microsoft Excel. IRR assumes evenly spaced time intervals, while XIRR accounts for actual dates. “[Outside of Excel, you can extrapolate a few probable rates and figure out the exact IRR by a trial and error method.]”
Why is IRR important in real estate investing?
IRR is critical for evaluating the time-adjusted return of a real estate investment. It helps compare the profitability of different projects and assess whether a fund or property has outperformed its target benchmarks.
What was the IRR of Horizon Real Estate Fund IV?
Horizon Real Estate Fund IV achieved a 15.1% IRR, exceeding its original target IRR of 14%. This was based on €1.5 billion in capital deployed and total net distributions of €3.34 billion over 10 years.
What were the fund’s total equity contributions and distributions?
Total Equity Contributions: €1.5 billion
Operational Cash Flows: €1.14359 billion
Sale Proceeds: €2.2 billion
Total Distributions: €3.34359 billion
What was the calculated equity multiple for the fund?
The equity multiple was calculated as:
€3.34359 billion ÷ €1.5 billion = 2.23x, meaning investors more than doubled their money over the fund’s life.
What factors contributed to the fund exceeding its IRR target?
Key factors included:
10% annual operational cash flow growth
Strategic exits at favorable market timing
Investments in high-demand data center locations
How does IRR reflect market timing and execution?
IRR is highly sensitive to the timing of cash flows. The fund’s bulk sale in Year 10 during strong market conditions helped maximize returns, highlighting how well-timed exits can significantly improve IRR.
Click here to get this CRE Glossary in an eBook (PDF) format.