SIP Goal Planner
Calculate the monthly SIP needed to reach a target corpus over a chosen tenure at an assumed annual return. Uses the standard future value of annuity formula.
Result
About SIP Goal Planner
Calculate the monthly SIP needed to reach a target corpus over a chosen tenure at an assumed annual return. Uses the standard future value of annuity formula.
Features
- Instant SIP amount for your goal.
- Works with any tenure and rate.
- INR formatting for readability.
How to Use
- Enter target corpus.
- Enter annual return and months.
- Review required monthly SIP.
What is a SIP goal planner?
A SIP goal planner works backwards from a target. Instead of asking what a monthly SIP will grow to, it tells you how much you need to invest every month to reach a specific amount by a chosen date, such as ₹25 lakh for a child's education or ₹1 crore for retirement. It's the simplest way to turn a vague goal into a monthly number you can commit to.
Monthly SIP needed for a goal
Target is the amount you want, r the expected monthly return (annual return ÷ 12 ÷ 100) and n the number of months. This is the standard SIP future-value formula solved for the monthly amount, assuming each instalment is invested at the start of the month. Enter the target in future rupees: a goal that costs ₹10 lakh today and is 15 years away needs about ₹24 lakh at 6% inflation.
Tips for planning SIP goals
- Inflate the goal first. Costs rise every year, so plan for the future price, not today's.
- Start early. Giving a goal 20 years instead of 10 cuts the monthly SIP by more than three-quarters.
- Step up your SIP every year with your salary. Even a 10% annual increase reaches the same goal with a much smaller starting amount.
- Match the investment to the time frame: equity for goals 7+ years away, a mix for 3–7 years, and debt funds or FDs for money needed within 3 years.
- Review once a year, and shift gradually to safer investments as the goal gets close.
Worked example: ₹1 crore in 15 years
- Goal: ₹1,00,00,000 in 15 years (180 months), expecting 12% a year (1% a month)
- SIP factor = ((1.01)¹⁸⁰ − 1) ÷ 0.01 × 1.01 ≈ 504.6
- Monthly SIP needed = ₹1,00,00,000 ÷ 504.6 = ₹19,819
- Total invested: ₹35,67,420. The remaining ₹64 lakh or so comes from compounding
- With only 10 years to go, the SIP rises to ₹43,041 a month; with 20 years, it falls to ₹10,009
Monthly SIP needed at 12%
Monthly investment required to reach each target at a 12% expected annual return.
| Target | 5 years | 10 years | 15 years | 20 years |
|---|---|---|---|---|
| ₹10,00,000 | ₹12,123 | ₹4,304 | ₹1,982 | ₹1,001 |
| ₹25,00,000 | ₹30,308 | ₹10,760 | ₹4,955 | ₹2,502 |
| ₹50,00,000 | ₹60,616 | ₹21,520 | ₹9,909 | ₹5,004 |
| ₹1,00,00,000 | ₹1,21,232 | ₹43,041 | ₹19,819 | ₹10,009 |
Assumes a constant 12% return and investment at the start of each month. Actual returns vary, so build in a margin of safety.