Investment
CAGR vs XIRR
No Sign-Up. No Paywall.
Two return metrics, two completely different answers. Learn why XIRR is what actually matters for SIP investors.
What CAGR and XIRR Actually Mean
CAGR. Compound Annual Growth Rate is the single annual rate that would take one starting value to one ending value over a given period. It needs exactly three inputs: what you put in, what it became, and how long it took. It assumes one investment and one exit.
XIRR. Extended Internal Rate of Return is the annualised rate that makes a series of dated cash flows net out to zero. It handles any number of investments and withdrawals on any dates, weighting each by how long that particular rupee was actually invested.
This is not really a choice between two metrics. CAGR is the special case of XIRR where there is only one cash flow in and one out. The question is only whether your investment looked like that. If you invested once and sold once, they give the same answer. If you invested monthly, CAGR does not apply and using it will mislead you — usually by overstating your return.
Key Differences
| Feature | CAGR | XIRR |
|---|---|---|
| Measures | Lumpsum point-to-point return | Return on irregular cash flows |
| Best for | One-time investments, benchmarks | SIPs, redemptions, dividends |
| Considers timing | No | Yes — exact date of each cash flow |
| Can handle SIP? | No (misleading result) | Yes — this is the right metric |
| Formula | (End/Start)^(1/n) – 1 | IRR of dated cash flows |
| Number of cash flows handled | Two — one in, one out | Any number, on any dates |
| Does the timing of each investment matter | No — there is only one | Yes — that is the entire point |
| Correct for a lumpsum | Yes | Yes — it returns the same figure |
| Correct for a SIP | No | Yes |
| How to compute it | A formula | Iterative — use a spreadsheet’s XIRR function |
When to Choose Which
Choose CAGR
- Comparing two investments over same period
- Evaluating a lumpsum investment
- Benchmarking against index returns
- Quick portfolio growth estimation
Choose XIRR
- Calculating SIP portfolio actual returns
- Any investment with multiple cash flows
- Comparing funds with different SIP histories
- Real-world return measurement
Worked Examples
Assume ₹10,000 a month for 12 months, ending at ₹1,30,000 against ₹1,20,000 invested.
| Scenario | CAGR | XIRR |
|---|---|---|
| What CAGR appears to say | Treats ₹1.2 lakh as if invested on day one — understates the true rate | — |
| What actually happened | The first instalment was invested 12 months, the last about one month | XIRR weights each by its own period |
| Which figure to quote | Not applicable to a SIP | The correct one |
| A one-off ₹1 lakh growing to ₹1.3 lakh in 3 years | Correct — a single flow in and out | Identical answer |
The direction of the error depends on the cash-flow pattern, which is exactly why you should not reason about it intuitively. In a rising SIP the average rupee was invested for roughly half the period, so treating the whole sum as if it had been invested from day one understates the rate; where money went in near the end and the value rose, the same mistake overstates it. Use XIRR and the question disappears.
Where This Actually Bites
Neither figure is a tax concept — both are ways of measuring return — but getting the wrong one has three practical consequences.
Comparing your SIP to a fund’s advertised return. Fund factsheets typically quote point-to-point or CAGR figures for a lumpsum held over the period. Your SIP did not do that, so your XIRR will differ from the advertised CAGR even though you held the same fund over the same window. Neither number is wrong; they answer different questions. Compare your XIRR against the fund’s SIP return, not its lumpsum CAGR.
Judging whether to continue. A SIP evaluated with CAGR during a rising market looks worse than it is, and people stop good investments on the strength of a badly computed number.
Comparing across products. An FD’s contracted rate, a SIP’s XIRR and a lumpsum’s CAGR are not directly comparable unless you also account for tax treatment and for whether the return is contracted or merely realised. Compute everything as XIRR on post-tax cash flows and the comparison becomes honest.
Both measures describe what happened. Neither predicts what will happen, and a high past XIRR on a short period is often just a favourable starting point.
Advantages and Limitations
CAGR
Works for you when
- Simple to compute and easy to explain
- Exactly right for a single investment held to a single exit
- The standard way long-term index and fund returns are quoted
- Useful for comparing two lumpsums over identical periods
Watch out for
- Wrong for a SIP or any staggered investment
- Ignores when money went in
- Cannot handle withdrawals part-way through
- Hides volatility entirely — two very different journeys can show the same CAGR
XIRR
Works for you when
- Correct for SIPs, top-ups, partial withdrawals and irregular investing
- Weights every cash flow by its own holding period
- Reduces to CAGR automatically for a single flow
- Available as a built-in spreadsheet function
Watch out for
- Needs a full dated list of every cash flow
- Can behave oddly over very short periods or unusual flow patterns
- Not something you compute in your head
- Easy to mis-enter — investments negative, redemptions positive
How to Decide
The rule is short enough to remember.
- One investment, one exit? CAGR. XIRR would give you the same answer anyway.
- More than one cash flow — a SIP, a top-up, a partial withdrawal? XIRR. CAGR does not apply and will mislead you.
- Comparing your return to a fund factsheet? Match like with like — your SIP XIRR against the fund’s SIP return, your lumpsum CAGR against its point-to-point CAGR.
- Comparing across products? Put everything on post-tax cash flows and use XIRR throughout, or the comparison is not real.
- Judging a short period? Be careful with both. Annualising a few months of movement produces impressive-looking numbers that mean very little.
If you only remember one thing: CAGR is XIRR with a single cash flow. Use XIRR by default and you will never have to decide. Both measure what already happened; to project a rate forward instead, use the future value calculator.
Frequently Asked Questions
Sources and Method
This page explains two standard return calculations. There are no regulatory figures on it.
- CAGR and XIRR are standard financial computations; XIRR is implemented as a built-in function in Excel, Google Sheets and LibreOffice Calc.
- Mutual fund return disclosure conventions — SEBI advertisement and disclosure norms for mutual funds, and AMFI industry practice.
- Figures on this page are illustrations of the arithmetic, not projections of any actual investment.
Last reviewed 17 August 2026. This page is general information, not advice.