What Is the Difference Between XIRR and CAGR?
CAGR is the yearly growth rate of one lump sum from start to end. XIRR is the annualised return across many cash flows on different dates, like a SIP. That is why a fund can show a 14% 3-year CAGR on Value Research while a 3-year SIP in the same fund shows a 4% XIRR after a correction.
Nothing is wrong in that case. The two numbers measure different things. Mixing them up can push you into a panic exit in the early years of a SIP, so here is how each one works and when to use it.
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, and 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
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 ₹3.84 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.
XIRR vs CAGR Side by Side
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.
Why an 18-Month XIRR Tells You Little
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%, so 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, so 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 and Fund B shows 10% CAGR, so 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, since 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 read anything into, and the rule above is to wait 5 years before judging it against the category.
- 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
Use CAGR to compare funds and XIRR to measure your own SIP, and give the XIRR at least 5 years before you judge the fund by it.