XIRR Calculator
The yearly return on money that went in and came out on different dates.
Cash flows by date
Each cash flow discounted to the first date at the XIRR. The present values add up to zero — that is what the XIRR means.
How this was calculated
Results are estimates for general information and planning, not financial advice. Banks and institutions may calculate differently (rounding, fees, rate changes). Confirm figures with your lender or a qualified adviser before deciding.
About the XIRR Calculator
When you invest through a SIP, add a lump sum later or take money out along the way, every rupee has been invested for a different length of time. A simple “total gain ÷ total invested” ignores that, and a CAGR only works for one amount in and one amount out. XIRR (extended internal rate of return) is the one yearly rate that, applied to each cash flow for exactly the days it was invested, makes everything balance. It is the usual way to state the return on a SIP or a portfolio with many transactions.
Enter each amount with its date and whether you invested it, withdrew it or it is the value today, or paste the rows from a spreadsheet or statement. The calculator uses the same equation and day count as Microsoft Excel’s XIRR function, so the results match a spreadsheet, and shows XNPV at a rate you choose, your absolute return and the holding period. Nothing you enter leaves your browser.
How to use it
- Add one row per cash flow: the date, the type (Invested, Withdrawn / received, or Value today) and the amount. Enter amounts without a minus sign; the type decides the direction.
- For a SIP, open Fill in a SIP to add every instalment at once — amount, first date, how many and how often, with an optional yearly step-up.
- Add the value today (the current value of your holding) with today’s date as the last row. Use Add value today to put in a row dated today.
- Or open Paste from a spreadsheet and paste lines with a date and an amount (negative = invested, as in Excel), with an optional type word such as SIP, Redemption or Value.
- Read the XIRR, the absolute return and the holding period. Under Options you can set the XNPV discount rate and the starting guess. Copy the summary or download the table as CSV.
Examples
−10,000 on 1 Jan 2008; +2,750 on 1 Mar 2008; +4,250 on 30 Oct 2008; +3,250 on 15 Feb 2009; +2,750 on 1 Apr 2009
XIRR 37.34% a year · XNPV at 9% = 2,086.65 · absolute return 30%
The same figures as the examples on Microsoft’s XIRR and XNPV help pages; they are the calculator’s starting values.
₹10,000 on the 5th of every month from January to December 2024; value ₹1,30,000 on 5 Jan 2025
XIRR 15.66% a year, while the absolute return is only 8.33%
The December instalment was invested for one month and the January one for a year. XIRR weighs each by its time; dividing ₹10,000 of gain by ₹1,20,000 does not.
−₹1,000 on 1 Jan 2020; +₹1,100 on 1 Jan 2021
XIRR 9.97% (1.1^(365 ÷ 366) − 1: 2020 had 366 days)
Common uses
- Check the return a mutual fund statement reports for your SIP, or work it out for a fund your app does not show.
- Compare two investments with different top-up and withdrawal histories on the same basis.
- Check a spreadsheet’s XIRR, or get one without opening a spreadsheet.
- See how much a late lump sum or an early withdrawal changed your real yearly return.
The XIRR and XNPV formulas
XIRR is the rate r that makes the net present value of the dated cash flows zero:
0 = Σ Pᵢ ÷ (1 + r)^((dᵢ − d₁) ÷ 365)
- Pᵢ is each cash flow: money you invested is negative, money you received (and the value today) positive.
- d₁ is the first date and dᵢ − d₁ the days from it to each cash flow, counted on a 365-day year.
XNPV uses the same sum with a discount rate you choose, XNPV = Σ Pᵢ ÷ (1 + rate)^((dᵢ − d₁) ÷ 365), and gives the value of all the cash flows on the first date. There is no direct formula for r, so the calculator searches for it as Excel does: Newton–Raphson from a 10% guess, and if that does not converge, bisection between −99.9999% and 1,000,000% a year. Formula and conventions as in Microsoft’s XIRR and XNPV documentation.
XIRR, CAGR and absolute return
- Absolute return = (everything received + value today − everything invested) ÷ everything invested. It ignores time: 30% in 3 months and 30% in 10 years look the same.
- CAGR is the yearly rate between one starting and one ending amount. For a single lump sum, XIRR and CAGR (on the same 365-day count) are the same number — use the CAGR calculator for that case.
- XIRR handles any number of cash flows on any dates. It is a money-weighted return: the months in which more money was invested count for more.
Pasting cash flows
Each line needs a date and an amount; a type word in any column is optional. Columns can be separated by tabs (copied from Excel or Google Sheets), semicolons or commas, and amounts may keep their digit grouping (1,00,000). Without a type word, a negative amount counts as invested and a positive one as received, as in Excel. Dates can be written as 2025-01-31, 31/01/2025, 31-Jan-25 or Jan 31, 2025; choose whether numeric dates are day-first (India, UK) or month-first (US). A header line is skipped and lines that cannot be read are listed, so nothing is dropped silently.
Recognised type words include SIP, purchase, buy and investment (invested); redemption, withdrawal, sell, SWP and dividend (received); and value, current value and market value (value today).
Limitations
- Days are counted on a 365-day year from the first date, exactly as Excel does; a leap day therefore counts as 1/365 of a year. Other conventions (actual/actual, 365.25) give slightly different results.
- The value today is treated as if you received it on its date. Exit loads, taxes and charges on selling are not deducted unless you reduce the value yourself.
- Cash flows that change from invested to received and back more than once can have more than one rate that balances them. The calculator lists every one it finds and shows the one nearest the guess.
- Over a few days or weeks a small gain becomes an enormous yearly rate; read the absolute return instead. Rates above 1,000,000% a year are not shown.
- Up to 2,000 cash flows at a time.
Privacy
Everything is calculated in your browser. Your cash flows, pasted text and results are never uploaded or stored on a server.
Frequently asked questions
Why is my XIRR different from the one my fund house or app shows?
Usually the dates or the amounts differ: statements use the date each unit was allotted rather than the date money left your bank, may value the holding on a different day, and may count stamp duty or dividends differently. The formula is the same everywhere; with the same dates and amounts this calculator gives the same answer as Excel’s XIRR.
Should the current value be positive or negative?
Positive: choose Value today for it. XIRR treats the value as money you would receive if you sold on that date. Investments are negative (type Invested), withdrawals and dividends positive.
Why does XIRR show a huge percentage for a short period?
XIRR is a yearly rate. A 5% gain in two weeks compounds to more than 200% a year, which says nothing useful about the investment. Under a year, the absolute return is easier to read; the calculator warns you when the period is short.
Is XIRR the same as IRR?
IRR assumes equal periods between cash flows (every month, every year). XIRR uses the actual dates, so it works for SIPs with missed or extra instalments, irregular top-ups and partial withdrawals. With exactly yearly cash flows on a 365-day year both give the same rate.
What is XNPV used for?
XNPV discounts every cash flow to the first date at a rate you choose — for example the return you could have earned elsewhere. A positive XNPV means the investment did better than that rate; zero means it matched it exactly, which is what the XIRR is.
Can XIRR be negative?
Yes. If what you got back (including the value today) is less than what you invested, the XIRR is negative — for example −5.13% a year for ₹1,000 that became ₹900 over two years.