Manuals/calci/cumipmt

CUMIPMT(R, NPPeriods, PValue, SP, EP, Type)

• $R$ is the interest rate.
• $NPPeriods$ is the total number of payment periods.
• $PV$ is the present value.
• $SP$ is the first period beginning with 1.
• $EP$ is the last period.
• $Type$ is the timing of the payment.

Description

• This function gives the cumulative interest paid on a loan between $SP$ and $EP$.
• CUMIPMT shows the ERROR value when

1. $R\leq 0$
2. $NPPeriods\leq 0$
3. $PresentValue\leq 0$
4. Failed to parse (unknown function "\lt"): {\displaystyle P\lt 1}

5. Failed to parse (unknown function "\lt"): {\displaystyle EP\lt 1}

6. Failed to parse (unknown function "\gt"): {\displaystyle SP \gt EP}
,

• $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.