You open your investment app on a lazy Sunday, scroll to the fund you have been feeding ₹10,000 a month for years, and the app says your return is 11.4%. Then you visit the fund’s own page. It says the scheme has delivered 17.8% over ten years. Same fund. Same money. Two numbers that refuse to agree.
Nobody is cheating you. The complete investing roadmap for Indian investors covers how SIPs work mechanically, but this piece goes after the specific thing that confuses almost everybody: the SIP vs advertised mutual fund returns gap, and why it is baked into the arithmetic rather than hidden in the fine print.
The Fund Page Is Answering a Question You Never Asked
When a fund advertises “17.8% over 10 years,” it is describing one very specific investor: someone who put a single lump sum into the scheme on a particular date exactly ten years ago and did not touch it again.
That investor does not exist in most portfolios. You did not invest one lump sum. You invested 120 separate lump sums, on 120 different dates, at 120 different NAVs. Your first instalment has been compounding for a decade. Your most recent one has been invested for three weeks.
Measuring both with the same yardstick is like comparing a marathon runner’s finish time to a relay team where runners kept joining halfway through the race.
CAGR vs XIRR: The Root of the Confusion
CAGR measures the fund. XIRR measures you.
CAGR (Compound Annual Growth Rate) assumes one entry and one exit. It takes the NAV on day one, the NAV on the last day, and smooths the journey into a single annual rate. It is a time-weighted number, which makes it a fair way to judge a fund manager, because it ignores when investors happened to put money in.
XIRR (Extended Internal Rate of Return) handles messy, real-life cash flows. It knows your ₹10,000 landed on the 5th of every month, that you paused for four months in 2023, and that you topped up ₹50,000 once. It is a money-weighted number, which makes it the only honest measure of what your money actually earned.
So the two figures are not competing. They are measuring different things:
- CAGR answers: How well did this scheme perform between these two dates?
- XIRR answers: Given the dates I actually invested on, what rate did my rupees compound at?
A fund can post a brilliant CAGR while its SIP investors earn far less. It can also post a modest CAGR while SIP investors quietly do beautifully. Which brings us to the part almost nobody explains properly.
The Sequence of Returns Decides Your Fate
Here is a comparison that makes the whole thing click. Two funds, ten years each, identical ₹10,000 monthly SIP, identical ₹12,00,000 invested.
- Fund A: Grows 25% a year for the first five years, then 5% a year for the last five.
- Fund B: Grows 5% a year for the first five years, then 25% a year for the last five.
Both funds finish with exactly the same ten-year CAGR: 14.6%. On a fund factsheet, they look like twins. Now look at what an SIP investor actually ends up with.
| Measure | Fund A (strong early) | Fund B (strong late) |
|---|---|---|
| Advertised 10-yr CAGR | 14.6% | 14.6% |
| Total invested via SIP | ₹12,00,000 | ₹12,00,000 |
| Final corpus | ≈ ₹20.7 lakh | ≈ ₹31.6 lakh |
| Your actual SIP XIRR | ≈ 10.7% | ≈ 18.7% |
Nearly ₹11 lakh separates two funds with identical advertised returns. The difference is not skill or fees. It is when the good years showed up relative to when your money showed up.
Fund A rallied while your SIP balance was tiny and stalled once your corpus got big. Fund B did the opposite. That is the entire story of the SIP vs advertised mutual fund returns gap in one table.
Your Money Has Not Been Invested As Long As You Think
Run a ten-year SIP and it feels like a ten-year investment. It is not. The average rupee in that SIP has been invested for roughly five years, because half your instalments arrived in the second half of the period.
This has two consequences most investors never internalise:
- Recent performance dominates your number. By year eight or nine, a single bad quarter moves more rupees than the entire first three years did. Your XIRR swings hard on recent moves.
- Comparing your XIRR to a 10-year CAGR is unfair to yourself. The honest comparison is against the fund’s roughly five-year performance, or better, against the fund’s own published SIP returns.
This is also why a two-year-old SIP showing 4% is not a broken fund. It is a fund whose money has barely had time to work. Two years is noise. This is why deciding how much of your salary goes where matters more early on than obsessing over which fund topped last year’s chart, because allocation is what you control and sequence is what you do not.
The Entry Point You Were Never Offered
Point-to-point returns are extremely sensitive to their start date, and start dates on fund pages are set by the calendar, not by fairness.
A “5-year return” quoted in early 2025 starts from the March 2020 COVID crash. That is close to a generational bottom for Indian equities. Almost every equity fund looks like a genius from that base. Shift the start date six months earlier and the same fund’s five-year number drops several percentage points.
You could not have bought at that exact bottom. Nobody could. Your SIP bought a bit at the bottom, a bit near the top, and a lot in between. That averaging is a feature, not a flaw, but it guarantees your entry price will never match the flattering one on a factsheet.
What to look at instead: rolling returns
Rolling returns take every possible start date over a period and calculate the return for each. Instead of one cherry-picked number, you get a distribution: best case, worst case, and how often the fund cleared 12%.
A fund with a 16% point-to-point CAGR but 5-year rolling returns ranging from 3% to 24% is a very different animal from one averaging 14% with a range of 10% to 18%. The second one is far more likely to give you an experience close to what is advertised.
Four Smaller Leaks That Widen the Gap
Sequence and timing explain most of the difference. These four explain the rest.
- Regular vs direct plan. You may be comparing your regular plan holding against the direct plan number. The distributor commission inside a regular plan typically costs 0.5% to 1% a year, and over a decade that compounds into a visible dent.
- Exit loads. Most equity funds charge around 1% if you redeem within a year. Every SIP instalment has its own clock, so a redemption after five years can still trigger a load on your last twelve instalments.
- Taxes. Advertised returns are always pre-tax. Under current rules, long-term capital gains on equity funds above ₹1.25 lakh a year are taxed at 12.5%, and short-term gains at 20%. Your post-tax XIRR is the only one that pays for anything.
- The IDCW trap. If you hold the IDCW (dividend) option, every payout reduces the NAV. Unless you have reinvested those payouts and your app is tracking them, your displayed return will look artificially low.
How to Calculate Your Real Return in Ten Minutes
Stop guessing. Do this instead:
- Pull your Consolidated Account Statement (CAS) from CAMS or KFintech. It is free and covers every fund you hold across AMCs.
- Open a spreadsheet. In one column list every SIP date; in the next, the amount as a negative number (money going out).
- On the last row, enter today’s date and your current value as a positive number.
- Use
=XIRR(values, dates). That percentage is your genuine annualised return.
Do it once a year, not once a week. Checking a money-weighted return monthly is a fast route to bad decisions.
So What Should You Actually Do About It?
- Compare like with like. Judge your SIP XIRR against the fund’s published SIP return for the same period, never against its lump-sum CAGR.
- Give it a fair window. Under five years, your XIRR says more about the market cycle than about the fund.
- Check rolling returns before you buy. Consistency beats a single dazzling headline number.
- Switch to direct plans if you are comfortable doing your own research. It is the one part of this gap you can close by filling a form.
- Do not exit because the gap exists. Exiting a fund because your XIRR lags its CAGR usually means selling something that has just been through a weak stretch, which is exactly when future SIP instalments become most valuable.
The Uncomfortable, Freeing Truth
Advertised returns are marketing wrapped around real math. They are not fabricated, but they describe a hypothetical investor with perfect timing and infinite patience, not you.
Your XIRR being lower is usually a sign the market rose before your corpus grew, not a sign you picked badly. And the flip side is genuinely good news: if you keep investing through a flat or falling stretch, you are quietly loading up units at low prices, and your XIRR can eventually finish above the fund’s CAGR. Every long-term SIP investor who kept going through a dull patch has experienced this.
Market cycles are the engine underneath all of this, which is why it helps to understand the broader picture of India’s economy and where the risks sit rather than reading a single percentage as a verdict on your choices.
Track your XIRR. Ignore the poster. Keep the SIP running.
Frequently Asked Questions
Is XIRR always lower than CAGR?
No. When a fund’s strongest years come late in your SIP period, your XIRR can comfortably exceed the fund’s CAGR. It is lower only when the big gains happened while your invested amount was still small.
Which number should I use to compare two funds?
Use CAGR or rolling returns to compare funds against each other, since both are time-weighted and independent of cash flows. Use XIRR only to measure your own portfolio.
My SIP is three years old and shows 6%. Should I switch?
Probably not on that basis alone. Check whether the fund is lagging its benchmark and category peers over the same window. If it is roughly in line with them, you are looking at a market cycle, not a bad fund.
Does my SIP date affect returns?
Barely. Over long periods the difference between the 1st, 15th and 25th of the month is statistically insignificant. Pick a date just after your salary lands so the instalment never bounces.
Why does my app’s return differ from my spreadsheet XIRR?
Apps show different things: absolute return, annualised return, or XIRR. Some exclude redemptions or switches. Check the label before you panic, and treat your CAS-based calculation as the source of truth.
