XIRR Calculator

Find the true annual return on investments made on different dates, such as SIPs, top-ups and partial redemptions. Enter each cash flow and the current value to get the XIRR.

  • Runs in your browser. Nothing is uploaded
  • Free, no sign-up
  • Works offline once opened
₹
₹
₹
₹
₹
What the investment is worth now (0 if fully withdrawn)
Pick the date of the current value.

XIRR uses the same formula as Excel and Google Sheets: the yearly rate at which the present value of all cash flows is zero, counting the actual days between them (365-day year).

Paste from a spreadsheet or statement

One cash flow per line: a date and an amount (copy two columns from Excel or Sheets). Negative amounts are investments, as in Excel. If every amount is positive, rows are treated as investments unless they say “redeem”, “withdraw” or “sell”.

Add monthly SIP instalments
₹

Your files stay here

  • XIRR Calculator runs inside this browser tab.
  • Nothing is sent to a server, so there is nothing to delete later.
  • Close the tab and it is gone from DeskTray.

Often used next

Looking for something else?

DeskTray has hundreds of free tools that work the same way.

How to calculate XIRR

  1. Add each investment and withdrawal with its date, or paste them from a spreadsheet.
  2. Enter the current value of the investment and the date of that value.
  3. Read the XIRR, total invested and gain.

Features

  • Any number of dated investments and withdrawals
  • Paste rows from Excel, Sheets or a statement
  • SIP helper to add monthly instalments
  • Matches Excel XIRR
  • Total invested, gain and absolute return
  • Rows saved in your browser

Frequently asked questions

What is XIRR?

XIRR (extended internal rate of return) is the yearly return that makes the present value of all your cash flows zero, using the actual dates. It is the right measure for SIPs and irregular investments, where each instalment is invested for a different length of time.

Does this match Excel’s XIRR function?

Yes. It uses the same formula as Excel and Google Sheets (actual days ÷ 365), solved with Newton–Raphson and a bisection fallback. Microsoft’s example (−10,000 on 1 Jan 2008 and four returns) gives 37.34% here, as in Excel.

How do I paste data from Excel?

Copy two columns, date and amount, and paste them into “Paste from a spreadsheet”. Negative amounts are treated as investments, as in Excel. Dates like 05/04/2024 are read day first; tick the option for US-style month-first dates.

Why is my XIRR different from the CAGR?

CAGR assumes all money was invested on day one. In a SIP, later instalments are invested for less time, so the same gain gives a higher XIRR than a CAGR calculated on the total invested.

More Money tools

All 34 Money Calculators