Mutual Fund Returns Explained: CAGR, XIRR and Rolling Returns With Examples

A mutual fund may show several different return numbers on an investment platform or fact sheet.

You may see:

• absolute return;
• one-year return;
• three-year CAGR;
• five-year CAGR;
• SIP XIRR;
• benchmark return; and
• rolling returns.

The numbers can look confusing because they are not measuring exactly the same thing.

A 15% CAGR, a 13% XIRR and a 12% three-year rolling return do not necessarily contradict one another. Each measurement answers a different question.

Understanding the difference between CAGR, XIRR and rolling returns can help investors interpret mutual-fund performance more intelligently instead of simply choosing whichever percentage looks highest.

Quick Comparison: CAGR vs XIRR vs Rolling Returns

What Is CAGR?

CAGR stands for Compound Annual Growth Rate.

It converts the total growth of an investment over several years into an equivalent annual compounded rate.

The formula is:

CAGR = (Ending Value ÷ Beginning Value)^(1 ÷ Number of Years) − 1

Suppose an investor puts ₹1,00,000 into a mutual fund.

Five years later, the investment is worth ₹1,80,000.

The absolute gain is:

₹80,000

The absolute return is:

80%

But saying the fund returned 80% does not tell us the annual rate of growth.

Using CAGR:

CAGR ≈ 12.47% per year

This means ₹1 lakh growing at approximately 12.47% annually on a compounded basis would reach roughly ₹1.80 lakh after five years.

CAGR Does Not Mean the Fund Earned 12.47% Every Year

This is one of the most common misunderstandings.

A CAGR of 12.47% does not mean the fund delivered exactly 12.47% in each of the five years.

Actual annual returns might have looked something like:

Year 1: +18%

Year 2: -9%

Year 3: +25%

Year 4: +7%

Year 5: +21%

CAGR smooths that irregular journey into one annualised number.

That makes it useful for comparison, but it hides the volatility experienced along the way.

When Is CAGR Most Useful?

CAGR works particularly well when there is:

one investment at the beginning + one value at the end.

For example:

• lump-sum mutual-fund investment;
• index investment;
• ETF investment;
• property appreciation;
• business revenue growth.

It is less suitable when money is continuously being added or withdrawn.

That is where XIRR becomes useful.

What Is XIRR?

XIRR stands for Extended Internal Rate of Return.

It calculates an annualised return while taking into account the amount and exact date of each cash flow.

This makes XIRR particularly useful for SIP investors.

Suppose an investor puts ₹10,000 into a mutual fund each month.

The January contribution remains invested longer than the June contribution.

Therefore, it would be incorrect to treat every ₹10,000 investment as though it had been invested for exactly the same period.

XIRR accounts for this difference.

Simple SIP XIRR Example

Imagine these cash flows:

The six contributions total:

₹60,000

The year-end value is:

₹66,000

A simple calculation might suggest the investor earned 10%.

But that would ignore the fact that much of the ₹60,000 was invested for less than one year.

Using the exact investment dates produces an XIRR of roughly:

12.8%

The example shows why XIRR can provide a more meaningful annualised return for investments involving multiple cash flows.

How to Calculate XIRR in Excel or Google Sheets

The structure is straightforward.

Create two columns:

Column A: Cash flow amount

Column B: Date

Investments should normally be entered as negative amounts because money is leaving the investor.

The current value or redemption proceeds should be positive.

The formula is:

=XIRR(values, dates)

For example:

=XIRR(A2:A8,B2:B8)

The result is an annualised money-weighted return.

XIRR Is Not the Same as Fund Performance

This distinction is extremely important.

XIRR measures your investment experience.

Two investors in exactly the same mutual fund can have different XIRRs.

Investor A may have started SIPs during a market decline.

Investor B may have started after markets had already risen substantially.

Even though both own the same scheme, their investment dates are different.

Therefore:

Fund return ≠ necessarily investor return

XIRR captures this difference.

XIRR Can Also Handle Withdrawals

XIRR is not limited to SIPs.

It can also account for:

• additional lump-sum investments;
• irregular contributions;
• partial redemptions;
• systematic withdrawals;
• dividends or distributions;
• final portfolio value.

This makes it useful for analysing a real investment account with several transactions.

What Are Rolling Returns?

Rolling returns answer a different question.

Suppose you want to know how a mutual fund performed over three-year periods.

A normal trailing return might calculate:

1 January 2023 → 1 January 2026

That provides only one observation.

But what if the starting date happened to be unusually favourable or unusually poor?

Rolling-return analysis solves this by calculating many overlapping three-year periods.

For example:

January 2020 → January 2023

February 2020 → February 2023

March 2020 → March 2023

April 2020 → April 2023

…and so on.

Instead of judging the fund using one start date and one end date, you examine many different investment periods.

Why Are Rolling Returns Useful?

Rolling returns can help answer questions such as:

• How consistently has the fund performed?
• How often did it beat its benchmark?
• What was its worst three-year period?
• What was its best three-year period?
• How wide was the range of outcomes?
• How often were returns negative?
• Did performance depend heavily on one unusually favourable period?

This gives investors a much deeper picture than simply looking at one five-year CAGR.

Rolling Return Is Not One Magic Number

It is important to understand that rolling-return analysis produces a series of returns, not necessarily one single return.

For example, a ten-year study of three-year rolling periods might produce hundreds of observations.

An analyst could then study:

Average rolling return

Median rolling return

Minimum return

Maximum return

Percentage of positive observations

Percentage of periods beating the benchmark

These statistics describe the distribution of historical outcomes.

Example: Two Funds With the Same CAGR

Imagine Fund A and Fund B both show:

5-year CAGR: 12%

At first glance they appear identical.

But rolling analysis might reveal:

Fund A

3-year rolling returns mostly between 9% and 15%.

Fund B

3-year rolling returns ranging from -4% to 24%.

Both could still end with similar point-to-point CAGR.

But the journey was very different.

Fund A demonstrated a narrower historical range.

Fund B experienced much greater variation.

This does not automatically mean Fund A is “safer,” but it provides useful information about historical consistency.

What Is a Trailing Return?

Trailing return is another term investors frequently see.

A trailing return simply measures performance from a fixed historical date to today or another fixed end date.

For example:

1-year trailing return

3-year trailing return

5-year trailing return

If today were August 22, 2026, a three-year trailing return would measure approximately:

August 22, 2023 → August 22, 2026

The weakness is obvious.

Change the starting date and the answer may change substantially.

This is why rolling returns are useful when assessing consistency.

Absolute Return vs CAGR

Absolute return ignores time.

Suppose:

Investment = ₹1,00,000

Final value = ₹1,20,000

Absolute return:

20%

If that happened in six months, 20% would be a very large short-period gain.

If it happened over five years, the annualised return would be much lower.

Therefore, absolute return alone becomes less informative as the investment period becomes longer.

Which Return Should a SIP Investor Look At?

For an investor evaluating their own SIP portfolio, XIRR is generally the most relevant of these three measures because each instalment enters the market on a different date.

But the investor should not use personal XIRR alone to decide whether the mutual fund itself is good or bad.

A more useful evaluation can include:

Your XIRR

versus

scheme benchmark performance

plus

appropriate category peers

plus

risk and drawdown

plus

rolling-return consistency

This provides better context.

Which Return Should a Lump-Sum Investor Use?

For a lump-sum investment held for several years, CAGR provides a useful annualised measure.

However, investors should also examine:

• benchmark CAGR;
• volatility;
• drawdowns;
• portfolio composition;
• expense ratio;
• consistency over different periods.

A high CAGR achieved through unusually concentrated risk may not suit every investor.

Which Metric Is Best for Comparing Mutual Funds?

There is no need to choose only one.

For a more complete comparison, investors can examine several dimensions.

1. CAGR

Shows point-to-point annualised performance.

2. Rolling returns

Shows how performance varied depending on the investment starting date.

3. Benchmark comparison

Shows whether the scheme added value relative to the market or benchmark it is supposed to follow.

4. Risk

Consider volatility and drawdowns rather than focusing only on returns.

5. Expense ratio

Costs reduce the return ultimately retained by investors.

SEBI's 2026 mutual-fund framework also requires expense-related disclosures because costs affect investor outcomes.

Why Fund Returns and Investor Returns Can Differ

This difference is often called the behaviour gap.

Imagine a fund performs very well over ten years.

An investor may still earn much less if they:

• invest after sharp rallies;
• redeem during market declines;
• repeatedly switch funds;
• stop SIPs during corrections;
• chase whichever category recently performed best.

The fund's historical CAGR can therefore be excellent while the investor's XIRR is much lower.

The return actually earned depends partly on investor behaviour.

Do Rolling Returns Predict Future Performance?

No.

Rolling returns improve historical analysis, but they remain historical.

A fund that delivered consistent returns across previous market cycles may behave differently in the future because of:

• fund-manager changes;
• portfolio changes;
• valuation conditions;
• economic cycles;
• regulation;
• interest rates;
• market structure.

Past consistency is useful evidence, not a guarantee.

Common Mistakes Investors Should Avoid

Looking only at the highest return

A higher percentage does not automatically mean a better investment.

Comparing different periods

A three-year CAGR should not be compared directly with another fund's five-year CAGR.

Using CAGR for SIP performance

CAGR assumes a simpler beginning-to-end investment structure and does not properly handle repeated cash flows.

Treating XIRR as the fund's return

XIRR is influenced by the investor's transaction dates.

Assuming rolling returns mean safety

Rolling returns show historical consistency, not guaranteed future stability.

Ignoring benchmark performance

A 12% return may appear excellent until you discover that the relevant benchmark returned 16% over the same period.

Ignoring expenses and taxes

The final return retained by an investor can differ from a headline gross-return figure.

A Better Way to Read Mutual-Fund Performance

Instead of asking:

“Which fund gave the highest return?”

consider asking:

How did it perform relative to its benchmark?

Was the performance consistent across different periods?

How much risk was taken?

What were the worst drawdowns?

What expenses were charged?

Does the fund still fit my investment objective?

Return is important, but it should be evaluated alongside risk, cost and investment horizon.

Final Takeaway

CAGR, XIRR and rolling returns are complementary tools.

CAGR is useful for understanding the annualised growth of a lump-sum investment between two points.

XIRR is useful when investments and withdrawals occur on different dates, making it especially relevant for SIP portfolios.

Rolling returns help investors understand how a fund performed across many different historical investment periods rather than relying on a single start and end date.

None of these measures should be used alone.

A stronger mutual-fund evaluation combines:

returns + benchmark comparison + risk + consistency + costs + investment objective.

And most importantly, historical returns should never be interpreted as guaranteed future performance.

Updated: August 22, 2026

Source note: Return concepts are based on standard financial mathematics and current SEBI mutual-fund performance-disclosure principles. XIRR methodology follows the standard irregular-cash-flow calculation used by spreadsheet software.

Disclaimer: This article is for educational and informational purposes only and does not constitute investment advice or a recommendation to invest in any mutual-fund scheme. Mutual-fund investments are subject to market risks. Historical returns, CAGR, XIRR and rolling-return analysis cannot guarantee future performance.

Helpful Resources on LiveWorldMarket

Everything Is Compounding: How Small Actions Can Create Extraordinary Wealth Over Time

Understand how regular investing and time can influence long-term investment outcomes.

Read the Compounding Guide

How ₹18,000 a Month Can Potentially Grow From ₹1 Crore to ₹10 Crore

See an illustrative SIP example showing how time and assumed annualised returns can affect a long-term corpus.

Read the SIP Compounding Example

What Is an Index Fund? A Beginner’s Guide to Smart Long-Term Investing

Learn how index mutual funds work, how they track benchmarks and why tracking performance matters.

Read the Index Fund Guide

Mutual Funds vs SIF vs PMS vs AIF: Tax Rules in India

Understand why gross returns alone do not tell the full story and how taxes can affect the return ultimately retained by investors.

Read the Investment Tax Comparison

Financial Products Taxation in India FY 2026–27

Understand the tax treatment of mutual funds, ETFs and other investments before comparing post-tax returns.

Read the FY 2026–27 Tax Guide

Educational Note: Investment-return calculations are useful analytical tools, but they do not measure risk by themselves. Investors should consider investment objectives, time horizon, volatility, expenses and taxation together.