XIRR Calculator
True annualised return on irregular investments and redemptions.
Investments (money you put in)
Current value (or redemption)
Add every purchase — SIP instalments, lumpsums and top-ups — then enter what the holding is worth today. Everything stays in your browser.
Cash flows used
| Date | Type | Amount |
|---|---|---|
| 2023-04-01 | Invested | -₹1,00,000 |
| 2024-04-01 | Invested | -₹1,00,000 |
| 2025-04-01 | Invested | -₹1,00,000 |
| 2026-04-01 | Current value | ₹3,80,000 |
XIRR (extended internal rate of return) is the annualised return on an investment where money went in and out on irregular dates — the standard way mutual fund houses report SIP returns. This XIRR calculator takes each purchase date and amount plus the current value of your holding and solves for the single yearly rate that ties them all together.
Use it when a simple CAGR cannot: SIP instalments, top-ups, partial redemptions and lumpsums bought at different times all get weighted by how long each rupee actually stayed invested. That is why your XIRR usually differs sharply from the headline 'absolute return' shown on an app.
How is XIRR calculated?
XIRR is the rate r that makes the present value of every cash flow add up to zero: Σ [amount ÷ (1 + r)^(days ÷ 365)] = 0, where days is the gap between that cash flow and the first one. Investments are entered as negative amounts, redemptions and the current value as positive. There is no closed-form answer, so the calculator searches for r numerically — the same thing Excel's XIRR() function does.
Worked example: you invested ₹1,00,000 on 1 April 2023, again on 1 April 2024 and again on 1 April 2025, and the folio is worth ₹3,80,000 on 1 April 2026. Total invested is ₹3,00,000 and the absolute gain is 26.67%, but the three instalments stayed invested for three, two and one years respectively — so the annualised XIRR works out to 12.29%. Quoting the 26.67% as a yearly return would badly overstate the fund's performance.
How to use this calculator
- Enter each investment as a row: the date you bought and the amount you put in.
- Use '+ Add cash flow' for every extra SIP instalment, top-up or lumpsum — order does not matter.
- Enter any partial redemption as a separate positive row on the date you received the money.
- Fill in the current value of the holding and the date it was valued (your latest statement date).
- Read the XIRR stat — that is your true annualised return. The absolute figure below it is the simple point-to-point gain, useful only for comparison.
- Open the cash-flow table to check the dates and amounts you entered before trusting the number.
XIRR for Indian mutual fund investors
Every mutual fund statement and CAS from CAMS or KFintech reports SIP performance as XIRR, and so do Groww, Zerodha Coin and Kuvera — so this is the number to quote when comparing your portfolio against a benchmark or a friend's fund. Use CAGR only when there was a single investment and a single exit; the moment you added a second instalment, XIRR is the correct measure.
Two Indian specifics are worth remembering. First, XIRR is a pre-tax figure: equity mutual funds attract 12.5% long-term capital gains tax above the ₹1.25 lakh annual exemption and 20% short-term, and each SIP instalment has its own holding period, so your post-tax XIRR will be lower. Second, ELSS units are locked in for three years from each instalment date, which means a redemption date you assume in this calculator may not actually be available yet. Feeding in the exact NAV-based value from your statement, rather than a rounded figure, keeps the result honest.
Frequently asked questions
What is a good XIRR for a mutual fund SIP?
Indian equity funds have historically delivered roughly 10–14% XIRR over long periods, while debt funds sit closer to 6–8%. Judge your fund against its benchmark index and category peers over the same dates rather than against an absolute target, because the market period matters far more than the fund.
What is the difference between XIRR and CAGR?
CAGR assumes one investment and one final value, so it ignores when money was added. XIRR handles any number of cash flows on any dates and weights each by the time it stayed invested. For a SIP, only XIRR gives a meaningful annualised return.
Why is my XIRR lower than the fund's advertised return?
Fund factsheets quote point-to-point or rolling returns for a lumpsum held for the whole period. Your SIP money arrived gradually, so recent instalments have had little time to grow. A rising market late in the period will also push the fund's CAGR above your personal XIRR.
Can XIRR be negative?
Yes. If the current value plus any redemptions is less than what you invested, the calculator returns a negative XIRR — the annualised rate at which your money shrank. A short holding period magnifies this, so a 10% paper loss after three months shows as a much larger negative annualised figure.
How do I add SIP instalments without typing every row?
For a monthly SIP, add one row per instalment date with the same amount — the calculator handles as many rows as you need. If you only want a rough figure, entering the instalments quarterly instead of monthly changes the XIRR by a fraction of a percent.
Does XIRR account for tax and exit load?
No. XIRR is calculated on the cash flows you enter, so it is a pre-tax, pre-load return. To see the post-tax figure, enter the redemption amount net of capital gains tax and any exit load instead of the gross value.
Related tools
SIP Calculator
Future value of monthly mutual-fund SIPs, with annual step-up.
Lumpsum Calculator
One-time investment growth and maturity value over the years.
SWP Calculator
Monthly withdrawals from a corpus and how long it lasts.
FD Calculator
Fixed deposit maturity value and interest with bank-style compounding.
RD Calculator
Recurring deposit maturity value and interest with quarterly compounding.
PPF Calculator
Public Provident Fund maturity value, interest and year-wise growth.
Salary Slip Generator
Create a professional payslip and download a white-label PDF — free.
Disclaimer: results are estimates based on the inputs and published rules/rates, for information only — not investment, tax or legal advice. Verify important decisions with a qualified professional. See our full disclaimer.