XFA Specification
Chapter 23, FormCalc Specification
Financial Built-in Functions
858
FV()
This function returns the future value of periodic constant payments at a constant interest rate.
Syntax
FV(n1, n2, n3)
Parameters
n1
is the amount of each equal payment.
n2
is the interest rate per period.
n3
is the total number of periods.
Returns
The future value or null if any of its parameters are null.
If n1 or n3 are non-positive, or if n2 is negative, the function generates an error exception.
If n2 is 0, the function returns the product of n1 and n3, i.e., the payment amount multiplied by the
number of payments.
Examples
FV(100, .075 / 12, 10 * 12)
returns 17793.03
*
, which is the amount present after paying $100 a month for 10 years in an account
bearing an annual interest of 7.5%.
FV(1000, 0.01, 12)
returns 12682.50
*
.