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.
- 01
Enter your transactions
Date, Invested or Withdrawn, and the amount — or paste them from a spreadsheet.
- 02
Add today's value
If you still hold the investment, add its current value as a withdrawal on today's date.
- 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%).
Related tools
CAGR Calculator
Calculate compound annual growth rate between two values — or the end or start value from a CAGR.
ROI Calculator
Calculate return on investment for investments, campaigns and projects — with annualised ROI and up to three comparisons.
SIP Calculator
Estimate mutual fund SIP maturity value, returns and step-up SIP growth, year by year.
Lumpsum Calculator
Project how a one-time investment could grow, with inflation-adjusted value and a two-scenario comparison.