When investors look at mutual fund performance, the biggest mistake is assuming that “one return number” tells the complete story. In reality, CAGR, XIRR, and rolling returns measure three completely different dimensions of performance—growth, cash-flow adjusted returns, and consistency. Understanding the difference is essential before comparing funds or making investment decisions.
CA Kinjal Shah, Vice President, Bombay Chartered Accountants’ Society, explains this with an example. “CAGR, XIRR and rolling returns measure different things, so using the wrong one can mislead investors. CAGR suits a lump-sum investment because it shows the average annual growth from start to finish. XIRR is better for SIPs because it captures the timing and size of each monthly investment. Rolling returns show consistency across market cycles by testing returns over overlapping periods.”
He further added, “For example, a fund may have delivered 14% CAGR over five years, but its rolling returns could reveal that in some three-year blocks it stayed near 11% to 15%, while in weaker market phases it fell below that range. That helps investors see whether performance was steady or just lifted by one favourable period. A ₹1 lakh one-time investment over five years is best judged by CAGR, while a ₹5,000 monthly SIP should be tracked with XIRR. Rolling returns tell you whether the fund performed steadily, not just on one lucky date.”
Keeping these factors in mind, let us discuss the basic differences between the three to attain conceptual clarity. What you should consider is that all three answer different financial questions and are evolved with distinct objectives.
Understanding the 3 return metrics
I. CAGR (Compound Annual Growth Rate)
CAGR is the smoothed annual return of an investment. It assumes growth at a steady rate over time. It only pays attention to the initial and final value of an investment and ignores volatility in between. This metric is best suited for lump-sum investments.
II. XIRR (Extended Internal Rate of Return)
XIRR is a metric that calculates the actual annualised return when money is invested in multiple instalments at different times, for example, Systematic Investment Plans (SIPs). This metric takes into account the exact date and amount of each cash flow, making it a more realistic measure for staggered investments.
III. Concept of Rolling Returns
Rolling returns are a metric that measures performance over multiple overlapping time periods (for example, every 1-year or 3 -year window across several dates). This approach allows identifying whether a fund performs consistently across different market cycles rather than relying entirely on a single entry or exit point.
Fundamental differences between CAGR, XIRR and Rolling Returns
|
Parameter |
CAGR (Compound Annual Growth Rate) |
XIRR (Extended Internal Rate of Return) |
Rolling Returns |
|---|---|---|---|
| Definition | Annualised growth rate between start and end value. | Annualised return considering exact timing and value of all cash flows. | Average return calculated across multiple overlapping time periods. |
| Investment Type Best Suited For | Lump-sum investments (one-time investment) | SIPs, staggered investments, irregular cash flows | Evaluating fund consistency across market cycles |
| Time & Cash Flow Treatment | Ignores intermediate cash flows and timing | Fully incorporates timing, size, and frequency of investments | Ignores individual cash flows; focuses on repeated time windows |
| What It Actually Shows | How much did an investment grow per year on average? | What was the real return experience as an investor? | How consistently did the fund perform across different periods? |
| Sensitivity to Market Timing | Highly sensitive (depends on start/end point) | Low sensitivity (smooths timing differences in SIPs) | Low sensitivity (removes point-to-point bias) |
| Best Use Case | Comparing the long-term wealth growth of lump sum investments | Measuring SIP performance accurately | Checking fund stability and avoiding cherry-picked performance |
| Limitation | Can mislead due to lucky/unlucky entry/exit points | Can be complex to calculate and interpret | Does not reflect the actual investor cash flow experience |
Why this difference matters
The CAGR metric can make a fund look better or worse, depending heavily on when the investor actually entered the fund. XIRR, on the other hand, more accurately reflects the real SIP experience. Finally, rolling returns help in removing the bias of ‘one lucky time period’ and show whether performance is consistent or cyclical.
Hence, while navigating volatile markets, relying solely on trailing returns or CAGR can lead to misleading expectations. That is why, if you are comparing returns, you should consider the big picture before locking in any funds.
As a sensible investor, before opting for any mutual fund, it is your responsibility not to rely on a single return metric. Instead, light must be shed on factors such as CAGR, XIRR, market volatility, rolling returns, expense ratio, risk level, fund manager track record and investment horizon so that a reasonable decision can be made after considering these factors.
Eventually, mutual fund selection should be based on a combination of data-driven analysis and personal finance objectives. A well-informed decision in this regard can only be taken after proper due diligence and guidance from a certified financial advisor. Such an approach towards investments is much better than just chasing the highest return numbers.
For all personal finance updates, visit here.