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) = 0There'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
| Measure | What it tells you | Use it for |
|---|---|---|
| Absolute return | Total gain ÷ total invested | A quick check, ignoring time |
| CAGR | Yearly growth of one lump sum | A single investment held for a period |
| XIRR | Yearly return across many dated payments | SIPs, 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
- For a SIP, enter the monthly amount, first date and number of months, then fill the list.
- Add any lump sums or withdrawals, or edit the list by hand.
- 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.