Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 ! |
#2
|
|||
|
|||
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". |
#3
|
|||
|
|||
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". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Interest formula on Personal Line | Excel Discussion (Misc queries) | |||
Compound interest calculation | Excel Worksheet Functions | |||
Compound interest calculation | Excel Discussion (Misc queries) | |||
Are financial functions calculated based on compound interest? | Excel Worksheet Functions | |||
compound interest | Excel Worksheet Functions |