Difference between revisions of "Manuals/calci/cumipmt"

Revision as of 07:03, 12 February 2014

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

This function gives the cumulative interest paid on a loan between Failed to parse (syntax error): {\displaystyle SP<math> and <math>EP<math>. *CUMIPMT shows the ERROR value when <math>R\le 0} , $NPPeriods\leq =0$ , 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

=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.

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''CUMIPMT(R, NPPeriods, PValue, SP, EP, Type)'''</div><br/>
-*<math>R<math> is the interest rate.
+*<math>R</math> is the interest rate.
-*<math>NPPeriods<math> is the total number of payment periods.
+*<math>NPPeriods</math> is the total number of payment periods.
-*<math>PV<math> is the present value.
+*<math>PV</math> is the present value.
-*<math>SP<math> is the first period beginning with 1.
+*<math>SP</math> is the first period beginning with 1.
-*<math>EP<math> is the last period.
+*<math>EP</math> is the last period.
-*<math>Type<math> is the timing of the payment.
+*<math>Type</math> is the timing of the payment.
 ==Description==
-*This function gives the cumulative interest paid on a loan between SP and EP.
+*This function gives the cumulative interest paid on a loan between <math>SP<math> and <math>EP<math>.
 *CUMIPMT shows the ERROR value when <math>R\le 0</math>, <math>NPPeriods\le=0</math>, <math>PresentValue\le 0<math>, or <math>P\lt 1<math>, <math>EP\lt 1<math>, <math>SP \gt EP<math>,
 *<math>Type</math> should be 0 or 1.