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
Is the interest calculated daily too?
Is the interest rate quoted as an annual rate, daily rate?
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
