XIRR Calculator

When money goes into an investment at different times, such as SIP instalments, top-ups or partial withdrawals, simple return and CAGR give misleading answers. XIRR is the single yearly rate that accounts for the date of every amount. Mutual fund statements and Excel use the same method.

Money in: negative (−). Money out or current value: positive.
Results update as you type.

XIRR (yearly return)

11.63%

over 2.75 years

Total put in
₹2,00,000
Total received or current value
₹2,60,000
Gain
₹60,00030% in absolute terms

Cash flows used

Cash flows used
DateAmountDays from first
1 January 2024−₹1,00,0000
1 July 2024−₹50,000182
1 January 2025−₹50,000366
1 October 2026₹2,60,0001,004

About this calculator

Enter up to six dates and amounts: money you put in as negative, and money you took out or the current value as positive.

How to use it

  1. Enter each investment with its date as a negative amount, for example −50,000.
  2. Enter any withdrawals as positive amounts with their dates.
  3. Enter the current value as a positive amount with today’s date.
  4. Read the XIRR.

The formula

Find r such that Σ amount ÷ (1 + r)days since first ÷ 365 = 0
amount
each cash flow: negative when invested, positive when received or for the current value
days
days from the first date to each amount’s date
r
the XIRR, found by trying rates until the total is zero

Worked example

Three investments and today’s value

  1. −₹1,00,000 on 1 January 2024, −₹50,000 on 1 July 2024, −₹50,000 on 1 January 2025.
  2. Current value ₹2,60,000 on 1 October 2026.
  3. XIRR = 11.63% a year, although the absolute gain is 30%.

What the result means

XIRR is the fairest way to judge an SIP or any investment with several cash flows. Compare it with what an FD or index fund would have given over the same dates.

A high absolute return can still be a low XIRR if the money was invested for a long time, and the opposite for money invested only recently.

Assumptions

  • A 365-day year, as Excel’s XIRR uses.

Limitations

  • Up to six cash flows; for longer histories use a spreadsheet’s XIRR function.
  • Very short periods can produce extreme yearly figures.
  • Some patterns of cash flows that change sign several times can have more than one possible rate.

Frequently asked questions

Why is my XIRR different from my absolute return?

Absolute return ignores time; XIRR converts the gain to a yearly rate based on how long each amount was invested.

How do I calculate XIRR for my SIP?

Enter each SIP instalment as a negative amount on its date and the current value as a positive amount on today’s date. For many instalments, use a spreadsheet.

Is XIRR the same as CAGR?

For a single investment and a single final value, yes. With several cash flows, only XIRR is correct.

For information only. This calculator gives estimates based on the figures you enter and the assumptions listed above. It is not financial advice. Actual amounts depend on the lender’s or institution’s terms, fees, rounding and rate changes. Please confirm with them before you decide.

Last reviewed on 1 October 2026. Found a mistake? Tell us.