Skip to main content

Investment · FINANCIAL TOOLS

Goal-Based SIP Calculator

Start from the amount you need and work backwards to the monthly investment it requires.

Understand the calculation

Calculation logic, formula, example and guardrails behind the estimate.

How it works

The calculator first projects what you already have. Existing savings are compounded forward at the same assumed rate over the same period, which usually covers a meaningful share of the target on its own.

Whatever the target exceeds that by is the gap the new contributions have to fund. If existing savings alone are projected to clear the target, the required contribution is zero and the calculator says so rather than returning a negative number.

More detail

The required monthly amount is then the gap divided by the future value of a ₹1 monthly SIP over the same period. That divisor comes from the same function the forward SIP calculator uses, so the two are exact inverses — feed the required contribution back into the SIP calculator and you land on the gap.

Because the answer scales linearly with the gap, doubling the target roughly doubles the contribution, but halving the time far more than doubles it. The duration scenario below makes that asymmetry visible.

Before setting a target, work out what it will actually cost by then — the inflation calculator converts today's price into future rupees.

If your contribution can rise each year, the starting amount needed is lower — model it with the step-up SIP calculator.

Formula

P = ( Target − Savings × (1 + i)ⁿ ) ÷ ( ((1 + i)ⁿ − 1) ÷ i × (1 + i) )

The numerator is the shortfall after existing savings have grown; the denominator is the future value of a ₹1 monthly SIP. When savings alone reach the target the numerator goes negative and the required contribution is reported as zero.

P
Required monthly investment
Target
The amount you want at the end
Savings
What you have already set aside for this goal
i
Monthly rate — the assumed annual return divided by 12, as a decimal
n
Number of monthly instalments (years × 12)
Worked example

A ₹50,00,000 target in 10 years, with ₹5,00,000 already saved, at an assumed 12% return.

  1. 01Monthly rate (i)12% ÷ 12 = 1% = 0.01
  2. 02Instalments (n)10 × 12 = 120
  3. 03Existing savings grow to₹5,00,000 × 1.01¹²⁰ ≈ ₹16,50,193
  4. 04Gap to fund₹50,00,000 − ₹16,50,193 ≈ ₹33,49,807
  5. 05Future value of a ₹1 SIP((1.01¹²⁰ − 1) ÷ 0.01) × 1.01 ≈ 232.34
  6. 06Required monthly SIP₹33,49,807 ÷ 232.34 ≈ ₹14,418
  7. 07Total contributed₹14,418 × 120 ≈ ₹17,30,160

The ₹5 lakh already saved does roughly a third of the work by itself, because it has the full ten years to compound. Starting a goal with something already set aside is worth considerably more than the amount suggests.

Frequently asked questions

Common questions about the goal-based sip calculator and the assumptions behind it.

Disclaimer

This calculator is provided for general information and planning only. It is not investment, tax or legal advice, and it does not take your personal circumstances into account. Outputs are estimates based on the assumptions stated on this page, exclude taxes and charges unless said otherwise, and market-linked returns are not guaranteed — the value of investments can fall as well as rise. Lending terms, rates and eligibility are decided by the lender. For advice on your own situation, speak to a qualified professional, several of whom you can consult on Finvestalk.