If you've ever tried to compare a real estate syndication's returns to a private equity fund, you've probably run into the same problem: the numbers don't line up the way you'd expect.
That's 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 doesn't.
The inputs you need
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 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 haven't 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 contribution 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's 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're never confused about what you're 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 hasn't 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.