XFA Specification
Chapter 23, FormCalc Specification
Financial Built-in Functions
864
Rate()
This function returns the compound interest rate per period required for an investment to grow from
present to future value in a given period.
Syntax
Rate(n1, n2, n3)
Parameters
n1
is the future value.
n2
is the present value.
n3
is the total number of periods.
Returns
The compound rate or null if any of its parameters are null.
If any of n1, n2 , or n3 are non-positive, the function generates an error exception.
Examples
Rate(110, 100, 1)
returns 0.10 which is what the rate of interest must be for and investment of $100 to grow to $110 if
invested for 1 term.