Rolling returns vs trailing returns in mutual funds

Rolling returns and trailing returns are two methods of computing mutual fund performance over a given time horizon (say, 3 years or 5 years). Both express the fund’s return as a compounded annual growth rate (CAGR) over the measurement period. The fundamental difference is: a trailing return is a single snapshot measured from a specific past date to today, while rolling returns compute that same CAGR for every possible starting date in the historical record, producing a distribution of returns rather than a single number.

Rolling returns are the academically preferred method for evaluating mutual fund track records because they are not biased by the choice of start date.

Trailing returns: definition and formula

A trailing return (also called “point-to-point return”) is the CAGR from a specific point in the past to the current date:

\[ \text{Trailing CAGR} = \left(\frac{\text{NAV}\text{today}}{\text{NAV}{n \text{ years ago}}}\right)^{1/n} - 1 \]

For example, a fund’s “3-year trailing return” as of 12 May 2026 is the CAGR from 12 May 2023 to 12 May 2026.

Trailing returns are the standard disclosure in AMC factsheets, AMFI data, and third-party fund-comparison portals. They are widely published because they are simple to compute and communicate.

Limitation: period sensitivity (start-date bias)

The critical weakness of trailing returns is that the result is entirely determined by the choice of measurement period endpoints. A fund’s trailing 3-year return will be very different depending on whether:

• The measurement period starts in a market trough (inflating the return)
• The measurement period starts at a market peak (depressing the return)
• The measurement period ends during a market rally vs a crash

For instance, a fund’s trailing 3-year return measured from:

• March 2020 to March 2023 (starts at COVID crash, ends mid-recovery): likely very high
• January 2018 to January 2021 (starts pre-crash): moderate

The fund’s actual management quality has not changed, only the measurement window has.

Rolling returns: definition and formula

A rolling return computes the CAGR for every possible start date within a historical data window, using a fixed rolling period (e.g., 3 years):

For each date \(t\) from the beginning of the data window to \(T - n\):

\[ \text{Rolling CAGR}t = \left(\frac{\text{NAV}{t+n}}{\text{NAV}_t}\right)^{1/n} - 1 \]

If the data goes back 10 years (daily NAV), there are approximately 7 years × 252 = 1,764 distinct 3-year rolling return observations. These are plotted or summarised statistically.

Summary statistics from rolling returns:

• Median rolling 3-year CAGR: The typical 3-year outcome the fund has delivered.
• Minimum rolling 3-year CAGR: Worst case among all 3-year periods, equivalent to maximum drawdown in a return-based framework.
• Percentage of positive 3-year rolling periods: What fraction of investors who held for 3 years made money.
• Standard deviation of rolling returns: Consistency of the fund’s performance.

Illustrative comparison

Consider Fund A and Fund B with identical trailing 5-year returns of 14% (as of May 2026):

Fund A rolling 5-year CAGR statistics:

• Median: 13.8%
• Minimum: 6.5%
• Maximum: 22.0%
• % positive periods: 95%

Fund B rolling 5-year CAGR statistics:

• Median: 11.2%
• Minimum: −2.0%
• Maximum: 28.0%
• % positive periods: 78%

Fund B has a negative minimum rolling return and lower median, indicating it has been more volatile and has actually underperformed Fund A over most holding periods, despite an identical trailing 5-year return. The trailing number coincidentally matches because Fund B happened to have a strong recent 3-year run.

Rolling returns and the comparison of active vs passive funds

Rolling returns are the standard tool for evaluating whether an active fund consistently beats its benchmark:

In this example, the active fund beats the benchmark in 62% of 3-year rolling periods. This is more informative than a single trailing return comparison.

For large-cap equity funds in India, rolling return analysis typically shows that:

• Over 3-year rolling periods (2010 to 2024), ~55 to 65% of large-cap funds beat the Nifty 100 TRI.
• Over 5-year rolling periods, the active-over-passive success rate falls to ~40 to 55%, suggesting decreasing alpha generation over longer periods.
• In the direct plan era (post-2013), the success rate has declined further because direct plan TER is lower.

CAGR and rolling returns relationship

All rolling returns are expressed as CAGRs. The distinction between CAGR and rolling returns is not a mathematical difference, CAGR is the formula used, and rolling is the methodology (applying that formula repeatedly across multiple windows). See CAGR vs XIRR for the distinction between CAGR and XIRR.

Rolling vs trailing in TER impact analysis

Rolling return analysis powerfully demonstrates the long-term TER drag. For two plans of the same fund (direct: 1.00% TER, regular: 1.90% TER):

• Over a 10-year rolling window, the direct plan outperforms the regular plan in 100% of periods.
• The median excess return of the direct plan over the regular plan over all rolling 10-year windows is about 0.90 percentage points per annum, compounding to a substantial corpus difference.

Where to find rolling return data in India

AMFI factsheets and AMC documents publish only trailing returns, computed to a single end date. Rolling returns are not a mandated disclosure, so an investor who wants them has to either compute them from the scheme’s daily NAV history (available from the AMC and AMFI NAV archives) or use a third-party fund-research platform or analysis tool that derives them from the same NAV series. A typical rolling-return view reports the minimum, median, and maximum annualised return across all windows, and the percentage of windows that were positive or that beat a stated threshold. SEBI has not mandated rolling-return disclosure in factsheets, though the analysis is widely used by advisers because it removes the single-end-date bias of a trailing number.

Choosing between the two for a decision

Use trailing returns for a quick relative ranking when screening a list of schemes; they are the number every factsheet and comparison portal publishes, so they are convenient for a first cut. Use rolling returns once a shortlist exists and the question becomes consistency: the minimum rolling return tells you the worst holding-period outcome, and the percentage of positive periods tells you how often a holder for that horizon made money.

For a goal tied to a specific horizon, run the rolling analysis at that horizon (rolling 5-year statistics for a five-year goal, rolling 10-year for a retirement leg). A scheme with a strong trailing 5-year number but a wide rolling spread carries more period risk than one with a tighter distribution at the same median, even when both report the same trailing figure.

See also

• CAGR vs XIRR in mutual funds
• XIRR for SIP returns
• Alpha (Jensen’s alpha) in mutual funds
• Maximum drawdown
• Total expense ratio in mutual funds
• Mutual fund

References

1. Association of Mutual Funds in India (AMFI), Best Practice Guidelines on standardised performance disclosure in factsheets.
2. SEBI (Mutual Funds) Regulations, 1996, and the SEBI advertisement code prescribing point-to-point and compounded annualised return disclosure.
3. SEBI Master Circular for Mutual Funds, provisions on standardised performance reporting and the use of the Total Return Index as benchmark.