The fund brochure says 18% CAGR. Your portfolio shows 11% XIRR. Both numbers are accurate. They're measuring different things. Understanding the difference could change how you evaluate every investment.
The Fundamental Mismatch
Compound Annual Growth Rate (CAGR) answers the question: if I had invested a lump sum on date X, what annual return would explain the NAV movement to date Y? It's a clean, simple metric for lump-sum performance evaluation.
But you didn't invest a lump sum. You invested ₹10,000 every month for 60 months. Your first installment had 60 months in the market. Your last installment had 1 month. The CAGR of the fund measures a different investment pattern than yours. The fund CAGR is not your return.
XIRR (Extended Internal Rate of Return) is the correct metric for SIP investors. It accounts for the timing and size of every cash flow. If you invested ₹10,000 in January 2020 and different amounts in subsequent months, XIRR gives you the single annualized return that makes all those cash flows add up correctly. This is your actual return.
Same CAGR, Different Money: The Sequence Problem
Even more counterintuitive: two funds with identical 10-year CAGR can produce different actual wealth for SIP investors. The reason is the order in which returns occur — the sequence of returns.
This has a positive implication: SIP investors benefit from early market weakness. When the market falls in Year 1 and Year 2, your ₹10,000/month buys more units at lower prices. Those units then grow substantially when the market recovers in Year 4 and Year 5. Dollar-cost averaging works because bad early years allow you to accumulate more units at cheaper prices.
The lesson: stop worrying about market timing for SIP investments. An immediate crash after you start a SIP is actually good news — you're buying more units at a discount.
How Fund Houses Cherry-Pick Windows
Every fund house's marketing team knows that choosing the right 3-year or 5-year window can make any fund look exceptional. Starting the measurement at a market low (like March 2020 COVID crash) and ending at a market high produces spectacular-looking CAGR numbers.
The better metrics: 10-year and 15-year CAGR (captures multiple market cycles), rolling returns (average of all N-year windows since inception), and benchmark comparison (does the fund beat Nifty 50 TRI over 10 years after expenses?). Rolling returns are particularly honest — they can't be cherry-picked because they average all periods.
How to Calculate Your Actual XIRR
Most modern investment platforms make this easy. Zerodha Coin, Kuvera, and Groww all display XIRR prominently. Paytm Money and ET Money also show it. MF Central (the AMFI-run consolidator) shows XIRR across all your funds in one place — free, with your PAN.
If your platform shows XIRR significantly lower than the fund's advertised CAGR: that's expected and not a problem. The gap is the difference between how the fund grew and how your specific investment timing translated to returns. As long as your XIRR beats fixed deposits and inflation (comfortably for long-tenure equity SIPs), the investment is doing its job.
The Rolling Returns Reality for Nifty 50
Nifty 50's rolling 3-year CAGR has averaged approximately 11% over any randomly chosen 3-year window since 2005. Some windows showed -8% (2006-09). Most showed 10-25%. This distribution — one bad period, many good ones — is what long-term equity investing actually looks like.
The implication for SIP investors: if you stay invested through at least one full market cycle (typically 7-10 years), you capture the good windows and dilute the bad ones through continued investment. The math gets dramatically better with patience.
See our related guides: Direct vs Regular plans (don't let expense ratios eat your CAGR), SIP advertised vs actual returns, and the mutual funds hub.
FAQ
What is the difference between CAGR and XIRR in mutual funds?
CAGR (Compound Annual Growth Rate) measures how a single lump-sum investment has grown from point A to point B. It assumes one investment at the start. XIRR (Extended Internal Rate of Return) accounts for multiple investments at different times — which is how SIPs work. For SIP investors, CAGR of a fund is almost always higher than your actual XIRR, because each SIP installment has progressively less time in the market. Always use XIRR for SIP return evaluation.
Why is my actual mutual fund return lower than the fund's advertised CAGR?
Several reasons: (1) The fund's CAGR is point-to-point on a single investment — your SIP installments have different entry points and time horizons. (2) The advertised CAGR might use a cherry-picked start date (often a market low) that makes returns look exceptional. (3) Taxes on gains (LTCG/STCG) and exit loads reduce your actual take-home. (4) Expense ratio drag reduces NAV growth over time. Calculate XIRR using your actual investment dates and current portfolio value for an honest picture.
How do I calculate XIRR for my SIP?
Download your transaction statement from CAMS or KFintech (free with PAN). Open Excel. Create two columns: cash flows (negative for each SIP installment, positive for current portfolio value as of today) and dates (corresponding dates for each transaction). Use formula =XIRR(cash flow column, dates column, 0.1). The result is your annual XIRR. Most modern platforms (Zerodha Coin, Kuvera, MF Central) also display XIRR directly in the portfolio section — look for it there first.
What is a good XIRR for a mutual fund SIP?
For a Nifty 50 index fund SIP over 10+ years, XIRR in the range of 10-14% is realistic and good. Large cap active funds: 11-15% XIRR historically. Flexi cap and mid cap funds: 12-18% XIRR in good periods. XIRR below 8% on a 10-year SIP suggests either poor fund selection or you were unlucky with timing. Debt fund SIPs: 6-8% XIRR is typical. Compare your XIRR against the fund's category average and Nifty 50 benchmark XIRR over the same period.
What are rolling returns and why are they a better metric?
Rolling returns are the average of all CAGR periods of a specific length (say, all 3-year periods since 2000). This eliminates start-date bias. Instead of 'the fund returned 25% in the 3 years ending December 2023,' rolling returns say 'across all 3-year windows from 2003 to 2026, this fund's average 3-year return was 14%.' This is a more reliable predictor of future performance. Value Research Online and Advisor Khoj provide rolling return data for free.
What is the sequence of returns risk for SIP investors?
Sequence of returns risk means identical average returns produce different actual wealth depending on when good vs bad years occur. For SIP investors: early market drops are actually beneficial because you accumulate more units cheaply, which then grow in later bull runs. Late market drops (near withdrawal) are harmful because your accumulated corpus shrinks. This is why SIP investors often hear 'market crashes are a sale.' The real risk for SIP investors is needing to withdraw at the wrong time — build a timeline-appropriate portfolio as you approach your goal.
Should I compare mutual funds by CAGR or XIRR?
Use CAGR only for lump sum investments. Use XIRR for SIP investments — always. For fund comparison, look at 10-year CAGR (lump sum reference), rolling 3-year returns (consistency indicator), and benchmark comparison (does the fund beat Nifty 50 over 10 years?). For your personal portfolio, use XIRR with your actual investment amounts and dates — not fund house-reported CAGR numbers. They're measuring different things.
Related: mutual funds hub · direct vs regular · SIP advertised vs actual