CUMIPMT
Returns the cumulative interest paid on a loan between two periods
Syntax
CUMIPMT(rate, nper, pv, start_period, end_period, type)
Parameters
- rate: Required. The interest rate
- nper: Required. The total number of payment periods
- pv: Required. The present value
- start_period: Required. The first period in the calculation
- end_period: Required. The last period in the calculation
- type: Required. The timing of the payment (0=end of period, 1=beginning of period)
Example
=CUMIPMT(0.09/12, 30*12, 125000, 1, 1, 0)