SIP Calculator
Estimate the future value of a monthly mutual fund SIP, with an optional yearly step-up and a year-by-year table.
Estimate the future value of a monthly mutual fund SIP, with an optional yearly step-up and a year-by-year table.
A Systematic Investment Plan (SIP) invests a fixed amount in a mutual fund every month. This calculator projects what those instalments could grow to at the yearly return you assume. It follows the method used by AMFI (the Association of Mutual Funds in India) on its investor education calculator: each instalment is invested at the start of the month, and the monthly rate is the yearly rate divided by 12.
Enter your monthly SIP, the return you expect, the number of years and an optional yearly step-up. The results show the total you invest, the estimated value at the end and the estimated gain, with a year-by-year table you can download as a CSV file.
Future value = P x [((1 + i)^n - 1) / i] x (1 + i), where P is the monthly SIP, i is the yearly return divided by 12 (as a decimal) and n is the number of monthly instalments.
The extra (1 + i) at the end is what makes the instalment count from the start of each month. If you switch the timing to the end of the month, that factor is dropped and the result is a little lower.
Example: ₹10,000 a month for 10 years at 12% gives a total investment of ₹12,00,000 and an estimated value of about ₹23,23,391. AMFI's own example of ₹5,000 a month for 7 years at 12% (about ₹4.20 lakh invested) comes to about ₹6.60 lakh, which this calculator reproduces as ₹6,59,895.
With a step-up, your SIP rises by a fixed percentage once every 12 instalments. The instalment in year k is P x (1 + step-up)^(k - 1), and each instalment grows at the monthly rate until the end of the period. With a 0% step-up the result is exactly the AMFI formula above. A 10% step-up on ₹10,000 a month for 10 years means investing about ₹19,12,491 in total, with an estimated value of about ₹33,74,326 at 12%.
Calculators are for illustration only and do not represent actual returns. Mutual funds do not have a fixed rate of return, and past performance may or may not be sustained in future.
Mutual Fund investments are subject to market risks, read all scheme related documents carefully.
Formula and convention: AMFI SIP calculator on mutualfundssahihai.com. Risk wording: SEBI circular SEBI/IMD/CIR No. 17/193751/2010 dated 4 February 2010.
This calculator gives an estimate for planning only. It is not financial, tax or investment advice. Rates, rules and tax laws change, so confirm the figures with your bank, post office or a qualified adviser before you invest.
Be the first to share your experience with the SIP Calculator.