CAGR vs XIRR: Which Return Metric Should You Trust?

Why One Fund Can Show Three Different Returns

Three returns can describe the same fund over the same three years, and all of them can be accurate. A fund that rises +31.69% in absolute terms over 3 years reports a 3-year CAGR of 9.61%, while a monthly SIP inside that same fund can log an XIRR of 8.38%. None of these numbers is wrong; each answers a different question. Knowing which one to use stops you from comparing returns that were never comparable.

Foundation

For beginners learning to read their returns.

Absolute return: how much, ignoring time

Absolute return is the simplest measure: the percentage change between where an investment started and where it ended. ₹1 Lakh growing to ₹1.50 Lakh is a +50% absolute return. It works as a quick scoreboard and fails as a judge of pace, because +50% over 3 years and +50% over 10 years are very different outcomes. The formal definition sits in the absolute return glossary entry.

CAGR: the same growth, every year

CAGR, or compound annual growth rate, converts start and end values into one smoothed annual rate: the steady rate at which a lump sum would have grown to reach its final value. ₹1 Lakh doubling to ₹2 Lakh in 6 years is a 12.25% CAGR. That is why CAGR is the standard way to compare lump-sum investments of different lengths, and the number the CAGR glossary defines precisely.

XIRR: the return on your actual cash flows

Real investing rarely happens in one shot. You invest ₹10,000 every month for 36 months, and your later instalments have less time to grow than your first. XIRR (extended internal rate of return) annualizes a series of dated cash flows (each instalment in, the current value out) and reduces them to one rate. For SIPs, step-ups and portfolios that receive money on many dates, XIRR is the metric that matches your experience.

Which one answers your question?

• “How much did I make overall?” → Absolute return.
• “At what steady annual rate did a lump sum grow?” → CAGR.
• “What did my monthly investments actually earn?” → XIRR.

Practical Insights

For active investors tracking real portfolios.

One fund, one window, three numbers

Start a SIP of ₹10,000 per month for 36 months, ₹3.60 Lakh invested in total. The fund has a rough run: +24% in year 1, −10% in year 2, +18% in year 3, with the returns applied smoothly within each year.

What you measure	Number	What it answers
Fund absolute return (3 years)	+31.69%	How much did the fund’s value change, ignoring time?
Fund CAGR (3 years)	9.61%	At what steady annual rate did the fund grow?
SIP XIRR (your cash flows)	8.38%	What did your dated ₹10,000 instalments actually earn?

Compounding those yearly returns, the fund ends +31.69% higher, and in absolute terms the order of the good and bad years doesn’t matter at all. Your SIP is different: the instalments explained in What is SIP? enter at different NAVs, so no two rupees are exposed to the same slice of the path. The SIP ends at ₹4,08,674, and its XIRR is 8.38%. Three honest numbers, one fund: 31.7%, 9.61%, 8.38%.

The baseline: smooth growth flatters every number

Suppose the same fund grew smoothly at 12% a year instead. The identical ₹10,000 SIP would end at ₹4,30,793 with an XIRR of ≈11.97%, almost exactly the fund’s own return. That is the “no magic” baseline. When the path is smooth, your money-weighted return hugs the headline number. The 8.38% above is not a worse fund; it is the same underlying growth filtered through the timing of your instalments.

Cash drag: why a SIP trails a lump sum in a rising market

Invest ₹3.60 Lakh as a single lump sum at 12% for 3 years and you end with ₹5,05,774. The SIP version ends at ₹4,30,793. The gap is not a flaw in SIPs; it is the cost of gradual entry, because later instalments simply spend less time compounding. Compounding rewards time in the market, and a SIP buys that time in monthly instalments.

Which number should you quote?

Compare like with like. Line up a fund’s 3-year CAGR against its benchmark’s 3-year CAGR, and your SIP’s XIRR against a benchmark SIP over the same dates. Quoting a fund’s headline CAGR next to your SIP’s XIRR mixes a fund-runway number with a personal cash-flow number. The gap looks dramatic and teaches you nothing.

Advanced Concepts

For professionals who want the exact mechanics.

The three formulas

Absolute return has no time dimension:

$$\text{Absolute Return} = \frac{V_{\text{end}} - V_{\text{start}}}{V_{\text{start}}} \times 100\%$$

CAGR spreads that same growth evenly across n years:

$$\text{CAGR} = \left( \frac{V_{\text{end}}}{V_{\text{start}}} \right)^{\frac{1}{n}} - 1$$

A +50% absolute return over 3 years works out to 14.47% CAGR; the same +30% over 18 months annualizes to 19.11% CAGR. Absolute return hides time; CAGR exposes it.

XIRR replaces the ratio with an equation: find the rate r that sets the net present value of every dated cash flow to zero.

$$\sum_{i=1}^{m} \frac{CF_i}{(1 + r)^{t_i}} = 0$$

Here $CF_i$ is the cash flow on date i (negative for each SIP instalment, positive for the final value), $t_i$ is the elapsed time from the first cash flow in years, and m is the number of cash flows. No closed-form solution exists, so the rate is found iteratively: Newton-Raphson, the same approach Excel’s XIRR uses. Our methodology documents the solver.

Time-weighted vs money-weighted

A fund factsheet’s CAGR is a time-weighted return: it strips out cash-flow timing to measure the manager’s consistency, and SEBI-regulated factsheets report it as standard. Your SIP’s XIRR is a money-weighted return: it reflects the size and date of every rupee you committed. The two diverge whenever markets are volatile or cash flows are uneven. Use time-weighted return to judge a fund, and money-weighted return, your XIRR, to judge yourself.

Edge cases

• With one investment and one redemption, XIRR converges with CAGR; the two diverge only when there are multiple dated cash flows.
• XIRR annualizes on a 365-day convention from the first cash flow. For holding periods under a year, annualized figures exaggerate. Treat them as directional, not predictive.
• If cash flows change sign more than once (invest, redeem, invest again), more than one mathematical rate can exist; calculators return the one nearest their starting guess.

Key Takeaways

• Absolute return ignores time: +31.69% tells you the size of a gain, not the 3 years it took.
• Use CAGR for a single lump sum; XIRR for SIPs, step-ups and any portfolio built from dated cash flows.
• Smooth growth makes a SIP’s XIRR hug the fund’s return; divergence is a timing effect, not a flaw.

Common Mistakes

• Mistake #1: Comparing your SIP’s XIRR with a fund’s headline CAGR, which measure different things over different windows.
• Mistake #2: Quoting absolute return without its time frame; +31.69% over 3 years is not the same signal as over 10.
• Mistake #3: Annualizing a short holding period; over a few months, an “annualized” return is mostly noise.

Try the Calculators

Put these concepts into practice using our interactive tools:

• Turn start and end values into a steady annual rate with the CAGR Calculator.
• Compute the XIRR behind your own instalment dates and amounts with the XIRR Calculator.