Function group | Execute on client | Platform(s) |
---|---|---|
Financial | NO | All |
cmp(rate,periods)
Returns the compound interest multiplier for a given interest rate over a given number of periods.
That is, cmp() evaluates the expression (1+(rate/100))periods; the interest rate is given by the argument rate/100.
Calculate lAmount as cmp(10,10) ## = (1+(10/100))10
# returns 2.59 (to 2 decimal places)
Calculate lAmount as cmp(15,25) ## = (1+(15/100))25
# returns 32.92 (to 2 decimal places)
Calculate lAmount as cmp(5,0.5) ## = (1+(5/100))0.5
# returns 1.02 (to 2 decimal places)