How to Use Rolling Returns to Identify Top Performing Mutual Funds in India

2 days ago

4 min read

Selecting the right mutual fund requires more than a glance at recent one-year returns. Point-to-point performance figures can be misleading because they depend heavily on the start and end dates chosen. AMS Investments believes that a fund that looks exceptional over a specific twelve-month window may have delivered poor results across most other periods.

This is precisely where rolling returns in mutual funds offer a more reliable lens for evaluating performance and consistency.

What Are Rolling Returns in Mutual Funds?

Mutual fund rolling returns measure the annualised returns of a fund over a fixed holding period, calculated repeatedly across a series of start dates within a larger historical window. Instead of measuring performance from a single point in time, rolling returns capture how a fund has performed across every possible entry point within the observation period.

For example, if you are evaluating three-year rolling returns over a ten-year history, the analysis calculates the annualised return for every three-year window starting 1 January of year one, then 2 January, then 3 January and so on generating hundreds of data points rather than just one. This approach removes the bias of cherry-picked time frames and reveals the consistency of a fund's

performance.

Why Rolling Returns Matter More Than Trailing Returns

Trailing or point-to-point returns show performance between two fixed dates. The problem is that both dates can coincide with market peaks or troughs, painting an inaccurate picture. AMS Investments highlights that rolling returns in mutual funds, by contrast, account for multiple market cycles, helping investors understand how often a fund has outperformed its benchmark and by how much.

Consistency check: Rolling returns reveal whether a fund delivers strong results only occasionally or across the majority of periods.
Benchmark comparison: You can assess how frequently the fund beat its benchmark across all rolling windows.
Risk visibility: Negative rolling return periods indicate how a fund behaves during market downturns.
Manager skill assessment: Consistent outperformance across rolling periods suggests genuine fund management skill rather than fortunate timing.

How to Calculate Rolling Returns in Mutual Funds

Understanding how to calculate rolling returns in mutual funds requires a structured approach. Here is a step-by-step method you can apply manually or through a spreadsheet.

Step 1: Gather NAV Data

Download the historical Net Asset Value (NAV) data for the fund you wish to evaluate. Most fund houses and financial data platforms provide daily NAV history. Collect at least seven to ten years of data to generate a statistically meaningful number of rolling windows.

Step 2: Choose Your Rolling Period

Decide the holding period you want to test commonly one year, three years, or five years. Longer rolling periods are generally preferred because they smooth out short-term volatility and better reflect the wealth-creation potential of a fund.

Step 3: Calculate Annualised Returns for Each Window

For each start date in your dataset, identify the NAV on that date and the NAV exactly one, three, or five years later. Apply the Compound Annual Growth Rate (CAGR) formula:

CAGR = [(Ending NAV / Beginning NAV) ^ (1 / Number of Years)] – 1.

Repeat this calculation by shifting the start date forward by one day, generating a new data point each time. You will end up with a large series of CAGR values representing every possible investment entry point within your historical window.

Step 4: Analyse the Distribution of Results

Once you have the full series of rolling return figures, calculate the following summary statistics:

Metric	What It Tells You
Average Rolling Return	The typical annualised return an investor would have earned across all entry points
Minimum Rolling Return	The worst-case outcome important for understanding downside risk
Maximum Rolling Return	The best-case outcome across all windows
Percentage of Positive Periods	How often the fund delivered a positive return a consistency indicator
Percentage of Benchmark Outperformance	How frequently the fund beat its benchmark a measure of active management value

How to Evaluate Mutual Fund Performance Using Rolling Returns

Knowing how to evaluate mutual fund performance using rolling returns involves comparing these metrics across funds within the same category. AMS Investments recommends using the following framework when making comparisons:

Compare Funds Within the Same Category

Rolling return comparisons are only meaningful when funds share the same investment mandate. Compare large-cap funds against other large-cap funds, and mid-cap funds against their peers. Mixing categories distorts the analysis.

Use the Same Rolling Period Across All Funds

Apply an identical rolling window say three years to all funds under consideration. This ensures you are measuring performance under the same conditions for every fund in your shortlist.

Prioritise Consistency Over Peak Returns

A fund that delivers an average three-year mutual fund rolling returns figure with a high percentage of outperformance periods is generally preferable to one that shows exceptional peak returns but frequent underperformance. Consistency protects investors who invest at different points in the market cycle.

Include the Benchmark and Category Average

Always calculate the same rolling metrics for the fund's benchmark index and the category average. A fund that outperforms its benchmark in more than sixty to seventy percent of all rolling periods is demonstrating meaningful consistency. Anything below fifty percent suggests the fund is not adding value relative to a passive index strategy.

Consider Different Holding Periods Together

Run rolling return analysis for one-year, three-year, and five-year periods simultaneously. A high-quality fund should rank well across all three horizons. A fund that excels only over one-year rolling windows but lags over five-year windows may be taking excessive short-term risks that are not sustainable over longer periods.

Practical Limitations to Keep in Mind

While rolling returns in mutual funds are one of the most robust performance evaluation tools available, they are not without limitations. Past rolling performance does not guarantee future results. Fund managers change, market conditions evolve, and a fund's investment style may drift over time. Rolling return analysis should always be used alongside other qualitative and quantitative factors such as expense ratio, fund size, portfolio turnover, and risk-adjusted return metrics.

Take the Next Step With AMS Investments

Applying rolling return analysis systematically across a universe of funds requires both data access and analytical discipline. At AMS Investments, we integrate mutual fund rolling returns analysis into our fund selection process to help investors build portfolios grounded in consistent, evidence-based performance rather than short-term noise.

If you would like a personalised review of your mutual fund portfolio using rolling return methodology, book a call with our team today and take a more informed approach to long-term wealth creation.