XIRR vs CAGR vs absolute return: which one fits your investments
If money went in or came out on more than one date, as with a SIP or a partial redemption, XIRR is the number to read. CAGR only fits a single lump sum left alone, and absolute return ignores time altogether.
What each measures
- Absolute return: (value − invested) ÷ invested. A 20% gain reads the same over one year or five.
- CAGR: the steady yearly rate that turns one starting amount into one ending amount, (end ÷ start)^(1 ÷ years) − 1. It assumes all the money was in from the first day to the last, with nothing added or taken out.
- XIRR: the yearly rate that fits every dated flow, in and out. It is the only one of the three that knows when each rupee went in.
With one purchase and nothing else, CAGR and XIRR give the same answer. They split the moment money moves on a second date.
Where each misleads: SIPs
A SIP puts money in on many dates. Absolute return counts last month's ₹5,000 the same as the ₹5,000 from three years ago. CAGR needs one starting amount, so people plug in the total invested, which pretends every instalment went in on day one. Both make the yearly rate look lower than it was, because most of the money was invested for only part of the period. SIP returns from your statement goes through it step by step.
Where each misleads: withdrawals
Redeem part of a holding and today's value drops. Set that against the total you invested and a profitable holding can look like a loss. Absolute return only works if you add the withdrawals back: (value + withdrawn − invested) ÷ invested. CAGR has nowhere to put a withdrawal. XIRR counts it as money received on its date.
Two examples, worked out
This is an invented example with round numbers, to show the idea. It is not a real fund and not a forecast.
Example 1, a SIP. ₹5,000 is invested on the 1st of each month from 01-Jan-2023 to 01-Dec-2023 (12 instalments, ₹60,000 in all). On 01-Jan-2024 the holding is worth ₹66,000.
| Measure | Result | What it says |
|---|---|---|
| Absolute return | 10.0% | Gain ₹6,000 on ₹60,000. No time in it. |
| CAGR (₹60,000 as the start, 1 year) | 10.0% | Treats all ₹60,000 as in for the full year. |
| XIRR | 18.9% | Uses each instalment's own date. |
Counted to 01-Jan-2024, the average instalment was invested for about 199 days, a little over half a year. Earning 10% in half a year is a much higher yearly rate than 10%. The 18.9% comes from the same solver Sachfolio uses.
Example 2, a withdrawal. ₹1,00,000 is invested on 01-Jan-2021. ₹50,000 is withdrawn on 01-Jan-2022. On 01-Jan-2023 the rest is worth ₹60,000.
- Value ÷ invested: ₹60,000 against ₹1,00,000 reads as a 40% loss. It isn't one: ₹50,000 already came back to you.
- Absolute return, withdrawal added back: (60,000 + 50,000 − 1,00,000) ÷ 1,00,000 = 10.0%.
- XIRR: 6.4% a year. Check: ₹50,000 ÷ 1.06394 + ₹60,000 ÷ 1.06394² = ₹46,995 + ₹53,005 = ₹1,00,000.
How Sachfolio shows them
XIRR for each scheme and for the whole portfolio, worked out on your device from the dated transactions in your detailed statement. Under a year of history gets a note. If the statement doesn't go back to your first purchase, there's no figure at all rather than a wrong one.
All three are measures of past returns. None is a forecast, and none includes tax.
Questions
Is XIRR better than CAGR?
For one lump sum left untouched, they agree. For anything with more than one date, such as a SIP, CAGR gives the wrong answer and XIRR doesn't.
Why is my XIRR higher than my absolute return?
Because much of your money went in later and was invested for less than the full period. The same gain over a shorter time is a higher yearly rate.
Can I use CAGR for a SIP?
Not meaningfully. CAGR needs one amount on one start date, and a SIP has dozens. Use XIRR.
Does a withdrawal change my XIRR?
It's counted as money received on its date, so the XIRR stays correct after a partial redemption.
See your own numbers
Sachfolio works out XIRR from your statement, on your device.