SIP Annualised Return Calculator

Work out the annualised return on a monthly SIP from the instalments you paid and the value today, using the XIRR method.

months

The current fund value, not the amount you paid in.

Only the symbol changes — amounts are not converted.

Annualised return (XIRR method)

12.66%

Gain of 93.3% on what you paid in.

  • Total invested$600,000.00
  • Gain or loss$560,000.00
  • Absolute return93.33%
  • Monthly rate used0.998%

How it works

Solve P × ((1 + i)^n − 1) ÷ i × (1 + i) = V for the monthly rate i, then XIRR = (1 + i)^12 − 1

Assumptions

  • Assumes an equal investment at the start of each month and one valuation at the end of the last month; it does not model withdrawals, dividends paid out, or irregular dates.
  • Spreadsheet XIRR takes dated cash flows. Because months differ in length, this regular-monthly version can differ from XIRR on a statement by a few hundredths of a percentage point.
  • The result is solved numerically from your own figures. It is a measurement of the past, not a forecast of the future.
  • This is not investment or tax advice. For regulated advice in India, consult an adviser registered with SEBI.

Sources

  • Internal rate of return and XIRR definitions (standard financial mathematics; Microsoft Excel XIRR documentation)
  • Future value of an annuity due (e.g. Bodie, Kane & Marcus, Investments)

Questions

How is XIRR different from absolute return?

Absolute return compares what you put in with what it is worth, ignoring time. XIRR converts that into a yearly rate, so a 16% gain over five years and a 16% gain over one year stop looking equivalent — the first is about 3% a year.

Why is my XIRR lower than the fund’s published return?

Because your money was not invested for the whole period. Early instalments compound for years, the most recent ones for a month, so the blended rate is usually below the fund’s since-inception figure.

Can this handle irregular dates or withdrawals?

No. It assumes one investment per month and a single valuation at the end. For irregular cash flows use the XIRR function in a spreadsheet, which takes dated entries.