The interest rate for the loan.
The total number of payments for the loan.
The present value, or the total amount that a series of future payments is worth now; also known as the principal.
Optionalfv: number = 0The future value, or a cash balance you want to
attain after the last payment is made. If fv is omitted, it is assumed to
be 0 (zero), that is, the future value of a loan is 0.
Optionaltype: 0 | 1 = 0The number 0 (zero) or 1 and indicates when
payments are due. Set type equal to 0 or omitted if payments are due at
the end of the period. Set type equal to 1 if payments are due at the
beginning of the period.
The periodic payment amount.
Calculates the payment for a loan based on constant payments and a constant interest rate.
Remarks:
rateandnper. If you make monthly payments on a four-year loan at an annual interest rate of 12 percent, use0.12 / 12forrateand4 * 12fornper. If you make annual payments on the same loan, use0.12forrateand4fornper.