If you have spent any time evaluating private market investments, you have seen both terms: IRR and XIRR. Sponsors report one. Spreadsheets offer both as functions. Articles about private equity performance use them interchangeably.
They are not the same calculation, and the difference matters more than most investors realize.
What IRR measures
IRR stands for Internal Rate of Return. It is the annualized rate of return that makes the net present value of all cash flows from an investment equal to zero — in plain English, the discount rate at which the present value of what you put in equals the present value of what you get back.
What matters for this discussion is the assumption built into the standard IRR calculation: it treats cash flows as occurring at regular, evenly spaced intervals. When you run an IRR calculation in a spreadsheet, you typically lay out cash flows by period — year 1, year 2, year 3 — and the function assumes each period is the same length.
This works fine when cash flows actually occur at regular intervals. It becomes an approximation when they do not.
What XIRR measures
XIRR stands for Extended Internal Rate of Return. It calculates the same thing as IRR — the annualized rate of return that equates the present value of inflows and outflows — but it does not assume regular intervals.
XIRR takes a date alongside each cash flow. A capital contribution on March 15 is counted as occurring on March 15. A distribution on November 3 is counted as occurring on November 3. The calculation accounts for the exact number of days between each cash flow rather than approximating to the nearest year-end.
The result is a more precise annualized return figure for investments where cash flows are irregular — which describes essentially every private market investment.
Why the difference matters for private equity and real estate
In private market investing, cash flows almost never occur at neat annual intervals.
A private equity fund might call capital in February, May, and October of year one. A real estate syndication might distribute quarterly but skip a quarter during a renovation. A private credit fund might receive principal repayments mid-year. Capital calls come when deals close, not on December 31.
When you calculate IRR on these irregular cash flows by approximating to annual periods, you introduce error. The error is usually small for a single investment over a long hold period. It compounds across a portfolio of multiple investments with many cash flows occurring at different points in the year.
Consider a simple example. You invest $100,000 in a fund on January 15. The fund distributes $130,000 to you on December 20 of the same year — nearly 11 months later.
If you calculate IRR treating this as a one-year period, you get 30%. But you did not hold the investment for a full year — you held it for approximately 340 days. XIRR, which accounts for the actual dates, produces a slightly higher annualized return because the same absolute gain was achieved in less than a full year.
The difference in this example is modest. Across a portfolio of twenty investments with hundreds of cash flows spanning multiple years, the aggregate difference between IRR and XIRR is more meaningful — and XIRR is the more accurate number.
How sponsors report returns versus how you should track them
Most private equity sponsors report fund performance using IRR — sometimes gross IRR (before fees and carried interest) and net IRR (after fees and carry). This is industry convention, partly for simplicity and partly because it allows comparison across funds using a standardized methodology.
When a sponsor tells you a fund has generated a 22% net IRR, they are typically using periodic cash flows rather than exact dates. This is fine for benchmarking and comparison purposes — if every fund reports on the same basis, the relative rankings are meaningful even if the absolute numbers are approximations.
For evaluating your own portfolio — calculating your personal return on each investment and across your portfolio as a whole — you have actual transaction dates available. Using XIRR is more accurate and gives you a truer picture of your return than approximating to annual periods.
This is also why the XIRR you calculate on your own portfolio may differ slightly from the IRR the sponsor reports. You are measuring the same underlying investment but using a more precise methodology on actual dates versus approximated periods.
A practical comparison of XIRR vs IRR
Here is a more detailed example showing how the two calculations can diverge.
You commit $200,000 to a real estate syndication. Capital is called in three installments:
- $100,000 on February 10, Year 1
- $60,000 on August 22, Year 1
- $40,000 on March 5, Year 2
You receive distributions of $15,000 on each of June 30 and December 31 in Years 2, 3, and 4 — six distributions totaling $90,000.
The fund exits in Year 5, and you receive $280,000 on September 14.
If you calculate IRR by approximating each contribution and distribution to the nearest year, you get one number. If you calculate XIRR using the actual dates above, you get a slightly different number — because the exact timing of when each contribution was funded and when each distribution was received affects the true annualized return.
For investments with a long hold period and relatively smooth cash flows, the difference between IRR and XIRR is typically small — often less than one percentage point. For investments with front-loaded contributions, back-loaded distributions, or unusual timing, the difference can be larger.
The direction of the difference depends on the specific pattern of cash flows. There is no rule that XIRR is always higher or always lower than IRR for the same investment — it depends on whether the actual cash flow dates are earlier or later than the annual approximation would suggest.
Which should you use?
The answer depends on what you are trying to do.
For comparing your investments to benchmarks or to sponsor-reported returns: use IRR, or at least be aware that benchmarks are typically reported on an IRR basis. Comparing your XIRR to a sponsor's reported IRR introduces a methodological mismatch that can make comparisons misleading.
For calculating your true personal return on each investment: use XIRR. You have the actual dates. Using them produces a more accurate result.
For portfolio-level performance tracking: use XIRR. The aggregate of many investments with many cash flows benefits most from precise date accounting, and the error that accumulates from IRR approximation is most significant at the portfolio level.
For quick back-of-envelope estimates: IRR is fine. The approximation error is small enough that for a rough sense of how an investment is performing, annual period IRR is perfectly adequate.
The spreadsheet version of each
If you are calculating these manually in Excel or Google Sheets:
The IRR function takes a range of cash flows with no dates — =IRR(values, [guess]). It assumes each value occurs one period apart, where the period length is determined by the interval between rows.
The XIRR function takes both cash flows and corresponding dates — =XIRR(values, dates, [guess]). Each cash flow in the values range must have a corresponding date in the dates range.
For XIRR to work correctly:
- Contributions must be entered as negative numbers
- Distributions and current NAV must be entered as positive numbers
- Dates must be in a format the spreadsheet recognizes as dates, not text
- There must be at least one negative and one positive value in the series
- The date range must correspond exactly to the cash flow range — same order, same number of entries
The function can occasionally return an error if the guess parameter is far from the actual result or if the cash flows are unusual. Providing a reasonable starting guess — 0.1 for 10% — usually resolves this.
How AltTrack handles XIRR calculation
Maintaining accurate XIRR calculations across a portfolio of fifteen or twenty investments — with contributions, distributions, and NAV updates arriving on different schedules — is one of the most tedious parts of tracking a private market portfolio in a spreadsheet.
Each new capital call and each new distribution requires updating the cash flow table for that investment. A missed entry, a wrong date, or a sign convention error produces an incorrect result that the formula still returns without flagging the problem.
AltTrack calculates XIRR automatically from your transaction history for each investment, using exact dates and correct sign conventions. The portfolio-level XIRR updates whenever new transactions are logged. You see accurate, current return figures without maintaining formulas manually.
For investors who are still tracking this in spreadsheets, this is one of the most practically useful things a purpose-built tool handles — not because the calculation is conceptually difficult, but because keeping it accurate across many investments over many years requires discipline that is easy to let slip.
The bottom line on XIRR vs IRR
XIRR and IRR are both valid ways to measure investment returns. IRR is the industry standard for fund-level reporting and benchmarking. XIRR is the more accurate calculation for individual investors tracking their own portfolios because it accounts for the actual timing of every cash flow.
When you see a sponsor report a net IRR of 18%, that is an IRR calculation using approximated annual periods. When you calculate your personal return on that same investment using XIRR and your actual transaction dates, you may get a slightly different number — and XIRR is the more accurate reflection of your actual experience as an investor.
The two metrics are measuring the same underlying thing. XIRR just does it more precisely.