The interest rate.
The total number of payment periods.
The present value.
The first period in the calculation. Payment periods are numbered beginning with 1.
The last period in the calculation.
The timing of the payment. 0 (zero) = payment at the
end of the period. 1 = payment at the beginning of the period.
The cumulative interest paid
Calculates the cumulative principal paid on a loan between a start period and an end period.
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.rate<=0,nper<=0, orpv<=0, this function throws a RangeError.startPeriod<1,endPeriod<1, orstartPeriod>endPeriod, this function throws a RangeError.