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.