To estimate when you will reach a savings goal, divide the amount still to save by your average monthly contribution, round up to whole months, and count forward from today. If ₹2,05,000 remains and you put in ₹10,000 a month on average, you need 20.5 months, so 21. That date is a projection, not a promise, but it tells you whether your target date is realistic.
How do you work out months to go?
Take a hypothetical goal: a ₹3,00,000 down payment for a vehicle, with ₹95,000 saved. The remaining amount is ₹3,00,000 − ₹95,000 = ₹2,05,000. Over the last four months you put in ₹12,000, ₹9,000, ₹11,000 and ₹8,000, which is ₹40,000 in total, or ₹10,000 a month on average. Months to go = ₹2,05,000 ÷ ₹10,000 = 20.5, which you round up to 21 because a part-month still needs a payment.
How do you turn that into a date?
Say you have just closed October 2026 and your next contribution is in November 2026. Count November as month 1. Month 12 is October 2027, month 13 is November 2027, and month 21 is July 2028. So your projected completion is July 2028.
In a spreadsheet, put the remaining amount in B1, the average contribution in B2 and the date of your next contribution in B3. Months needed: =ROUNDUP(B1/B2, 0). Completion date: =EDATE(B3, ROUNDUP(B1/B2, 0)-1). EDATE works in both Excel and Google Sheets; in Excel you may need to format the result cell as a date.
How does the projection compare with your target date?
Say you wanted the money by March 2028, which is month 17. At ₹10,000 a month you will be about four months late. To reach it in 17 months you would need ₹2,05,000 ÷ 17 = ₹12,059 a month (rounded up), which is ₹2,059 more than you are putting in now.
It helps to see how sensitive the date is to the monthly amount.
| Monthly contribution | Working | Months needed | Finish (starting November 2026) |
|---|---|---|---|
| ₹8,000 | ₹2,05,000 ÷ 8,000 = 25.6 | 26 | December 2028 |
| ₹10,000 | ₹2,05,000 ÷ 10,000 = 20.5 | 21 | July 2028 |
| ₹12,000 | ₹2,05,000 ÷ 12,000 = 17.1 | 18 | April 2028 |
| ₹15,000 | ₹2,05,000 ÷ 15,000 = 13.7 | 14 | December 2027 |
Raising the amount from ₹10,000 to ₹12,000 cuts three months. Going from ₹10,000 down to ₹8,000 adds five. The date moves more when you slip than when you stretch, which is a good reason to keep the monthly amount from sliding.
Which average should you use?
- Three to six months is a sensible window. One month is too noisy; two years is out of date.
- Include months where you put in nothing. Leaving them out flatters the projection.
- If a bonus or gift made one month unusually high, treat it as a one-off and consider using a typical month instead.
- If your income is about to change, use the new figure and say so in your notes.
What should you change if the date is too late?
- Check whether the target is firm. Part of it might be optional, such as accessories or extras.
- Find a recurring cost you could trim. Your last few months of categories will show where.
- Move the target date if nothing else works, and tell whoever else depends on it.
- Recalculate in a month. The projection should be a running number, not a one-time exercise.
A note on records
The projection is only as good as your contribution history. If you import statements into SpendixAI, the months where money went to the goal account can be looked up rather than recalled. Its savings goals feature on Pro is a place to keep the goal, but the arithmetic above is useful either way.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


