Back to Vera Insights
Investing 8 min read

CAGR vs. XIRR: Which Return Metric Should You Actually Look At?

October 28, 2026

Every mutual fund factsheet, financial portal, and performance leaderboard displays trailing returns prominently: “3-Year CAGR: 26.4%”, “5-Year CAGR: 22.1%”.

Relying on these rankings, an investor picks the fund sitting at rank #1 on the 3-year CAGR chart and starts a ₹10,000 monthly Systematic Investment Plan (SIP). Three years later, they check their portfolio statement and are baffled. Their realized annual return is nowhere near 26%, and a peer fund with a lower advertised CAGR produced substantially more wealth.

How can a mutual fund have a higher CAGR than its rival, yet leave an SIP investor with less money? The answer lies in the mathematical divide between CAGR (Compounded Annual Growth Rate) and XIRR (Extended Internal Rate of Return), and how cash flow timing alters your real-world profits.


What Is CAGR? (And How Is It Calculated?)

CAGR (Compounded Annual Growth Rate) measures the constant annual rate at which a lumpsum investment would have grown if it compounded smoothly from start to finish.

It is a point-to-point metric that requires only two data points: the initial investment value on Day 1 and the final valuation at the end of the tenure.

The Formula

CAGR=(Final ValueInitial Value)1n−1\text{CAGR} = \left(\frac{\text{Final Value}}{\text{Initial Value}}\right)^{\frac{1}{n}} - 1

Where:

  • Final Value\text{Final Value} = Portfolio value at the end of the period
  • Initial Value\text{Initial Value} = Initial lumpsum investment
  • nn = Investment duration in years

Concrete Example:

Suppose you invest a single lumpsum of ₹1,00,000 in a fund. Exactly 3 years later, your investment is worth ₹1,72,800.

CAGR=(1,72,8001,00,000)13−1\text{CAGR} = \left(\frac{1{,}72{,}800}{1{,}00{,}000}\right)^{\frac{1}{3}} - 1

Calculating this step by step:

1,72,8001,00,000=1.728\frac{1{,}72{,}800}{1{,}00{,}000} = 1.728 (1.728)13=1.20(1.728)^{\frac{1}{3}} = 1.20 1.20−1=0.20 or 20.0% p.a.1.20 - 1 = 0.20 \text{ or } 20.0\% \text{ p.a.}

Your money compounded at an effective annual rate of 20.0%.

The Key Limitation of CAGR: It assumes a single initial deposit and a single final withdrawal. It is completely blind to any cash inflows or outflows occurring along the way, as well as the path taken between start and finish.


What Is XIRR? (And How Is It Calculated?)

While CAGR works for a single lumpsum, most retail investors accumulate wealth systematically through periodic cash flows such as monthly SIPs, quarterly bonuses, or occasional withdrawals.

XIRR (Extended Internal Rate of Return) is a money-weighted annualized return metric designed specifically for multiple cash flows occurring on different dates. It calculates the single discount rate that equates the net present value (NPV) of all cash inflows and outflows to zero.

The Mathematical Equation

∑i=1NCi(1+r)di−d0365=0\sum_{i=1}^{N} \frac{C_i}{(1 + r)^{\frac{d_i - d_0}{365}}} = 0

Where:

  • CiC_i = Cash flow on date did_i (negative for investments, positive for current portfolio value)
  • d0d_0 = Date of the first investment
  • did_i = Date of subsequent cash flow ii
  • rr = The XIRR (internal rate of return)

Concrete Example:

Suppose you invest ₹10,000 every six months over 1.5 years (three installments totaling ₹30,000):

  • 01-Jan-2024: -₹10,000 (invested for 18 months)
  • 01-Jul-2024: -₹10,000 (invested for 12 months)
  • 01-Jan-2025: -₹10,000 (invested for 6 months)
  • 01-Jul-2025 (Current Portfolio Value): +₹34,500

Each installment had a different amount of time to compound. Your first ₹10,000 worked for 1.5 years, while your last ₹10,000 worked for only 6 months.

Using the XIRR equation, the annualized return is 14.8%. If you tried to calculate a simple CAGR by comparing the ₹30,000 total outlay directly to ₹34,500 over 1.5 years, you would get an inaccurate return of 9.7%, because CAGR mistakenly assumes all ₹30,000 was deployed on Day 1.


Why XIRR Is the True Metric for SIP Investors

In an SIP, you never invest your entire capital at the starting bell. Your capital at risk starts small (just your first installment) and expands with every passing month.

Because XIRR is money-weighted, it assigns greater weight to market returns when your deployed capital is large, and lesser weight when your capital is small.

This introduces the Sequence of Returns Effect:

  1. For a lumpsum investment, return sequence does not matter. Gaining +50% in Year 1 and losing -10% in Year 3 yields the exact same lumpsum wealth as losing -10% in Year 1 and gaining +50% in Year 3.
  2. For an SIP investment, return sequence is everything. A sharp crash in Year 3 hurts you far more than a crash in Year 1, because the Year 3 crash strikes when your accumulated corpus is at its peak.

The Real-World Paradox: Higher CAGR, Lower SIP Wealth

To see how this plays out in actual markets, consider an empirical 3-year study comparing two prominent midcap funds from January 2023 to January 2026.

  • Fund 1: Motilal Oswal Midcap Fund (Direct - Growth)
  • Fund 2: ICICI Prudential MidCap Fund (Direct - Growth)
  • Strategy: ₹10,000 monthly SIP (36 installments = ₹3,60,000 total capital invested)
Performance MetricMotilal Oswal Midcap (Fund 1)ICICI Prudential MidCap (Fund 2)Difference / Outcome
Starting NAV (02-Jan-2023)₹56.52₹185.90Baseline
Ending NAV (05-Jan-2026)₹114.48₹359.91Baseline
Absolute NAV Growth+102.55%+93.60%Fund 1 gained +8.95% more
Point-to-Point CAGR26.43% p.a.24.55% p.a.Fund 1 leads (+1.88% p.a.)
Total Amount Invested₹3,60,000₹3,60,000Identical Capital
Final Portfolio Value₹4,75,009₹5,04,777Fund 2 leads (+₹29,768)
Net Profit Earned+₹1,15,009+₹1,44,777Fund 2 delivered +25.9% more profit
Monthly SIP XIRR18.69% p.a.23.02% p.a.Fund 2 leads (+4.33% p.a.)

Why Did the Fund With Lower CAGR Create More Wealth?

On paper, Fund 1 looked like the clear winner: its NAV more than doubled and its CAGR beat Fund 2 by nearly 1.9% per year. Yet, the SIP investor in Fund 2 walked away with ₹29,768 more cash and an XIRR that was 4.33% per year higher.

The annual return breakdown explains why:

Calendar YearMotilal Oswal Midcap (Fund 1)ICICI Prudential MidCap (Fund 2)The SIP Capital Dynamic
2023+42.57%+30.66%Fund 1 exploded early, but investor capital was tiny (under ₹1.2 Lakh).
2024+57.20%+31.28%Fund 1 continued a massive rally; SIP investor bought units at peak prices.
2025-9.64%+12.87%The turning point: Fund 1 dropped ~10% right when accumulated capital was at peak. Fund 2 continued steady compounding.

Fund 1 front-loaded its performance. By the time the investor had accumulated significant units in 2025, the fund suffered a drawdown, inflicting heavy damage on a large corpus.

In contrast, Fund 2 delivered steady, consistent gains throughout. Its positive performance in Year 3 amplified the investor peak capital, proving that steady compounding crushes front-loaded momentum in an SIP.


What Should Investors Actually Look At When Comparing Funds?

Choosing funds based purely on trailing 3-year or 5-year point-to-point CAGR is one of the most common mistakes in mutual fund investing.

To evaluate funds effectively, follow this framework:

1. Align the Metric With Your Investment Mode

  • If investing a lumpsum: CAGR is mathematically valid, but point-to-point numbers remain vulnerable to start-and-end date bias.
  • If investing via SIP: Ignore lumpsum trailing CAGR tables. Always compare historical SIP XIRR across identical 3-year, 5-year, and 7-year windows.

2. Prioritize Rolling Returns Over Trailing Returns

Trailing CAGR only shows what happened between two arbitrary calendar dates. A fund that had a massive run two years ago might look brilliant on a 3-year chart even if it has stagnated for the past twelve months.

Rolling returns calculate CAGR or SIP XIRR across hundreds of overlapping periods (such as every 3-year or 5-year block over the past decade). A fund that beats its benchmark in 80% of rolling 5-year periods is vastly more dependable than a fund that tops a single trailing chart.

3. Evaluate Downside Protection

In systematic investing, avoiding severe drawdowns late in your journey is far more important than catching the sharpest rally early on. Review:

  • Downside Capture Ratio: Measures how much the fund falls relative to its benchmark during market drops (a ratio below 80% indicates superior capital preservation).
  • Sortino Ratio: Measures return per unit of downside risk.

Summary Framework

MetricBest Used ForWhat It CapturesPrimary Blind Spot
CAGRLumpsum investmentsOverall point-to-point growth rateIgnores cash flow timing and interim volatility
XIRRSIP, STP, SWP, irregular flowsRealized money-weighted return on actual cash flowsCannot be judged without knowing cash flow dates
Rolling ReturnsFund selection & comparisonConsistency of performance across market cyclesRequires specialized charting tools

Trailing CAGR tells you how a hypothetical single deposit performed in the past. XIRR tells you what actually happens to your bank balance when you invest month after month. For anyone running an SIP, consistency, downside defense, and rolling performance matter far more than who sits at the top of a static CAGR ranking.


This article is for financial education only, this does not constitute investment advice.

Investment in securities market are subject to market risks, read all the related documents carefully before investing.