compound interest

D

David

How can I calculate the amount I would receive in compound interest on a
fixed amount at a fixed interest rate for a fixed peirod. Should be easy !
 
J

joeu2004

David said:
How can I calculate the amount I would receive in
compound interest on a fixed amount at a fixed
interest rate for a fixed peirod.
Click to expand...

One way:

=FV(rate,nper,0,pv) - pv

where "rate" is the "fixed interest rate" per
compounding period (e.g, 2.5%/365 for daily
compounding), "nper" is the number of compounding
periods over the "fixed period" (e.g, 5*365 for
daily compounding over 5 yr), and "pv" is the
"fixed amount".
 
Top