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.