XIRR vs CAGR — Which One Really Shows Your Mutual Fund Returns?

Open any mutual fund portfolio app and you will see two different return numbers — XIRR and CAGR — often showing different values for the same investment. Many investors are confused about which one represents their actual return. This guide explains both clearly and tells you exactly when to use which.

What is CAGR?

CAGR stands for Compound Annual Growth Rate. It measures the growth of a single lump-sum investment from one point to another, expressed as an annualised percentage.

Formula: CAGR = (Ending Value ÷ Beginning Value)^(1/Years) − 1

Example: You invested ₹1,00,000 in a mutual fund 5 years ago. Today it is worth ₹1,76,234.

CAGR = (1,76,234 ÷ 1,00,000)^(1/5) − 1 = 12% per year

This means your investment grew at exactly 12% per year, compounded annually. Simple and clean — because there was only one cash flow (the initial investment).

What is XIRR?

XIRR stands for Extended Internal Rate of Return. It is used when there are multiple cash flows at different times — which is exactly what happens with SIP investments.

With a monthly SIP, you invest ₹5,000 on the 5th of every month. Each of these ₹5,000 instalments enters the fund at a different NAV and has been invested for a different number of months. CAGR cannot handle this — it only works with one investment date. XIRR calculates the single annualised return rate that makes all those cash flows and the final value consistent.

Example: You started a ₹5,000 monthly SIP 3 years ago (36 instalments = ₹1,80,000 total invested). Current portfolio value: ₹2,28,500. Your XIRR works out to approximately 15.4% — that is the effective annualised return on your actual cash flows.

Why XIRR and CAGR Often Show Different Numbers

Consider this scenario: A fund's CAGR over 5 years is 14%. But your XIRR on the same fund, investing via SIP, might show 11% or 17% depending on when you started your SIP relative to market cycles.

This is not a mistake — it is the correct answer to different questions:

• CAGR answers: "How did the fund perform as an investment vehicle over this period?"
• XIRR answers: "What return did I personally earn on my actual money invested at my actual timing?"

If you started your SIP just before a bull run, your XIRR will be higher than the fund's CAGR. If you started just before a crash, your XIRR may be lower — even though the fund's long-term CAGR is strong.

When to Use CAGR

Use CAGR when:

• Comparing two funds' historical performance (both funds had the same investment amount at the same date)
• Evaluating a lump-sum investment you made at one specific time
• Reading fund factsheets — the 1Y, 3Y, 5Y returns shown are always CAGR
• Comparing fund performance vs benchmark (benchmark returns are stated as CAGR)

When to Use XIRR

Use XIRR when:

• Calculating your personal SIP returns — the only correct method
• Any situation with multiple investment dates (additional purchases, top-ups, partial redemptions)
• Calculating total portfolio XIRR across multiple funds
• Comparing your actual result vs a fixed deposit or other instrument over the same period

Most portfolio tracking apps (Kuvera, Zerodha, Groww) show XIRR for your personal portfolio because that is the accurate personal return measure. When they show "fund returns," they use CAGR.

Absolute Returns — A Third Term You'll See

Many apps also show "absolute returns" — the simple total percentage gain without annualising. If you invested ₹1,00,000 and have ₹1,30,000, absolute return is 30%. This is useful only for short periods (under 1 year). For anything over 1 year, always use XIRR or CAGR — absolute returns are misleading because they don't account for how long the money was invested.

Quick Summary Table

Conclusion

For your SIP portfolio, always look at XIRR — it is the only accurate measure of your personal return. For comparing funds or reading historical performance, use CAGR. Never evaluate a long-term investment using absolute returns. Use TopFund's SIP calculator to project future corpus with realistic CAGR assumptions, and track your personal XIRR in your fund house app or on Kuvera.