XFA Specification
Chapter 23, FormCalc Specification
Financial Built-in Functions
856
Financial Built-in Functions
Note: the value of the results in the examples of this section have all been rounded for presentation
purposes. A number followed by an
*
indicates a rounded return value.
Apr()
This function returns the annual percentage rate for a loan.
Syntax
Apr(n1, n2, n3)
Parameters
n1
is the principal amount of the loan.
n2
is the payment on the loan.
n3
is the number of periods.
Returns
The annual percentage 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
Apr(35000, 269.50, 30 * 12)
returns 0.085
*
(8.5%) which is the annual interest rate on a loan of $35,000 being repaid at $269.50 per
month over 30 years.