Rolling Returns of Mutual Funds: How to Read Them (2026)

If you opened your mutual fund app in October 2026 and saw red on the 1-year return, it's normal to feel uneasy. The trap is deciding a fund is "bad" from that one number. Rolling returns of mutual funds fix this. A rolling return works out the fund's annualised return (CAGR) for every 3, 5 or 7-year window across its history, so you see a range: the best case, the worst case and the usual case. A point-to-point return depends on whichever start and end dates you picked.

I'll keep this to the same plain-language format as our expense ratio explainer. You'll get a worked example with correct CAGR maths, a do-it-yourself Excel calculator, and a checklist for reading the output.

TL;DR

• A rolling return is the CAGR for a fixed window (say 5 years), recalculated from every start date. You get many returns, not one.
• Look at four things: the minimum, the % of negative windows, the % of windows that beat the benchmark, and how wide the range is. The average alone isn't enough.
• For equity funds, use 5-year rolling returns, and 7-year for small caps. A bad 1-year number during a correction tells you very little.

Why so many people searched for rolling returns of mutual funds in October 2026

Searches for "rolling returns of mutual funds" hit Breakout on Google Trends in the 24 hours to 28 October 2026. As far as I could find, there's no new SEBI rule behind it. The likelier reason is the market.

• The Nifty 50 closed at 22,600 on 23 October 2026. That's about 13.8% below its peak of 26,216.05 on 26 September 2024, according to Business Today.
• Up to 31 August 2026, before the September 2026 fall, the Nifty 50 TRI (Total Return Index, which counts reinvested dividends) returned −0.4% over 1 year, 9.0% over 3 years and 8.3% over 5 years.
• Investors kept going anyway. Monthly SIP inflows were about ₹32,490 crore in September 2026, from 10.06 crore contributing accounts. Those are AMFI figures as reported by Equity Research India. I haven't checked them against AMFI directly.

If your 1 to 3-year returns look poor, you want a fairer way to judge the fund. Rolling returns are that fairer way.

What are rolling returns? The plain-English version

Pick a window length, say 3 years. Work out the fund's CAGR from 1 January 2016 to 1 January 2019. Then move the start forward a day, a month or a year and repeat, until you run out of data. Each result is one "rolling" return.

CAGR (Compound Annual Growth Rate) is the steady yearly growth rate that would take your money from the start value to the end value. The formula is:

CAGR = (End NAV ÷ Start NAV)^1/years − 1

NAV (Net Asset Value) is the per-unit price of the fund on a given day. Rolling returns are just this formula run hundreds or thousands of times.

Rolling returns vs point-to-point (trailing) returns

	Point-to-point / trailing return	Rolling return
What it is	One CAGR between two fixed dates, usually the latest NAV date and the date 1, 3 or 5 years before it	Many CAGRs, one for every start date in the fund's history
Output	A single number	A range: average, minimum, maximum, % negative
Biggest weakness	A crash at the end date drags it down, and a rally lifts it	Needs a long history, and old rallies can flatter the average
Where you see it	Factsheets, AMFI, every app	AMC tools, third-party sites, or your own spreadsheet
Best for	"How has my fund done recently?"	"How consistent is this fund, and what's the worst I should expect?"

A worked example with correct CAGR maths

Here's a hypothetical equity fund with its NAV on 31 December each year. I've used yearly steps so you can follow the arithmetic. Real tools step daily or monthly.

Year-end	2016	2017	2018	2019	2020	2021	2022	2023	2024	2025
NAV (₹)	100	125	120	132	150	195	196	240	265	238

Now take every 3-year window:

Window	Calculation	3-year CAGR
2016–2019	(132 ÷ 100)1/3 − 1	9.70%
2017–2020	(150 ÷ 125)1/3 − 1	6.27%
2018–2021	(195 ÷ 120)1/3 − 1	17.57%
2019–2022	(196 ÷ 132)1/3 − 1	14.08%
2020–2023	(240 ÷ 150)1/3 − 1	16.96%
2021–2024	(265 ÷ 195)1/3 − 1	10.77%
2022–2025	(238 ÷ 196)1/3 − 1	6.69%

The maths, summarised: 7 windows. Average 11.72%. Worst 6.27%. Best 17.57%. Negative windows: 0 of 7. Windows above 10%: 4 of 7 (57%).

Now look at the point-to-point view. An investor checking at the end of 2025 sees a 1-year return of −10.19% (238 ÷ 265 − 1) and a 3-year return of 6.69%. Someone who checked the same fund at the end of 2021 would have seen 17.57%. Same fund, same manager, opposite conclusions. The rolling view shows what's really going on: an average of about 11.7%, and no 3-year window has lost money.

Small aside: averaging CAGRs, as I did here, is how most tools report the "average rolling return." Just make sure each window uses CAGR. Simple percentage change overstates multi-year returns. A few top-ranking explainers get this wrong.

How to calculate rolling returns in Excel (your own rolling returns calculator)

1. Get the NAV history. Download the NAV history of the direct plan from the AMC's website or AMFI. Monthly NAVs are enough for most people.
2. Lay it out. Put dates in column A and NAVs in column B, oldest first, starting at row 2.
3. Write the window formula. For 3-year rolling returns on monthly data (36 rows ahead), type =(B38/B2)^(1/3)-1 in C2. For 5-year, use =(B62/B2)^(1/5)-1.
4. Drag it down until the formula runs out of future NAVs.
5. Summarise. Use =AVERAGE(C:C), =MIN(C:C), =MAX(C:C) and =COUNTIF(C:C,"<0")/COUNT(C:C) for the share of negative windows.
6. Repeat for the benchmark TRI in column D, then count how often column C beats column D.

If you'd rather skip the spreadsheet, Advisorkhoj's rolling return comparison tool lets you put funds side by side. Several AMCs also have calculators, such as the one linked from Tata Mutual Fund's explainer.

How to read the output: a 5-point checklist

1. Minimum first. The worst window is the closest thing you'll get to an honest stress test. Ask whether you could sit through it.
2. % of negative windows. For a 5-year equity window, anything above zero needs an explanation.
3. % of windows beating the benchmark TRI. If the fund can't beat its index most of the time, a cheaper index fund does the same job.
4. Width of the range. Of two funds with similar averages, the one with the narrower range has been more consistent.
5. Compare with the category. A small-cap fund will always look wild next to a large-cap fund. Compare it with other small-cap funds.

Which rolling period should you use: 3, 5 or 7 years?

Match the window to how long you'll actually hold the fund. My rule of thumb:

• Large-cap and flexi-cap funds: 5-year rolling.
• Mid-cap and small-cap funds: 7-year rolling. They need longer to smooth out.
• Hybrid funds: 3-year rolling.
• Debt funds: 1 to 3-year rolling, matched to the fund's duration.

Longer windows really do change the picture. Industry studies have found that no 7-year rolling window of the Nifty 50 TRI since 1999 has been negative. The index also doubled over a 5-year window about 41% of the time. These are third-party historical studies, not a promise about the next seven years.

Where to check rolling returns, and what SEBI actually requires

This catches people out: SEBI does not require AMCs to publish rolling returns. Factsheets must show CAGR against the TRI benchmark for 1, 3 and 5 years and since inception. All of those are trailing returns. Rolling returns come from AMC tools, third-party platforms or your own spreadsheet. AMFI publishes the official trailing numbers on its Fund Performance page.

The closest official "consistency" measure is the Information Ratio: a fund's excess return over its benchmark, divided by how much that excess return swings. Under a SEBI circular dated 17 January 2025 (SEBI/HO/IMD/IMD-PoD-2/P/CIR/2025/6), AMCs must publish it daily for equity schemes and AMFI must host the data (Business Standard). Use it alongside rolling returns. The SEBI (Mutual Funds) Regulations, 2026 took effect on 1 April 2026, and the Master Circular for Mutual Funds is dated 20 March 2026. Neither adds rolling-return disclosure as far as I found. You can browse the circulars on SEBI's master circulars page.

Watch out: where rolling returns can mislead you

• Old rallies inflate averages. Some value funds show 10-year rolling averages of about 19–23% while their current 3-year returns are about 10–15%. Those older windows include the 2020–21 rally.
• Past consistency doesn't persist much. FundsIndia's research found that only about 26% of top-quartile funds stayed top-quartile over the next 3 years, and about 21% over the next 5. Use rolling returns to rule funds out, not to crown a winner.
• Short histories. A fund launched in 2022 can't have a meaningful 7-year rolling record. Don't let a tool make up for missing data.
• Regular vs direct plan. Regular plans carry a higher expense ratio, which lowers every window. Compare direct with direct.

So, should you stop your SIP because returns are negative?

I'll be straight with you: probably not, but first check whether this money should be in equity at all. A single period can mislead. Here's how a few funds did from the Nifty 50's peak in September 2024 to 23 October 2026, in absolute returns, according to Business Today's report of 24 October 2026:

Fund	Return, September 2024 to 23 October 2026
Parag Parikh Flexi Cap	−1.53%
Samco Flexi Cap	−23.32%
Motilal Oswal Small Cap	+12.34%
Tata Small Cap	−18.24%
SBI Focused	+9.34%

That's one window. Rolling returns tell you whether a fund's bad run is unusual for that fund or typical of it. On SIPs specifically, the PhonePe Wealth/Share.Market CRISP scorecard (June 2026) looked at 32 cases where a 2-year Nifty 500 SIP was at or below zero. None was still negative after 5 years, and about 69% reached double-digit annualised returns.

There's a catch, though. That only helps if you can stay invested. If you don't have an emergency fund, build one before you add to your SIP. If you're carrying a credit card balance at 36–48% a year (see our credit card interest rate guide), clear that first. No fund's rolling average beats a guaranteed 40% cost.

My pick: how I'd use rolling returns of mutual funds

Here's my one rule. For an equity fund, pull the 5-year rolling returns (7-year for small caps) and pick the fund that beats its benchmark TRI in the most windows and has the highest minimum. Don't pick the one with the highest average. Then check its Information Ratio and expense ratio before committing. If no active fund in the category clears that bar, buy the index fund and stop worrying about it.

Once you've picked, automate the SIP and judge it again in 5 years, not 5 weeks. If you want a shortlist to run this test on, our best mutual funds for the next 10 years piece is a good place to start. For the rest of our guides, head to the Monzy blog home.

This is my honest read, not formal financial advice. I'm not your advisor, so run anything big past a professional before you act. The worked example uses hypothetical NAVs, and past rolling returns don't guarantee future ones. But this is exactly how I'd think about it, and you're well able to make this call yourself.