Financial Calculators
XIRR Calculator
Calculate the actual annualised return (XIRR) on your SIP or irregular investments.
This tool provides an estimate or a starting draft. Check the assumptions and current official requirements before relying on the result. It does not replace qualified financial, legal or medical advice.
Run XIRR Calculator online
In-browserDocument processing runs on your device. External resources may still load.
Enable JavaScript to use the interactive tool. Read the instructions, limitations and FAQs below before starting.
XIRR (Extended Internal Rate of Return) is the most accurate measure of return on investments with irregular cash flows — such as monthly SIPs, lump sum additions, and partial redemptions. Unlike CAGR (which assumes a single lump-sum investment), XIRR accounts for the timing of each cash flow, giving you the true annualised return on your portfolio.
Our XIRR Calculator uses an iterative numerical method to solve the discount rate that makes the net present value of all cash flows equal to zero. You simply enter each investment date and amount (negative for investments, positive for redemptions), and the calculator outputs the annualised return rate. This is how mutual fund fact sheets, financial advisors, and Value Research calculate SIP returns.
Interpreting XIRR: a 12% XIRR means your investments have grown at the equivalent of 12% per year compounded annually. For equity mutual funds, long-term XIRR of 12–15% is excellent. For debt funds, 7–9% is typical. A negative XIRR means your portfolio is currently underwater. XIRR above 20% over 5+ years indicates exceptional fund performance.
How to use this utility
- Use the controls below—paste text, pick files, or adjust options as described on the tool.
- Click the main action button. Processing runs in your browser on this device.
- Download or copy the output. Check the processing note for any external services used by this operation.
Common use cases
- Measuring the actual return on a multi-year SIP across different market cycles
- Comparing returns across multiple mutual funds invested at different times
- Evaluating ULIP performance vs equivalent term insurance + mutual fund strategy
- Calculating actual return on stock portfolio with multiple buy and sell transactions
- Comparing SIP returns in equity funds vs recurring deposits
Tips for best results
- 1Use current market value (not invested amount) as the final positive cash flow for XIRR on ongoing SIPs
- 2XIRR of 12–15% for equity mutual funds over 7+ years is considered very good performance
- 3Negative XIRR after 3+ years in equity suggests the fund is poor — consider switching
- 4XIRR can be higher than CAGR if most investments were made during market dips
- 5Short-term XIRR (under 2 years) is meaningless for equity — markets fluctuate too much
Frequently asked questions
- Is Konnect2Tools free?
- Yes. These in-browser tools are completely free to use with no account required for core functionality.
- Do my files leave my device?
- Browser document operations run locally, except where the operation uses an external service, such as AI summarisation. Read the processing note before using sensitive inputs.
- Is the XIRR Calculator tool safe to use?
- Local operations process document content on your device. External-service operations may send inputs as described in the processing note. Keep originals and inspect the output.
- How is XIRR different from CAGR?
- CAGR assumes one investment at the start and measures growth to the end date. XIRR accounts for every individual cash flow — each SIP installment — and its exact date, making it precise for portfolios with multiple investments. CAGR is a simplification; XIRR is the accurate measure.
- Why does XIRR show a different return than what the mutual fund reports?
- Mutual funds report point-to-point NAV returns (CAGR). Your personal XIRR will differ because it depends on when you invested — investing at a market peak will show lower XIRR than someone who invested during a dip, even in the same fund.
- What should I enter as the final cash flow?
- If you've already redeemed, enter the redemption amount as a positive cash flow. If the investment is still running, enter today's current market value (portfolio value) as a positive cash flow on today's date. This gives you the XIRR on your current unrealised gain.
- What is a good XIRR for mutual funds?
- For equity mutual funds: 12–15% XIRR over 5–10 years is excellent. 10–12% is good. Below 10% over 7+ years suggests the fund is underperforming the index, and you should consider index funds. For debt funds, 7–9% is normal.
Related tools
Continue with another utility in financial calculators.