XFA Specification
Chapter 23, FormCalc Specification
Financial Built-in Functions
865
Term()
This function returns the number of periods needed to reach a given future value from periodic constant
payments into an interest bearing account.
Syntax
Term(n1, n2, n3)
Parameters
n1
is the payment amount made at the end of each period.
n2
is the interest rate per period.
n3
is the future value.
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
Term(475, .05, 1500)
returns 3
*
which is the number of periods for an investment of $475, deposited at the end of each period
into an account bearing 5% compound interest, to grow to $1500.00.