Rolling Returns vs CAGR: Which one should you trust?

This is not fraud. It is not even dishonest in a narrow legal sense. It is something subtler and in some ways more dangerous: it is the perfectly legal use of a mathematically correct but deeply incomplete picture. CAGR, or Compound Annual Growth Rate, is the return metric most investors rely on almost exclusively. It has real value, but it also has a structural weakness that the fund industry has quietly learned to exploit. Rolling returns exist precisely to correct that weakness, and yet most investors have never heard of them.

This article explains both metrics clearly, shows you exactly how they differ with real world scenarios, and tells you which one to trust, and when, so that the next time you look at a fund's return history, you are seeing the full picture rather than the carefully selected one.

CAGR stands for Compound Annual Growth Rate. It tells you the annualised rate at which an investment grew between two specific points in time, assuming growth was perfectly smooth and compounded continuously. The formula is straightforward.

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 of ups and downs into a single clean number. It answers the question every investor wants answered: if I had invested at point A and stayed until point B, what was my annualised return? It is also easily comparable across funds, asset classes, and time periods, which is why it became the default language of the investment industry.

CAGR is genuinely useful when you know exactly when you invested and when you plan to redeem, and when that period happens to be meaningfully long. But outside of those conditions, it has a vulnerability that makes it easy to manipulate and easy to misinterpret.

CAGR is entirely dependent on two data points: where you start and where you end. Everything that happened in between, every crash and every rally, every period of flat returns and every surge, is compressed and hidden inside that single annualised figure. This means that by carefully choosing the start and end dates, you can make virtually any fund look exceptional or mediocre.

Consider a fund that earned 6 percent CAGR over 10 years but happened to have a spectacular final year. If you measure its 3 year CAGR ending on that date, it might show 18 percent. Now consider another fund that earned 14 percent CAGR over 10 years but had a rough final 18 months. Its 3 year CAGR might show only 8 percent. Which fund is the better long term performer? The 10 year number answers that clearly. The 3 year CAGR answers it deceptively.

This is not a hypothetical concern. It happens routinely in fund marketing. Funds launch advertising campaigns featuring their CAGR figures immediately after strong performance periods. Comparison websites default to 1 year or 3 year CAGR, the windows most likely to show recent market momentum rather than long term manager skill. And investors, reasonably but incorrectly, treat these numbers as reliable guides to what a fund will do going forward.

Rolling returns solve the start date and end date problem by refusing to commit to any single pair of dates. Instead of measuring a fund's return from one specific point to another, rolling returns calculate the fund's return over a fixed time window, say 3 years or 5 years, starting from every possible date within the fund's history, and then report all of those returns together.

Imagine you want to know the 3 year rolling return of a fund that has been running for 10 years. You start by measuring the return from January 2015 to January 2018. Then you move forward by one day and measure February 2015 to February 2018. Then March 2015 to March 2018. You continue this process all the way until the most recent available 3 year window. By the time you are done, you might have 1,500 or more individual 3 year CAGR data points. Rolling returns show you the distribution of all those outcomes.

What this gives you is something CAGR fundamentally cannot: a view of the fund's performance consistency across different market entry points. Rather than telling you what happened if you invested at one specific moment, rolling returns tell you what happened across the full range of moments an investor might have chosen to enter. That is a far more honest representation of the experience a real investor could have expected.

When you look at a fund's rolling return chart or data, you are looking for four things above all else.

› The average rolling return: This is the fund's typical performance across all measured windows. A higher average means stronger consistent performance.

› The minimum rolling return: This is the worst outcome any investor who stayed invested for the full window would have experienced. A fund with a high average but a deeply negative minimum carries hidden risk.

› The percentage of positive periods: What fraction of all the rolling windows produced a positive return? For a well managed equity fund over a 5 year window, this should ideally be close to 100 percent.

› Consistency relative to the benchmark: Does the fund beat its benchmark in most rolling periods, or only in some? A fund that beats only when the market is strong but lags when it is difficult is not adding the value its CAGR might suggest.

Here is a direct comparison of how the two metrics behave and what each one is genuinely useful 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. Imagine two equity funds, both with exactly 10 years of history.

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 for most investors. The investor who entered Fund B at the wrong time could have waited 5 full years and still been sitting on a loss. The investor who entered Fund A at any point in its history almost always came out comfortably positive within 5 years.

Which fund would you rather own?

In India, SEBI mandates that mutual funds display point to point returns for standardised periods, typically 1 year, 3 years, 5 years, and since inception, alongside the benchmark return for the same periods. This standardisation was a genuine improvement over the wild west of return reporting that existed earlier. But it still has a fundamental limitation: it anchors all comparisons to specific calendar dates rather than showing the range of investor experiences.

The since inception CAGR figure deserves particular scrutiny. When a fund was launched at a market bottom, as many were during the post crash opportunities of 2009 or 2020, its since inception CAGR can look spectacular for years simply because of the favourable starting point, regardless of what the manager actually did with the money. Conversely, a genuinely excellent fund launched near a market peak may show an unremarkable since inception CAGR that underrepresents its true quality.

Rolling returns cut through all of this. They do not care whether the fund launched at a peak or a trough. They measure the fund across hundreds of different entry points and show you the realistic distribution of what investors who chose the fund at different times actually experienced.

Rolling return data is not as readily visible as CAGR on most fund platforms, but it is increasingly available for investors willing to look for it.

The answer is not that one replaces the other. Both have their place and the most informed investors use both, for different purposes.

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 a window to distinguish skill from luck, especially after a strong bull market run.

› Assuming that a fund with the highest rolling return average is always the best choice. A very high average with a very negative minimum may mean the fund takes concentrated risks that occasionally work spectacularly but occasionally destroy wealth.

› Using since inception CAGR to compare funds with different start dates. A fund launched in March 2009 at market lows will almost always show a higher since inception CAGR than one launched in January 2008 at near market highs, regardless of fund quality.

› Thinking rolling returns are too complex to be useful. The concept is simple: how did the fund perform across all possible 3 or 5 year windows? The arithmetic is just done many times over.

› Ignoring rolling return data because it is not displayed prominently. The fact that platforms default to CAGR does not mean CAGR is more informative. It means it is more convenient for marketing.

› Treating a 100 percent positive rolling return record as mandatory. Even excellent funds occasionally produce short negative rolling return windows during severe market crashes.

What matters is frequency and magnitude, not perfection.

The following approach combines both metrics in a way that gives you a genuinely complete picture before committing to any fund. Use it as a mental checklist every time you are seriously evaluating a new addition to your portfolio.

› Start with the 10 year CAGR as an initial filter. It is long enough to span at least one full market cycle, reducing the distortion of any single bull or bear phase. Funds with 10 year CAGR consistently above their benchmark deserve further examination. Those consistently below it can usually be set aside.

› Move to 5 year rolling returns for the consistency test. Look at the average, the minimum, and the percentage of positive periods. A fund that clears the CAGR filter but shows a poor rolling return profile is likely a one cycle wonder rather than a genuinely skilled operation.

› Compare rolling returns against the benchmark and category average, not just in absolute terms. A fund that beats its benchmark in 80 percent of all 5 year rolling periods is adding genuine value. One that beats in only 50 percent of periods is, on average, delivering no alpha at all.

› Check the standard deviation of rolling returns. Two funds with the same average 5 year rolling return of 13 percent can look very different if one has a standard deviation of 1 percent (very consistent) and the other has a standard deviation of 5 percent (wildly inconsistent). Consistency has real value for an investor who cannot predict their exit point.

› Use CAGR one final time to check your specific entry scenario. If you plan to invest for exactly 7 years from a known start date, the 7 year CAGR from a comparable historical period can give you a rough sense of what to expect. But treat it as context, not as a promise.

If you invest through a Systematic Investment Plan, neither CAGR nor rolling returns fully captures your experience, because you are not making a single lump sum investment at one point in time. Each SIP instalment is a separate investment at a different NAV. The correct metric for an SIP investor is XIRR, which accounts for the timing and size of each individual cash flow.

However, rolling returns still matter for SIP investors, and perhaps more than they realise. When you run a long term SIP, you are effectively buying the fund at hundreds of different entry points across many market cycles. Your eventual outcome will resemble the average rolling return of the fund over your SIP duration more closely than any single point to point CAGR. A fund with a high and consistent average rolling return is therefore precisely what a long term SIP investor should be looking for.

The minimum rolling return is also especially relevant for SIP investors because it tells you the worst case scenario for the portion of your investment that happened to be timed poorly. If a fund's 5 year minimum rolling return is negative 8 percent, it means that investors who put in a lump sum at the worst historical entry point waited five full years and still lost money. For a disciplined SIP investor this is less alarming because cost averaging softens the impact of a bad entry point, but it remains a signal about the fund's volatility and downside risk that deserves attention.

The honest answer is that you should trust both, but not equally, and not for the same purpose. CAGR is a useful snapshot. It tells you what happened between two specific dates and allows quick comparison across funds when the measurement periods are standardised. It is the right tool for understanding your own personal return from a known investment.

Rolling returns, however, are closer to the truth of how a fund actually behaves across the range of market conditions and investor entry points it will encounter over its lifetime. If you are choosing a fund that you do not already own, and you want to know whether it has genuinely rewarded its investors across different market cycles and entry points, rolling returns are the superior lens. A fund that looks good on CAGR but poor on rolling returns has something to hide. A fund that looks good on both has earned your consideration.

At Equity Research India, we believe that the widespread reliance on CAGR alone is one of the most consequential blind spots in Indian retail investing. It is not that the number is wrong. It is that it is incomplete, and incompleteness in the service of a marketing purpose is a form of misdirection that costs investors real money. The next time a fund's advertisement shows you an impressive return figure, ask the question the advertisement is not designed to answer: what were the rolling returns? The answer will tell you far more than the headline ever will.