Manuals/calci/cumipmt
CUMIPMT(R, NPPeriods, PValue, SP, EP, Type)
- is the interest rate.
- is the total number of payment periods.
- is the present value.
- is the first period beginning with 1.
- is the last period.
- is the timing of the payment.
is the interest rate.
is the total number of payment periods.
is the present value.
is the first period beginning with 1.
is the last period.
is the timing of the payment.Description
- This function gives the cumulative interest paid on a loan between and .
- CUMIPMT shows the ERROR value when , , Failed to parse (syntax error): {\displaystyle PresentValue\le 0<math>, or <math>P\lt 1<math>, <math>EP\lt 1<math>, <math>SP \gt EP<math>, *<math>Type} should be 0 or 1.
, 
, Failed to parse (syntax error): {\displaystyle PresentValue\le 0<math>, or <math>P\lt 1<math>, <math>EP\lt 1<math>, <math>SP \gt EP<math>, *<math>Type}
should be 0 or 1.TYPE TIMIING 0 Payment at the end of the period 1 Payment at the beginning of the period
Examples
=CUMIPMT(0.03/12,B3*12,B4,13,24,0)
CUMIPMT returns -5527.3132.
Consider another example
=CUMIPMT(0.02/12,10*12,200000,10,20,1) CUMIPMT returns -3269.9831.