XFA Specification
Chapter 23, FormCalc Specification
Financial Built-in Functions
861
Pmt()
This function returns the payment for a loan based on constant payments and a constant interest rate.
Syntax
Pmt(n1, n2, n3)
Parameters
n1
is the principal amount of the loan.
n2
is the interest rate per period.
n3
is the number of payment periods.
Returns
The loan payment 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
Pmt(30000.00, .085 / 12, 12 * 12)
returns 333.01
*
, which is the monthly payment for a loan of a $30,000, borrowed at a yearly interest rate of
8.5%, repayable over 12 years (144 months).
Pmt(10000, .08 / 12, 10)
returns 1037.03
*
, which is the monthly payment for a loan of a $10,000 loan, borrowed at a yearly interest
rate of 8.0%, repayable over 10 months.