Difference between revisions of "Manuals/calci/cumprinc"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''CUMPRINC'''(R, NPPeriods, PV, SP, EP, Type) where, '''R''' - the interest rate. '''NPPeriods''' - the tot...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <<div style="font-size:30px">'''CUMPRINC(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 <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> | ||
| + | <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== | |
| + | =CUMPRINC(0.03/12,B3*12,B4,13,24,0) | ||
| − | + | CUMPRINC returns -11046.6464. | |
| − | + | Consider another example | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | =CUMPRINC(0.02/12,10*12,200000,10,20,1) | |
| − | + | CUMPRINC returns -16939.2946. | |
| − | + | ==References== | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | UNIQ067d4adc59e17ebd-nowiki-00000004-QINU | |
CUMPRINC returns -11046.6464. | CUMPRINC returns -11046.6464. | ||
| Line 55: | Line 50: | ||
Consider another example | Consider another example | ||
| − | + | UNIQ067d4adc59e17ebd-nowiki-00000005-QINU | |
CUMPRINC returns -16939.2946. | CUMPRINC returns -16939.2946. | ||
Revision as of 06:14, 12 February 2014
<
CUMPRINC(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 and .
- CUMIPMT shows the ERROR value when
Failed to parse (unknown function "\lt"): {\displaystyle P\lt 1} Failed to parse (unknown function "\lt"): {\displaystyle EP\lt 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 SP \gt EP} ,
Failed to parse (unknown function "\lt"): {\displaystyle P\lt 1}
Failed to parse (unknown function "\lt"): {\displaystyle EP\lt 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 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
=CUMPRINC(0.03/12,B3*12,B4,13,24,0)
CUMPRINC returns -11046.6464.
Consider another example
=CUMPRINC(0.02/12,10*12,200000,10,20,1)
CUMPRINC returns -16939.2946.
References
?UNIQ067d4adc59e17ebd-nowiki-00000004-QINU?
CUMPRINC returns -11046.6464.
Consider another example
?UNIQ067d4adc59e17ebd-nowiki-00000005-QINU?
CUMPRINC returns -16939.2946.
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | ||||
| Row2 | 15 | 10 | 128 | |
| Row3 | 200000 | 200000 | ||
| Row4 | -11046.646138 | -16939.294642 | 10000 | |
| Row5 | 183070.705358 | 10000 | 128 | |
| Row6 | 0.850904 | 1.619775 | 0.525322 |
