Rolling Returns vs CAGR in Mutual Funds: A Practical Guide for Indian Investors

Mutual fund investors often see CAGR and rolling returns on factsheets, apps and research tools, but many are unsure which number is more useful. CAGR shows point-to-point growth between one starting date and one ending date, while rolling returns show how that growth would have looked across many different time periods.

This guide compares rolling returns vs CAGR specifically for Indian mutual funds. We will look at definitions, formulas, examples, comparison tables, common mistakes and FAQs in beginner-friendly language.

Novelty Wealth is a SEBI-registered investment adviser (RIA) that provides portfolio analysis and financial planning tools. In an educational context, such tools can help investors view return metrics, portfolio risk and mutual fund investments in one place.

Basics of Mutual Fund Returns: Key Terms You’ll See

Before comparing rolling returns vs CAGR, it helps to understand the common return terms used for mutual fund schemes.

• Absolute return: The total gain or loss over a time period, without annualisation. If ₹1,00,000 becomes ₹1,20,000, the absolute return is 20%. Total return is calculated as a proportion of the initial investment.
• Total return: Total return includes interest, capital gains, and dividends.
• Point-to-point returns: Trailing returns are also known as point-to-point returns. These measure performance from one start date to one end date, such as 31-Mar-2021 to 31-Mar-2024.
• CAGR: CAGR provides a single, point-to-point annualized average. It shows the average annual return needed for the investment to grow from the initial value to the final value.
• Rolling returns: Rolling returns measure mutual fund performance over various periods. Rolling returns assess performance over various overlapping periods and provide a continuous view of fund performance.
• Year rolling periods: 1-year rolling, 3-year rolling and 5-year rolling returns show annualized returns for every one year, three years or five years holding window.

AMCs and research websites in India usually show 1-year, 3-year, 5-year and since-inception trailing returns. Some also show mutual funds rolling returns charts. For simplicity, examples here assume growth options of mutual fund schemes with dividends reinvested and are not investment advice.

What is CAGR in Mutual Funds?

CAGR stands for Compound Annual Growth Rate. It represents the smoothed annual growth rate of an investment over a specific period. CAGR measures the mean annual growth rate of an investment assuming profits are reinvested.

For mutual funds, AMCs commonly use CAGR to show annualized returns for periods longer than one year, such as 3-year, 5-year, 10-year and since inception returns. These are point returns for a specified period, not a full picture of every investor’s journey.

CAGR formula:

CAGR = (Final Value ÷ Initial Investment)^(1 ÷ Number of Years) − 1

Example: Suppose an investment of ₹1,00,000 in an equity mutual fund on 01-Jan-2016 grew to ₹2,11,000 on 01-Jan-2023.

CAGR = (2,11,000 ÷ 1,00,000)^(1 ÷ 7) − 1
     ≈ 11.12% per annum

This means the investment grew as if it compounded at about 11.12% every year. In reality, annual returns may have been very different on a yearly basis.

CAGR smooths volatility because:

• CAGR assumes the investment compounded at a steady rate.
• It hides the actual rate of each year’s rise or fall.
• It does not show whether the fund's performance was stable or highly volatile.

CAGR is usually calculated using NAVs of the scheme and assumes a lump sum investment. For SIPs, cash flows happen on different dates, so XIRR is often more suitable than CAGR for evaluating SIP returns.

Advantages of Using CAGR

CAGR is widely used because it is straightforward to calculate and easy to communicate.

• It is simple for beginners: “This fund delivered 11% annualised return over seven years” is easy to understand.
• It helps compare different mutual funds over the same time frame.
• It is useful for financial planning and illustrates the power of compounding in mutual fund investments. For example, ₹1,00,000 growing at 10% CAGR for 10 years becomes about ₹2.59 lakh before costs and taxes.
• It matches how many factsheets display scheme performance.
• It gives a clean view of long-term growth, especially for lump sum investments.

However, CAGR explains past performance only. It does not predict future performance or guarantee returns.

Limitations and When CAGR Can Be Misleading

CAGR can sometimes give an incomplete picture because it hides the year-to-year journey.

Key limitations include:

• One-time market conditions near the start date or end date can distort CAGR.
• It does not show negative returns inside the holding period.
• Two funds can have the same CAGR but very different risk.
• A fund's absolute return and CAGR may look attractive, but interim drawdowns may still have been uncomfortable.

Example of two hypothetical funds:

Both could end near a similar 5-year CAGR, but Fund B had deeper drawdowns. This difference matters for risk tolerance and investment goals.

For SIP investors, relying only on lump-sum CAGR of a mutual fund scheme can be misleading because each instalment has a different investment tenure.

What are Rolling Returns in Mutual Funds?

Rolling returns are annualized returns of a mutual fund calculated over a fixed rolling period, such as three years or five years, across many overlapping start dates. Rolling returns measure how a fund performed for investors entering at different points in time.

Instead of asking, “What was the 5-year return from 31-Mar-2019 to 31-Mar-2024?”, rolling returns ask, “What return did investors get for every possible 5-year period between 2010 and 2024?”

Rolling returns provide a continuous view of fund performance. They are useful for checking consistency, volatility and the frequency of negative returns. Rolling returns can benchmark funds against market indices such as NIFTY 50 TRI or NIFTY 500 TRI, purely for analytical comparison of relative performance.

How to Calculate Rolling Returns: Step-by-Step

Calculating rolling returns is conceptually simple:

1. Choose NAV data: For example, daily NAVs of a diversified equity fund from 01-Jan-2010 to 31-Dec-2024.
2. Choose the rolling returns period: For example, 3-year rolling returns.
3. Calculate the first window: Use NAV on 01-Jan-2010 and NAV on 01-Jan-2013 to calculate the 3-year CAGR.
4. Move the start date: Shift to 02-Jan-2010 and 02-Jan-2013, then repeat. You can calculate rolling returns using overlapping timeframes.
5. Summarise results: Look at average, median, maximum and minimum values, standard deviation and percentage of negative periods.

Spreadsheets, online calculators and analytics modules for tracking mutual fund performance like a smart investor on platforms like Novelty Wealth can help with calculating rolling returns without manually exporting every NAV point.

Example: 3-Year Rolling Returns for an Equity Mutual Fund

The table below is hypothetical and only for explanation.

Here, one 3-year window is negative, possibly because the time period includes a sharp correction. If the minimum is -3.72%, maximum is 12.86% and average return is around 7–8%, that range gives more context than a single 10-year CAGR.

Rolling Returns vs CAGR: Key Differences

CAGR is a single-period measure. Rolling returns are multiple overlapping periods rolled across time. Both use historical NAV data, but they answer different questions.

Trailing returns shown in factsheets are point-to-point returns for a specific period. For example, a 5-year trailing return as of the last day of Mar-2024 is a CAGR from Mar-2019 to Mar-2024. Rolling returns show many such windows.

Both metrics are backward-looking. Neither guarantees future performance. But rolling returns often provide better context on how often investors faced drawdowns across different time periods.

For example, two funds may both show 12% 10-year CAGR. Fund A’s 5-year rolling returns may mostly stay between 8% and 16%, while Fund B’s 5-year rolling returns may swing from -10% to +30%. CAGR hides this difference; rolling returns reveal it.

CAGR vs Point-to-Point (Trailing) Returns

In mutual fund factsheets, 1-year, 3-year, 5-year and since-inception returns are usually trailing returns. They are CAGRs calculated between specific dates.

For instance, a 3-year trailing return from jan 2025 to jul 2025 may change sharply if the latest six months include a rally or correction. This is why trailing returns are easy to read but can be affected by recency bias.

Many investors confuse trailing returns with “typical” returns. They are not typical; they are one specific time window.

Rolling Returns vs Point-to-Point Returns

Rolling returns and point-to-point returns use the same NAV history, but rolling returns convert one observation into many observations.

Rolling returns help because they:

• Show the full distribution of outcomes.
• Reveal how often returns generated were negative.
• Reduce the impact of lucky or unlucky start dates.
• Show performance across different market cycles.

A 5-year trailing return as of 31-Dec-2024 may show 14% CAGR, but 5-year rolling returns from 2010 to 2024 may show some windows near 0% or below. Analysts often prefer rolling analysis for consistency, while many retail investors first see only trailing CAGRs.

Why Rolling Returns Provide Additional Context

Rolling returns help investors understand not just how much a mutual fund grew, but how consistently it delivered returns.

They add context by showing:

• Minimum and maximum return range.
• Stability of historical returns.
• Frequency of negative returns.
• Benchmark comparison over various periods.
• Impact of different entry dates.

Historical market data has shown that negative return periods can occur across equity fund categories, although the frequency has often decreased as holding periods become longer. This supports the idea that longer investment tenure can reduce, but not remove, short-term stock market risk.

Rolling returns also help compare categories such as large cap, flexi cap, mid cap, sectoral funds and other asset classes. This is educational only; different categories carry different risks and are not directly comparable without context.

Example: If two hypothetical mutual funds both show 13% 10-year CAGR, but Fund X has a 5-year rolling range of 7% to 18% while Fund Y has -6% to 28%, the investor experience would be very different. The difference is about volatility, not just growth.

How Investors Use Rolling Returns to Analyse Mutual Fund Consistency

A disciplined investor or financial advisor may review:

• Percentage of 3-year periods with positive returns.
• Number of 3-year periods with negative returns.
• Time taken to recover after major drawdowns.
• How often the scheme beat its benchmark on a rolling basis.
• Whether half yearly or monthly rolling data changes the interpretation.
• Whether the fund manager’s style changed during the period.

Some investors use month-end or quarter-end rolling periods instead of daily data to reduce noise. Platforms like Novelty Wealth can track and monitor mutual funds in one place by aggregating NAV histories, benchmarks and return analytics so investors do not need to manage raw data themselves.

Common Mistakes When Evaluating Mutual Fund Returns

Both CAGR and rolling returns are useful, but they can be misused.

• Focusing only on recent one year trailing returns: Short-term performance can be driven by temporary market conditions.
• Selecting funds only by highest past CAGR: Past returns may reflect a favourable start date and end date.
• Ignoring the period used: Comparing different funds over different time periods can mislead.
• Mixing absolute return with annualised return: A 30% absolute return over three years is not the same as 30% per year.
• Assuming past rolling returns guarantee future performance: They do not, even though rolling return analysis and other performance metrics improve historical understanding.
• Ignoring drawdowns: Returns should be evaluated with risk, investment horizon, asset allocation and personal goals, ideally within a structured mutual fund portfolio analysis framework.
• Comparing different mutual categories incorrectly: A large cap fund and a sector fund may have different risk profiles.
• Ignoring costs and taxes: Expense ratios, exit loads and tax rules affect realised returns.
• Misunderstanding negative returns: Even established equity mutual funds can show negative 1-year or 3-year rolling returns during deep corrections.

Investors should read all scheme related documents carefully before making investment decisions. The phrase “scheme related documents” includes details on risk, costs, strategy and suitability.

How to Use CAGR and Rolling Returns Together

There is no single measure that fully captures mutual fund performance. CAGR and rolling returns work better together.

A practical process:

1. Use CAGR to compare long-term growth across funds in the same category.
2. Use rolling returns to test consistency and downside behaviour.
3. For under one year, focus on absolute or simple returns.
4. For 3–10 years, review both 3-year and 5-year rolling series, and align your choice between SIP and lump sum investing based on goals and market conditions.
5. Compare scheme returns with appropriate benchmark rolling returns.
6. For SIPs, also use XIRR or rolling SIP returns, and tools such as an online SIP calculator for planning contributions and goals.

Example: An investor evaluating two large cap mutual funds for a 7–10 year goal may first check 10-year CAGR. Then the investor may compare 3-year and 5-year rolling returns from 2010–2024 to see which fund had fewer negative periods and lower volatility.

It is also useful to track returns at the portfolio level, not only at the scheme level, especially when holdings include funds, stocks, deposits, insurance products and other asset classes, using a unified portfolio tracking tool for Indian investors.

Conclusion

• CAGR is a clean point-to-point measure of average annual growth.
• Rolling returns show performance across many starting dates and help assess consistency.
• Both are based on past performance and cannot predict future performance.
• Return metrics should be read with risk, goals, costs and investment tenure.

No single number can fully describe a mutual fund’s behaviour. The destination matters, but so does the journey: volatility, drawdowns and negative return phases. Tools such as Novelty Wealth can assist with data and analytics, while investment decisions should remain aligned with personal financial plans.

Disclaimer

Disclaimer: FW Fintech Private Limited (Novelty Wealth) is a SEBI Registered Investment Adviser (SEBI Registration No: INA000019415). This content is for informational & illustration purposes only and does not guarantee returns. Investments in securities market are subject to market risks. Use of Novelty Wealth’s platform is subject to its [Terms and Conditions](https://www.noveltywealth.in/terms-and-conditions).

Frequently Asked Questions (FAQs)

1. What is the difference between CAGR and rolling returns in mutual funds?

CAGR is one point-to-point annualized return. Rolling returns measure returns over many overlapping time periods.

2. Are rolling returns a better indicator of future performance than CAGR?

No metric can predict future performance. Rolling returns only show historical consistency better than a single CAGR.

3. How many years of data are ideal for rolling returns?

Where available, at least one full market cycle, such as 7–10 years, gives more useful context.

4. Can rolling returns be negative for long-term equity mutual funds?

Yes. Certain 1-year or 3-year windows can be negative during market downturns.

5. What is the difference between rolling returns and trailing returns?

Trailing returns use one start and end date. Rolling returns use many overlapping dates.

6. How can I calculate rolling returns myself?

Use Excel or an online calculator. Add NAV data, define the rolling period and shift each start date forward.

7. Which is more useful: 1-year, 3-year or 5-year rolling returns?

1-year rolling returns show short-term volatility. 3-year and 5-year rolling returns are often more useful for long-term equity evaluation.

8. Can I use CAGR to evaluate SIP investments?

CAGR gives scheme-level context, but SIP returns need cash-flow-aware metrics such as XIRR.

9. How often should I review rolling returns?

A half yearly or annual review is usually enough for long-term investors to avoid reacting to short-term noise.

10. Does Novelty Wealth provide tools to view CAGR and rolling returns?

Novelty Wealth helps users track mutual funds and other assets, and its analytics may include return metrics such as CAGR and rolling returns for educational portfolio review.