"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 the remaining 23 months.

Total at the end of 24 months:
=FV(2%/12,23,-10,-100*(1+2%/12),1)

A1: =100*(1+2%/12)
A2: =(A1+10)*(1+2%/12)

Copy A2 down through A24.


2. You mean that you invest $100 at the beginning of the first month, and
you add $10 at the end of each of 24 months including the first one. Thus,
you do not earn interest on the last $10 deposit.

Total at the end of 24 months:
=FV(2%/12,2*12,-10,-100)

A1: =100*(1+2%/12)+10
A2: =A1*(1+2%/12)+10

Copy A2 down through A24.


3. You mean that you invest $100 at the beginning of the first month, and
you $10 at the beginning of the each of 24 months including the first one.
Thus, you invest $110 initially(!).

Total at the end of 24 months:
=FV(2%/12,24,-10,-100,1)

A1: =110*(1+2%/12)
A2: =(A1+10)*(1+2%/12)

Copy A2 down through A24.


----- original message -----

"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 ?

pmail also please to

Thanks, J