Create an annuity in Excel having monthly deposits plus interest

G

gas

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

Bernie Deitrick

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
 
Top