Help with formula to calculate target

[seriousdamage]

Hello All,

I am working on my budget tracker, I would like to incorporate a goals functionality,
let's say I want to buy an item that costs 1200 euros and I have 12 months to save for it,
Assuming that I start on September 1st, 2018 with my first deposit, the formula would tell me
that I need to deposit 1200/12=100, however, if I miss a month, or a month I cannot save 100
and I only save 50, I would like that the formula would be able to recalculate the amount needed
every month to meet the target.

It does not matter how many cells I need to use, for example in one I can have the 1200 target,
in another the 12 months period in another the actual, and another what I saved so far. I am flexible about that.

Thanks for your help

Regards
Nic

 

[Oaktree]

I'd set up a few columns:

1) Item cost
2) Months left
3) Cumulative Amount Paid
4) Calculation for remaining monthly payment, defined as =(Cost - cumulative amount paid)/months left

If "Months left" isn't simple, maybe use three additional columns? One for starting month, one for ending month (or duration, either way), and one for current month. "Months left" can then be =Ending Month - Current Month or similar.

 

[seriousdamage]

Thanks a lot, for the months left I have used the DATEDIF formula, with all your indications I now have what I need.
Thanks again
Regards
Nic