XIRR vs CAGR: Which Return Number Should You Trust?
By Dinesh Babu, Founder & Editor, PaisaCalc · Updated July 2026
Open any mutual fund statement and you'll see a return figure — but which one? CAGR and XIRR are the two numbers investors argue about most, and using the wrong one can make you badly over- or under-estimate how your money actually did. Here's the plain-English difference, and why for a SIP only one of them tells the truth.
What CAGR actually measures
CAGR stands for Compound Annual Growth Rate. It answers a very specific question: if I put in one amount at the start and pulled out a bigger amount at the end, what single steady annual rate would connect the two?
The formula is CAGR = (Ending Value / Beginning Value) ^ (1 / number of years) − 1. It smooths out all the ups and downs into one clean annual number. That makes it perfect for a single lumpsum investment held for a fixed period — say ₹1,00,000 that grew to ₹2,00,000 over 6 years.
The catch: CAGR only knows two things — your starting value and your ending value. It is completely blind to anything that happens in between. Any money you added or withdrew along the way simply does not exist as far as CAGR is concerned.
Why CAGR breaks for SIPs
A SIP is not one investment — it is dozens of small investments made on different dates. The instalment you paid in the first month has been compounding for years; the one you paid last month has barely had time to grow at all.
If you naively apply CAGR by comparing your total invested amount to your current value, you treat every rupee as if it were invested on day one. That massively overstates your return, because most of your money was actually invested much later and has grown for far less time.
In short: the moment your cash flows are spread across multiple dates, CAGR is the wrong tool. You need a metric that respects when each rupee went in.
What XIRR does differently
XIRR stands for Extended Internal Rate of Return. Instead of ignoring the timing of your money, it puts the date next to every single cash flow — every SIP instalment, every extra top-up, every partial withdrawal — and finds the one annual rate that makes all of them balance out to your final value today.
Technically, XIRR is the annualised rate that makes the net present value (NPV) of all your dated cash flows equal to zero. You don't need to compute that by hand — every spreadsheet has an XIRR function. You list each date and the amount (outflows negative, your investments; inflow positive, the final redemption value), and it returns the true annualised return.
Because XIRR weights each contribution by how long it was actually invested, it is the correct metric for SIPs, for lumpy top-ups, for anything with irregular cash flows.
A worked contrast: where they diverge
Imagine you run a SIP of ₹10,000 a month for 12 months — you invest ₹1,20,000 in total. At the end of the year your portfolio is worth ₹1,32,000, a ₹12,000 gain.
A tempting but wrong calculation: ₹12,000 gain on ₹1,20,000 invested looks like a 10% return, and you might even call that your CAGR. But that treats the whole ₹1,20,000 as if it sat invested for the full year — it didn't. Your December instalment was invested for barely a month.
Run the same cash flows through XIRR — twelve outflows of ₹10,000 on their real dates and one inflow of ₹1,32,000 at year-end — and the annualised return comes out closer to 18-19%, not 10%. The same profit, honestly time-weighted, is a much higher annual rate because your average rupee was invested for only about half the year.
| Metric | What it assumes | Result | Correct for a SIP? |
|---|---|---|---|
| Naive "CAGR" | All ₹1,20,000 invested on day one | ~10% | No — understates the true rate |
| XIRR | Each ₹10,000 dated to its real month | ~18-19% | Yes |
When each number is the right one
- One lumpsum, no additions or withdrawals → CAGR is fine and easy.
- A SIP, or any plan where you added money over time → use XIRR.
- You took partial withdrawals or made irregular top-ups → XIRR is the only honest choice.
- Comparing two funds you invested in differently → compare XIRR to XIRR, never XIRR to CAGR.
How to read the number your fund shows you
Most fund houses and portfolio apps already report SIP returns as XIRR — that is the correct default, so trust it for anything you invested gradually. Point-to-point or "since inception" figures for a single investment are usually CAGR.
The mistake to avoid is mentally comparing the two. A 12% CAGR on a lumpsum and a 12% XIRR on a SIP mean the same thing — a genuine 12% annualised return — but a raw 'total gain / total invested' percentage does not, and comparing that to either will mislead you.
Key takeaways
- CAGR = one start value, one end value, one smoothed annual rate. Great for lumpsums, wrong for SIPs.
- XIRR = every cash flow with its date, solved for the true annualised return. The correct metric whenever money went in or out at different times.
- The naive 'gain ÷ invested' shortcut is neither, and usually understates your SIP's real annual return.
- When in doubt with a SIP or irregular investing, use XIRR — and only ever compare like with like.