XIRR vs CAGR: what your SIP actually earned
SIPs and investing8 min read

By the numbers
- twelve instalments of ₹10,000
- ₹1,32,022
- the absolute gain on them
- 10.0%
- the XIRR it actually earned
- 19%
On this page
Two numbers, same fund, same year. One says the fund returned 19%. The other says you made 10%. Both are arithmetically correct, and the gap between them is the most common reason people lose faith in a SIP that is working exactly as designed.
I have had this conversation more often than any other in my years of advising. A client forwards a statement, sees a percentage that looks small next to the fund's published return, and asks whether the SIP is being skimmed. It is not. The two numbers are answering different questions, and the statement rarely says which one it is printing.
Here is the whole argument in one page, then the arithmetic behind it.
Three numbers, three questions
| Number | The question it answers | Where it is the right answer |
|---|---|---|
| Absolute return | How much more money do I have than I put in? | A single purchase held for a period you already know |
| CAGR | What steady yearly rate turns my starting value into my ending value? | A lumpsum left alone for years |
| XIRR | What yearly rate did each rupee earn, given the day it arrived? | SIPs, top-ups, redemptions, a goal you fund monthly |
None of the three is dishonest. They are simply not interchangeable, and the mistake is using the convenient one for a cash-flow pattern it was never built for.
Why a SIP's percentage is not an annual return
Start with the case nobody argues about. You invest ₹1,00,000 on 1 January and the fund gains 10% by 31 December. You have ₹1,10,000. That is a 10% return, and the arithmetic is not in dispute.
Now invest ₹10,000 a month for twelve months instead. The first instalment is invested for a full year. The last one is invested for a month. On average, a rupee in that SIP was in the market for six and a half months — so of course the total gain is smaller than the fund's annual return. It had less time to happen in.
| What the fund did over the 12 months | Value of 12 × ₹10,000 | Your absolute gain | Your XIRR |
|---|---|---|---|
| 0% | ₹1,20,000 | 0% | 0% |
| 12% | ₹1,27,665 | 6.4% | 12% |
| 19% | ₹1,32,022 | 10.0% | 19% |
Read the second row and the third together. In both, the column that matters — the rate the money actually earned — is identical to what the fund did. The absolute column is roughly half of it, every time, because the average rupee only had half a year.
That is the entire confusion. A 10% gain on money that was invested for an average of six months is not a 10% annual return. It is a 19% annual return, observed for half a year at a time.
What CAGR fixes, and what it does not
CAGR is the honest annualisation of a single deposit. ₹1,00,000 becomes ₹2,00,000 in six years; the CAGR is 12.25%, because 1.1225 multiplied by itself six times is 2. That number is genuinely useful and genuinely comparable across funds, which is why every factsheet prints something like it.
But CAGR assumes the whole amount was present from the first day to the last. In a SIP it was not. Apply CAGR to the two endpoints of a monthly SIP and it quietly answers a question you did not ask: what steady rate would have turned my total contributions into my final value if I had invested all of it on day one?
| ₹10,000 a month for 10 years, fund compounding at 12% | |
|---|---|
| Total invested | ₹12,00,000 |
| Value after ten years | ₹23,23,391 |
| Absolute gain | 93.6% |
| CAGR of the two endpoints | 6.8% |
| XIRR | 12.0% |
One outcome, three numbers, and only one of them is the return your money earned. The 93.6% is real money but not a rate; the 6.8% is a rate but not your rate, because it credits the first instalment with ten years of growth on all ₹12 lakh. The 12% is the number that survives the question "when did each rupee actually arrive?"
Notice also what the 6.8% does to a conversation. A client comparing that figure to a fixed deposit at 7% concludes the equity fund was pointless. The same client, shown the XIRR, sees a fund that beat the deposit by five percentage points a year — which is the truth, and a very different decision.
The worked example, in full
Two deposits and one value, so the arithmetic is checkable by hand.
- ₹10,000 on 1 January
- ₹10,000 on 1 July
- ₹21,500 on 31 December
Divide the ₹1,500 gain by the ₹20,000 invested and you get 7.5%. That is the absolute return, and it is the number most people would quote.
Now solve for the rate at which the two deposits grow into ₹21,500:
- the January deposit grows for twelve months: ₹10,000 × 1.1008 = ₹11,008
- the July deposit grows for six months: ₹10,000 × √1.1008 = ₹10,492
- together: ₹21,500
The rate is 10.08%. That is the XIRR. The 7.5% was never wrong; it was a total, not a rate, and it divided a full year's growth by money that had not been there for a full year.
The four limits of XIRR
XIRR is the right tool for a SIP, but it is not a verdict, and it is worth knowing exactly where it lies to you.
It measures you, not the fund. XIRR is money-weighted: it depends on when you put money in. Two investors in the same scheme over the same year can print different XIRRs, because one added a large amount just before a rally and the other just after. If you want to judge the fund, use its rolling returns. Use XIRR to judge your plan.
It assumes you can reinvest every rupee at the same rate. That is a convention of the formula, not a promise from the market. A 14% XIRR does not mean you will find a 14% home for each instalment's gain.
It annualises noise. Three good months annualise to something spectacular and meaningless. On a SIP younger than about three years, the XIRR is a mood, not a measurement. I do not read it before year three, and I do not act on it before year five.
It can have more than one answer. If your cash flows change sign more than once — invest, withdraw, invest again — the equation can have several roots. Excel returns one of them without telling you there were others. For a plain SIP and one current value, there is a single answer and this does not bite.
How to compute it, and what to compare it against
Two columns in a spreadsheet. Money going in is negative, the current value is positive, and the dates are real dates rather than month numbers. Then:
=XIRR(B2:B121, A2:A121)
That is the whole recipe for a ten-year monthly SIP: 120 negative rows and one positive. Google Sheets and Excel use the same function and the same 365-day convention, so the platform's figure and yours should agree to two decimal places. If they do not, the usual cause is a missing instalment or a date typed as text.
The comparison matters more than the calculation. Your 12% XIRR over seven years should be set against the same cash flows into the benchmark's total return index over the same seven years — not against a fund's best five-year window, and not against a headline number from a different period. Like against like, or the exercise teaches you nothing.
What I actually track
Three numbers, looked at once a year:
- The fund's rolling returns — its own record, over every three- and five-year window, against its benchmark. This is how I decide whether the fund is still doing its job.
- My XIRR per goal — one number per purpose (retirement, a child's education), because mixing goals hides which one is behind.
- The absolute value — the only figure that eventually pays a fee.
Everything else is entertainment. A daily XIRR is a mood ring; a yearly one is a measurement.
The last word
If money arrives once, use CAGR. If money arrives many times, use XIRR. If someone quotes you a percentage without telling you which one it is, ask — because the same year can honestly be reported as 6.4%, 10% or 12%, and the difference between those numbers is not performance. It is arithmetic.
A SIP that shows a modest total gain in its early years is not underperforming. It is early. The number that will decide your retirement is the XIRR, and the only way to have a good one is to keep the instalments arriving long enough for the average rupee to have a decade behind it.
Questions this raises
- Why does my SIP's XIRR come out higher than the fund's own return?
- It should come out equal if you have the cash flow dates right. The fund's published return assumes money invested on day one; your SIP invested a twelfth of it every month, so the later instalments simply had less time to grow and less time to lose. XIRR is the rate that reconciles your actual deposits with the value today, which is why it lands on the fund's return rather than on your absolute gain.
- Is XIRR the same thing as CAGR?
- No. CAGR assumes one deposit at the start and one value at the end — it is a special case of XIRR with exactly two cash flows. The moment money moves more than once, the two diverge, and for a SIP the gap is large: a ₹10,000 monthly SIP held ten years at 12% has a 12% XIRR and a 6.8% CAGR on its endpoints.
- How do I calculate XIRR in Excel or Google Sheets?
- Two columns: the cash flows and the dates. Money you put in is negative, the current value is positive, and every date is a real date rather than a month number. Then =XIRR(B2:B121, A2:A121). Both programs use the same function and the same 365-day convention, so a spreadsheet and a fund platform should agree to two decimal places.
- What XIRR should I expect from an equity SIP?
- Over fifteen years or more, planning on 10–12% a year before tax is a reasonable working assumption for an Indian equity portfolio, and plenty of ten-year windows have delivered less. The number matters less than what you compare it with: your XIRR against the same cash flows into the benchmark's total return index, not against a fund's best five-year window.
- My statement shows 94% growth over ten years. Why is that not a 94% return?
- Because 94% is the total gain, not an annual rate — and because most of your money arrived years after the first instalment. Compounded at 12% a year for ten years, a rupee grows 3.1 times; your SIP's average rupee grew less than that because it was invested for less time. The 94% is real money; it is simply not a rate.