XIRR vs CAGR: which number is your actual return?

The three measures, precisely

Absolute return is value ÷ invested − 1. It is honest arithmetic with no concept of time: 60% over two years is spectacular, 60% over fifteen is a fixed deposit. Use it only when the period is obvious and short.

CAGR — compound annual growth rate — answers: at what steady annual rate would one lump sum, invested on day one and untouched, have grown into the final value? It is the right measure for anything with a single entry and single exit: a lumpsum fund purchase, a property, gold bought once, one FD. The CAGR calculator computes it from start value, end value and years. Because it assumes all the money was present throughout, it is also the fair way to compare instruments with each other — which is why fund fact sheets quote it.

XIRR — extended internal rate of return — answers the harder, more personal question: given money that entered and left on many different dates, what single annual rate explains the final value? It is the only correct measure for a SIP, for irregular top-ups, for portfolios with withdrawals — any situation where “when did each rupee arrive” varies. Every instalment is weighted by exactly how long it was actually invested. Spreadsheets compute it with the XIRR function from a dated list of cash flows; most investing apps now show it by default.

Why your SIP return is not the fund’s return

Suppose a fund’s NAV climbs steadily for three years, then treads water for two. Its five-year CAGR — the lump-sum, day-one measure — looks decent because the early growth compounds through the flat stretch. Your five-year SIP in the same fund tells a different story: most of your money arrived in the later, flatter years, so your XIRR is lower. Nobody cheated you. The fund’s number describes the fund; your number describes your money. Reverse the sequence — flat first, then a surge — and your SIP XIRR will beat the fund’s CAGR, because your instalments bought cheap units before the rise.

This is also why two colleagues in the same fund report different returns: they started on different dates, so their cash-flow patterns differ, so their XIRRs differ. And it is why judging a SIP a year or two in is nearly meaningless — early on, your outcome is mostly sequence luck. What compounds over a full horizon is the fund’s quality and your discipline, which is the argument behind rupee-cost averaging and step-ups. Project the mechanics on the SIP calculator; it assumes a constant return precisely so you can see the effect of amount and duration in isolation.

Reading the numbers without fooling yourself

The classic mistake runs in both directions. An investor sees the fund’s 14% CAGR, their own 11% XIRR, and concludes the app is lying or the fund is bad — when the gap is just cash-flow timing. Another sees their 16% XIRR beat the fund’s 13% CAGR and concludes they timed the market — same explanation, luckier sequence. The only apples-to-apples comparisons are: your XIRR against your goal’s required return, and fund CAGR against fund CAGR over the identical period.

Three further habits keep the numbers honest. First, measure after costs and taxes where you can — exit loads, and tax on redemptions, sit between the fund’s return and yours; our inflation guide covers the further haircut from real-terms thinking. Second, distrust annualised anything under a year — a good quarter annualises into a fantasy. Third, when a projection matters — retirement, a child’s education — run it at assumed returns meaningfully below the trailing CAGR you are shown. Past CAGR is a record; XIRR is your record; neither is a promise. Mutual fund investments are subject to market risk, and the sequence of returns, as this guide shows, is half your outcome.