Overview
XIRR and CAGR both answer the same underlying question — what annualized return did my investment generate — but they're built for different cash flow patterns, and using the wrong one produces a number that doesn't reflect reality. CAGR assumes a single investment at the start and a single value at the end. XIRR handles any number of cash flows on any dates, which is exactly the shape of a SIP: 12 or more deposits a year, each compounding for a different length of time.
Getting this distinction right matters because the two metrics are not interchangeable substitutes — applying CAGR to a SIP doesn't just give a slightly different number, it gives a number that doesn't correspond to any real return an investor experienced.
Side-by-Side Comparison
| Dimension | XIRR | CAGR |
|---|---|---|
| Use case | Multiple cash flows at different dates (SIP, recurring investments) | Single lumpsum investment, single ending value |
| Calculation method | Iterative — solved via Newton's method, no closed-form formula | Simple direct formula: (Ending/Beginning)^(1/n) − 1 |
| Best for | SIP, recurring investments, irregular contributions or withdrawals | Lumpsum, fixed deposits, point-to-point NAV comparison |
| Inputs needed | Date and amount of every individual cash flow | Beginning value, ending value, number of years |
| Complexity | Requires Excel's XIRR() function or a dedicated calculator | Calculable by hand with a basic calculator |
| Accuracy for SIP | Accurate — reflects actual contribution timing | Misleading — assumes a single cash flow that never happened |
XIRR — Deep Dive
XIRR (Extended Internal Rate of Return) is the rate that makes the net present value of a series of cash flows equal to zero — each SIP installment counted as a negative outflow on its specific date, and the final redemption counted as a positive inflow on its date. Because real investments rarely consist of a single lumpsum, XIRR is the metric built for the far more common scenario of irregular cash flows: a SIP with 12+ deposits per year, a lumpsum top-up made mid-way, or a partial withdrawal taken at some point before final redemption.
There is no algebraic shortcut to solve for XIRR directly — the calculation requires iteration, typically Newton's method, which repeatedly refines a guessed rate until the net present value of all cash flows converges to zero. This is why XIRR isn't something you compute by hand the way you might estimate CAGR. Excel and Google Sheets provide a built-in XIRR() function that takes a list of dates and corresponding cash flow amounts and returns the annualized rate directly, and a dedicated XIRR calculator does the same without needing spreadsheet software.
This is also exactly why mutual fund registrar and transfer agents — CAMS and KFin, who together service the overwhelming majority of Indian mutual fund folios — report XIRR, not CAGR, on SIP account statements. Every SIP installment you've made is its own cash flow with its own date, and XIRR is the only metric that correctly accounts for the fact that your first installment has compounded for years while your most recent one has barely started growing. A SIP's XIRR also naturally absorbs irregular events: a missed installment, a step-up in SIP amount, or a partial redemption mid-way are all just additional cash flows on additional dates, which XIRR handles without any special-case logic.
XIRR is also sensitive to timing in a way that surprises many investors the first time they check it. Two people who invested the exact same total amount in the exact same fund can end up with meaningfully different XIRR figures purely because their contribution dates differed — one started a SIP in a falling market and kept contributing through the recovery, while the other started near a peak. This sensitivity isn't a flaw in the calculation; it's the calculation correctly reflecting that the first investor's rupees, on average, had more favorable entry points than the second investor's. Long-term equity SIPs in India have historically produced XIRR figures in the 10-15% range over rolling 10-15 year periods, though any individual investor's actual figure depends heavily on their specific contribution dates and the market's path during that exact window.
CAGR — Deep Dive
CAGR (Compound Annual Growth Rate) measures the constant annual growth rate that would carry a single beginning value to a single ending value over a specified number of years: CAGR = (Ending Value / Beginning Value)^(1/n) − 1. The formula assumes exactly one investment made at time zero and exactly one value observed at the end — no contributions or withdrawals in between. This is precisely the shape of a lumpsum investment or a fixed deposit, and it's why mutual fund fact sheets commonly use CAGR to report historical fund performance: they're typically comparing the fund's NAV at one date against its NAV at a later date, a clean point-to-point comparison.
The trouble starts when CAGR is applied to a SIP. There is no clean way to treat a SIP as a single beginning value, since the money went in across dozens of separate dates rather than all at once. Investors sometimes attempt to force-fit CAGR onto a SIP by treating the total amount invested as the "beginning value" and the final corpus as the "ending value," but this produces a number that systematically misrepresents the return — it implicitly assumes the entire sum was invested on day one, which overstates the time each rupee actually had to grow and produces a return figure that doesn't correspond to any cash flow pattern that actually occurred. The alternative — treating every SIP installment as a separate lumpsum and calculating a weighted CAGR across all of them — is mathematically closer to correct but cumbersome enough that it's rarely done by hand, and it's functionally just reconstructing what XIRR already does in one step.
When to Use XIRR
- You're measuring returns on any SIP or recurring investment with multiple deposits at different dates.
- Your investment includes irregular events — a lumpsum top-up, a step-up in contribution amount, or a partial withdrawal before final redemption.
- You want to know your actual personalized return, accounting for exactly when each rupee of yours went in and came out.
- You're checking the XIRR figure reported on your CAMS or KFin mutual fund statement against your own expectations.
When to Use CAGR
- You made a single lumpsum investment and want the annualized return to a single ending value.
- You're comparing a mutual fund's or stock's NAV performance at two specific dates — the standard format used in fund fact sheets.
- You're evaluating a fixed deposit or any instrument with one inflow and one outflow.
- You want a quick, hand-calculable estimate and don't need to model multiple cash flows.
Our Verdict
For SIP investors, XIRR is the only correct way to measure your actual annualized return. CAGR, when forced onto a SIP's contribution pattern, produces a number that is either overstated or understated depending on market timing and contribution sequencing — it simply isn't built for a stream of cash flows at different dates. If your mutual fund statement shows XIRR, that figure is the one that reflects what you actually earned.
For lumpsum investments, CAGR is simpler to compute and equally accurate, since a single inflow and single outflow is exactly the scenario it's designed for — in that case, XIRR and CAGR will agree. Use the XIRR Calculator to get an accurate annualized return on your SIP folios by entering each installment's date and amount, and use the CAGR Calculator for straightforward lumpsum comparisons. If you're still deciding how to structure new contributions, the SIP Calculator can help you project a target corpus before you start.