cmp()

Function group Execute on client Platform(s)
Financial NO All

Syntax

cmp(rate,periods)

Description

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.

Example

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)