Difference between revisions of "Manuals/calci/cumipmt"
Jump to navigation
Jump to search
(11 intermediate revisions by one other user not shown) | |||
Line 1: | Line 1: | ||
− | <div style="font-size:30px">'''CUMIPMT(R, | + | <div style="font-size:30px">'''CUMIPMT(R,PP,PV,SP,EP,Type)'''</div><br/> |
*<math>R</math> is the interest rate. | *<math>R</math> is the interest rate. | ||
− | *<math> | + | *<math>PP</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 | + | *<math>SP</math> is the Start period beginning with 1. |
− | *<math>EP</math> is | + | *<math>EP</math> is the End period. |
*<math>Type</math> is the timing of the payment. | *<math>Type</math> is the timing of the payment. | ||
Line 10: | Line 10: | ||
*This function gives the cumulative interest paid on a loan between <math>SP</math> and <math>EP</math>. | *This function gives the cumulative interest paid on a loan between <math>SP</math> and <math>EP</math>. | ||
*CUMIPMT shows the ERROR value when | *CUMIPMT shows the ERROR value when | ||
− | 1.<math>R\le 0</math> | + | 1. Interest Rate<math>(R)\le 0</math> |
− | 2.<math> | + | 2. Payment Periods <math>(PP)\le 0</math> |
− | 3.<math> | + | 3. Present Value<math>(PV)\le 0</math> |
− | 4.<math> | + | 4. Start Period<math>(SP)\lt 1</math> |
− | 5.<math>EP\lt 1</math> | + | 5. End Period<math>(EP)\lt 1</math> |
− | 6.<math>SP \gt EP</math> | + | 6. <math>SP \gt EP</math> |
*<math>Type</math> should be 0 or 1. | *<math>Type</math> should be 0 or 1. | ||
'''TYPE''' '''TIMIING''' | '''TYPE''' '''TIMIING''' | ||
Line 22: | Line 22: | ||
==Examples== | ==Examples== | ||
− | =CUMIPMT(0.03/12, | + | =CUMIPMT(0.03/12,12*12,12000,13,24,0) |
+ | -322.8066039 | ||
+ | =CUMIPMT(0.02/12,10*12,200000,10,20,1) | ||
+ | -3269.9831. | ||
− | + | ==Related Videos== | |
− | + | {{#ev:youtube|1jQp96xzkhY|280|center|CUMIPMT}} | |
− | = | + | ==See Also== |
− | + | *[[Manuals/calci/cumprinc | CUMPRINC]] | |
+ | *[[Manuals/calci/couppcd | COUPPCD]] | ||
+ | *[[Manuals/calci/coupncd | COUPNCD]] | ||
==References== | ==References== | ||
+ | [https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_CUMIPMT_function CUMIPMT] |
Latest revision as of 13:02, 19 July 2015
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 PeriodFailed to parse (unknown function "\lt"): {\displaystyle (SP)\lt 1} 5. End PeriodFailed to parse (unknown function "\lt"): {\displaystyle (EP)\lt 1} 6. Failed to parse (unknown function "\gt"): {\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.