future value calculation in excel
 

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.

future value calculation in excel
 

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

Regards,

OssieMac

"reichertj" wrote:

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.

future value calculation in excel
 

No problem. Use the FV function.

--
Regards,
Fred


"reichertj" wrote in message
...
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.

future value calculation in excel
 

"reichertj" wrote apparently:
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.