The interest rate per period.
Specifies the period and must be in the range 1 to
nper.
The total number of payment periods in an annuity.
The present value — the total amount that a series of future payments is worth now.
OptionalfutureValue: 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 payment on the principal for the specified period.
Calculates the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate.
Remarks:
rateandnper. If you make monthly payments on a four-year loan at 12 percent annual interest, use0.12 / 12forrateand4 * 12fornper. If you make annual payments on the same loan, use0.12forrateand4fornper.