CAGR vs XIRR vs Rolling Returns: Mutual Fund Returns Explained

Open any mutual fund app or factsheet and you'll be greeted by a small dictionary of terms: Absolute Return, CAGR, XIRR, Trailing Return, Rolling Return. Each one is a "return," yet each tells a different story about the same investment.

Most investors don't pause here. They glance at the biggest number on the screen, form a judgement, and move on. The trouble is, a fund can look brilliant by one metric and ordinary by another — not because anyone is hiding anything, but because each metric measures something different. An investor who doesn't know the difference isn't reading the fund's performance; they're reading a number out of context.

This article decodes these return metrics one by one — what each measures, when it is useful, and when it can mislead — so the next time you see a return figure, you know exactly what it is telling you, and what it is not.

What are Mutual Fund Returns?

So when we talk about mutual fund returns we are talking about the money your investment makes over time. You can generate returns in Mutual fund in the following ways-

• Capital Appreciation: The funds NAV (Net Asset Value) going up
• Dividend Income: The mutual fund paying out dividends or IDCW

Let’s take an example. You put ₹1,00,000 into a fund. After one year the value of your fund is ₹1,20,000. This means your mutual fund investment has made ₹20,000. The ₹20,000 is the return on your mutual fund investment.

But how should that return be measured? That's where different types of mutual fund returns come into the picture.

Types of Mutual Fund Returns

1. Absolute Returns: The Simplest Return Calculation

Absolute return measures how much your investment has grown between two points in time.

Formula: Absolute Return = (Current Value – Invested Amount) ÷ Invested Amount × 100

Example: (Illustration Purpose Only)

You invest ₹1,00,000. After 8 months, the value becomes ₹1,20,000. Absolute Return = ((₹1,20,000 – ₹1,00,000) ÷ ₹1,00,000) × 100 = 20%

Simple enough.

When Should You Use It?

Absolute returns are most useful when the investment is in growth assets like equity & the period is less than one year.

The Drawback: Absolute returns do not consider the holding period.

Suppose: Investor A earns 50% in 2 years. Investor B earns 50% in 10 years. Both show the same absolute return of 50%, yet Investor A's money clearly worked much harder. Without the time dimension, the number tells you how much you earned, but not how fast.

This is why, for any holding period beyond a year, investors need annualized return metrics — which brings us to CAGR.

Why Annualized Returns Matter

When investments run for several years, simply looking at total return is not enough. We need a metric that tells us: "How much did my money grow every year on average?"

This brings us to CAGR.

2. What is CAGR?

The Compound Annual Growth Rate or CAGR is a way to figure out how fast your investment is growing. It helps you understand what the growth rate of your investment would be if it was growing at the pace every single year.

The Compound Annual Growth Rate(CAGR) is really about finding a growth rate for your investment over time.The Compound Annual Growth Rate helps you understand the yearly growth of a lump sum investment. It gives you an idea of how your investment grew each year on average.

Example: (Illustration Purpose Only)

Suppose you invested ₹1,00,000.
After 5 years, it became ₹1,61,000 @ 10% CAGR. Your money did not necessarily grow exactly 10% every year. Markets move up and down. However, CAGR tells us that the investment effectively grew at approximately 10% per year.

Real-Life Example

Suppose two investors start with ₹1,00,000 each and both end up with ₹1,50,000.

At first glance, both investments appear equally successful because they generated the same 50% return. However, the time taken to achieve that return is very different.

Investor A:
=RATE(2,0,-100000,150000,1) → CAGR ≈ 22%

Investor B:
=RATE(10,0,-100000,150000,1) → CAGR ≈ 4%

This shows why simply looking at total returns can be misleading. Both investors earned the same 50% return, but Investor A achieved it in just 2 years, while Investor B took 10 years.

CAGR converts the total return into an annual growth rate, allowing investors to compare investments that have different holding periods. In this example, CAGR clearly shows that Investor A's money grew much faster than Investor B's, even though the final return percentage was the same.

Disclaimer: The figures shown are for illustration purposes only and are based on assumed rates of return. Actual returns may vary depending on market conditions and investment performance. Past performance is not indicative of future results.

Best Used For

• One-time lumpsum investments
• Comparing long-term fund performance
• Evaluating historical fund growth

Limitations: Suppose you invest ₹50,000 at the start of Year 1, ₹60,000 at the start of Year 2, and ₹70,000 at the start of Year 3. At the end of Year 3, the total value is ₹2,10,000.

Here, CAGR fails - there are three cashflows of different amounts, and each has been invested for a different length of time (3 years, 2 years, and 1 year respectively). There is no single starting amount and date to apply the CAGR formula to.

Notice, however, that the cashflows still have one thing in common: they occur at regular intervals (yearly). When cash flows follow a regular frequency like this — even if the amounts differ the return of the entire series can be computed using IRR, the Internal Rate of Return.

3. What is IRR?

IRR means Internal Rate of Return. This is a way to figure out how money you are making when you have a lot of money coming in and going out.

It helps you answer a question: what rate of return each year will make all my investments and the money I take out equal to how much money I have in the end. IRR is really about finding that one rate of return that makes everything balance out.

Simple Example (Illustration Purpose Only)

Suppose you invest:

• ₹50,000 in Year 1
• ₹60,000 in Year 2
• ₹70,000 in Year 3

At the end of Year 4, the investment value becomes ₹2,10,000.

Calculating IRR for Multiple Cashflows

50,000 / (1 + r)^3 + 60,000 / (1 + r)^2 + 70,000 / (1 + r)^1 = 2,10,000 so, r = IRR ≈ 8.39%

If you look at the investments made over three years. The ₹50,000 invested in Year 1 has time to grow than the ₹60,000 invested in Year 2. The ₹70,000 invested in Year 3 has the amount of time to grow. Since there are multiple uneven cash flows you cannot use CAGR directly. The IRR formula looks at all the cash flows together and calculates one return. This return makes the total money invested equal to the value you receive.

In this example the IRR is around 8.39%. This means your entire investment journey is like earning about 8.39%, per year. The investments were made in years and in different amounts but the IRR gives you a single annual return. The ₹50,000, ₹60,000 and ₹70,000 investments all contribute to this 8.39% return. The IRR helps you understand the performance of all your investments together.

Disclaimer: The figures shown are for illustration purposes only and are based on assumed rates of return. Actual returns may vary depending on market conditions and investment performance. Past performance is not indicative of future results.

Where is IRR Generally Used?

IRR is commonly used in:

• Insurance illustrations
• Rental returns calculation
• Business investments
• Capital budgeting decisions

The Drawback: IRR assumes that all cash flows occur at regular intervals — yearly, monthly, or quarterly. The formula counts periods, not actual dates.

Real-life investing is rarely this disciplined. You may invest ₹50,000 in January, add ₹25,000 in March when you get a bonus, withdraw ₹30,000 in August for an emergency, and top up again in December. The gaps between transactions are uneven — 2 months, 5 months, 4 months. IRR has no way to handle this. It would treat every gap as one equal "period," distorting the true return. The moment your cashflows fall on irregular dates, IRR gives an inaccurate picture.

What investors need is a metric that works with the actual date of every transaction — and that is exactly what XIRR does.

4. What is XIRR?

XIRR is something called the Extended Internal Rate of Return. This thing calculates the returns on your money each year. It does this by looking at the dates when you put money in and took money out. XIRR is really good at figuring out how well your investments are doing over time by using the dates of every single investment and every single withdrawal.

Suppose you make the following investments: (Illustration Purpose Only)

On 31 Dec 2025, suppose your portfolio value is ₹1,65,000.

Solution (Illustration Purpose Only)

XIRR is the rate (r) that satisfies:

50,000 / (1 + r)^3 + 25,000 / (1 + r)^1.80 + 30,000 / (1 + r)^0.36 + 20,000 / (1 + r)^0.02
= 1,54,000
Solving for r gives: r = 11.83%

XIRR considers the exact date of every investment and the final portfolio value to calculate an annualized return for the entire investment journey.

In this example the XIRR is 11.83%. This means that despite the investments being made at times and in different amounts the overall portfolio generated an annualized return of about 11.83% on our investments.

This is why investment platforms use XIRR to display returns for investments like these. They use XIRR to show returns, for investments, additional investments, withdrawals and overall portfolio performance.

Disclaimer: The figures shown are for illustration purposes only and are based on assumed rates of return. Actual returns may vary depending on market conditions and investment performance. Past performance is not indicative of future results.

Best Used For

• SIP investments
• Additional lumpsum investments
• Systematic Withdrawal Plans (SWPs)
• Complete portfolio performance tracking

For most investors, XIRR is the closest representation of their actual investment experience.

CAGR vs XIRR

One of the most common investor questions is: CAGR vs XIRR — which one should I use?

Simple Rule

→ CAGR (Frequency and Cash flows are same)
→ IRR (multiple Uneven - cashflows, regular intervals)
→ XIRR (any cashflows, uneven frequency). 

5. What Are Rolling Returns?

Rolling returns measure returns across multiple overlapping periods instead of a single start and end date. Among all mutual fund performance metrics, rolling returns are often considered one of the most reliable.

Example (Illustration Purpose Only)

Let's assume we are evaluating a fund's 3-year rolling returns over a 10-year period. Instead of calculating only one return from 31st March 2023 to 31st March 2026, we calculate:

• 31st March 2016 to 31st March 2019
• 1st April 2016 to 1st April 2019
• 2nd April 2016 to 2nd April 2019 continue this process every month until the latest available date.
• Last observation - 31st March 2023 to 31st March 2026

This may create more than 2500 3-year return observations.

Advantages of Rolling returns:

• Reduces Timing Bias
• Shows Consistency
• Captures Multiple Market Cycles
• Improves Fund Comparison
• Provides Better Decision-Making Data

Why Past point-to-points Returns Can Mislead

Trailing returns simply calculate: Today's NAV versus NAV a few years ago. The result depends heavily on current market conditions. If markets are at a peak or a major low, trailing returns can give a distorted picture. Rolling returns reduce this timing bias.

Why Investors Should Care

Rolling returns help identify funds that:

• Perform consistently
• Handle bull markets well
• Survive bear markets effectively
• Beat benchmarks across different market cycles

Conclusion

Understanding mutual fund returns is not about becoming a finance expert. It is about making smarter investment decisions.

While understanding return metrics is valuable, interpreting them correctly is equally important. A return number in isolation rarely tells the complete story. Factors such as investment horizon, risk appetite, market conditions, and portfolio allocation all influence how those numbers should be viewed. This is where a Mutual Fund Distributor can add value by helping investors focus on the right metrics, stay disciplined during market volatility, and make decisions aligned with their long-term investment needs.

Remember:

• Rolling returns help identify consistency.
• Compounding rewards patience.
• A Step-up SIP can accelerate wealth building.
• Proper nominations and a valid Will help protect your legacy.

The next time you review your portfolio, don't just look at profit or loss. Look at the right metric. Because the right return number often tells a completely different story.

FAQs

Q) What is the difference between CAGR, IRR and XIRR?
CAGR can be used for single cash flows and also for multiple cash flows, however for multiple cash flows the frequency and the amount should be even. 

IRR can be used for multiple cash flows when there is no specific date on which the investment is made. For IRR the cash flows can be even but the frequency should be the same.

XIRR can be calculated for any investment even if the investment is made on a specific date. In case of uneven frequency XIRR should be used.

Q) Which should I use: CAGR, IRR or XIRR?
It depends on the cash flows, their frequency, and whether specific dates are involved.

Use CAGR for a single cash flow or equal cash flows at an even frequency. Use IRR for multiple cash flows at a regular frequency. Use XIRR when cash flows occur on specific dates or at uneven intervals.

Q) What is XIRR in mutual funds?
XIRR is the annualized return earned on investments made on different dates. If the investment is made on different dates XIRR is used to calculate the returns.

Q) How are SIP returns calculated?
SIP returns are generally calculated using XIRR. XIRR accounts for the date and amount of each SIP installment, providing a realistic view of the return generated by your investment journey.

Q) What are rolling returns in mutual funds?
Rolling returns measure returns across multiple overlapping periods rather than a single start and end date. They help investors understand how consistently a fund has performed across different market conditions.

Mutual Fund investments are subject to market risks, read all scheme related documents carefully.