Skip to main content
WealthMaze LogoWealthMaze
Back to Blog Hub
Investing

Why Your 12% SIP Return Might Actually Be 8% (Understanding XIRR vs. CAGR)

Om K.November 1, 202611 min read
!

YMYL Advisory Notice: This article is part of WealthMaze's educational library. Information is compiled from official regulatory portals (such as RBI, SEBI, or the Income Tax Dept) but does not constitute personal financial, tax, or investment advice. Read our Editorial Policy and Calculator Methodology to learn how our content and calculators are verified. Mutual fund investments are subject to market risks; read all scheme related documents carefully.

Alex has been running a SIP for seven years. Every month, $300 goes into an equity mutual fund. The fund's fact sheet shows a 7-year CAGR of 12.4%. Alex does the mental math, feels good about the portfolio, and tells Sam the fund has been returning around 12%.

Sam pulls up a calculator, enters all of Alex's actual monthly investments and the current portfolio value, and runs XIRR.

The result: 8.1%.

Alex is not wrong about the fund. The fund did return 12.4% over seven years — for someone who invested a lump sum on day one and held it to today. But Alex did not invest a lump sum on day one. Alex invested $300 every month, across 84 different purchase dates, at 84 different NAVs, each unit carrying a different holding period and a different gain.

CAGR measures the fund. XIRR measures the investor. And for anyone running a SIP, these two numbers are almost never the same — and the gap between them is not random noise. It follows a pattern, it has a cause, and once understood, it changes how SIP returns should be read, compared, and evaluated.

Why CAGR Cannot Measure a SIP

CAGR — Compound Annual Growth Rate — answers one specific question: at what steady annual rate did a single investment grow from a starting value to an ending value over a fixed number of years?

The formula is clean:

CAGR = (Ending Value / Beginning Value)^(1/N) − 1

It requires two values and one time period. It assumes all the money entered at a single point in time. For a lump sum investment, this is a complete and accurate picture of what happened.

A SIP violates every one of those assumptions.

When Alex invests $300 a month for seven years, there are 84 separate cash flows, each entering at a different date, each purchasing units at the NAV on that specific day, each carrying a different holding period. The $300 invested in month one has compounded for 84 months. The $300 invested last month has compounded for one month. Treating these as a single lump sum with a single entry point — which is what CAGR does implicitly — produces a number that describes the fund's performance over the period, not the investor's actual experience of it.

This is not a flaw in CAGR. It is a flaw in applying CAGR to a situation it was never designed to measure.

XIRR — Extended Internal Rate of Return — was built exactly for this situation. It calculates the single annualised return rate that makes the present value of all cash outflows (the monthly investments) equal to the present value of all cash inflows (the final portfolio value), accounting for the precise date of every transaction.

In plain terms: XIRR finds the one interest rate that, if applied to each investment from the exact date it was made, would produce exactly the portfolio value sitting in the account today. It is the only metric that accurately measures what a SIP investor actually earned.

The Mechanics: Why XIRR and CAGR Diverge

Understanding why these two numbers differ requires understanding what each one is actually measuring.

Consider a simplified version of Alex's situation.

The figures below are illustrative examples designed to show how the comparison works. They are not predictions of actual fund or investor performance.

Imagine a fund that delivers the following annual returns over five years:

YearFund Annual Return
Year 1+35%
Year 2+28%
Year 3−22%
Year 4+18%
Year 5+31%

Over five years, the CAGR of this fund works out to approximately 15.8%. A lump sum investor who put in $10,000 on day one and held through all of it would have approximately $20,800 at the end — a 15.8% CAGR experience.

Now consider a SIP investor — call him Sam — putting in $200 every month across those same five years.

Sam's first $200 compounds through all five years, including the big up years. But Sam's $200 in month 25 — right before the −22% year — loses value and starts recovering from a lower base. Sam's last several months of contributions have barely compounded at all before the calculation date.

When XIRR is calculated on Sam's actual cash flows — 60 monthly investments of $200, and the current portfolio value on the calculation date — the result is different from 15.8%. Whether it's higher or lower than the fund's CAGR depends on exactly when the bad year fell and when the good years fell relative to Sam's contribution schedule.

This is the central insight: CAGR is fixed for the fund. XIRR varies for each investor based on the timing of their specific contributions.

Two investors in the same fund, with the same monthly SIP amount, who started six months apart, can have different XIRRs — because the sequence of returns they experienced, relative to when their money entered, was different.

The Specific Pattern: When XIRR Trails CAGR (and When It Beats It)

The relationship between XIRR and CAGR for a SIP investor is not random. It follows a predictable pattern based on when strong and weak returns occurred relative to the investment timeline.

XIRR tends to be lower than CAGR when:

The fund delivered its strongest returns early in the investment period, and weaker or negative returns came later. In this scenario, the lump-sum investor (whose CAGR measures) benefited from the early gains on the full capital. The SIP investor had very little capital deployed during the early strong years — most of the money came in later, when returns were weaker. The SIP investor's XIRR trails the fund's CAGR.

XIRR tends to be higher than CAGR when:

The fund went through a significant correction early in the investment period, recovered strongly, and delivered good returns through the later years. The lump-sum investor suffered the full drawdown on the full capital. The SIP investor had little capital at risk during the crash, accumulated units cheaply through the correction, and benefited from the recovery on a low average cost base. The SIP investor's XIRR can exceed the fund's CAGR in this scenario — this is rupee cost averaging working at its most effective.

Market ScenarioLump Sum Investor ExperienceSIP Investor XIRR vs Fund CAGR
Strong gains early, weakness laterBenefits from full capital in early rallyXIRR likely below CAGR
Weakness early, strong recovery laterFull drawdown on full capitalXIRR often above CAGR
Steady, consistent growth throughoutPredictable compoundingXIRR close to CAGR
High volatility throughoutVolatile experienceXIRR varies by entry timing

The practical implication: when a fund's marketing material shows a 5-year CAGR of 14%, and that five-year period included a significant market rally in years one and two, a SIP investor who started that same SIP five years ago very likely earned an XIRR meaningfully below 14% — not because the fund underperformed, but because most of their capital entered after the early rally had already happened.

A Worked Comparison: Alex and Sam Run the Numbers

Alex and Sam both invested in the same equity fund for five years. Alex did a lump sum of $12,000 on day one. Sam did a $200/month SIP across the same five years.

These are illustrative figures using assumed return sequences. Actual fund returns vary.

The fund delivered the following calendar-year returns:

YearFund Return
Year 1+32%
Year 2+24%
Year 3+8%
Year 4−14%
Year 5+19%

Alex's outcome (lump sum):

$12,000 compounded through all five years at those returns ends at approximately $21,700. CAGR: approximately 12.6%.

Sam's outcome (SIP):

Sam's early contributions — the $200/month in year one — compounded through the 32% and 24% returns before hitting the down year. But Sam's contributions in years three, four, and five were larger in aggregate than the early months, and those later contributions experienced the weak year three and the negative year four before the year-five recovery.

Running XIRR on Sam's 60 monthly cash flows and the final portfolio value: approximately 7.9% (a final portfolio of roughly $14,700 on $12,000 invested).

Same fund. Same five-year period. Alex's CAGR: 12.6%. Sam's XIRR: 7.9%.

The gap is not a measurement error. It reflects the genuine difference between how a lump sum experienced the return sequence versus how a monthly SIP experienced the same sequence — where the strongest returns came early, before most of Sam's capital had entered the market.

The Contrarian Take: Fund CAGRs Are Not Lying — But They Are Not Your Number

Fund fact sheets, AMC websites, and mutual fund comparison platforms universally report CAGR figures. This is not dishonesty — CAGR is the right metric for comparing funds against each other and against benchmarks. A fund's 5-year CAGR accurately describes what that fund returned over that period for a lump sum investor who was fully invested from start to finish.

The problem is not the metric. The problem is that SIP investors read CAGR figures and assume they describe their own experience. They do not — and the assumption leads to systematic overestimation of personal returns, which distorts financial planning in ways that only become visible years later.

If Alex believes the portfolio is earning 12.4% but XIRR says it is actually earning 8.1%, every projection built on that portfolio — retirement corpus estimates, goal achievement timelines, required future SIP increases — is being built on a number that is 4.3 percentage points too optimistic. The downstream planning error is not abstract. It is the difference between arriving at retirement with the corpus expected and arriving with something considerably smaller, with no time remaining to course-correct.

There is a secondary problem worth naming: CAGR figures are most often reported for periods that flatter the fund. A fund launched near a market bottom, reporting its CAGR two years later near a market peak, shows extraordinary numbers that no ongoing SIP investor is likely to replicate. The CAGR is mathematically accurate for that specific window. It is not representative of the experience of an investor who has been contributing through the full cycle.

The question an investor should ask is not "what CAGR has this fund shown?" It is: "what XIRR have I personally earned from my actual contributions into this fund?" These are different questions, and only one of them reflects actual wealth being built.

How to Calculate XIRR on Your Own Portfolio

XIRR is not a figure fund platforms typically display by default — most show CAGR or simple absolute returns. Calculating XIRR on a personal SIP requires the investment dates, the investment amounts, and the current portfolio value.

In Excel or Google Sheets:

The XIRR function handles this directly.

=XIRR(values, dates)

Where:

  • values is a column containing each SIP investment as a negative number (cash out), followed by the current portfolio value as a positive number (cash in)
  • dates is a corresponding column with the date of each transaction, and the current date for the portfolio value entry

Example setup:

DateCash Flow
01/01/2020-$200
01/02/2020-$200
01/03/2020-$200
......
01/06/2025+$18,400 (current value)

=XIRR(B2:B62, A2:A62) returns the annualised XIRR.

Most fund platforms and investment apps provide a downloadable transaction statement that lists every SIP instalment with the exact date and amount — making the data collection straightforward. The XIRR calculation itself takes under two minutes once the data is in a spreadsheet.

The WealthMaze XIRR Calculator handles this without a spreadsheet — enter the transaction data and the current value, and the calculator returns the XIRR directly.

When to Use XIRR and When CAGR Still Applies

Neither metric is universally superior. They serve different purposes, and using the wrong one for the wrong purpose produces misleading conclusions in both directions.

SituationRight MetricWhy
Comparing two mutual funds against each otherCAGRBoth are measured on the same lump-sum basis; comparison is apples to apples
Measuring personal SIP returnsXIRRAccounts for the actual timing and amount of each contribution
Comparing a fund to its benchmark indexCAGRBenchmark returns are also CAGR-based; same measurement basis
Evaluating whether personal wealth is growing fast enough for a goalXIRRThe goal needs the investor's actual return, not the fund's theoretical lump-sum return
Checking if a fund manager added value over timeCAGRStandard basis for manager evaluation and peer comparison
Deciding whether to continue, pause, or switch a SIPXIRRReflects what the investor is actually earning on actual contributions

The simplest rule: use CAGR to evaluate funds. Use XIRR to evaluate yourself.

Key Takeaways

  • CAGR measures the fund's performance assuming a single lump-sum investment held from start to finish. It does not measure a SIP investor's actual return.
  • XIRR measures the investor's actual annualised return by accounting for the exact date and amount of every contribution — it is the correct metric for any investment involving multiple cash flows.
  • For the same fund over the same period, a SIP investor's XIRR can be meaningfully higher or lower than the fund's CAGR, depending on when strong and weak returns occurred relative to the contribution schedule.
  • XIRR typically trails CAGR when the fund's strongest returns came early in the investment period, before most SIP capital had entered the market.
  • Building financial plans, retirement projections, or goal timelines on a fund's CAGR figure — when the actual investment is a SIP — risks systematic overestimation of returns and an under-prepared corpus at the goal date.
  • XIRR can be calculated in Excel or Google Sheets using the XIRR function, or directly through the WealthMaze XIRR Calculator.

FAQ

Why does XIRR matter more than CAGR for a SIP investor?

CAGR calculates returns assuming all money was invested at a single point in time. A SIP involves dozens or hundreds of investments on different dates, each experiencing a different portion of the return sequence. XIRR accounts for this precisely; CAGR cannot.

Can XIRR be higher than the fund's CAGR?

Yes — particularly when the fund went through a significant correction early in the investment period and recovered strongly afterward. In this scenario, the SIP investor accumulated cheap units during the drawdown and benefited disproportionately from the recovery. The XIRR can exceed the fund's CAGR in these conditions.

How often should XIRR be calculated?

Annually is a reasonable cadence for most investors — frequent enough to catch meaningful drift from the expected return, infrequent enough that short-term market movements do not drive unnecessary portfolio changes. Calculating it before any major decision — increasing the SIP, switching funds, or making a large redemption — is also worth doing.

Why do most fund platforms show CAGR instead of XIRR?

CAGR is the standardised metric for comparing fund performance across the industry — it puts all funds on the same lump-sum basis, which makes peer comparison and benchmark comparison straightforward. Reporting XIRR would require each platform to calculate individualised returns for each investor's specific transaction history, which most platforms either don't surface clearly or show under different labels like "personalised return" or "money-weighted return."

Is a lower XIRR always bad news?

Not necessarily. A XIRR below the fund's CAGR simply means the investor's contributions were timed in a way that did not fully capture the fund's strongest returns — usually because the best returns came early, before most SIP capital had entered. It reflects market sequencing, not poor fund selection. The relevant question is whether the XIRR is sufficient to reach the investor's financial goal within the available time horizon.

What is the difference between XIRR and IRR?

IRR (Internal Rate of Return) assumes cash flows occur at regular, equally spaced intervals. XIRR handles irregular timing — any date for any cash flow — which is essential for SIP calculations where investment dates may not fall on perfectly regular intervals.

Sources & Further Reading

Disclaimer: This article is for educational and informational purposes only and does not constitute financial or investment advice. All return figures and worked examples are illustrative and based on assumed values — they do not represent actual fund performance or guaranteed future returns. Mutual fund investments are subject to market risks; please read all scheme-related documents carefully. Consult a qualified financial advisor before making investment decisions.

WealthMaze Logo

Written by Om K.

Om K. is the founder of WealthMaze and a personal finance researcher with a deep interest in behavioral finance — studying why people make the financial decisions they do, and how those decisions shape long-term wealth outcomes. Om built WealthMaze to bridge the gap between complex financial tools and everyday investors who deserve clear, unbiased answers. His writing focuses on the ideas most finance content gets wrong — the psychology, the real-world frameworks, and the honest math behind financial decisions.

⚠️ Legal & Financial Disclaimer

The content provided on this page, including articles, calculators, guides, and links, is intended strictly for general informational, educational, and illustrative purposes.

WealthMaze does not provide licensed investment, financial, legal, or tax advice. No calculations or editorial points represent guaranteed returns, future wealth outcomes, or tax liabilities.

Financial markets, taxation rates, and lending guidelines carry inherent risk and change regularly. You should perform your own research and consult with a qualified, registered financial advisor, certified tax consultant, or legal expert before executing any financial strategy or investment plan.