future value calculation in excel

R

reichertj

How do I calculate the future value of a series of annual deposits? I would
like to accomplish this with a single formula in a cell that references other
cells with the annual deposit amount, the interst rate and the number of
years.
 
O

OssieMac

There is a good description of this if you look up 'fv worksheet function'
on the Answer Wizard tab in help

Regards,

OssieMac
 
J

joeu2004

reichertj said:
How do I calculate the future value of a series of annual deposits? I would
like to accomplish this with a single formula in a cell that references other
cells with the annual deposit amount, the interst rate and the number of years

Click on Help -> Excel Help and search for the FV function. But a
concrete example might help.

If A1 is the annual deposit, A2 is the annual "interest rate", and A3
is the number of years, ostensibly you could do the following:

=fv(A2, A3, -A1, 0, 1)

That assumes that the "interest rate" is the APY, not the nominal
interest rate. If you have only nominal interest rate, the following
estimates the APY, assuming daily compounding:

fv(A2/365, 365, 0, -1) - 1

You could put that in place of "A2" in the first formula. But
arguably it is a nitpick. The difference is likely to be very small,
especially as a percentage of the total future value.
 

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

Top