XIRR vs CAGR: Why Your SIP Returns Can Look Wrong for Years

XIRR vs CAGR: Why Your SIP Returns Can Look Wrong for Years
On this page
Tool for this guideCompute your SIP XIRR Open

What Is the Difference Between XIRR and CAGR?

CAGR is the yearly growth rate of one lump sum from a start value to an end value. XIRR is the annualised return across many cash flows on different dates, like a SIP. Use CAGR to judge a fund and XIRR to judge your own SIP: in the worked example below, the same fund shows an 8.3% CAGR while two SIPs in it show XIRRs of 3.7% and 13.4%.

Nothing is wrong when the two numbers disagree. They 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 turn 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%. Your money grew at an effective 14.87% a year, compounded.

CAGR works perfectly for lumpsum investments: one buy, one sell, one number. It only looks at the two end points, so it says nothing about what happened in between.

XIRR: For SIPs and Irregular Cash Flows

XIRR (the "extended" internal rate of return, named after the Excel function) handles SIPs, where you make dozens of separate investments on different dates at different prices. It finds the single annualised rate at which the present value of all your cash flows, including the current value, nets to zero.

Think of it as the annualised return each rupee earned, weighted by how long it was invested. An instalment made 5 years ago has had more time to compound than one made 3 months ago, and XIRR accounts for this.

There's no closed-form formula. It's solved numerically, which is what Excel's XIRR function and our XIRR calculator do.

Worked Example: One Fund, One CAGR, Two Very Different XIRRs

Illustrative example, computed with a script. Two investors each run a ₹10,000 monthly SIP for 5 years (1 January 2021 to 1 December 2025), ₹6 lakh in total, and value it on 1 January 2026. The NAV starts at ₹100 and ends at about ₹148.7 in both cases, so the fund's 5-year CAGR is the same 8.3%. Only the path in between differs.

SIP A: rise first, fall at the endSIP B: fall first, rise later
NAV path (assumed)+15% a year for 4 years, then −15% in year 5−15% in year 1, then +15% a year for 4 years
Fund CAGR, start to end NAV8.3%8.3%
Total invested₹6,00,000₹6,00,000
Value on 1 Jan 2026About ₹6.6 lakhAbout ₹8.4 lakh
SIP XIRR3.7%13.4%

SIP A bought most of its units at high prices and then took the fall. SIP B bought many cheap units early and rode the recovery. The fund did exactly the same thing from start to finish in both cases, which is all CAGR sees.

One more trap: don't plug a SIP's total invested and final value into the CAGR formula. For SIP B, (8.4 / 6)^(1/5) − 1 gives about 6.9%, well below the true 13.4%, because it pretends all ₹6 lakh was invested on day one. Check your own figures with the XIRR calculator for a SIP and the CAGR calculator for a lump sum.

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 hits those recent units hardest 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, the portfolio is worth ₹3.84 lakh. XIRR is about 4%.

The fund's CAGR over the same 3 years might still be 14%, because CAGR measures the fund's NAV growth, not the outcome of your SIP schedule. Most of your recent instalments are under water, while the older ones bought at lower prices are fine. CAGR doesn't care when you bought; XIRR does. If a fall like this has you thinking of stopping, read whether to pause a SIP in a market crash first.

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 the underlying fundFor your personal returns

When to Use Each Metric

  • Comparing two funds: use CAGR over the same period. It's the fund's performance irrespective of when you invested.
  • Measuring your own SIP returns: use XIRR. It's your actual, timing-dependent outcome.
  • Evaluating a lumpsum purchase: CAGR works fine. For how the two approaches compare, see lumpsum vs SIP.
  • Evaluating an ongoing SIP plus occasional lumpsums: XIRR is the only honest metric.
  • Comparing yourself with a benchmark: compute a benchmark XIRR assuming the same cash flows went into the index, then compare it with your portfolio XIRR.

Why an 18-Month XIRR Tells You Little

Most SIP investors check returns too early. An 18-month SIP XIRR is almost meaningless as a signal of fund quality. It reflects recent market moves far more than the fund manager's skill.

A useful rule: wait for 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." Not necessarily. Your XIRR depends on your cash-flow timing and recent market moves.
  • "My XIRR went up 8 percentage points this quarter, so my fund is great." A rally compressed into a short period lifts young SIP XIRRs sharply, 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 cover the same period, category and benchmark. Otherwise the comparison is flawed.
  • "Rolling returns show my investment returned X%." Rolling returns smooth out timing noise but depend on the sample period and method.
  • "I should switch funds because my XIRR dropped." A drop in early XIRR is rarely a fund problem. Check the fund's performance against its category first.

How to Read XIRR Correctly in Your App

When your mutual fund app or CAS shows a SIP XIRR:

  1. 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.
  2. Compare with the fund's NAV-based CAGR for the same period. Big gaps are usually timing effects, not fund issues.
  3. Look at XIRR at several points in time. Consistency matters more than one snapshot.
  4. Check the benchmark's return assuming the same cash flows. Your XIRR is "good" or "bad" only relative to this.
  5. Don't annualise tiny periods. A 6-month XIRR of 60% doesn't mean you'll earn 60% a year.

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. To plan what a SIP could grow to, try the SIP calculator, and find more fund guides in the mutual funds hub.

Questions about this for your own money?

Ask FinChat, our AI planning assistant, how this applies to you. Free to try, no signup.

Ask FinChat

Sources

  • SEBI — Return calculation methodology for mutual funds
  • AMFI — Investor education material on XIRR and CAGR
  • Value Research — XIRR behavior analysis in early-stage SIPs

How we research: figures are taken from official sources with the date they were checked. Read our editorial policy, or spot a mistake? Report a correction.