Difference between revisions of "Manuals/calci/cumipmt"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
<div style="font-size:30px">'''CUMIPMT(R, NPPeriods, PValue, SP, EP, Type)'''</div><br/> | <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== | ==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>, | *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. | *<math>Type</math> should be 0 or 1. | ||
Revision as of 07:03, 12 February 2014
CUMIPMT(R, NPPeriods, PValue, SP, EP, Type)
- is the interest rate.
- is the total number of payment periods.
- is the present value.
- is the first period beginning with 1.
- is the last period.
- is the timing of the payment.
is the interest rate.
is the total number of payment periods.
is the present value.
is the first period beginning with 1.
is the last period.
is the timing of the payment.Description
- 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} , , 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 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 (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 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.