XIRR vs CAGR vs Absolute Return: What's the Difference and When to Use Each

If you've ever looked at your mutual fund statement and seen three different "return" numbers that don't agree with each other, you're not misreading anything. XIRR, CAGR, and absolute return are genuinely different calculations, built to answer different questions — and using the wrong one can make an investment look far better, or far worse, than it actually is.

Here's what each one actually measures, and how to tell which number you should be looking at.

Absolute Return: The Simplest, and Most Misleading

Absolute return is just the total percentage gain on your money, with no regard for how long it took to earn it.

Absolute Return = (Current Value − Invested Amount) / Invested Amount × 100

If you invested ₹1,00,000 and it's now worth ₹1,50,000, your absolute return is 50%. That's true whether it took 6 months or 6 years — and that's exactly the problem. A 50% return in 6 months is spectacular. A 50% return over 6 years is roughly 7% annualized, which is fairly ordinary. Absolute return alone can't tell you which one you're looking at.

It's useful for one thing: knowing your total gain in rupee terms over the life of a single, one-time investment. It's not useful for comparing investments, and it's actively misleading for anything involving multiple cash flows.

CAGR: Annualizing a Single Lump-Sum Investment

CAGR (Compound Annual Growth Rate) fixes the time problem — but only for the simplest case: one investment, made once, held for a fixed period, with one final value.

CAGR = (Ending Value / Beginning Value)(1/n) − 1

where n is the number of years.

Using the same example — ₹1,00,000 growing to ₹1,50,000 — if that took 6 years, the CAGR is:

(1,50,000 / 1,00,000)(1/6) − 1 ≈ 6.99%

That 6.99% is a much more honest, comparable figure than the 50% absolute return. You can now compare it directly to a fixed deposit rate, another fund's CAGR, or an inflation figure.

The catch: CAGR breaks down the moment you add more money later, withdraw partway through, or invest via SIP. It has no way to account for cash flows happening on different dates for different amounts. And for almost every real investor — anyone doing a monthly SIP, or topping up occasionally — that's exactly the situation they're in.

XIRR: The One That Handles Real Life

XIRR (Extended Internal Rate of Return) is built for irregular cash flows: money going in and out on different dates, in different amounts — which describes almost every real investment portfolio.

Instead of a simple formula, XIRR works by solving for the discount rate that makes the net present value of all your cash flows — every investment, every withdrawal, each on its actual date — equal to zero. Because this requires solving an equation with no clean algebraic solution, it's computed iteratively (which is exactly what an XIRR calculator or Excel's XIRR() function does under the hood).

A concrete example:

Suppose you invest:

• ₹50,000 on 1 January
• ₹30,000 on 1 June
• Your holdings are worth ₹95,000 on 31 December of the same year

A naive absolute return calculation would say: total invested ₹80,000, current value ₹95,000, gain of ₹15,000, or 18.75%. But that treats the June ₹30,000 as if it had been invested for a full year — it hasn't; it's only been in the market for 7 months.

XIRR correctly weights each cash flow by how long it's actually been invested, and in this case would show an annualized return noticeably higher than the naive 18.75% figure, because the same total gain was achieved with money invested for less total time.

This is precisely why your SIP statement shows XIRR rather than CAGR: a SIP is nothing but a long series of irregularly-timed, individually-dated investments, and XIRR is the only one of the three metrics actually built to handle that.

Which One Should You Use?

Common Mistakes to Avoid

• Comparing a SIP's absolute return to a lump sum's CAGR. These aren't the same kind of number and the comparison is meaningless — you need XIRR on both sides, or you need to compare like with like.
• Assuming XIRR and CAGR will match for a SIP. They generally won't, and there's no reason they should — CAGR isn't even defined for a series of cash flows, so any "CAGR" someone quotes for a SIP is really an approximation, not a true CAGR.
• Ignoring the sign convention when calculating XIRR manually. Investments (money leaving your pocket) should be entered as negative values, and the final value or withdrawals (money coming to you) as positive — get this backward and the calculation will either fail or return a nonsensical rate.

Plug your actual SIP cash flows into the XIRR calculator to get your true annualized return.