Rolling Returns Explained: A Better Way to See How a Mutual Fund Behaves Across Years

A fund’s three-year return is 14%. Is that good? It depends on when you looked. Check again twelve months later and the same fund, with the same manager, can show a very different number.

A single trailing return is a photograph. Rolling returns are the film. This guide shows you the difference using real index data, explains how to read the range, and gives you a simple spreadsheet method to build rolling returns yourself.

Trailing and rolling returns, side by side

Trailing return looks back from one date. A 3-year trailing return as of today covers the three years ending today. It is a single number.

Rolling return repeats that calculation from many start dates. For 3-year rolling returns, you compute the 3-year return starting on every day (or month, or year) over a long history, then look at the whole set.

A worked example with Nifty 50 data

To make this concrete, we calculated 3-year rolling returns for the Nifty 50 using calendar-year price changes for 2012 to 2025 from a published table. Each row is the annualised return for the three years that start in the year shown.

Illustration built from year-by-year price changes. It assumes even growth within a year, excludes dividends and costs, and describes an index, not a fund. Real rolling returns use daily or monthly data and will differ.

Read the whole table instead of one row. The lowest window is 8.3%, the highest is 21.5%, and the middle value is about 12.0%. Nine of the twelve windows are at or above 10%, and none is negative.

Now notice what a single snapshot would have told you. A 3-year trailing return measured at the end of 2014 reads 21.5%. A year later, at the end of 2015, it reads 10.4%. The index did not change character in twelve months. The snapshot just moved. The rolling table shows both numbers belong to the same distribution.

For comparison, the one-year changes in the same period ranged from -4.1% to +31.4%. Longer windows narrow the spread, though they do not remove it, a pattern we saw in our pillar article on yearly returns.

How to read a rolling-return table

When you see rolling returns for a fund, look at four things.

1. The window length. Match it to how long you plan to hold. If your goal is seven years away, look at 5-year and 7-year windows, not 1-year windows.
2. The worst window. This shows you the weakest period you would have experienced. Ask whether you could have stayed invested through it.
3. The median. This is the middle outcome, a fairer central figure than the best case.
4. The share of windows above a level you care about. If you need 10% a year, how many windows cleared it? A fund that cleared it in 9 of 12 windows is different from one that cleared it in 5 of 12, even if their latest trailing returns match.

Then compare against the fund’s benchmark and category over the same windows. A fund with a narrower range and a similar median may suit a nervous investor better than one with a higher peak and a deeper low. We explain how to compare these lines in our factsheet guide.

Build your own rolling returns in a spreadsheet

You can do this with free data in about fifteen minutes.

1. Download the NAV history. The AMFI website, amfiindia.com, lets you download historical NAVs for a scheme. Use the Direct or Regular plan that you hold, since their NAVs differ.
2. Pick a sampling date. Use one NAV per month, for example the first business day, to keep the sheet manageable.
3. Calculate the 3-year rolling return. In a new column, for each month, divide that month’s NAV by the NAV 36 rows earlier, raise it to the power of one-third and subtract one. In a spreadsheet, that looks like =(B38/B2)^(1/3)-1.
4. Summarise the column. Use MIN, MEDIAN and MAX, and use COUNTIF to count how many values exceed 10%.
5. Repeat for other windows. Change the 36 to 60 for 5-year windows, with the exponent 1/5.

This ignores dividends if you hold an IDCW option and does not reflect taxes. It gives a reasonable picture for growth options.

What rolling returns cannot tell you

Rolling returns have limits, and it helps to know them.

The windows overlap. Twelve 3-year windows drawn from 14 years of data are not twelve independent tests. Consecutive windows share two of their three years. The table looks like more evidence than it is.

They only describe the past. A good rolling record does not promise the same future.

The history might be too short or too kind. The 14 years in our table contain no fall as large as the one in 2008-09, when the Nifty 50 Total Returns Index lost about 35% over a financial year (table). A fund with only five years of history has very few windows.

Survivors look better. Funds that did badly were sometimes merged or closed, so the ones you can look up are partly the winners.

Three situations where it changes the decision

These examples are invented.

Two funds with the same trailing number. Pooja, 32, finds that two funds show a 3-year return of 14%. Their rolling tables look different. One ranged from 6% to 20%, and the other from 10% to 17%. If a wide range would tempt her to sell during a weak period, the narrower fund might suit her better. If she has a long horizon and strong nerves, she may accept the wider range.

A holding period tied to a lock-in. Manoj holds an ELSS fund with a three-year lock-in per instalment. The 3-year rolling range is the most relevant view for him, since each instalment is stuck for exactly that long.

A seven-year goal. Deepa is saving for a home in seven years. She looks at 7-year windows and sees that the lowest was still positive in the data she found. That helps her set expectations. It does not make her goal safe, and she still tests it at lower returns using the method in our 12% assumption article.

At Artha Vridhi, our Financial Literacy service shows investors how to read rolling returns on their own funds, so the numbers on a screen become a range and not a verdict.

When trailing returns are enough

If you only want to know how much your holding grew in the past year, a trailing return answers that. Rolling returns help when you are judging how consistent a fund has been, or what range to expect. They are not needed for every decision.

Frequently asked questions

What are rolling returns in a mutual fund?

They are returns over a fixed window, such as three years, calculated from many different start dates. They show a range of outcomes, not a single number.

Are rolling returns better than trailing returns?

They answer a different question. Trailing returns show recent performance, while rolling returns show consistency. Many investors use both.

Which window should I use?

Use a window close to your holding period. For a long-term goal, 5-year and 7-year windows are common choices.

Do rolling returns include SIP returns?

Standard rolling returns describe a lump sum held for the window. For a SIP view, use XIRR, as we explain in CAGR vs XIRR.

Can you help me read rolling returns for my fund? Message us on WhatsApp with the fund name.

Disclosures

Mutual fund investments are subject to market risks, read all scheme-related documents carefully.

Artha Vridhi is an AMFI-registered Mutual Fund Distributor (ARN-362803). This article is for education and is not personal investment advice or a recommendation of any scheme. Index figures come from third-party sources cited above and should be verified against NSE Indices data. Illustrations use assumed or simplified numbers and are not forecasts or promises of return. Past performance may or may not be sustained in future. Distributors are paid commission by fund houses on regular-plan investments.