XIRR calculator: your real return on SIPs and irregular investments

Enter what you invested and withdrew, with dates, and what it's worth now. The calculator gives your annualised return, the same XIRR your fund statement shows.

  • For India, the US and Australia
  • By the Gleexa team
  • Free, no sign-up
  • Last reviewed
  • Private: nothing you type is stored
Show amounts for
Loading calculator…

If you invest a little every month, simple return figures mislead. Your first SIP payment has been invested for years, your last for a few days. XIRR, the extended internal rate of return, weighs every payment by how long it was invested and turns the result into one yearly rate.

How XIRR works

Treat every investment as money going out (negative) and every withdrawal, plus today's value, as money coming in (positive), each with its date. XIRR is the yearly rate r that makes them add up to zero:

Σ amount ÷ (1 + r)^(days since first payment ÷ 365) = 0

There's no direct formula, so the rate is found by trial: the calculator narrows it down until the total is zero, just as Excel and Google Sheets do.

Example: A two-year SIP

₹10,000 on the 5th of every month from January 2024: 24 payments, ₹2,40,000.

Worth ₹2,80,000 on 5 January 2026.

Absolute return: 16.7%. XIRR: about 15.5% a year.

XIRR, CAGR and absolute return

MeasureWhat it tells youUse it for
Absolute returnTotal gain ÷ total investedA quick check, ignoring time
CAGRYearly growth of one lump sumA single investment held for a period
XIRRYearly return across many dated paymentsSIPs, top-ups, partial withdrawals

For a single lump sum with no top-ups, XIRR and CAGR give the same answer.

Tips for an accurate figure

  • Use the actual dates from your statement; a few days' difference matters little, but months do.
  • Leave out dividends you reinvested: they're already in the current value.
  • Use the value on a recent date and enter that same date, not today's if the price is old.
  • Over less than a year, XIRR annualises the result, so a small gain can look like a big yearly rate.

How to use this calculator

  1. For a SIP, enter the monthly amount, first date and number of months, then fill the list.
  2. Add any lump sums or withdrawals, or edit the list by hand.
  3. Enter the current value and the date it's from.

FAQs

What is a good XIRR for a SIP?

Compare it with a fixed deposit rate, the fund's benchmark index and your other options. Over a year or two, equity XIRR swings widely, so judge it over five years or more.

Why is XIRR different from absolute return?

Absolute return is total gain ÷ total invested, ignoring time. In a SIP, the last payments were invested only briefly, so XIRR, which accounts for that, is the fair yearly figure.

Is XIRR the same as CAGR?

For a single investment with no top-ups, yes. XIRR is CAGR extended to many payments on different dates.

Results are estimates and aren't financial advice. For decisions about your own money, check with a qualified adviser. Spotted a mistake? Tell us.

XIRR Calculator: SIP & Mutual Fund Returns with Dates | Gleexa