What XIRR means
XIRR (extended internal rate of return) is the single yearly rate that, applied to every cash flow from its own date, makes all your investments and withdrawals add up to the current value. It answers: "What yearly return did my money actually earn?"
Why your SIP needs XIRR, not absolute return
In the example, ₹5,000 a month for 36 months adds up to ₹1,80,000, now worth ₹2,20,000. That is a 22.2% absolute return over three years. Dividing by three (7.4% a year) understates the return, because:
- the first instalment was invested for 3 years,
- the last instalment for only a few days,
- on average, your money was invested for about 1.5 years.
XIRR weights each instalment by how long it was invested and gives 13.35% a year. That is the number to compare with an FD rate or a fund's CAGR.
XIRR vs CAGR vs absolute return
| Measure | Use it for | Example result |
|---|---|---|
| Absolute return | A quick look at total gain | 22.2% |
| CAGR | One lump sum, held for a period | Not valid for a SIP |
| XIRR | SIPs, top-ups, withdrawals, irregular investing | 13.35% a year |
For a single lump sum with no other cash flows, XIRR and CAGR give the same answer.
How to use the calculator
- SIP quick fill: enter the SIP amount, the date of the first instalment and the number of instalments, then press Fill cash flows. Each instalment is placed on the same date every month.
- Edit the rows if any instalment was missed, changed or bounced, or add a lump-sum top-up with Add row.
- Add withdrawals by setting the row type to Withdrawal (for example, a partial redemption).
- Enter the current value and the valuation date from your fund statement or app.
How XIRR is calculated
The calculator solves this equation for r:
Σ Cash flowᵢ ÷ (1 + r)^((dateᵢ − first date) ÷ 365) = 0
Investments count as negative cash flows and withdrawals and the current value as positive. There is no direct formula, so it is solved by trial and refinement (the Newton–Raphson method), the same way Excel does it.
In Excel or Google Sheets: list amounts in one column (investments negative, current value positive) and dates in the next, then use =XIRR(amounts, dates).
What is a good XIRR?
Compare your XIRR with what the same money could have earned elsewhere over the same period:
- Bank FD: about 6.5%–7% a year.
- PPF: 7.1% a year, tax-free.
- Inflation: 5.54% (CPI, September 2026).
An equity SIP's XIRR swings a lot in the first few years. A low or negative XIRR after one or two years is common and says little about the long-term outcome. Judge it over five years or more. To plan future SIPs, see the SIP calculator and the step-up SIP calculator.