Absolute Return, CAGR, and XIRR - 3 numbers every investor encounters
You invested ₹1,00,000 in a mutual fund three years ago. Today it's worth ₹1,42,000. Your app says you've earned 42%. Your friend says the fund gives 12.4% per year. But if you invested via monthly SIPs instead, your chartered accountant might quote a different number altogether. All three are correct. They're just measuring different things.
These three numbers are Absolute return, CAGR, and XIRR. Understanding when each applies and when each misleads is one of the most practical skills in personal investing.
Absolute Return
Absolute return answers the simplest question: how has my money grown?
It ignores time entirely.
Absolute Return (%) = [(Final Value - Initial Value) / Initial Value] × 100
For example, if you invest ₹50,000 in a stock and sell it for ₹65,000, your absolute return will be 30%. The holding period doesn't factor in at all. Whether you hold for 6 months or 6 years, the absolute return remains 30%.
The core limitation: 30% over 2 months is extraordinary. 30% over 10 years is mediocre. Absolute return can't tell you which one you're looking at.
When to use absolute return?
Absolute return is useful for short-term investments under one year, including fixed deposits, liquid funds, and short-duration debt funds, where annualising such a period would create misleading figures. If a liquid fund gives you 1.8% in 3 months, saying "7.35% CAGR" sounds impressive but distorts reality.
CAGR - Compounded Annual Growth Rate
CAGR answers a more nuanced question: at what steady annual rate would my money have grown to reach this outcome? It converts any multi-year return into a comparable annual figure, assuming smooth, compounding growth throughout the period.
CAGR (%) = [(Final Value / Initial Value)^(1/n) − 1] × 100
Where n = Number of years.
For example, you invest 1,00,000 lump sum. After 5 years it becomes ₹1,76,234. Your absolute return will be 76.2%, and the CAGR will be 12%. The CAGR of 12% means that if your money had grown at exactly 12% every year, compounding, it would have reached the same ₹1,76,234. It's a smooth, idealised rate, not what actually happens year on year.
The core limitation: CAGR only works correctly for a single lump-sum investment with no additional inflows or withdrawals. The moment you start adding money (like an SIP) or pulling money out, CAGR becomes inaccurate, sometimes dramatically so.
When to use CAGR?
CAGR is ideal for comparing mutual fund performance, benchmarking against indices, and evaluating lump-sum investments over multiple years. It's the standard metric in fund fact sheets for a reason: it lets you compare a 3-year return with a 5-year return on equal footing.
XIRR - Extended Internal Rate of Return
XIRR is the most sophisticated of the three. It answers the question: what single annual return rate, applied to every cash flow on its exact date, would produce this outcome?
Unlike CAGR, XIRR handles multiple investments and withdrawals at irregular intervals, which is exactly what real-world investing looks like.
In practice you never calculate XIRR by hand – Excel, Google Sheets, and most investment apps do it for you.
To see why XIRR matters, consider an SIP scenario: you invest ₹5,000 every month for 2 years (24 installments), then redeem everything all at once.
Total invested = ₹1,20,000
Corpus at redemption = ₹1,43,200
Absolute return = 19.3%
XIRR ≈14.8%
CAGR would be misleading here. The ₹1,20,000 wasn't invested in one day. Each installment has a different holding period. Only the XIRR accounts for the fact that the first SIP unit worked for 24 months while the last one worked for just 1 month.
Equally, if you had invested ₹1,00,000 as a lump sum and redeemed ₹1,42,000 three years later with no other transactions, your XIRR and CAGR would both be 12.4%. The two metrics only diverge when multiple cash flows are involved.
When to use XIRR?
XIRR is the right metric whenever your investment involves multiple cash flows, whether SIPs, top-ups, partial withdrawals, or irregular lump sums. It's what your portfolio tracker uses behind the scenes, and it's the only number that reflects how your money actually moved.
Quick reference
| Metric | What it measures | Best for | Watch out when |
|---|---|---|---|
| Absolute return | Total % growth, ignoring time | Short-term investments under 1 year | Comparing across different holding periods |
| CAGR | Smoothed annual growth rate | Lump-sum investments and comparing funds | Any investment with multiple cash flows |
| XIRR | Annualised return across all cash flows and their exact dates | SIPs, top-ups, partial withdrawals | Rarely misleads — it's the most complete measure |
The bottom line
None of these three metrics is wrong. They answer different questions. Absolute return is the simplest and most accurate method for short windows. CAGR is the industry standard for comparing funds and lump-sum growth. XIRR is the most accurate indicator of how most of us actually invest in dribs and drabs over time, with occasional withdrawals.
