XIRR - Extended IRR for Irregular Cash Flows

By EC Assets Research Team, Performance Measurement · Published 19 May 2026 · Updated 14 October 2026

XIRR: XIRR (Extended Internal Rate of Return) calculates the annualised return on investments with irregular cash flow timing. It is the standard methodology for private equity, venture capital, and any investment with non-uniform cash flow dates.

What XIRR Measures

XIRR is the annualised internal rate of return of a set of cash flows that occur on irregular dates. It finds the single discount rate at which the present value of everything received equals the present value of everything paid in. The X stands for the extension of the ordinary IRR, which assumes equally spaced periods, to cash flows with arbitrary dates.

That makes it the natural measure for private equity, venture capital, infrastructure and real estate funds. Capital is drawn when the manager finds investments, through capital calls, and returned when it exits them, both at dates no investor chooses. XIRR is money-weighted: periods in which more of the investor's capital is at work count for more. The contrast with time-weighted measures is covered in time-weighted vs money-weighted return.

How It Works

$$0 = \sum_i \frac{CF_i}{(1 + r)^{(d_i - d_0)/365}}$$

Outflows are negative, inflows positive, and time is measured in days from the first cash flow divided by 365. There is no closed-form solution; spreadsheet functions find r iteratively.

Private fund reporting puts XIRR next to multiples, because each answers a different question:

A good private fund report shows the rate and the multiples together; either one alone can mislead.

For funds that are still running, the remaining net asset value enters the calculation as a final notional distribution on the reporting date.

Worked Example

An investor's cash flows in a private equity fund:

Paid in 5.5 million, received 8.5 million: a TVPI of 1.55 times.

The XIRR is 12.28 percent. Two changes that leave the multiple untouched show how much of that figure is timing:

• Bring the final distribution forward by six months and the XIRR rises to 13.33 percent.
• Keep the distributions but delay every capital call by 180 days, as a fund does when it bridges calls with a subscription credit line, and the XIRR rises to 14.25 percent. The investor's profit is the same 3.0 million; only the period in which its money was outstanding is shorter.

The same effect separates speed from size. A deal returning 1.3 times its cost after one year has an IRR of 30 percent; one returning 2.0 times after five years has an IRR of 14.9 percent. The second made far more money.

When It Applies (and Limitations)

It rewards speed, not only profit. Because IRR measures a rate, early partial exits and late capital calls raise it even when the total gain does not change. That is why the multiple belongs next to it in every report, and why a high IRR on a small multiple deserves a second look.

Interim figures depend on valuations. Before a fund is fully realised, its XIRR includes the reported NAV as if it were a cash distribution. Optimistic marks raise the IRR; the final figure is known only when the last holding is sold. The early years also carry the J-curve, when fees and costs make the IRR negative before investments mature.

Several sign changes allow several answers. A pattern of calls, distributions and further calls can produce more than one rate that sets net present value to zero, and spreadsheet functions return whichever their starting guess finds.

It says nothing about risk or about alternatives. A 15 percent XIRR is good or bad only relative to what public markets returned over the same dates. Public market equivalent methods, such as the ratio introduced by Kaplan and Schoar (2005), invest the same cash flows in an index and compare the outcomes.

Why It Matters for Institutional Investors

It is the headline number in private markets. Fund marketing, benchmarking by vintage year and manager selection all lead with net IRR. Knowing how it can be moved by timing, credit lines and interim marks is the first defence against comparing unlike figures.

Subscription lines need separate disclosure. The Institutional Limited Partners Association recommends reporting IRR both with and without the effect of credit facilities. As the worked example shows, the difference can amount to two percentage points without any difference in investment results.

Distribution timing shapes the IRR as well as the cash. Under a distribution waterfall the manager's carried interest often depends on a hurdle measured as an IRR, which gives the manager an incentive to return capital early and call it late.

Pooled and averaged IRRs differ. The IRR of a portfolio of funds is not the average of their IRRs. Pooling the cash flows of all funds and solving once gives the investor's actual experience; averaging fund IRRs gives every fund equal weight regardless of size and timing.

References

1. Microsoft. (n.d.). XIRR function. Microsoft Support documentation for Excel.
2. Kaplan, S. N., & Schoar, A. (2005). Private Equity Performance: Returns, Persistence, and Capital Flows. Journal of Finance, 60(4), 1791-1823.
3. Phalippou, L., & Gottschalg, O. (2009). The Performance of Private Equity Funds. Review of Financial Studies, 22(4), 1747-1776.
4. Institutional Limited Partners Association. (2020). Enhancing Transparency Around Subscription Lines of Credit: Recommended Disclosures Regarding Exposure, Capital Calls and Performance Impact. ILPA.