compound interest
 

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 !

David wrote:
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.

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".

try this (If I remeber my arithmetic correct- a few decades back)

A=P(1+R/100)^n

P is the principal
R is the annual interest rate (10 if it is 10%)
n is no. of years.
A return value

check with any elementary arithmetic book


wrote in message
ups.com...
David wrote:
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.

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".