You set up a table.
A2 is a period or date, say, 2009-12-01
B2 is the opening balance, $100
C2 is your payment, $10
D2 is the interest earned for the period, $0
E2 is the closing balance, B2+C2+D2
A3 =date(year(a2),month(a2)+1,day(a2)
B3 =E2
C3 =C2
D3 =E2*2%/12
E3 =B3+C3+D3
Copy row 3 down as far as necessary.
Regards,
Fred
"JohnH" wrote in message
...
I have two years to save
I have a starting value, say $100
I have an intrest rate, say 2%
I want to add $10 a month
[Q] How can I use Excel to show my total compounded balance 'each month'
forecast over the two years ?
pmail also please to
Thanks, J