Manuals/calci/cumprinc

CUMPRINC(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

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

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

Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\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

=CUMPRINC(0.03/12,B3*12,B4,13,24,0)

CUMPRINC returns -11046.6464.

Consider another example

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

CUMPRINC returns -16939.2946.

References

?UNIQ067d4adc59e17ebd-nowiki-00000004-QINU?

CUMPRINC returns -11046.6464.

Consider another example

?UNIQ067d4adc59e17ebd-nowiki-00000005-QINU?

CUMPRINC returns -16939.2946.

---

Syntax

---

Remarks

---

Examples

---

Description

---

	Column1	Column2	Column3	Column4
Row1
Row2	15	10		128
Row3	200000	200000
Row4	-11046.646138	-16939.294642	10000
Row5		183070.705358	10000	128
Row6		0.850904	1.619775	0.525322

File:Calci1.gif

---