XFA Specification
Chapter 23, FormCalc Specification
Financial Built-in Functions
857
CTerm()
This function returns the number of periods needed for an investment earning a fixed, but compounded,
interest rate to grow to a future value.
Syntax
CTerm(n1, n2, n3)
Parameters
n1
is the interest rate per period.
n2
is the future value of the investment.
n3
is the amount of the initial investment.
Returns
The number of periods 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
CTerm(.02, 200, 100)
returns 35
*
, which is the required period for $100 invested at 2% to grow to $200.