The monthly amount a goal needs is what is left to save divided by the months remaining. Compare that with your average contribution over the last three months and the difference is your goal gap. If the goal is ₹1,80,000 with 14 months to go and ₹40,000 already saved, you need ₹1,40,000 ÷ 14 = ₹10,000 a month.
How do you calculate the required contribution?
- Take the target: ₹1,80,000.
- Subtract what you have already saved for this goal: ₹1,80,000 − ₹40,000 = ₹1,40,000 remaining.
- Divide by months left: ₹1,40,000 ÷ 14 = ₹10,000 a month.
This ignores interest the money may earn. If it sits in an account that pays interest, the true requirement is a little lower, so the figure above is the cautious one. Recalculate every month, because the remaining amount and the months left both change.
What are you actually contributing?
Look at what really went into the goal in the last three months, not what you meant to put in. Say the figures were ₹7,000, ₹8,500 and ₹6,500. The total is ₹22,000, and the average is ₹22,000 ÷ 3 = ₹7,333 a month. Three months smooths out one lumpy month without hiding a real trend. If you skipped a month entirely, include the zero.
How big is the gap?
The gap is ₹10,000 − ₹7,333 = ₹2,667 a month. Over 14 months, at your current pace, you would add about ₹7,333 × 14 = ₹1,02,667. Added to the ₹40,000 you already have, that is ₹1,42,667, which is ₹37,333 short of ₹1,80,000. That number, more than the monthly gap, tells you what is at stake.
| Measure | Working | Result |
|---|---|---|
| Remaining to save | ₹1,80,000 − ₹40,000 | ₹1,40,000 |
| Required per month | ₹1,40,000 ÷ 14 | ₹10,000 |
| Actual per month (3-month average) | (₹7,000 + ₹8,500 + ₹6,500) ÷ 3 | about ₹7,333 |
| Monthly gap | ₹10,000 − ₹7,333 | about ₹2,667 |
| Projected total at current pace | ₹40,000 + ₹7,333 × 14 | about ₹1,42,667 |
| Projected shortfall | ₹1,80,000 − ₹1,42,667 | about ₹37,333 |
What can you change to close the gap?
You have three levers, and you can mix them.
- Raise the contribution: find ₹2,667 a month from somewhere. Your own spending records show which category has slack.
- Move the date: at ₹7,333 a month, ₹1,40,000 takes about 19.1 months, so 20 months. That adds six months to the original 14. Spread over 20 months the requirement falls to ₹7,000 a month, which is below your current pace.
- Reduce the target: at the current pace the goal would reach about ₹1,42,000, so a smaller version of the goal might be enough.
None of these is a failure. What matters is choosing one on purpose, instead of reaching month 14 and finding the money is not there.
How do you do this in a spreadsheet?
With the target in B1, saved so far in B2 and months left in B3, the required amount is =(B1-B2)/B3. If your last three contributions are in C2:C4, the average is =AVERAGE(C2:C4) and the gap is the required amount minus that average. These formulas work the same way in Excel and Google Sheets. To find months needed at your current pace, use =ROUNDUP((B1-B2)/AVERAGE(C2:C4), 0).
Where can records help?
Your contribution is only as accurate as your records. If your bank statements go into SpendixAI, you can see what came in and what went out each month, which makes the three-month average a matter of looking things up rather than remembering. The goal arithmetic itself stays the same either way.
Before you change the plan
- Check that the three-month average is not distorted by a one-off.
- Recalculate the required amount on the same date each month.
- Decide which lever you will pull, and write down the new number.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


