Independent Research on Mutual Funds, Stocks & IPOs for Indian Investors

top of page

Rolling Returns vs CAGR: Which one should you trust?

  • Apr 22
  • 8 min read

Updated: Aug 11

Last Reviewed and Updated: 17 Aug 2026

This is not fraud. It is not even dishonest in a narrow legal sense. It is something more subtle and arguably more dangerous: a fund showcasing its best possible performance window while technically disclosing everything required by regulation. Understanding why this happens, and how to protect yourself, requires understanding two metrics: CAGR and rolling returns.


This article explains both metrics clearly, shows you exactly how they differ with concrete Indian market examples, and gives you a practical framework for using both effectively when evaluating mutual funds.


CAGR stands for Compound Annual Growth Rate. It tells you the annualised rate of return between two specific dates: a start date and an end date. It collapses the entire journey between those two points into a single smooth growth rate, as if the fund grew at exactly that rate every year.


CAGR Formula

CAGR = [(Ending Value / Beginning Value) ^ (1/Years)] - 1

Example: Rs 1 lakh grows to Rs 3.2 lakhs in 10 years  →  CAGR = 12.3% per year


The appeal of CAGR is its simplicity. It collapses a complex, messy 10-year journey into a single comparable number. You can easily compare Fund A’s 10-year CAGR of 14% with Fund B’s 10-year CAGR of 11%.


CAGR is genuinely useful when you know exactly when you invested and when you plan to exit. If you bought a fund 7 years ago and are selling today, the CAGR of that specific period is exactly what you earned. For a lump sum investment with known entry and exit dates, CAGR is the correct metric.


CAGR is entirely dependent on two data points: where you start and where you end. Every data point in between is irrelevant to the calculation. This makes it dangerously easy to manipulate, not through dishonesty, but through the deliberate selection of start and end dates that maximise the apparent return.


Consider a fund that earned 6% CAGR over 10 years but happened to have a spectacular final 2 years that pushed the 2-year CAGR to 24%. A fund house promoting this fund can legitimately show the 2-year return of 24% in its marketing materials. Both numbers are accurate. The 2-year number is simply not representative of what a typical investor experienced.



This is not a hypothetical concern. It happens routinely in fund marketing. Fund factsheets often display the time periods that make the fund look best, and SEBI’s disclosure requirements, while improving, still leave room for selective framing. The investor who relies solely on CAGR is vulnerable to this framing effect.


Rolling returns solve the start date and end date problem by refusing to commit to any particular time window. Instead, they calculate returns across every possible period of a specified length within a fund’s history.


Imagine you want to know the 3-year rolling return of a fund that has been running for 10 years. You calculate the 3-year CAGR starting on Day 1, then the 3-year CAGR starting on Day 2, then Day 3, and so on. If the fund has 10 years of history, you have roughly 7 years worth of 3-year windows, giving you thousands of individual 3-year CAGR observations.


What this gives you is something CAGR fundamentally cannot: a view of the fund’s performance distribution across all market conditions, not just the specific scenario that the fund house chose to highlight.


When you look at a fund’s rolling return chart or data, you are looking for four things:


› The average rolling return: this is the fund’s typical performance across all market conditions.

› The minimum rolling return: this is the worst outcome any investor who stayed invested for the full period experienced.

› The percentage of positive periods: what fraction of all the rolling windows produced a positive return.

› Consistency relative to the benchmark: does the fund beat its benchmark in most rolling windows or only in some?



Here is a direct comparison of how the two metrics behave and what each one is good for.


CAGR: What It Does Well


› Simple to calculate and explain to any investor.

› Useful for comparing funds over the exact same time period.

› Answers a specific investor's actual return if they know their entry and exit dates.

› Works well for very long periods (10 to 20 years) where short term distortions smooth out.

› Standard metric across mutual fund fact sheets and platforms, making comparison easy.

Rolling Returns: What It Does Better


› Removes the bias of cherry-picked start and end dates entirely.

› Shows the distribution of outcomes across all possible entry points.

› Reveals consistency, or the lack of it, that CAGR hides.

› Exposes funds that look good only because of one favourable period.

› Far better for evaluating the realistic investor experience over time.


Let us make this concrete with a scenario that plays out more often than most investors realise. We compare two equity funds using both CAGR and 3-year rolling returns over a 10-year period.


FUND A  The Consistent Compounder

Fund A is managed by a cautious, disciplined manager who keeps volatility low and compounds steadily. It grows at roughly 12 to 14 percent in most years, dips modestly during corrections, and recovers quickly. Over 10 years it delivers a solid 12.8 percent CAGR.

Its rolling return profile: Average 5 year rolling return of 12.5 percent. Minimum 5 year rolling return of 9.1 percent. It produced a positive return in 98 percent of all 5 year windows measured.


FUND B  The Boom and Bust Flier

Fund B is managed aggressively. It surges during bull markets but falls hard during corrections. Its first seven years were turbulent: big gains followed by large losses. But in its 8th, 9th, and 10th years it rode a powerful rally to produce extraordinary returns, delivering 45, 38, and 31 percent in three consecutive years.

Its 10 year CAGR? An impressive 13.4 percent. Its rolling return profile tells a very different story: Average 5 year rolling return of 10.2 percent. Minimum 5 year rolling return of negative 4.8 percent. It produced a positive return in only 71 percent of all 5 year windows measured.


On CAGR alone, Fund B looks like the better investment. On rolling returns, Fund A is clearly superior. Fund A beats its benchmark in 78% of all rolling 3-year windows. Fund B beats its benchmark only 34% of the time. Fund A’s worst 3-year outcome is a positive 2%, meaning no investor who held for 3 years lost money. Fund B’s worst outcome is negative 8%.


Which fund would you rather own?


In India, SEBI mandates that mutual funds display point-to-point returns for standardised periods (1, 3, 5 years and since inception) in all advertisements and factsheets. This protects against the most egregious cherry-picking but does not eliminate it.


The since-inception CAGR figure deserves particular scrutiny. When a fund was launched at an opportune moment, say just before a major bull run, the since-inception CAGR will be dramatically higher than what any investor who bought later actually experienced.


Rolling returns cut through all of this. They do not care whether the fund launched in a bull market or a bear market. They measure consistency across all starting points, which is far more relevant to the experience of a real investor.


Rolling return data is not as readily visible as CAGR on most fund platforms, but it is available. Platforms like Value Research Online, Morningstar India, and Advisorkhoj provide rolling return charts for most funds.


The answer is not that one replaces the other. Both have their place and the most effective investors use them in combination.


Situation

Use CAGR When...

Use Rolling Returns When...

Comparing two funds

Both have identical measurement periods and similar launch dates

Funds have different inception dates or different volatility profiles

Evaluating a new fund

The fund is less than 3 years old and rolling data is insufficient

The fund has 5 or more years of history

Checking your own return

You know your exact investment date and want your personal IRR

You want to know if your entry point was typical or exceptional

Screening funds

Doing a quick initial filter across many funds

Doing a deep evaluation of a shortlisted fund before committing

Assessing consistency

Never the right tool for this purpose

The primary tool: minimum return, percentage positive periods, std deviation of rolling returns

Comparing to benchmark

Acceptable if the same period is used for both fund and benchmark

Superior: shows in what fraction of periods the fund actually beat its benchmark


What Investors Get Wrong About CAGR and Rolling Returns:


› Believing that a higher 3-year CAGR means a better fund. Three years is too short to draw reliable conclusions about fund quality.

› Assuming that a fund with the highest rolling return average is always the best choice. Risk-adjusted rolling returns matter.

› Using since-inception CAGR to compare funds with different start dates. A fund launched in 2009 has a completely different since-inception return than one launched in 2007, purely due to the starting point.

› Thinking rolling returns are too complex to be useful. The concept is simple: how did investors who started at different points in time actually do?

› Ignoring rolling return data because it is not displayed prominently. The fact that it requires extra effort to find is precisely why it is more reliable than the prominently displayed CAGR figures.

› Treating a 100% positive rolling return record as mandatory. Even excellent funds have occasional negative rolling return periods during severe bear markets.


What matters is frequency and magnitude, not perfection.


The following approach combines both metrics in a way that gives you a genuinely useful picture of a fund’s quality:


› Start with the 10-year CAGR as an initial filter. It is long enough to span at least one complete market cycle and filters out funds that have simply been lucky in the short term.

› Move to 5-year rolling returns for the consistency test. Look at the average, minimum, and percentage of positive periods.

› Compare rolling returns against the benchmark and category average, not just in absolute terms.

› Check the standard deviation of rolling returns. Two funds with the same average rolling return but different standard deviations offer very different investment experiences.

› Use CAGR one final time to check your specific entry scenario. If you plan to invest for 7 years starting now, the 7-year rolling return distribution is the most relevant guide to your realistic outcome range.


If you invest through a Systematic Investment Plan, neither CAGR nor rolling returns in their standard form perfectly capture your experience. Your actual return is your XIRR, which accounts for the fact that each SIP instalment was invested at a different NAV.


However, rolling returns still matter for SIP investors, and perhaps more than they realise. When you run a monthly SIP over 15 years, your outcome is essentially the average of thousands of different starting points. That average closely approximates the average rolling return for your investment duration.


The minimum rolling return is also especially relevant for SIP investors because it represents the worst-case scenario for an investor who happened to start their SIP at the worst possible time and needed to exit at the worst possible time.


The honest answer is that you should trust both, but not equally, and not for the same purposes. CAGR is useful, precise, and easily manipulated. Use it as your starting point, not your ending point.


Rolling returns, however, are closer to the truth of how a fund actually behaves across the full range of investor experiences. They are harder to cherry-pick, harder to frame misleadingly, and harder to dismiss as a statistical artefact. They show you the distribution of outcomes, not just the headline.


At Equity Research India, we believe that the widespread reliance on CAGR alone is one of the most correctable mistakes in Indian retail investing. Not because CAGR is wrong, but because it is incomplete. Adding rolling return analysis to your fund evaluation process costs you perhaps 10 extra minutes of research and may save you from years of compounding underperformance.



Disclaimer

The content on this website is for informational and educational purposes only and should not be construed as investment advice, a recommendation, or a solicitation to buy or sell any security, mutual fund, or financial instrument. Equity Research India is not a SEBI-registered investment advisor or research analyst, and nothing on this site constitutes personalized financial advice.

Mutual fund investments are subject to market risks. Please read all scheme-related documents carefully before investing. Past performance is not indicative of future returns. NAV, returns, rankings, and other data may change and may not reflect the most current information at the time of reading.

Readers should conduct their own due diligence and consult a SEBI-registered financial advisor before making any investment decisions. Equity Research India and its authors accept no liability for any loss or damage arising from the use of this content.

Comments


Commenting on this post isn't available anymore. Contact the site owner for more info.
  • X
  • LinkedIn
  • Instagram
  • Facebook

Warning: Investment in Mutual Funds and  Securities Market are subject to market risks. Read all scheme related documents carefully before investing.

Disclaimer: This website provides educational content only and does not offer investment advice.

List of mutual fund companies (AMCs):  ONE  |  Abakkus  |  Aditya Birla Sun Life  |  Angel One  |  Axis  |  Bajaj Finserv  |  Bandhan  |  Bank of India  |  Baroda  |   BNP Paribas  |  Canara Robeco  |  Capitalmind  |  Choice  |  DSP  |  Edelweiss  |  Franklin Templeton  |  Groww  |  HDFC  |  Helios  |  HSBC  |  ICICI Prudential  | Invesco  |  ITI  |  JioBlackRock  |  JM Financial  |  Kotak Mahindra  |  LIC  |  Mahindra Manulife  |  Mirae Asset  |  Motilal Oswal  |  Navi  |  Nippon India  |  NJ  |  Old Bridge  |  PGIM India  |  PPFAS  |  Quant  |  Quantum  |  Samco  |  SBI  |  Shriram  |  Sundaram  |  Tata  |  Taurus  |  The Wealth Company  |  TRUST  |  Unifi  |  Union  |  UTI  |  WhiteOak  |   Capital  |  Zerodha

© 2026 by Equity Research India

bottom of page