Excel function for FV of daily investment at compound rates

R

rbwm

I need an Excel function to calculate Fututre Values of a constant daily
investment to which is applied compound interest rate
 
N

N Harkawat

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
 
P

P Daulton

Is the interest calculated daily too?
Is the interest rate quoted as an annual rate, daily rate?
 
Top