Create an annuity in Excel having monthly deposits plus interest
 

I need to create an annuity which has an initial value plus constant deposits
made monthly over the period.

Create an annuity in Excel having monthly deposits plus interest
 

See help on the FV function. When you enter teh interest rate, make sure that you divide the annual
rate by 12 to get the monthly rate:

=FV(8%/12,60,-100, -5000)

will return the value of an annuity that is intially worth $5,000, you deposit $100 each month for
five years, get an 8% APR.

HTH,
Bernie
MS Excel MVP


"gas" wrote in message
...
I need to create an annuity which has an initial value plus constant deposits
made monthly over the period.