CAGR vs XIRR vs Absolute Return: Which Number Should You Trust?

Quick answer: Each of these answers a different question.

• Absolute return asks how much your money grew in total. Use it for holdings under a year.
• CAGR asks what yearly rate turned one starting amount into one ending amount. Use it for a single lump sum held for a year or more, and to compare funds.
• XIRR asks what yearly rate you earned across many investments on different dates. Use it for SIPs, top-ups and withdrawals.

Most confusion comes from using the wrong one. A “61% return” sounds better than a “10% CAGR”, but they can describe exactly the same investment.

Last updated: 10 November 2026

The three in one table

Absolute return: the simplest, and the most misused

Formula: Absolute return = (Current value − Amount invested) ÷ Amount invested × 100

Example: You invest ₹1,00,000. Five years later it’s worth ₹1,61,051.

Absolute return = (1,61,051 − 1,00,000) ÷ 1,00,000 = 61.05%

That’s correct, but it doesn’t say how long the growth took. 61% over 2 years is excellent. Over 10 years, it’s poor. Absolute return can’t tell the two apart.

A common mistake: dividing absolute return by the number of years. 61.05% ÷ 5 = 12.2% “a year” sounds reasonable, but it’s wrong. It ignores compounding, so it always overstates the real yearly rate when returns are positive.

CAGR: the yearly growth rate of a lump sum

CAGR (Compound Annual Growth Rate) is the steady yearly rate that would take your starting amount to your ending amount.

CAGR = (Ending value ÷ Starting value)^(1 ÷ Years) − 1

Using the same example: (1,61,051 ÷ 1,00,000)^(1/5) − 1 = 10.0% a year.

So “61% absolute” and “10% CAGR” describe the same investment. Because of compounding, the real yearly rate is 10%, not 12.2%.

Why CAGR is the standard for comparing funds

The 1-year, 3-year and 5-year returns on a fund’s factsheet are point-to-point CAGRs. They show what one lump sum, invested on a fixed date, would have earned each year. That makes it fair to compare funds, or a fund against its benchmark, over the same period.

What CAGR hides

CAGR smooths over the ride. A fund that went +40%, −20%, +25% over three years has a CAGR of about 11.9%. One that rose a steady 12% each year has a CAGR of 12%. The CAGRs are almost the same. The experience of holding them is very different. Check the fund’s standard deviation and worst fall as well (see our Sharpe ratio guide).

XIRR: for anything with more than one cash flow

A SIP is really dozens of small lump sums, each invested on a different date. CAGR needs a single start date, so it can’t handle that. XIRR can.

Here’s a quick example. A ₹5,000 monthly SIP for 2025 (₹60,000 in total) is worth ₹64,500 in January 2026:

• Absolute return: 7.5%
• XIRR: about 14.1% a year, because on average each rupee was invested for only about six and a half months.

For the formula, Excel steps and what counts as a “good” XIRR, see What Is XIRR in Mutual Funds?

For a single lump sum with no other transactions, XIRR and CAGR give the same answer.

Why you shouldn’t annualise short-term returns

Say a fund is up 3% after 2 months. Annualised, that’s (1.03)^6 − 1 = 19.4% a year.

That number assumes the same 3% will repeat every two months for a whole year, which is very unlikely. For holdings under a year, stick with absolute return. This is also why your app’s XIRR jumps around wildly in the first months of a new SIP.

Trailing returns vs rolling returns

You’ll see these two terms on research sites:

• Trailing returns are CAGRs ending today, for example the 3-year return up to yesterday. They depend heavily on where the market is right now. A 3-year return measured just after a crash looks terrible, and one measured at a peak looks great.
• Rolling returns take every 3-year (or 5-year) period over a long history and show the average, the best and the worst. They show how consistent a fund has been, not just how it looks today.

If you’re choosing between funds, rolling returns over 5+ years tell you far more than a single trailing figure. We use this approach in Why the Best-Performing Fund Is Often a Bad Choice.

Which return to use: quick decision guide

Three questions to ask when someone quotes a return

The next time a fund is pitched as having given “a 30% return”, ask:

1. Which kind? Absolute, CAGR or XIRR?
2. Over what period, ending when? A return ending at a market peak flatters everyone.
3. Compared with what? The fund’s benchmark and category average over the same dates.

If you don’t get clear answers to all three, the number on its own doesn’t tell you much.

FAQs

What is CAGR in mutual funds?
It’s the yearly rate at which a single investment would have grown to its current value, assuming steady compounding. Fund factsheets use it for 1, 3 and 5-year returns.

What is absolute return in mutual funds?
The total percentage gain or loss on your investment, without considering how long it took.

Is CAGR better than XIRR?
Neither is better. They answer different questions. CAGR suits a single lump sum. XIRR suits SIPs and other multiple cash flows. For a lump sum, both give the same number.

Why is my absolute return higher than my CAGR?
Absolute return is the total gain over the whole period. CAGR spreads that gain across the years with compounding, so for any holding longer than a year, the yearly CAGR figure is smaller.

Can CAGR be negative?
Yes, if the investment is worth less than you put in.

How do I convert absolute return to CAGR?
CAGR = (1 + absolute return)^(1 ÷ years) − 1. For example, 61.05% over 5 years: (1.6105)^(0.2) − 1 = 10%.

Mutual fund investments are subject to market risks. Read all scheme-related documents carefully. RingMoney is an AMFI-registered mutual fund distributor (ARN-320453). All examples are illustrative and don’t indicate the returns of any scheme. Past performance doesn’t guarantee future returns.

Try it: SIP Calculator · Related reading: What Is XIRR in Mutual Funds? · SIP vs Lumpsum · Flexi Cap vs Index Fund