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?

MeasureThe question it answersFits
Absolute returnHow much did my money grow in total, as a percentage?Any period; the more meaningful figure under one year
CAGRAt what steady yearly rate did one sum grow?One investment, no money added or taken out
XIRRWhat 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 yearsResult
Absolute return50%
CAGR10.67% a year
XIRR10.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.

Time invested by three SIP payments
The first ₹10,000 invested in November 2023 has 36 months to grow by 5 November 2026. The May 2025 instalment has 18 months and the October 2026 instalment has one month. XIRR uses all 36 actual payment dates.
Same SIP, same dates, same valueResult
Absolute return19.7%
CAGR on ₹3,60,000 over three years6.17% a year
XIRR12.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

  1. List every purchase with its date and amount, from your consolidated account statement. In a spreadsheet, enter them as negative numbers.
  2. List every redemption and IDCW (dividend) payout to you, as positive numbers.
  3. Add today's value as a final positive amount, dated today.
  4. 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.