Skip to content

XIRR Calculator – True Return on SIPs & Mutual Funds

Dated cash flows · SIP auto-fill · same method as Excel XIRR

Enter each investment as a negative amount and each withdrawal or today's value as a positive amount.

DateAmount (₹)Remove
Fill in a SIP automatically
₹
₹

Your annualised return

XIRR–
Total invested–
Total received / value–
Gain–
Absolute return–

Share on WhatsApp
· Author: · Same method as the spreadsheet XIRR function

What is 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.

How to use this calculator

  1. Enter every investment with its date as a negative amount.
  2. Enter every withdrawal (redemption, dividend) as a positive amount.
  3. Add today's value of what you still hold as a positive amount dated today.

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.

Example

₹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.

XIRR vs CAGR vs absolute return

MeasureBest for
Absolute returnTotal gain as a percentage, ignoring time
CAGROne investment, one start and end value
XIRRMany investments or withdrawals on different dates (SIPs, top-ups, SWPs)

Related calculators

SIP calculator · Step-up SIP · CAGR calculator · Lumpsum calculator

Frequently asked questions

What is a good XIRR for a mutual fund SIP?

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.

Why is my XIRR higher than my absolute return?

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.

How is XIRR different from CAGR?

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.

Is XIRR the same as Excel's XIRR function?

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.