Thread: [Q] How to use Excel to show est. compounded value displayed by mo

"JohnH" wrote: > 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 ? Depends on what you mean. 1. You mean that you invest $100 at the beginning of the first month and $10 at the beginning of each of...

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

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...