Understanding how mutual fund returns are calculated is not a technical exercise — it is a practical necessity for every investor who wants to evaluate whether their fund is actually performing as expected, compare funds meaningfully, and make informed decisions about continuing, switching, or exiting an investment. Mutual fund returns are expressed in several different ways — absolute return, CAGR, XIRR, and rolling returns — and each tells a different part of the performance story. Knowing which metric to use in which context prevents the common mistake of comparing funds on numbers that are not actually measuring the same thing.
Absolute Return — Simple but Limited
Absolute return is the simplest measure: the percentage change in investment value from start to end, regardless of time. If you invested ₹1,00,000 and it became ₹1,30,000, the absolute return is 30%.
The limitation is obvious — this 30% could have been earned in 1 year (excellent) or 5 years (modest). Absolute return does not account for time, making it useful only for comparing investments held over identical periods. It is the most appropriate metric for investments held less than one year.
CAGR — Compounded Annual Growth Rate
CAGR is the standard return metric for evaluating lump sum investments held over one year or more. It expresses the annual growth rate that would take an investment from its starting value to its ending value over a specific period, assuming compounding.
The formula: CAGR = (Ending Value / Beginning Value) ^ (1 / Number of Years) − 1
If you invested ₹1,00,000 and it grew to ₹2,00,000 over 5 years, the CAGR is approximately 14.87%. This means the investment grew at an effective rate of 14.87% per year on a compounded basis — even though some years may have returned 25% and others returned -5%.
CAGR is appropriate for evaluating the historical performance of a mutual fund on a 1-year, 3-year, 5-year, or 10-year basis. When you see a fund’s “5-year returns” expressed as 18%, that is its 5-year CAGR — not that it returned 18% in every single year.
XIRR — For SIP Returns
CAGR works for lump sum investments where a single amount is invested at one point and redeemed at another. For SIP investments — where you invest at multiple different dates and amounts — CAGR produces an inaccurate picture because different instalments have different investment periods.
XIRR (Extended Internal Rate of Return) accounts for the timing and amount of each cash flow — each SIP instalment and any partial redemptions — to calculate the actual annualised return on your SIP portfolio. It is the correct metric for evaluating the performance of an ongoing or completed SIP.
Most mutual fund platforms — Zerodha Coin, Groww, Angel One — display XIRR as the return on your SIP portfolio. If your platform shows 15% returns on your SIP, that is the XIRR — the annualised return on your actual invested cash flows given the specific dates and amounts of each instalment.
Rolling Returns — The Most Honest Consistency Measure
Absolute return, CAGR, and XIRR all measure performance over a single fixed period. Rolling returns measure performance across all possible periods of a given length within a historical window — and this is the most honest picture of consistency.
A fund’s 5-year rolling return calculates the 5-year CAGR starting from every possible date in the fund’s history — January 2010 to January 2015, February 2010 to February 2015, and so on — and shows what percentage of those periods delivered positive returns and what the average, minimum, and maximum CAGR was. A fund that shows consistently positive rolling 5-year returns across all periods in its history demonstrates performance that is reliably positive across market cycles — a far more meaningful signal than a single period’s headline return.
NAV Growth as the Underlying Mechanic
All these return calculations ultimately rest on NAV (Net Asset Value) — the daily per-unit value of a fund’s portfolio. Your return = (Exit NAV − Entry NAV) / Entry NAV × 100. For SIPs, the calculation is more complex because you have different entry NAVs on different purchase dates, which is why XIRR is required.
Overview Table: Mutual Fund Return Metrics
| Metric | Best Used For | Limitation |
| Absolute Return | Short-term; under 1 year | Does not account for time |
| CAGR | Lump sum; comparing 1Y/3Y/5Y returns | Assumes single investment date |
| XIRR | SIP portfolios with multiple cash flows | More complex to calculate manually |
| Rolling Returns | Evaluating consistency across cycles | Historical — not predictive |
Frequently Asked Questions (FAQs)
Q1. Why do two different calculators show different returns for the same SIP? If one uses CAGR and the other uses XIRR, the results will differ because CAGR treats the SIP as if all money was invested from the first instalment’s date while XIRR correctly accounts for each instalment’s individual investment date.
Q2. Is a fund with 20% returns over 1 year definitely better than one showing 15%? Not necessarily — one year of outperformance is meaningless without context. The 20% fund may have simply been in a hot sector or taken higher risk. Evaluate 5-year and 10-year CAGR and rolling returns for meaningful comparison.
Q3. What is a good CAGR for an equity mutual fund over 10 years? 12 to 18% CAGR over 10 years is considered good for a diversified equity fund in India. Index funds have historically delivered 12 to 14%; active equity funds with genuine alpha may deliver 14 to 18%.
Q4. How do I calculate XIRR on my SIP portfolio? Most broker platforms display XIRR automatically. Alternatively, use the XIRR function in Excel or Google Sheets with each instalment date, negative investment amounts, and the current portfolio value as a positive final cash flow.
Q5. Does a fund with lower NAV give better returns than one with higher NAV? No — NAV level is irrelevant to future returns. A fund with NAV ₹500 and a fund with NAV ₹10 can both deliver 15% returns. What matters is the percentage growth in NAV, not its absolute level.
Leave a Reply