CAGR, XIRR OR ROLLING RETURNS: WHAT SMART INVESTORS COMPARE

When evaluating mutual fund performance, many investors make the mistake of relying on a single return metric to judge the entire investment story. However, CAGR, XIRR, and rolling returns each measure a different dimension of performance-overall growth, cash-flow-adjusted returns, and consistency of returns. Understanding these distinctions is essential before comparing funds or making investment decisions.

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.

For example, a mutual fund may report a 14% CAGR over five years, suggesting strong overall growth. Yet, its rolling returns could show that returns varied between 11% and 15% across different three-year periods and even fell lower during weaker market phases. This provides deeper insight into whether the fund delivered stable performance consistently or whether returns were driven by a few favourable market periods.

The choice of return metric also depends on the nature of the investment. A one-time lump-sum investment of ₹1 lakh over five years is best assessed using CAGR, as it measures the compounded annual growth of a single investment. In contrast, a monthly SIP of ₹10,000 should be evaluated using XIRR because it accounts for multiple cash inflows made at different dates. Rolling returns, meanwhile, help investors analyse how consistently a fund has performed across various market cycles rather than between just one start and end date.

Although all three metrics are used to evaluate investment performance, they differ significantly in both methodology and purpose. Each metric answers a different financial question:

• CAGR indicates how much a lump-sum investment has grown annually over a specific period.
• XIRR shows the actual return earned when investments are made at different points in time.
• Rolling Returns reveal the consistency and reliability of performance across market cycles

Therefore, no single metric should be used in isolation. Investors should analyse CAGR, XIRR, and rolling returns together to gain a more accurate, balanced, and comprehensive understanding of a mutual fund's true performance.

In the context of navigating volatile markets, it's important to note that relying exclusively on trailing returns or Compound Annual Growth Rate (CAGR) can result in inaccurate expectations. Therefore, when comparing returns, it's advisable to consider the broader picture before zeroing in on funds. As a prudent investor, it's your duty not to depend on a single return metric when choosing a mutual fund. Ultimately, mutual fund selection should be based on a blend of data-driven analysis and your personal financial goals.

How to Calculate Compound Annual Growth Rate (CAGR)

To calculate the CAGR of an investment:

1. Divide the value of an investment at the end of the period by its value at the beginning of that period.
2. Raise the result to an exponent of one divided by the number of years.
3. Subtract one from the subsequent result.
4. Multiply by 100 to convert the answer into a percentage.

CAGR remains popular because it converts performance into a single annualised return, making it easy to compare funds, asset classes, and investment periods. Used properly, it provides a clear summary for investors with a defined entry point, exit point, and long holding horizon. The issue arises when CAGR is treated as a complete measure of investment quality rather than a limited snapshot.

Its main weakness is that it considers only the starting and ending values, ignoring everything in between. Market crashes, volatility, stagnation, and rallies are compressed into one smooth figure. As a result, CAGR can vary significantly depending on the period chosen.

This creates scope for distortion. A fund that delivered just 6-7% CAGR over ten years may show 16% over the last three years after a late rally. Conversely, a fund that compounded at 14% over a decade could display only 8-9% if recent performance weakened. Shorter periods can therefore create misleading impressions of long-term performance.

This is common in fund marketing, where strong short-term CAGR figures are often highlighted after market rallies. Financial websites also tend to default to one- or three-year comparisons, emphasising recent momentum rather than sustained investment skill.

Rolling returns address this problem by removing dependence on a single start and end date. Instead of measuring one period, they calculate returns across every possible period of a fixed length within a fund's history. For example, a three-year rolling return on a ten-year fund measures January 2021-January 2024, then February 2021-February 2024, and so on.

While CAGR shows the outcome of investing at one specific point in time, rolling returns reveal the range of outcomes across multiple entry points, making them a far better measure of consistency and reliability.

Four rolling-return metrics matter most:

• Average rolling return: Indicates the fund's typical long-term performance.
• Minimum rolling return: Shows the worst outcome investors experienced, revealing downside risk.
• Percentage of positive periods: Measures how often investors earned positive returns across rolling windows.
• Consistency against Benchmark: Strong funds should outperform benchmarks across most periods, not only during bull markets.

How is XIRR Different from CAGR and Rolling Returns?

As explained earlier, CAGR and Rolling Returns are widely used to evaluate investment performance. However, these metrics are not well-suited for investments that involve multiple cash flows over time.

For instance, consider an investor making monthly SIP contributions for 36 months. CAGR can measure the overall growth of the mutual fund during the investment period, but it does not accurately reflect the return earned on each individual contribution made at different points in time. Calculating separate CAGR values for every SIP installment would be both time-consuming and complicated.

In summary, while XIRR is best for investments with irregular cash flows, CAGR is ideal for lump-sum investments with a single initial and final value, and Rolling Returns offer a more dynamic view of investment performance over time.