Difference between revisions of "Manuals/calci/cumipmt"
Jump to navigation
Jump to search
| (19 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. |
==Description== | ==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> | + | *CUMIPMT shows the ERROR value when |
| + | 1. Interest Rate<math>(R)\le 0</math> | ||
| + | 2. Payment Periods <math>(PP)\le 0</math> | ||
| + | 3. Present Value<math>(PV)\le 0</math> | ||
| + | 4. Start Period<math>(SP)\lt 1</math> | ||
| + | 5. End Period<math>(EP)\lt 1</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''' | |
| − | |||
0 Payment at the end of the period | 0 Payment at the end of the period | ||
| − | |||
1 Payment at the beginning of the period | 1 Payment at the beginning of the period | ||
| − | |||
==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] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | CUMIPMT | ||
Latest revision as of 12: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.
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 (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)\lt 1} 5. End PeriodFailed 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 (EP)\lt 1} 6. 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}
2. Payment Periods 
3. Present Value
4. Start PeriodFailed 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)\lt 1}
5. End PeriodFailed 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 (EP)\lt 1}
6. 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}
- 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.