How SIP Returns Are Calculated
Updated
A SIP (systematic investment plan) puts a fixed amount into a mutual fund every month. Because each instalment is invested for a different length of time, working out the final value takes a formula rather than a single multiplication. Here is how it works.
The SIP formula
The future value of a monthly SIP is P × ((1 + i)^n − 1) ÷ i × (1 + i). P is the monthly amount, i is the monthly rate of return (the yearly rate divided by 12, then by 100), and n is the number of months. The final × (1 + i) assumes each instalment is invested at the start of its month, as fund houses' own calculators do.
A worked example
Take ₹5,000 a month for 10 years at an expected 12% a year. That's 120 instalments, so you invest ₹6,00,000. At 1% a month, the formula gives about ₹11,61,695, so the expected gain is about ₹5,61,695. Kept going for 20 years, the same SIP invests ₹12 lakh and could grow to about ₹49,95,740, because the early instalments have far longer to compound.
What a step-up does
A step-up raises the SIP every year, usually in line with your salary. With a 10% yearly step-up, the same ₹5,000 SIP becomes ₹11,790 a month by year 10. You invest about ₹9,56,246 in total, and at 12% it could grow to about ₹16,87,164. There's no single formula for this; calculators work it out month by month.
Why the return looks different in your fund statement
Statements and apps show your SIP's return as XIRR, a yearly rate that takes into account the date of every instalment. It is the right measure for money invested in pieces. A plain percentage gain, such as 94% on ₹6 lakh turning into ₹11.6 lakh, overstates the yearly return because most of the money wasn't invested for the full 10 years.
In Excel
For a plain SIP: =FV(12%/12, 120, -5000, 0, 1). The final 1 tells Excel that payments happen at the start of each month. For XIRR, list each instalment as a negative amount with its date, the current value as a positive amount with today's date, and use =XIRR(amounts, dates).
Returns are not guaranteed
Mutual fund returns go up and down, and can be negative over short periods. A steady 12% is a planning assumption, not a promise. Check the fund's factsheet for its actual history, and remember that exit loads and tax on gains come out of the final value.
Try it
The SIP Calculator works out the value for any amount, period and step-up, or the SIP you need for a goal, with a year-by-year table. The CAGR & XIRR Calculator works out the actual return on your own instalments.