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 |
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 |
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 |
All times are GMT +1. The time now is 01:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com