Difference between revisions of "Manuals/calci/cumipmt"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''CUMIPMT'''(R, NPPeriods, PValue, SP, EP, Type) where, '''R''' - the interest rate. '''NPPeriods''' - the ...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''CUMIPMT(R, NPPeriods, PValue, SP, EP, Type)'''</div><br/> |
| + | *<math>R<math> is the interest rate. | ||
| + | *<math>NPPeriods<math> is the total number of payment periods. | ||
| + | *<math>PV<math> is the present value. | ||
| + | *<math>SP<math> is the first period beginning with 1. | ||
| + | *<math>EP<math> is the last period. | ||
| + | *<math>Type<math> 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 <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. | ||
| + | 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. | ||
| + | |||
| + | ==References== | ||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Lets see an example | Lets see an example | ||
| − | + | UNIQ8a938ab9c7940197-nowiki-00000004-QINU | |
CUMIPMT returns -5527.3132. | CUMIPMT returns -5527.3132. | ||
| Line 55: | Line 62: | ||
Consider another example | Consider another example | ||
| − | + | UNIQ8a938ab9c7940197-nowiki-00000005-QINU | |
CUMIPMT returns -3269.9831. | CUMIPMT returns -3269.9831. | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 07:01, 12 February 2014
CUMIPMT(R, NPPeriods, PValue, SP, EP, Type)
- Failed to parse (syntax error): {\displaystyle R<math> is the interest rate. *<math>NPPeriods<math> is the total number of payment periods. *<math>PV<math> is the present value. *<math>SP<math> is the first period beginning with 1. *<math>EP<math> is the last period. *<math>Type<math> 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 <math>R\le 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.
, 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.
References
Lets see an example
?UNIQ8a938ab9c7940197-nowiki-00000004-QINU?
CUMIPMT returns -5527.3132.
Consider another example
?UNIQ8a938ab9c7940197-nowiki-00000005-QINU?
CUMIPMT returns -3269.9831.