Why Your Mutual Fund Returns Don’t Match Your Statement

Why Your Mutual Fund Returns Don't Match Your Statement

Investors get excited when they see a mutual fund advertisement claiming a whopping 25% Trailing Return. But after buying the fund and checking the Consolidated Account Statement (CAS), one may find the actual returns to be close to -30%.

“Are the fund houses running a scam?”

No. The fund house isn't lying, and your app isn't broken. You are just looking at two completely different mathematical scoring systems: CAGR and XIRR.

Here is why they don't match, and which one actually tells the truth about your fund.

Advertised, Static CAGR vs. Personalized, Path-Sensitive XIRR

The advertised return rate, or the Compound Annual Growth Rate (CAGR), is used in the calculations for a lump-sum investment, where the entire fund gets the same time to compound and grow undisturbed. So, CAGR is affected only by the entry and exit point NAVs of the investment. It is not affected by any market fluctuations happening in between.

On the other hand, monthly SIP investment calculations use the Extended Internal Rate of Return (XIRR), where the computation accounts for each monthly installment having different time durations to compound. Thus, the XIRR is affected by the journey that a fund’s NAV takes during market volatility, between the entry and exit points of the investor’s investment.

The advertised CAGR rate, like 25% as used in the example, follows SEBI’s guidelines, cited in the Master Circular for Mutual Funds, 2026 (Chapter 14, 14.2.1(a)).

The XIRR reported on investment dashboards is still the annualized return rate and will be identical to the reported return rate on the advertisement, under perfectly calm market conditions for the duration of the investment.

XIRR and CAGR Are Different in a Volatile Market

Under a rising market, the CAGR is still the same at 25%. But the final annualized XIRR here changes.

MonthDateSIP AmountNAV on the DateUnits Allotted (Amount / NAV)
1Jan 1₹1,000₹10.00100
2Feb 1₹1,000₹12.0083.3333
3Mar 1₹1,000₹14.5068.9655
4Apr 1₹1,000₹16.0062.5
5May 1₹1,000₹18.5054.0540
6Jun 1₹1,000₹20.5048.7804
7Jul 1₹1,000₹21.00 (Peak)47.6190
8Aug 1₹1,000₹19.0052.6315
9Sep 1₹1,000₹17.5057.1428
10Oct 1₹1,000₹15.5064.5161
11Nov 1₹1,000₹14.0071.4285
12Dec 1₹1,000₹12.5080

For simplicity, we're treating the ~11-month Jan-to-Dec window as one year for this comparison. In practice, CAGR would be annualized precisely to the exact number of days held.

Total SIP Invested = ₹12,000
Total Units Accumulated = 790.9711 units
Starting NAV (Jan 1) = ₹10.00
Ending NAV (Dec 1) = ₹12.50

Ending Portfolio Value = Total Units Held × Latest Available NAV
Weighted Average Unit Cost = Total Cash Spent / Total Units Bought

For our example,

Ending Portfolio value = 790.9711 units × ₹12.50 = ₹9,887.14
Weighted Average Unit Cost = ₹12,000 / 790.9711 units = ₹15.17 per unit

Now, the XIRR (annualized rate) for the above investment can be calculated using the monthly cash outflow of ₹1,000, the ending portfolio value, and the dates of investments, as below,

0  =  ΣMonthly Cash Flow(1 + annualized rate)Time Fraction in Years

The annualized rate can be solved from the above formula using trial and error or a numerical iteration solution method only.

For our example, the XIRR = -35.5%

This XIRR of -35.5% reported on the investor’s dashboard is vastly different from the advertised 25% CAGR. It is even showing a massive loss.

The fund’s CAGR correctly computes the growth to be 25%, based on a hypothetical initial lump-sum investment of ₹12,000, made all on a single day (Jan 1). The fund NAV grew from ₹10 (Jan 1) to ₹12.50 (Dec 1), and this growth is reported as a CAGR.

For a SIP, there is no single start NAV to compare with. Comparing the Weighted Average Unit Cost (₹15.17) to the Ending NAV (₹12.50) tells one, in plain rupee terms, that the investor is sitting on a loss. But your statement's XIRR figure goes a step further; it also accounts for how long each installment was actually invested, which is why the annualized XIRR (-35.5%) shows such a steep loss.

Why SIPfund?

We are an AMFI-registered mutual fund distributor, and we support investors when they need help in goal planning, fund selection, and during market volatility.

Our SIPfund App provides easy fund selection and investment review to its investors through algorithm-powered planning and consolidated tracking. The money invested in the fund houses is also well protected through the use of NSE’s secure mutual fund platforms.

The Final Verdict

CAGR tells you where the fund started and ended. XIRR tells you what actually happened to your fund along the way. A positive CAGR with a negative XIRR can feel alarming. But it just means that the fund made money overall, even though your personal entry points hit a rough patch.

You can check the current Returns of your funds easily on the SIPfund App (iOS or Android).

If you still have any questions about the advertised fund CAGR and your actual Returns on the App, call our experts at 95133 55661, and they will walk you through it.

Disclaimer: The information provided in this article is for educational purposes only and does not constitute investment advice or a recommendation to buy or sell any mutual fund. Mutual Fund investments are subject to market risks, read all scheme-related documents carefully.