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 interest paid on a loan between a start period and and 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.