Short answer. CAGR is the yearly growth rate of one lump sum, from one start date to one end date. XIRR is the yearly rate for many cash flows on different dates, such as SIP instalments, top-ups and withdrawals. For a single lump sum they give the same answer. For a SIP, read XIRR; a CAGR worked out on the total invested understates the return.
Our view: XIRR is the right yardstick for a SIP, but only once the SIP has run for a few years. Over a few months it exaggerates both gains and losses.
What do absolute return, CAGR and XIRR each measure?
| Measure | The question it answers | Fits |
|---|---|---|
| Absolute return | How much did my money grow in total, as a percentage? | Any period; the more meaningful figure under one year |
| CAGR | At what steady yearly rate did one sum grow? | One investment, no money added or taken out |
| XIRR | What single yearly rate explains all my dated cash flows? | SIPs, top-ups, partial withdrawals, IDCW (dividend) payouts |
Absolute return ignores time: 50% over four years and 50% over ten look the same. CAGR adds time, but assumes all the money went in on day one. XIRR gives each rupee its own start date.
A lump sum: CAGR and XIRR agree
Illustration at an assumed outcome, not any scheme's expected return: ₹1,00,000 invested on 5 November 2022 is worth ₹1,50,000 on 5 November 2026.
| ₹1,00,000, one lump sum, four years | Result |
|---|---|
| Absolute return | 50% |
| CAGR | 10.67% a year |
| XIRR | 10.66% a year |
The hundredth of a point is only a day count: XIRR counts the actual 1,461 days, including a leap day, on a 365-day year.
A SIP: why its CAGR misleads
Illustration at an assumed 12% a year, not any scheme's expected return: a SIP of ₹10,000 on the 5th of each month, 36 instalments from 5 November 2023 to 5 October 2026, in a fund whose NAV rises at a steady 12% a year. Value on 5 November 2026: ₹4,30,892, on ₹3,60,000 put in.
| Same SIP, same dates, same value | Result |
|---|---|
| Absolute return | 19.7% |
| CAGR on ₹3,60,000 over three years | 6.17% a year |
| XIRR | 12.00% a year |
The fund grew at 12% a year, and only XIRR says so. The CAGR treats all ₹3,60,000 as invested on day one, though the last instalment had one month to grow. On average, each rupee here was invested for about 1.5 years, not three.
A SIP's CAGR understates its return this way whenever the SIP is in gain; when it is at a loss, it understates the loss. Compared with an FD's rate, it can make a SIP that kept pace look as if it lagged.
When XIRR misleads
XIRR turns any gain into a yearly rate, and over short periods that stretches the numbers.
Illustration, not any scheme's expected return: six SIP instalments of ₹10,000, from 5 May to 5 October 2026, worth ₹63,000 on 5 November 2026. The absolute return is 5%. The XIRR is 17.9% a year, because the money was invested for only about three and a half months on average. A small fall would show a sharply negative XIRR in the same way.
SEBI's rules on how fund houses show returns, as on 7 November 2026, point the same way. A scheme less than six months old may not advertise past performance (overnight, liquid and money market funds have their own short-period rule); one between six months and a year shows a simple annualised figure; older schemes show compounded yearly returns over one, three and five years and since launch. Its formats for scheme documents ask for absolute returns since launch for schemes less than a year old.
XIRR vs IRR
IRR assumes cash flows at equal intervals. XIRR uses each cash flow's actual date, so a moved SIP date, a missed instalment, a top-up or a partial withdrawal is counted correctly. IRR also gives a rate per interval, so a monthly IRR must be converted to a yearly one. XIRR in Excel discounts on a 365-day year; in Excel and Google Sheets it needs at least one money-in and one money-out value.
How to work out your own XIRR
- List every purchase with its date and amount, from your consolidated account statement. In a spreadsheet, enter them as negative numbers.
- List every redemption and IDCW (dividend) payout to you, as positive numbers.
- Add today's value as a final positive amount, dated today.
- Run XIRR in a spreadsheet, or use the XIRR calculator, which takes your own dates and asks whether each amount went in or came out, instead of using signs.
A paused or stopped SIP needs no special handling: the instalments that went in are simply the cash flows.
What to check before you read a return
- Which measure it is. A fund house's advertised one-, three- and five-year figures are lump-sum CAGRs; your own SIP has different dates.
- The period. Under a year, look at the absolute return.
- The plan. Direct Plan and Regular Plan returns differ because their expenses differ.
- A fair comparison. Set your XIRR against the scheme's benchmark total return index (TRI) on the same SIP dates. For how lump-sum CAGRs compared with FDs over ten years, see equity funds vs FDs.
- Before tax. An XIRR worked out on the current value is before exit load and tax. The amount paid out on redemption is after exit load but, for a resident, before capital gains tax; deduct the tax to see what you kept. This is general information, not tax advice.
Past performance may or may not be sustained in future and is not a guarantee of future returns.
Mutual Fund investments are subject to market risks, read all scheme related documents carefully.