XIRR calculator for SIPs, stocks and irregular cash flows
This XIRR calculator works out the annualised return of money that went in and came out on different dates — monthly SIP instalments, a one-off top-up, a partial withdrawal, dividends you took as cash, and the value of what you still hold today. Unlike absolute return, XIRR weights every amount by how long it was invested.
You can type each cash flow, paste two columns straight from Excel, Google Sheets or a statement (dates such as 31/01/2025, 31-Jan-2025 or 2025-01-31; amounts with ₹, $ or lakh grouping such as ₹1,25,000), or build a schedule with the SIP generator. The calculator follows Excel’s XIRR convention — a 365-day year counted from the earliest date — so the answer matches a spreadsheet. It also gives XNPV at any discount rate, the absolute return, and an IRR mode for cash flows spaced one period apart.
Everything runs in your browser; nothing is uploaded or stored. XIRR describes past performance — it is not a forecast or financial advice.
How to use the XIRR Calculator
- Keep XIRR – dated flows selected (choose IRR – periods for cash flows exactly one year, quarter or month apart).
- Enter each cash flow with its date. Money you invest is negative (−10,000); withdrawals, dividends paid out and today’s value of your holding are positive.
- To bring in many rows at once, open Paste from a spreadsheet, paste a date column and an amount column, and press Import cash flows. For a regular SIP, open the SIP generator, fill in the instalment, frequency, count and current value, and press Create SIP cash flows.
- Read the XIRR, the total invested and received, net gain and absolute return. Change the discount rate to see the XNPV — the value of all cash flows on the first date.
- Check each row’s discounted value in the table (they sum to zero at the XIRR) and press Download CSV to keep it.
XIRR Calculator features
Matches Excel
Actual days ÷ 365 from the earliest date, solved by Newton–Raphson with a bracketing and bisection fallback.
Spreadsheet paste
Tab, comma or semicolon columns in either order; ISO, day-first, month-first and month-name dates; Excel date serials; ₹, $, £, € and Indian or Western grouping; (1,000) as a negative.
SIP generator
Weekly, monthly, quarterly, half-yearly or yearly instalments with month-end dates kept correct (31 Jan → 28 Feb → 31 Mar).
XNPV, IRR and NPV
Value the cash flows at your own discount rate, or switch to IRR for equally spaced periods with an effective annual figure.
Honest errors
Clear messages when the signs never change, every date is the same, no rate balances the flows, or more than one rate does.
How XIRR is calculated — Microsoft’s own example
XIRR is the rate r that makes the discounted cash flows add up to zero: Σ Pᵢ ÷ (1 + r)(dᵢ − d₁) ÷ 365 = 0, where Pᵢ is each amount and dᵢ − d₁ the days since the first date. There is no closed formula, so the calculator iterates until the sum is zero to about a billionth of the amounts.
Microsoft’s documentation for Excel’s XIRR uses five cash flows. Paste them and you get 37.34%; Excel shows 0.373362535, and this calculator’s 37.3363% agrees to the eighth decimal place (the last digit differs only because Excel stops iterating at a tolerance). At a 9% discount rate the XNPV is 2,086.65, the figure in Microsoft’s XNPV example.
| Date | Amount | Days from first |
|---|---|---|
| 1 Jan 2008 | −10,000 | 0 |
| 1 Mar 2008 | 2,750 | 60 |
| 30 Oct 2008 | 4,250 | 303 |
| 15 Feb 2009 | 3,250 | 411 |
| 1 Apr 2009 | 2,750 | 456 |
XIRR, CAGR, absolute return and IRR
- One amount in, one amount out: XIRR equals CAGR. ₹1,00,000 invested on 1 Jan 2021 and worth ₹1,21,000 on 1 Jan 2023 (730 days) gives 10.00% XIRR and a 21% absolute return — check it with the CAGR calculator.
- Many dated amounts: only XIRR is meaningful. A SIP’s last instalment has been invested for a month, its first for years; XIRR is how fund statements report SIP returns. Plan future SIPs with the SIP calculator or compare direct and regular plans with the mutual fund calculator.
- Absolute return (net gain ÷ amount invested) ignores time; the ROI calculator annualises a single holding period.
- IRR assumes equal gaps. With −70,000 followed by 12,000, 15,000, 18,000, 21,000 and 26,000, IRR is 8.66% a period; using only the first four inflows it is −2.12%. Excel’s NPV() discounts the first value by one period, whereas this page treats period 0 as today.
When XIRR looks wrong
- A missing positive value: always add today’s value of what you still hold, dated today, or the return looks like −100%.
- Day and month swapped: 03/04/2025 is 3 April in India and the UK but March 4 in the US. Choose the date order when pasting if every day is 12 or less.
- Very short periods: a 2% gain in one month annualises to roughly 27%. Treat XIRR over less than a year with caution.
- Several sign changes (invest, withdraw, invest again) can produce more than one valid rate; the page tells you when that happens and uses the one closest to your starting guess.
XIRR Calculator FAQ
What is XIRR in mutual funds?
It is the annualised return of all your purchases and redemptions, each counted from its own date. Fund houses and apps use it for SIP returns because instalments are invested for different lengths of time.
How do I calculate XIRR for a SIP?
List each instalment as a negative amount on its date and add the current value as a positive amount on today’s date. The SIP generator in this XIRR calculator builds that list for you from the instalment, start date, frequency and count.
Is this the same as Excel’s XIRR function?
Yes. It uses actual days divided by 365 from the earliest date, so it reproduces Microsoft’s documented examples: 37.34% for the XIRR example and 2,086.65 for XNPV at 9%.
Why does XIRR show an error?
XIRR needs at least one negative and one positive amount on at least two different dates. If no rate between −99.9999% and an extremely large value makes the cash flows balance, there is no XIRR and the page says so instead of showing a misleading number.
What is the difference between IRR and XIRR?
IRR assumes every cash flow is exactly one period apart. XIRR uses the actual dates, which suits investments made on irregular days. For yearly flows on the same date each year the two are almost identical.