XIRR vs CAGR: which number shows your real mutual fund return on a monthly SIP?
You put ₹10,000 a month into a SIP for a year. The fund app shows a return of 18.9%. Your friend's app shows 10% for what looks like the same fund and the same money. Neither app is wrong. They are measuring different things, and knowing which is which stops you from judging a fund by the wrong number.
Three numbers, three questions
- Absolute return answers: how much did my money grow in total? It ignores time. - CAGR answers: at what steady yearly rate did one lump sum grow? It assumes you put all the money in on day one and took it out on the last day. - XIRR answers: what yearly rate did my money earn, given that I put in different amounts on different dates? It is built for SIP investors.
A worked example (illustrative, not a real fund)
Say you invest ₹10,000 on the 5th of every month from January to December 2025. That is 12 instalments and ₹1,20,000 in total. On 5 January 2026 your units are worth ₹1,32,000. The numbers are made up to show the maths, not taken from any fund.
Measure Result How it is worked out --------- Absolute return 10% ₹12,000 gain on ₹1,20,000 CAGR (treating it as one lump sum) 10% a year ₹1,20,000 to ₹1,32,000 in one year XIRR about 18.9% a year Each instalment counted from its own date
The 10% is the wrong number for a SIP. Your first instalment was invested for 12 months, but the last one for only 1 month. On average, each rupee was invested for about 6.5 months, not 12.
So the fund did not need to earn 18.9% for you to end up with 10% more money. It earned a gain of 10% on money that was, on average, invested for about half a year. Turned into a yearly rate, that is far higher. XIRR does this adjustment for you.
When a lump sum and a SIP look the same
If you put ₹1,20,000 in on 5 January 2025 and it grew to ₹1,32,000 by 5 January 2026, CAGR and XIRR are both 10%. With a single deposit and a single withdrawal, the two measures give the same answer. They only disagree when money goes in at different times.
A longer example for a lump sum: ₹1,00,000 growing to about ₹2,59,400 in 10 years is a CAGR of 10% a year (1.1 multiplied by itself ten times is about 2.594).
Which one should you look at?
- One-time (lump sum) investment: CAGR or XIRR. They match. - SIP, step-up SIP or SWP: XIRR. CAGR on the total invested amount is misleading. - Comparing two funds: use the same measure and the same dates for both. A fund's own published return for 3, 5 or 10 years is a lump-sum CAGR. Your personal return from a SIP is an XIRR. Do not compare one with the other.
Remember this Use XIRR for a SIP and CAGR for a lump sum. A SIP that shows 10% in one place and 18.9% in another is usually the same money measured two different ways.
Three traps
- Short periods inflate XIRR. A gain of 3% in two months becomes a yearly rate of about 19% when stretched to 12 months. Do not read a short-period XIRR as a promise. Look at periods of three years or more. - Your XIRR is not the fund's return. The fund's published return is for money invested on a fixed date. Yours depends on when you invested. Two people in the same fund can have different XIRRs. - Past returns are not a forecast. A good XIRR tells you what happened. It does not say what will happen next.
How to check it yourself
Put your dates and amounts in a spreadsheet. In Excel or Google Sheets, list each instalment as a negative number with its date, add today's value as a positive number with today's date, and use the XIRR function. The result should match your fund app.
Note: I am not a SEBI-registered investment advisor. This article is for educational purposes only and is not investment advice. Please consult a registered financial advisor before making investment decisions.