Formula used
Future cost = Cost today × (1 + Inflation)^YearsMonthly rate i = Expected return ÷ 12; months n = Years × 12Required SIP = Future cost × i ÷ ( ((1 + i)^n − 1) × (1 + i) )Existing savings are deducted from the goals before the SIP is worked outTotal monthly SIP = sum of the three goal SIPs
Why goals need inflation built in
A course that costs ₹25 lakh today will cost far more in twelve years. Planning with today's price means arriving short. By growing each cost at an inflation rate first, the planner sizes your target in the rupees you will actually be paying.
The calculation, step by step
- Step 1: inflate each goal's cost to its target year.
- Step 2: subtract any existing savings you allocate to goals.
- Step 3: convert the expected annual return to a monthly rate.
- Step 4: solve for the monthly instalment that grows to the future cost, using the annuity-due formula.
- Step 5: add the three SIPs.
Worked example with the default values
Three goals with 6% inflation, 11% expected return and no existing savings.
| Item | Value |
|---|---|
| Child education: ₹25,00,000 in 12 years, future cost | ₹50,30,491 |
| Child education: monthly SIP | ₹16,793 |
| Dream car: ₹12,00,000 in 5 years, future cost | ₹16,05,871 |
| Dream car: monthly SIP | ₹20,012 |
| Vacation: ₹5,00,000 in 3 years, future cost | ₹5,95,508 |
| Vacation: monthly SIP | ₹13,910 |
| Total monthly SIP | ₹50,715 |
The shortest goals have the heaviest monthly demand, so the car and holiday together outweigh the education plan in monthly terms even though they are far cheaper.
Who should use it
Young parents planning education, couples saving for a down payment or a wedding, and salaried people balancing several targets can use it to see whether their income can carry all goals at once. If the total is too high, extend a deadline or reduce a cost and watch the numbers fall.
Tips and common mistakes
- Do not assume the return will be steady; markets move, so leave a margin.
- Move money from equity to safer assets as a goal approaches.
- Review the plan once a year and update costs.
India context to keep in mind
Education costs abroad also depend on the rupee exchange rate, and remittances fall under the Liberalised Remittance Scheme with tax collected at source in some cases, so check current rules. Gains from mutual funds are taxed under rules that depend on the fund type and holding period. Sovereign Gold Bonds, now with paused fresh issues, and deposits may suit shorter goals. Consult a SEBI-registered adviser before committing.
Frequently Asked Questions
Why is the SIP for a short goal so high?
Fewer months mean less time for compounding, so more must come from your own pocket. Longer deadlines let growth do more of the work and reduce the required monthly amount. Remember that results follow your assumptions, so test more than one scenario.
What inflation rate should I use?
General inflation has often hovered around four to six percent, while education and healthcare can rise faster. Use a higher rate for those goals and test a few values. Check official or provider information before you commit money.
How are existing savings treated?
Savings you set aside are deducted from the goals before the SIP is worked out, which lowers the monthly amount. Enter only money that is genuinely earmarked for these goals. Treat the output as a planning estimate and confirm specifics before acting.
Is the expected return guaranteed?
No. Equity-oriented investments fluctuate, and the return you enter is only an assumption. For near-term goals prefer lower-risk options and consider a conservative rate. Use it as a guide, and verify the latest rules or quotes yourself.
Can I use it for retirement planning?
It is built for three medium-term goals. Retirement is long and has its own drawdown phase, so use a dedicated retirement calculator alongside it for a fuller view. Remember that results follow your assumptions, so test more than one scenario.
Disclaimer: This calculator provides estimates for planning and education. Actual figures depend on your lender, insurer or the latest rules. It is not investment, tax or legal advice.