# Manuals/calci/cumipmt

CUMIPMT(R,PP,PV,SP,EP,Type)

• is the interest rate.
• is the total number of payment periods.
•  is the present value.
•  is the Start period beginning with 1.
•  is the End 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
1. Interest Rate
2. Payment Periods
3. Present Value
4. Start Period$\displaystyle (SP)\lt 1$

5. End Period$\displaystyle (EP)\lt 1$

6. $\displaystyle SP \gt EP$


• 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,12*12,12000,13,24,0)

-322.8066039


=CUMIPMT(0.02/12,10*12,200000,10,20,1)

-3269.9831.


CUMIPMT