Why Mutual Fund Returns Differ: CAGR vs XIRR Explained (2025)
Why Your Mutual Fund Returns Look Different From Factsheets & Platforms (2025 Guide)
Investing in mutual funds has become one of the most popular ways for Indians to grow wealth. Whether you are using platforms like Groww, Zerodha, or Paytm Money, you might have noticed something confusing—the returns shown on your app or in the mutual fund factsheet don’t always match the returns you actually see in your portfolio.
For example, the factsheet might show a 12% CAGR (Compound Annual Growth Rate), but when you check your SIP investments, you may only see 9% or 10% growth. Many new investors feel frustrated or even cheated when they see this difference. But the truth is—there’s nothing wrong.
“Not sure how the stock market works? Here’s a complete beginner’s guide to the basics of stock investing.”
Basics of the Stock Market for Beginners. Complete Guide
In this guide, we’ll break down exactly why your mutual fund returns look different, what terms like CAGR and XIRR mean, and how to correctly interpret your portfolio performance. By the end, you’ll know how to read your returns like a pro.
“If you are new to investing, first understand how to open a Demat & Trading account online in India.”
How to Open a Demat & Trading Account Online in India (2025 Beginner’s Guide)
1. The Common Confusion: “Why Don’t My Returns Match?”
Let’s say you invest ₹5,000 per month in a mutual fund through SIP. After 3 years, you check the factsheet of that fund, which shows a 3-year CAGR of 12%. Naturally, you expect that your SIP should also give you close to 12%.
But when you look at your portfolio, your returns are showing 10% XIRR.
This makes you think—“Am I getting less than promised? Is the fund not performing as expected?”
The answer is simple: CAGR and XIRR are two different ways of calculating returns. They are both correct but represent different things.
2. Understanding CAGR (Compound Annual Growth Rate)
-
CAGR is the most common return figure you see in factsheets.
-
It assumes that you invested a lump sum amount at the start and held it until today.
-
For example, if you had invested ₹1,00,000 three years ago, CAGR tells you the average annual growth rate of that investment.
Formula for CAGR:
-
Final Value = Value of investment at the end
-
Initial Value = Value of investment at the beginning
-
n = Number of years
👉 Important: CAGR does not consider SIPs, partial withdrawals, or multiple cash flows. It’s only for a lump sum.
3. Understanding XIRR (Extended Internal Rate of Return)
-
XIRR is used when you invest through SIPs or make multiple transactions.
-
It calculates the actual annualized return considering all cash inflows (your SIPs) and outflows (withdrawals).
-
Platforms like Groww and Zerodha show XIRR for your personal portfolio.
XIRR Formula =XIRR(values, dates)
values = Cash flows (your SIP payments are negative, redemption/final value is positive).
-
dates = Dates of each cash flow.
👉 This is why your returns look different—you are investing monthly, while the factsheet assumes one-time investment.
4. Real-Life Example: SIP vs Lump Sum
Let’s assume:
-
You invest ₹5,000 every month for 3 years (total ₹1,80,000).
-
The fund grows well and at the end of 3 years, your value is ₹2,25,000.
Now apply:
=XIRR(B2:B37, A2:A37)
Now let’s compare:
-
CAGR (lump sum): If you had invested ₹1,80,000 at once, the CAGR might look like 12%.
-
XIRR (SIP): Since you invested gradually, your average holding period for most units is less than 3 years, so your XIRR might come around 10%.
👉 Both numbers are correct—they just represent different realities.
5. Other Factors That Create Return Differences
Apart from CAGR vs XIRR, a few more factors can make your returns look different:
(a) Expense Ratio
Mutual funds charge a small fee for managing your money. This is automatically deducted and reflected in your returns.
(b) Timing of SIP
If the market was high when some of your SIP installments went in, your returns may look slightly lower.
(c) Exit Loads & Taxes
If you sell within a short time, exit loads or capital gains tax may reduce your effective return.
(d) Platform Calculation Style
Different platforms may display returns slightly differently—some round off numbers, while others use exact formulas.
6. Why This Difference Is Normal (and Nothing to Worry About)
Many new investors panic when their personal SIP returns don’t match the “12% CAGR” they see in brochures or apps. But here’s the truth:
-
The factsheet CAGR is just a standardized marketing number.
-
Your actual XIRR is the true picture of your personal investment journey.
Think of CAGR as the “fund’s average speed” and XIRR as “your personal speed based on when you joined the ride.”
“Also, learn the difference between a Demat and a Trading account before you begin your SIP journey.”
Demat vs Trading Account: Key Differences & How to Open in 2025
7. How to Read Your Mutual Fund Returns Smartly
Here are some practical tips:
-
Always check XIRR for SIPs – This shows your real returns.
-
Don’t compare your XIRR with fund CAGR directly – They are different calculation styles.
-
Focus on long-term horizons – Over 5–10 years, XIRR usually comes close to CAGR.
-
Track consistency – Instead of chasing high CAGR funds, look for stability and lower volatility.
-
Use calculators – Many websites provide XIRR and CAGR calculators for better clarity.
8. Tools to Help You
Here are some tools where you can calculate or verify returns:
-
Groww App – Shows XIRR for SIPs.
-
Zerodha Coin – Portfolio analysis with XIRR.
-
Valueresearchonline & Morningstar – Compare fund CAGR, rolling returns, and SIP returns.
-
Excel/Google Sheets – Use the XIRR formula for manual calculation.
9. Key Takeaway
If your mutual fund returns look different from the factsheet or app, don’t panic.
-
CAGR is a benchmark used for comparison.
-
XIRR is your real return, especially if you are investing through SIP.
Understanding this difference will help you make better decisions, avoid unnecessary worry, and stay focused on your long-term wealth-building journey.
Final Words
The stock market rewards patience and discipline, not panic. Instead of comparing your returns blindly with factsheets, always interpret them correctly. As long as your XIRR is close to the long-term CAGR of the fund, you are on the right track.
So, next time you see your SIP returns showing 10% while the factsheet says 12%, you’ll know it’s perfectly normal—and you’re still growing wealth steadily.
Comments
Post a Comment