XIRR Calculator
The real annualised return when money went in and out on irregular dates.
XIRR is the annualised return that accounts for exactly when each amount went in or came out, which is the only correct measure for a SIP or any portfolio with irregular flows. Rs 2.25 lakh invested across three dates and now worth Rs 3 lakh is a 33.3% absolute return but only about 10% a year.
How this is calculated
Year-by-year breakdown
Free XIRR calculator for real portfolios
XIRR is the annualised return that accounts for exactly when each amount went in or came out. It is the only honest way to measure a real portfolio, because real money does not arrive in one neat lump: you start a SIP, you top up in a good month, you skip a bad one, you redeem part of it for a wedding. CAGR cannot handle any of that, and absolute return flatters money that was invested recently.
Paste your cash flows, one per line, as date, amount. Money going in is negative, money coming out or the value today is positive. It is the same number Excel's XIRR function returns, and the same number your mutual fund statement quotes.
Worked example
Rs 1,00,000 invested in Jan 2023, Rs 50,000 in Jul 2023, Rs 75,000 in Jun 2024, and the folio worth Rs 3,00,000 today: Rs 2.25 lakh went in, Rs 3 lakh is the value, so the absolute return is 33.3%. But over that period, weighted by when each amount was actually invested, the XIRR is about 10.05% a year. The absolute figure sounds better; the XIRR is the one you can compare against an index or a fixed deposit.
| Measure | Handles multiple dates? | What it tells you |
|---|---|---|
| Absolute return | No | Total gain as a percentage, with no reference to time |
| CAGR | No, one in and one out only | Annualised growth between two points |
| XIRR | Yes, any number of dated flows | The true annualised return of your actual investing pattern |
How to use it with a real mutual fund folio
Take your SIP instalments as negative amounts on their dates, add any lumpsum top-ups the same way, add redemptions as positive amounts, and finish with today's folio value as a positive amount dated today. That last line is what makes the whole thing work: the current value is treated as a final notional redemption.
Dates can be written as 2024-04-01 or 01/04/2024, day first. Blank lines and lines starting with # are ignored, so you can keep notes in the list.
For a single lumpsum with one start and one end, the CAGR calculator is simpler. To project a SIP forward rather than measure one backwards, use the SIP calculator.
Key facts
| What it solves | The rate r where the sum of CF / (1 + r)^(days/365) equals zero |
|---|---|
| Sign convention | Money in is negative, money out or current value is positive |
| Minimum input | At least one negative and one positive amount |
| Date formats | YYYY-MM-DD or DD/MM/YYYY |
| Matches | Excel's XIRR function and most Indian mutual fund platforms |
How to use the XIRR Calculator
- Write one cash flow per line, as date then a comma then the amount.
- Make money you invested negative, for example 2024-04-01, -50000.
- Make redemptions positive, and finish with today's total value as a positive line.
- Dates work as YYYY-MM-DD or DD/MM/YYYY.
- Read the XIRR, the total invested, the total returned and the absolute return.
- Compare the XIRR with a benchmark or a fixed deposit rate to see whether the effort was worth it.
Sources
Last reviewed and updated: 23 August 2026. Estimates only, not financial or tax advice.
Frequently asked questions
What is XIRR?
XIRR, or extended internal rate of return, is the annualised rate that makes the net present value of a series of dated cash flows equal to zero. It weights every amount by how long it was actually invested, which is why it is the correct measure for SIPs, top-ups and partial redemptions.
What is the difference between XIRR and CAGR?
CAGR assumes one amount in and one amount out, so it works for a single lumpsum and nothing else. XIRR handles any number of amounts on any dates. For a SIP, CAGR is simply the wrong tool and will usually overstate or understate the return significantly.
How do I calculate XIRR for a SIP?
List every instalment as a negative amount on the date it was debited, add any top-ups the same way, add any redemptions as positive amounts, and add today's folio value as a final positive line dated today. The result is your SIP's true annualised return.
Is XIRR the same as the return my mutual fund app shows?
Usually yes. Most Indian platforms report XIRR for folios with multiple transactions, and absolute return alongside it. If two apps disagree, it is almost always because one is showing absolute return and the other XIRR.
What is a good XIRR?
It depends on the asset. For Indian equity funds, a long-run XIRR of 11 to 13% is a reasonable expectation; anything above 15% sustained over a decade is exceptional. For debt funds, 6 to 8%. The right comparison is against the fund's benchmark index over the same period, not against another investor.
Why does my XIRR look low when I have made money?
Because most of your money may have been invested recently. If half the amount went in six months ago, it has had six months to grow, not five years. XIRR is honest about that, which is exactly why it is worth using.
Is this XIRR calculator free?
Yes, free with no sign-up, and every calculation runs in your browser, so your transaction list never leaves your device.