The SIP (Systematic Investment Plan) formula calculates the maturity value of a series of fixed monthly investments compounding at a given rate of return. Unlike a lump sum, where one amount compounds for the full duration, a SIP formula has to account for every monthly instalment compounding for a different length of time โ the first instalment grows for the whole period, the last one barely grows at all.
Formula
FV = P ร [(1 + r)โฟ โ 1] / r ร (1 + r)
| Variable | Meaning |
|---|---|
| FV | Future value โ your maturity corpus |
| P | Fixed monthly investment amount |
| r | Monthly rate of return (annual rate รท 12 รท 100) |
| n | Total number of monthly instalments |
Worked Example
Investing โน10,000 per month for 15 years (180 months) at an expected 12% annual return:
- Monthly rate: r = 12% รท 12 รท 100 = 0.01
- FV = 10,000 ร [(1.01)ยนโธโฐ โ 1] / 0.01 ร 1.01 = โน50,45,760
- Total invested: โน10,000 ร 180 = โน18,00,000
- Wealth gained from compounding: โน32,45,760
Notice that the gain (โน32.46 lakh) is nearly double the invested amount (โน18 lakh) โ that gap is entirely the effect of compounding over 15 years, not additional contributions.
Key Things to Know
- The formula assumes a constant monthly rate, but real mutual fund returns vary month to month. The final result is a smoothed projection, useful for planning but not a prediction of the exact final number.
- Small changes in duration matter more than small changes in the monthly amount at longer horizons, since compounding has more time to work โ extending the same SIP from 15 to 20 years often adds more to the corpus than doubling the monthly amount for 15 years.
- XIRR, not this formula, is used to measure actual historical SIP returns once contributions have happened at different NAVs โ this formula is for forward projection, not backward measurement.
- A Step-Up SIP formula is a variant that increases the monthly amount periodically rather than keeping P constant, compounding faster than the standard formula shown here.