Create an annuity in Excel having monthly deposits plus interest

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to create an annuity which has an initial value plus constant deposits
made monthly over the period.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

FV annuity re: compounding 3
Annuities 3
Annuity Payments From A Present Amount 2
RMD Question 2
How can I calculate a due interest of annuities for a certain peri 4
Present Value of a Continuously Compounded Annuity Payment 5
pv of annuity 4
pmt() uses 360-Days Bases, I need 365-Days Bases 1

Back
Top