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