Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Future Value Calculation | Excel Discussion (Misc queries) | |||
Tricky Date calculation: How to calculate a future date | Excel Discussion (Misc queries) | |||
calculating the future value of an investment in excel | Excel Worksheet Functions | |||
How do I calculate a future date in excel? | Excel Worksheet Functions | |||
How do I calculate a future date in Excel? | Excel Worksheet Functions |