Goal Planner
Find the monthly SIP needed to reach any financial goal.
What the Goal Planner Calculator does
A goal is a number with a date attached: Rs. 25 lakh for a child's degree in 2036, Rs. 60 lakh for a house down-payment in eight years, or Rs. 3 crore for retirement at 60. The trouble is that the price you see today is not the price you will pay on that date, because inflation quietly raises the cost every year. This Goal Planner Calculator does two jobs at once: it grows your goal from today's cost to its likely future cost, and then works backwards to tell you the monthly investment you must start now to get there.
Who it is for
It suits anyone planning a specific, dated money goal rather than a vague "save more" intention. Parents saving for school or college fees, young earners building a house or car corpus, and people mapping retirement all benefit from seeing a single, honest monthly figure. It is especially useful if you invest through SIPs in mutual funds, where a steady monthly amount is the natural unit of planning.
The exact formula, in words
The calculation runs in two stages.
Stage 1 - Inflate the goal. The future cost equals today's cost multiplied by (1 plus the inflation rate) raised to the power of the number of years. In symbols, Future Cost = Present Cost x (1 + inflation) ^ years.
Stage 2 - Find the monthly investment. Using the standard SIP future-value relationship for money invested at the start of each month, the required monthly amount is: Monthly Investment = Future Cost x r divided by [ ((1 + r) ^ N - 1) x (1 + r) ], where r is the monthly rate of return (annual expected return divided by 12) and N is the total number of months until the goal.
A fully worked example
Suppose you want to fund a college education that costs Rs. 20,00,000 today, the goal is 10 years away, you assume 8% education inflation, and you expect your equity SIP to earn 12% a year.
- Step 1 - future cost. (1.08) ^ 10 = 2.159. So Future Cost = 20,00,000 x 2.159 = Rs. 43,17,850 (about Rs. 43.18 lakh). This is what that same degree is likely to cost in 10 years.
- Step 2 - set up the SIP maths. Monthly return r = 12% / 12 = 1% = 0.01. Number of months N = 10 x 12 = 120. Compute (1.01) ^ 120 = 3.300.
- Step 3 - the growth factor. ((1.01) ^ 120 - 1) / 0.01 = (3.300 - 1) / 0.01 = 230.04. Multiply by (1 + r): 230.04 x 1.01 = 232.34.
- Step 4 - divide. Monthly Investment = 43,17,850 / 232.34 = Rs. 18,584 per month (round up to about Rs. 18,600).
Over 120 months you would invest roughly Rs. 22.3 lakh of your own money, and market growth supplies the remaining Rs. 21 lakh to reach the Rs. 43.18 lakh target. Notice how ignoring inflation would have been a costly mistake: planning for only Rs. 20 lakh would have left you short by more than half of the actual Rs. 43.18 lakh bill.
Rules, assumptions and edge cases
- Returns are assumptions, not promises. Equity returns vary and recent years have been volatile; a 10-12% long-run assumption is common for equity funds, while debt or hybrid options should use lower figures. Choose an inflation rate that fits the goal - general inflation is often 6%, but education and healthcare frequently run 8-10%.
- Short horizons need caution. For goals under three years, avoid high equity return assumptions - market volatility can leave you short exactly when you need the money. Debt funds, recurring deposits or FDs are safer for near-term goals.
- Start-of-month vs end-of-month. This planner assumes each instalment is invested at the start of the month. If your SIP debits later, the required amount is marginally higher.
- Existing savings. If you already hold a corpus toward the goal, grow it separately at your return rate and subtract its future value from the target before computing the SIP.
Tax treatment
The monthly figure assumes gross returns; taxes apply when you redeem. As of FY 2025-26, gains on equity mutual funds held over 12 months are long-term, with up to Rs. 1.25 lakh of such gains per year exempt and the excess taxed at 12.5%; equity gains within 12 months are short-term at 20%. Debt fund gains on units bought on or after 1 April 2023 are added to income and taxed at your slab rate. ELSS funds additionally offer a deduction under Section 80C (up to Rs. 1.5 lakh) if you are on the old tax regime, though they carry a three-year lock-in. Build a small tax buffer into your target so the post-tax amount still meets the goal.
Common mistakes to avoid
- Planning for today's price and ignoring inflation - the single biggest error.
- Assuming equity-level returns for a goal that is only a year or two away.
- Forgetting to step up the SIP as your income rises, which lets you start smaller and catch up.
- Treating the output as fixed - review yearly and adjust for actual returns and changed timelines.
- Overlooking exit loads and taxes when you finally redeem the corpus.
Frequently asked questions
What inflation rate should I use in the Goal Planner?
Match the rate to the goal. General living costs are often assumed at around 6%, but education and healthcare in India frequently rise 8-10% a year, so use the higher figure for those goals to avoid falling short.
How is the future cost of my goal calculated?
The planner multiplies today's cost by (1 + inflation) raised to the power of the number of years. For example, Rs. 20 lakh at 8% inflation over 10 years becomes about Rs. 43.18 lakh.
Why does the monthly amount fall when the goal is further away?
A longer horizon gives compounding more time to work, so a larger share of the target comes from growth rather than your contributions. That said, more years of inflation also raise the future cost, so the two effects partly offset each other.
Should I use equity returns for a short-term goal?
No. For goals within about three years, equity markets are too volatile and can leave you short when the money is due. Use debt funds, recurring deposits or FDs and a lower return assumption for near-term goals.
How are the gains taxed when I withdraw for my goal?
As of FY 2025-26, long-term equity fund gains above Rs. 1.25 lakh a year are taxed at 12.5% and short-term equity gains at 20%. Debt fund gains on units bought on or after 1 April 2023 are taxed at your income slab, so it helps to build a tax buffer into your target.
Can I start with a smaller SIP and increase it later?
Yes. A step-up SIP lets you begin with a lower amount and raise it each year as your income grows, which can be easier than committing the full required amount from day one. Just ensure the increases actually happen so you still reach the goal.