The Return Metric Everyone Misreads
A friend tells you his SIP has a 4% XIRR after three years. You panic — your SIP is in the same fund. The fund's 3-year CAGR on Value Research is 14%. What's happening? Is something wrong? Did he pick a bad fund or a bad period?
Answer: nothing's wrong. XIRR and CAGR measure completely different things. Most Indian investors confuse the two, and that confusion costs them — usually by triggering panic exits in the early years of a SIP. This guide demystifies both metrics and shows when to use each.
CAGR — For Lumpsum Investments
CAGR (Compound Annual Growth Rate) is the steady annual growth rate that would transform a starting value into an ending value over a given period. Formula:
CAGR = (Ending Value / Starting Value)^(1/Years) – 1
Example: you invest ₹1 lakh. After 5 years, it's ₹2 lakh. CAGR = (2/1)^(1/5) – 1 = 14.87%. That means your money grew at an effective 14.87% per year, compounded.
CAGR works perfectly for lumpsum investments: one buy, one sell, one number.
XIRR — For SIPs and Irregular Cash Flows
XIRR (Extended Internal Rate of Return) handles the real-world messiness of SIPs, where you make dozens of separate investments at different dates and different prices. XIRR finds the single annualised rate that makes the net present value of all cash flows equal to zero.
Think of it as the annualised return each rupee earned, weighted by when it was invested. An instalment made 5 years ago has had more compounding time than one made 3 months ago — XIRR accounts for this.
Formula: there's no clean closed-form. It's solved numerically (Excel has an XIRR function). What matters is what XIRR represents: the annualised return on your irregular cash flows.
Why XIRR Swings Wildly in the Early Years
This is the crucial insight. In the first few years of a SIP, your portfolio is dominated by recent contributions. A market correction affects those recent units disproportionately in the XIRR calculation.
Example. You run a ₹10,000 monthly SIP for three years. Total invested: ₹3.6 lakh. After an 18% market correction, portfolio value is ₹4 lakh. XIRR is roughly 4%.
But the fund's CAGR over the same 3 years might be 14% — because CAGR measures the fund's NAV growth, not the outcome for your specific SIP schedule.
Why the gap? Because most of your recent SIP instalments are now under water. The older ones (at lower prices) are fine. CAGR doesn't care about when you bought; XIRR does.
The Side-by-Side Table
MetricCAGRXIRR Use caseLumpsumSIP / irregular cash flows Number of cash flowsTwo (buy and sell)Many (monthly contributions + final value) Accounts for timing?Only start and end datesEvery cash flow date Sensitivity to recent eventsLowHigh in young portfolios Used by fund factsheetsYes, for published returnsNo, too user-specific Used by your MF platformFor underlying fundFor your personal returns
When to Use Each Metric
- Comparing two funds: use CAGR. It's the fund's performance irrespective of when you invested.
- Measuring your own SIP returns: use XIRR. It's your actual, personal, timing-dependent outcome.
- Evaluating lumpsum purchase: CAGR works fine.
- Evaluating ongoing SIP plus occasional lumpsum: XIRR is the only honest metric.
- Comparing yourself vs a benchmark: compute both a portfolio XIRR and a benchmark XIRR assuming the same cash flows went into the index. Then compare.
The 18-Month Trap
Most SIP investors check returns too early. An 18-month-old SIP XIRR is almost meaningless as a fund quality signal. It reflects recent market moves far more than fund manager skill.
Useful rule: wait at least 5 years of SIP history before judging your XIRR against the fund's category average. Before that, the noise drowns out the signal.
Common Misinterpretations
- "My fund's CAGR is 15% but my XIRR is 5% — my fund is bad." Wrong. Your fund is fine. Your XIRR is a function of your cash flow timing and recent market moves.
- "My XIRR went up 8 percentage points this quarter — my fund is great." Wrong again. A market rally compressed into a short period lifts young SIP XIRRs dramatically, but the underlying fund hasn't changed.
- "Fund A shows 12% CAGR, Fund B shows 10% CAGR — A is better." Only if both had the same 3-year window, same category, same benchmark. Otherwise, the comparison is structurally flawed.
- "Rolling XIRR shows my investment returned X%." Rolling returns flatten timing noise but add their own caveats — they depend on sample period and methodology.
- "I should switch funds because my XIRR dropped." Drop in early XIRR is rarely a fund problem. Check the fund's category-relative performance before acting.
How to Read XIRR Correctly in Your App
When your Kuvera/Groww/INDmoney app shows a SIP XIRR:
- Note the age of the SIP. Under 3 years: XIRR is too noisy to judge.
- Compare with the fund's NAV-based CAGR for the same period. Big gaps are usually timing artifacts, not fund issues.
- Look at rolling 3-year XIRR over multiple points in time. Consistency matters more than one snapshot.
- Check the benchmark's returns assuming the same cash flows. Your XIRR is "good" or "bad" only relative to this.
- Don't annualise tiny periods. A 6-month XIRR of 60% doesn't mean you'll earn 60% per year. Annualising short windows produces nonsense.
Frequently Asked Questions
If XIRR is so noisy, why does my app show it?
Because it's the only honest way to report personalised returns when you have multiple contributions at different dates. The noise is real; hiding it wouldn't help.
Can a SIP have negative XIRR even if the fund is up?
Yes, in the first 12–18 months if markets correct hard after your recent instalments. It doesn't mean the fund lost money — it means your average buy price is above the current NAV.
How do I compute XIRR myself?
In Excel or Google Sheets: list dates and cash flows (negative for purchases, positive for redemptions/ending value), then use =XIRR(values, dates). It gives the annualised return.
Is XIRR the same as IRR?
Close, but not identical. IRR assumes cash flows happen at equal intervals; XIRR handles arbitrary dates. For real-world SIPs with skipped months or varying dates, XIRR is correct.
Does XIRR include taxes?
No. XIRR is computed on gross portfolio values. Post-tax returns will be lower, depending on your redemption pattern and tax bracket.
Can I compare two different SIPs using XIRR?
Yes, but only if both had similar durations. A 3-year SIP XIRR vs a 10-year SIP XIRR is an apples-to-oranges comparison because age dramatically affects SIP XIRR behaviour.
The Final Word
XIRR is a powerful, honest measurement — but only once your SIP has enough history (at least 5 years) for the noise to settle. Before that, use it as a reporting tool, not a judgement tool. For fund selection and benchmarking, use CAGR. For personal performance in later years, XIRR tells the truth. Confuse the two, and you'll make decisions on phantom returns. Distinguish them, and you'll read your portfolio accurately.