XIRR vs CAGR: Why Your SIP's Real Return Is Different

Open your mutual fund app and you will often see two return figures that disagree. The fund's page brags about a 14% CAGR over five years, yet your own SIP in the same fund shows maybe 11%. Nobody cheated you. You are simply looking at two different ways of measuring money over time, and most Indian investors have never been told the difference. Getting this right is the single most useful thing you can do before judging whether a fund is actually working for you.

What CAGR actually measures

CAGR, the compound annual growth rate, answers one narrow question: if I put in a single amount on day one and didn't touch it, at what steady yearly rate did it grow? Suppose you invested ₹1 lakh and it became ₹2 lakh in five years. The CAGR is roughly 14.9% a year, because money compounding at that rate doubles in about five years.

The formula is clean precisely because it assumes one inflow and one outflow. There is a start date, an end date, and nothing happening in between. That makes CAGR honest and comparable for lump-sum investments, fixed deposits, or any point-to-point growth where you didn't add or withdraw a rupee along the way.

The trouble starts the moment your real life looks nothing like that. You don't invest once. You invest ₹5,000 every month, you pause during a tight quarter, you top up with a bonus, you redeem a slice for a wedding. CAGR has no language for any of that.

Why a SIP breaks CAGR

Think about a five-year SIP. The instalment you paid in the very first month has had a full five years to compound. The instalment you paid last month has been invested for barely 30 days. Treating them as if they all earned the same number for the same time is simply wrong.

This is the core reason your SIP return almost never equals the fund's headline CAGR. The brochure figure typically assumes money that sat invested for the entire stretch. Your money trickled in. Half your total corpus may have arrived in just the last couple of years, so it never got the long runway that makes compounding shine.

A quick way to feel this: in a rising market, your SIP XIRR will usually lag the lump-sum CAGR, because your later, larger instalments missed the early climb. In a market that fell and then recovered, your SIP can actually beat the lump-sum number, because you kept buying cheap units near the bottom. Same fund, completely different experience, driven entirely by when your money went in.

XIRR: the number that fits real life

XIRR, the extended internal rate of return, is built for exactly the messy cashflow timeline a SIP creates. It takes every transaction with its own date — each instalment as a negative cashflow, each redemption and the final value as a positive one — and finds the single annualised rate that ties them all together.

The magic is that XIRR weights each rupee by how long it stayed invested. Your old instalments are credited with years of compounding; your recent ones are credited with only a few weeks. The result is the truest answer to the question that actually matters: what annual return did my specific pattern of investing earn?

A few things worth knowing about XIRR:

• It handles irregular dates and amounts, so missed SIPs, lumpy top-ups and partial withdrawals are all fine.
• It is expressed as an annualised rate, so an XIRR of 12% is directly comparable to a 12% fixed deposit.
• A negative XIRR early in an equity SIP is normal and not a red flag, because so little time has passed.
• For a pure one-time investment with no other cashflows, XIRR and CAGR give the same answer. CAGR is really just a simplified special case.

The trap of absolute return

There is a third number that flatters everyone and informs no one: absolute return, sometimes called point-to-point or total return. It simply asks how much your value grew in percentage terms, ignoring time entirely.

If ₹1 lakh became ₹2 lakh, the absolute return is 100%, whether that took two years or twenty. Marketing loves absolute returns because a big number looks impressive in a screenshot. A fund showing "312% returns" since launch sounds thrilling until you realise it launched in 2009 and that works out to a fairly ordinary annual rate.

Use absolute return only for very short holdings under a year, where annualising would exaggerate things wildly. For anything longer, it is the least useful of the three. Never, ever pick between two funds on absolute return alone.

How to check your own XIRR in five minutes

You don't need to trust the app's headline figure. You can verify your personal return yourself.

1. Download your Consolidated Account Statement (CAS) from CAMS or KFintech, or open the holdings page in Groww, Zerodha Coin, Kuvera or Paytm Money. Most already display portfolio XIRR.
2. To do it by hand, list every SIP instalment and top-up in a spreadsheet as a negative amount against its date.
3. Add today's total fund value as a single positive amount with today's date.
4. Run the XIRR function in Excel or Google Sheets across the dates and amounts.
5. The percentage you get is your real annualised return, after the timing of every rupee.

If that number is well below the fund's category average over the same window, look closer. But give equity funds a fair stretch first. Judging an equity SIP on six months or even two years of XIRR is meaningless noise.

Reading returns like a pro

The deeper habit is matching the metric to the situation. For comparing two funds head to head, use the same measure over the same period — both CAGR for a lump sum, or both rolling returns. For judging your own portfolio, XIRR is the only number that respects how you actually invested.

One more level up is rolling returns, which average a fund's performance across hundreds of overlapping start dates rather than one lucky window. A fund can show a gorgeous five-year CAGR purely because it happened to start measuring from a market bottom. Rolling returns strip out that luck and reveal consistency, which is why serious analysts lean on them.

Keep three rules in your pocket. Absolute return is for bragging, not deciding. CAGR is for clean, single-shot investments. XIRR is for your actual life — the SIPs, the gaps, the top-ups, the redemptions. Once you internalise which number to trust, half the confusion around mutual fund returns simply disappears, and you stop chasing brochure figures you were never going to earn.