Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel function for FV of daily investment at compound rates
I need an Excel function to calculate Fututre Values of a constant daily
investment to which is applied compound interest rate |
#2
|
|||
|
|||
Assuming that the interest rates are constant over the period of
investment, =fv(5%/365,180,-100) where the annula rate is 5% number of days = 180 and daily investment = $100 if interest rate are also varing with time then take alook at the Product function and determine FV of each cash outflow and sum it all up to determine the FV "rbwm" wrote in message ... I need an Excel function to calculate Fututre Values of a constant daily investment to which is applied compound interest rate |
#3
|
|||
|
|||
Is the interest calculated daily too?
Is the interest rate quoted as an annual rate, daily rate? "rbwm" wrote in message ... I need an Excel function to calculate Fututre Values of a constant daily investment to which is applied compound interest rate |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Access Module coded converted to Excel Function | Excel Discussion (Misc queries) | |||
Excel function help facilities | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |