Dated cash flows · SIP auto-fill · same method as Excel XIRR
XIRR (extended internal rate of return) is the yearly return of an investment where money goes in and comes out on different dates — a SIP, a few lump sums, partial withdrawals or dividends. It is the single annual rate that makes the value of all your cash flows add up to zero. Mutual fund statements and apps report your SIP returns as XIRR.
For a regular SIP, open “Fill in a SIP automatically”, enter the amount, first date, number of instalments and current value, and the calculator creates all the rows for you.
₹1,00,000 invested in April 2022, ₹50,000 in August 2023 and ₹50,000 in December 2024, worth ₹2,65,000 in November 2026. The absolute return is 32.5%, but that gain was earned over four and a half years with money added at different times, so the XIRR is about 8.0% a year — a much more honest picture.
| Measure | Best for |
|---|---|
| Absolute return | Total gain as a percentage, ignoring time |
| CAGR | One investment, one start and end value |
| XIRR | Many investments or withdrawals on different dates (SIPs, top-ups, SWPs) |
SIP calculator · Step-up SIP · CAGR calculator · Lumpsum calculator
Over 5 years or more, an XIRR of 10–14% is considered good for an equity fund in India. Over short periods XIRR swings a lot with the market, so judge it over the long term.
Absolute return ignores time. If much of your money was invested recently, the same gain was earned in a shorter time, so the yearly rate (XIRR) can be higher than it looks.
CAGR assumes one investment and one final value. XIRR handles many investments and withdrawals on different dates, so it is the right measure for SIPs.
Yes. This calculator uses the same method: it finds the rate at which the present value of all dated cash flows, using a 365-day year, equals zero.
Disclaimer: Results are estimates for planning. Tax and scheme rules change; confirm with official sources or a qualified advisor before acting.