What is Internal Rate of Return?

What Is IRR?

Internal rate of return (IRR) is the annualised rate of return an investor can expect to earn over the life of an investment, considering the timing and magnitude of all cash flows. It is used to evaluate the profitability of an investment.

In technical terms, it represents the discount rate at which the net present value of all cash flows from an investment equals zero.

For investors in private markets, understanding IRR provides a standardised way to compare different investment opportunities, regardless of their size, duration or cash flow patterns.

Whether evaluating a private equity fund, a direct investment in a growing business or an infrastructure project, IRR offers a framework for assessing performance.

What is Internal Rate of Return Used For?

How IRR Measures Investment Performance

IRR measures investment performance by calculating the rate at which an investment achieves break even, in terms of net present value. This means it accounts for the time value of money, recognising that a pound received today is worth more than a pound received in five years.

By discounting future cash flows back to their present value, IRR provides a more accurate picture of an investment's true performance than simpler metrics, such as MOIC or MMx, that ignore timing.

The calculation considers all cash flows associated with an investment: the initial capital invested, any additional capital calls, distributions received, and the final exit value. By finding the discount rate that makes the present value of these cash flows equal to zero, IRR captures the effective annual return generated by the investment.

Why is IRR Important in Private Equity?

In private equity, IRR has become the standard metric for measuring and comparing fund performance. Private equity investments typically involve irregular cash flows over extended periods. Capital is called down as investment opportunities arise, portfolio companies require additional funding or transaction costs are incurred. This could span, for example, two to five years, dependent on the manager, market opportunity set and strategy. Distributions flow back to investors as companies are sold, dividends are paid or refinancing events occur. Again, this could span anywhere between, for example, two and eight years.

This irregular pattern makes it difficult to assess performance using simple return calculations. IRR solves this problem by incorporating the timing of each cash flow into a single percentage figure. A fund that returns capital quickly will show a higher IRR than one that takes longer to achieve the same multiple, even if both deliver identical absolute returns. This time sensitivity is particularly valuable in private equity, where the opportunity cost of capital and the J-curve effect can significantly impact investor outcomes.

Private equity fund managers typically target specific IRR ranges when raising capital, with different ranges expected for different strategies and asset classes. Buyout funds might target IRRs of 15% to 20%, whilst venture capital funds may aim for 25% or higher to compensate for greater risk. These targets provide investors with a benchmark against which to evaluate whether a fund's strategy and terms offer appropriate potential returns for the risks involved when compared to other strategies.

How IRR Is Calculated

The internal rate of return formula requires solving for the discount rate that satisfies this equation:

0 = CF₀ + CF₁/(1+IRR)¹ + CF₂/(1+IRR)² + ... + CFₙ/(1+IRR)ⁿ

Where:

• CF₀ is the initial investment (negative value)
• CF₁, CF₂, CFₙ are subsequent cash flows (positive for distributions, negative for additional investments)
• n is the number of periods
• IRR is the internal rate of return

Because this equation cannot be solved algebraically when there are multiple cash flows, IRR must be calculated iteratively using trial and error or financial software. Most spreadsheet programmes include built-in IRR functions that perform these calculations automatically.

To calculate IRR in Excel or similar tools, you need a series of cash flows with their corresponding dates. The cash flows should be arranged chronologically, with investments shown as negative numbers and distributions as positive numbers. The IRR function then iterates through different discount rates until it finds the one that makes the net present value equal to zero.

There’s no getting around the fact that IRR calculations are complex. And if you are not mathematically minded, they are definitely best left to experts, not least because there are common mistakes.

Common Mistakes in Data Entry for IRR Calculations

Common IRR calculation errors include incorrect cash flow signs. Investments should be negative while distributions should be positive. Omitting cash flows or entering them in wrong periods significantly distorts results; every transaction must be chronologically accurate. Irregular time intervals require Excel's XIRR function instead of standard IRR, which assumes equal periods.

Finally, ongoing investments need current portfolio valuations included as positive final-period cash flows to calculate accurate interim IRR for unrealised positions.

An Example of an IRR Being Calculated

Consider an investment in a private equity fund with the following cash flows:

• Year 0: Initial investment of £1m (cash flow: -£1,000,000)
• Year 2: Additional capital call of £200,000 (cash flow: -£200,000)
• Year 3: First distribution of £300,000 (cash flow: +£300,000)
• Year 5: Second distribution of £500,000 (cash flow: +£500,000)
• Year 7: Final distribution of £800,000 (cash flow: +£800,000)

Using the IRR formula, we need to find the discount rate that makes the net present value of these cash flows equal to zero:

0 = -£1,000,000 + (-£200,000)/(1+IRR)² + £300,000/(1+IRR)³ + £500,000/(1+IRR)⁵ + £800,000/(1+IRR)⁷

Through iterative calculation, the IRR for this investment is approximately 12.8% p.a. This means the investment generated an annualised return of 12.8%, accounting for the timing of all capital calls and distributions.

The total cash returned to investors was £1.6m on a total investment of £1.2m, representing a 1.33x multiple. However, the IRR of 12.8% provides additional insight by showing the annualised performance, making it easier to compare this investment with others that may have different time horizons.

Is IRR the Same as ROI?

IRR and return on investment (ROI) are related but distinct metrics. ROI measures total or absolute return as a percentage of initial capital but ignores timing; a 50% return over two years differs significantly from 50% over ten years. IRR addresses this by calculating annualised returns, incorporating time and cash flow timing.

An investment doubling in three years shows higher IRR than one doubling in seven, despite identical 100% ROI. Private equity favours IRR for its accuracy with irregular cash flows, though investors often use both metrics for comprehensive performance assessment.

What Is a Good Internal Rate of Return?

What constitutes a good IRR varies by asset class, strategy, and market conditions. Private equity buyout funds typically target 15-20% IRRs, reflecting illiquidity and risk premiums over public markets. Venture capital funds aim for 20%+ IRRs due to higher failure rates and greater upside potential. Infrastructure and real estate funds, offering the potential for more predictable cash flows, target 8-15% IRRs, while private credit strategies seek 10-15%.

When evaluating IRR attractiveness, investors consider the investment's risk level; higher risk demands higher returns. The interest rate environment matters too; a 15% IRR is compelling when risk-free rates are low but less attractive when bonds yield 5%. Illiquidity also justifies higher returns, as private market investments lock up capital for years without access. Understanding how private equity performs across market conditions helps establish realistic performance expectations.

Finally, investors should assess IRR in the context of their overall portfolio strategy. As high net worth investors increasingly allocate more to alternative assets, understanding what constitutes an appropriate IRR target becomes essential for portfolio construction.

Advantages and Disadvantages of IRR

Advantages

IRR’s primary strength is the incorporation of the time value of money. By discounting future cash flows back to the present, IRR recognises that returns received sooner are more valuable than those received later. This makes it particularly useful for evaluating investments with irregular cash flow patterns.

The metric also enables straightforward comparisons between different investments. Whether you're evaluating a three-year venture capital investment or a seven-year buyout fund, IRR provides a consistent annualised return figure that facilitates comparison. This standardisation is valuable when building a diversified portfolio across multiple strategies and time horizons.

IRR is widely understood and accepted in the investment industry, particularly in private markets. Fund managers report performance using IRR, limited partners evaluate funds based on IRR, and industry benchmarks are expressed in IRR terms. This universal adoption makes communication and comparison easier across the investment community.

Disadvantages

IRR has important limitations investors must understand. The metric assumes interim cash flows are reinvested at the same rate as the original investment, which is often unrealistic. If a fund distributes capital early and you cannot reinvest at the same IRR, your actual realised return will fall short of the calculated figure.

IRR can mislead when comparing investments of different sizes. A small investment doubling quickly shows impressive IRR, but contributes minimally to overall portfolio returns. A larger investment with lower IRR might add more absolute wealth.

The calculation can produce multiple solutions or none when cash flows change direction repeatedly. Multiple capital calls and distributions may yield several mathematically valid answers, complicating interpretation.

For ongoing investments, IRR relies on current valuations rather than actual exit proceeds. These interim valuations are subjective and may not reflect ultimate realised value. Valuation changes or market shifts can cause significant IRR fluctuations for funds still in their investment period.

Despite these limitations, IRR remains valuable for assessing private market performance. Investors should use it alongside other metrics, such as multiple on invested capital, distributed to paid-in capital, and total value to paid-in capital, to gain comprehensive performance insight.