savings planner

[chrisscott]

lets say i need to save £1500 from now over the next 1
months.
i want a tempate that when i add the ammount i save each week whic
will vary it will update how much i have saved and how much i stil
need to put away.
the chart might if possible also be able to tell me what i need to sav
on average to get to my target
a long shot i know but someone must be able to help me out
many thanks
chri

 

[JE McGimpsey]

One way:

A1: 1500 <-- target
A2: 43 <-- # of weeks, total

A3: first week's savings
B3: =IF(A3,A$1-SUM(A$3:A3),"") <-- Remaining balance
C3: =IF(A3,B3/(45-ROW())) <-- Avg for remaining weeks

Copy B3:C3 down to B44:C44. Enter subsequent week's savings into A4:A45.