Skip to content
zspace tools

Finance & Calculators

XIRR Calculator

Find the true annual return on investments made on different dates and in different amounts. Enter each investment and withdrawal — or paste them from a spreadsheet — and get the XIRR, the same figure Excel and fund statements use.

Runs in your browser

Features

What you get

  • Any dates, any amounts

    Add as many investments and withdrawals as you need — monthly SIPs, missed months, top-ups, partial redemptions.

  • No sign confusion

    Pick Invested or Withdrawn for each row instead of typing negative numbers.

  • Paste from a spreadsheet

    Copy date and amount columns from Excel or Google Sheets (negative = invested) and import them in one go.

  • Excel-compatible

    Actual days ÷ 365, the same convention as Excel's XIRR — tested against Microsoft's published example.

  • Honest when it can't answer

    Reports when cash flows have no solution or several, instead of picking one.

  • Benchmark comparison

    Compare with a rate such as an FD or index return, and see the money difference by the last date.

How to use

How to use the XIRR Calculator

XIRR is the rate r for which Σ CFᵢ ÷ (1 + r)^((dᵢ − d₀) ÷ 365) = 0, using actual days ÷ 365 like Excel. The calculator scans every possible rate for points where that sum changes sign and narrows each one down by bisection, so it never depends on a starting guess and can't run away. If no rate balances the cash flows — or more than one does — it tells you instead of returning a misleading number.

  1. 01

    Enter your transactions

    Date, Invested or Withdrawn, and the amount — or paste them from a spreadsheet.

  2. 02

    Add today's value

    If you still hold the investment, add its current value as a withdrawal on today's date.

  3. 03

    Read your XIRR

    See the annual return, totals, period and a transaction summary; optionally compare with a benchmark.

Examples

Worked examples

  • Excel's own example

    −10,000 on 1 Jan 2008, then +2,750, +4,250, +3,250 and +2,750 on 1 Mar 2008, 30 Oct 2008, 15 Feb 2009 and 1 Apr 2009: XIRR = 37.34% — the same as Excel.

  • A mutual fund with top-ups

    ₹50,000 in April 2021, four top-ups totalling ₹50,000, a ₹15,000 redemption in Dec 2022 and a ₹1,42,500 current value in Nov 2026: XIRR about 11.02% a year, though the absolute return is 57.5%.

  • Why dates matter

    ₹1,000 a year for three years then ₹3,500 back one year after the last payment is an XIRR of about 7.9% — far from the 16.7% the totals alone might suggest.

Guide

Understanding the XIRR calculator

What each input means

Date
The day money moved. Each day counts, so use the actual transaction dates from your statement.
Invested
Money you put in: SIP instalments, lump sums, top-ups. Treated as negative cash flow.
Withdrawn
Money you took out — redemptions, dividends paid out — and today's value if you still hold the investment.
Benchmark
Optional annual rate to compare with, such as an FD rate or an index's return.

How to read the result

  • XIRR is a yearly rate: 11% means your money grew as if it earned 11% a year, allowing for when each rupee went in and came out.
  • The absolute return (total gain ÷ total invested) isn't annualised and ignores timing, so it's usually very different from XIRR.
  • Periods shorter than a year are annualised too — a small gain over a few weeks can show a very high XIRR.

Who uses it

  • Checking the real return on a SIP or mutual fund folio
  • Comparing your return with an FD or index
  • Measuring a portfolio with irregular top-ups and withdrawals
  • Verifying the XIRR on a fund statement

Common mistakes

  • Forgetting to add today's value as a withdrawal, which makes the return look like a loss.
  • Entering investments as positive numbers when pasting — in spreadsheet format, money invested must be negative.
  • Comparing XIRR with an absolute return or with CAGR over a different period.
  • Using order dates instead of the dates units were actually allotted or redeemed.

Assumptions and limitations

  • XIRR assumes the same rate applied throughout; it says nothing about volatility.
  • When money changes direction several times, there can be more than one valid XIRR — the calculator reports this rather than choosing one.
  • Taxes and exit loads are only included if they're reflected in the amounts you enter.

Technical specifications

Equation
Σ CFᵢ ÷ (1 + r)^((dᵢ − d₀)/365) = 0
Day count
Actual days ÷ 365 (Excel XIRR)
Solver
Full-range sign scan + bisection to 1e-12; multiple/no roots reported
Transactions
Up to 2,000; same-day entries allowed
Paste formats
2021-04-05, 05/04/2021, 05-Apr-2021; tab, comma or semicolon
Exports
Copy, print, CSV

Privacy

Your transactions are calculated in your browser and never uploaded, stored or sent to analytics.

Read the full privacy policy.

FAQ

XIRR Calculator questions

XIRR (extended internal rate of return) is the single annual rate that makes all your dated cash flows balance out. ZSpace Tools' XIRR Calculator works it out from a list of investments and withdrawals with their dates, so it handles SIPs, missed instalments, lump-sum top-ups and partial redemptions that CAGR and simple ROI can't.

XIRR is the rate r for which Σ CFᵢ ÷ (1 + r)^((dᵢ − d₀) ÷ 365) = 0, using actual days ÷ 365 like Excel. The calculator scans every possible rate for points where that sum changes sign and narrows each one down by bisection, so it never depends on a starting guess and can't run away. If no rate balances the cash flows — or more than one does — it tells you instead of returning a misleading number.

XIRR is the annualised return on a series of cash flows that happen on irregular dates. It's the single yearly rate at which the present value of all your investments and withdrawals adds up to zero.

Each cash flow is discounted by (1 + r) raised to the number of years since the first date (days ÷ 365), and r is found so that the total is zero. There's no direct formula, so it's solved numerically — this calculator searches the full range of rates and refines each solution by bisection.

CAGR uses only a starting and an ending value, so it suits a single lump sum. XIRR uses every cash flow and its date, so it's the right measure for SIPs, top-ups and withdrawals.

ROI is the total gain divided by what you invested, ignoring time. XIRR is an annual rate that accounts for how long each amount was invested.

Add each instalment as Invested on its date, then add the current market value as Withdrawn on today's date.

If money goes in, comes out and goes in again, the equation can have two or more valid rates. No single XIRR describes such cash flows reliably, so the calculator lists them instead of picking one.

Yes — it uses Excel's convention of actual days divided by 365 and reproduces Microsoft's documented example (37.34%).