If you have ever tried to compare a real estate syndication's returns to a private equity fund, you have probably run into the same problem: the numbers do not line up the way you would expect.
That is because most return metrics — annualized return, cash-on-cash yield, equity multiple — measure different things. None of them account for the timing of your cash flows. XIRR does.
What XIRR actually measures
XIRR stands for Extended Internal Rate of Return. Unlike a simple annualized return, XIRR accounts for the exact date of every cash flow — every contribution you made, every distribution you received, and the current value of your remaining investment.
The result is a single annualized percentage that represents your true rate of return, adjusted for when money actually moved.
A fund that returned 2x your money over 10 years has a very different XIRR than one that returned 2x over 3 years. Simple multiples hide this. XIRR does not.
XIRR vs IRR — what is the difference?
Investors often use XIRR and IRR interchangeably, but they measure slightly different things.
IRR — Internal Rate of Return — assumes cash flows occur at regular intervals, typically annual periods. It is the standard metric used in fund modeling and sponsor pitch decks because it is easier to calculate and communicate.
XIRR — Extended Internal Rate of Return — accounts for the exact date of each cash flow. Because private market investments rarely call capital or distribute proceeds on a neat annual schedule, XIRR is more accurate for real portfolios. A capital call on March 15 and a distribution on November 3 are treated as occurring at their actual dates, not approximated to the nearest year-end.
For most individual investors evaluating their own portfolio, the practical difference is small but meaningful: XIRR will produce a slightly different number than IRR for the same investment, and it is the right one to use when you have actual transaction dates to work from.
AltTrack calculates XIRR rather than IRR for exactly this reason — actual timing matters, and approximating it introduces error.
The inputs you need to calculate XIRR
To calculate XIRR correctly for a single investment, you need three things:
- Every capital contribution with its exact date
- Every distribution received with its exact date
- The current NAV (net asset value) as of today, treated as a final cash flow
The contributions are negative cash flows (money leaving your pocket). Distributions and current NAV are positive cash flows (money coming back).
Common XIRR calculation mistakes
Mistake 1 — Using the wrong sign convention. Contributions must be negative. Distributions must be positive. Many investors flip these and get nonsensical results.
Mistake 2 — Ignoring the NAV. If you exclude the current NAV, XIRR only measures realized returns — which dramatically understates performance for early-stage funds that have not distributed yet.
Mistake 3 — Reinvesting distributions. If you reinvested a distribution into another fund, that cash flow should still appear as a positive entry in your XIRR calculation. The reinvestment is a separate transaction in a separate investment.
Mistake 4 — Using commitment date instead of actual funding date. Your commitment date and your actual wire transfer date are often different. Use the date your money actually left your account.
What a good XIRR looks like
For context, here are rough benchmarks by asset class:
- Private real estate syndications: 12-18% target XIRR
- Private equity: 15-25% target XIRR
- Private credit: 8-14% target XIRR
- Venture capital: highly variable, 20%+ target
These are targets, not guarantees. Many funds underperform their targets. A few dramatically outperform.
Portfolio-level XIRR
Calculating XIRR across a portfolio of 10, 20, or 30 investments is more complex than a single fund. You have two approaches.
NAV-weighted average — calculate each investment's XIRR individually, then weight by current NAV. This is what AltTrack displays. It is fast and gives a reasonable approximation of your overall performance.
True portfolio XIRR — combine all cash flows from all investments into a single timeline and run XIRR once. This is theoretically more accurate but computationally intensive and produces results that are harder to decompose by investment.
The two methods produce slightly different numbers. Neither is wrong — they measure subtly different things. AltTrack notes which methodology it uses so you are never confused about what you are looking at.
Tracking XIRR over time
A single XIRR snapshot is useful. XIRR tracked over time is powerful.
Early in an investment's life, XIRR is often negative or very low — capital has been deployed but has not yet generated returns. As distributions accumulate and NAV grows, XIRR improves. Seeing this trajectory helps you understand whether an investment is performing as expected relative to its stage.
This is why AltTrack tracks XIRR from inception rather than annualizing from a fixed start date — the trajectory matters as much as the current number.
Why spreadsheet XIRR calculations break down at scale
The Excel XIRR function works well for a single investment. Maintaining it across fifteen or twenty investments — with contributions, distributions, and NAV updates arriving on different schedules from different sponsors — becomes error-prone quickly.
A missed capital call date, a distribution entered with the wrong sign, or a NAV that was not updated after the last quarterly statement all produce incorrect results that are difficult to catch because the formula still runs without error.
AltTrack calculates XIRR automatically from your transaction data, using the correct sign conventions, actual dates, and current NAV — so the number you see reflects your actual return rather than a calculation that may have accumulated small errors over time.
If you are managing a meaningful alternative portfolio and still calculating XIRR by hand in a spreadsheet, the tool exists to do this correctly and keep it current without the manual overhead.