Difference between revisions of "Manuals/calci/cumprinc"

From ZCubes Wiki
Jump to navigation Jump to search
 
(7 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
<div style="font-size:30px">'''CUMPRINC(R, NPPeriods, PValue, SP, EP, Type)'''</div><br/>
+
<div style="font-size:30px">'''CUMPRINC(R,PP,PV,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>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 the first period beginning with 1.
+
*<math>SP</math> is the Start period beginning with 1.
−
*<math>EP</math> is the last period.
+
*<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
−
  <math>R\le 0</math>
+
  1. Interest Rate<math>(R)\le 0</math>
−
  <math>NPPeriods\le 0</math>
+
  2. Payment Periods <math>(PP)\le 0</math>
−
  <math>PresentValue\le 0</math>
+
  3. Present Value<math>(PV)\le 0</math>
−
  <math>P\lt 1</math>
+
  4. Start Period<math>(SP)\lt 1</math>
−
  <math>EP\lt 1</math>
+
  5. End Period<math>(EP)\lt 1</math>
−
  <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'''
 
  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==
−
=CUMPRINC(0.03/12,B3*12,B4,13,24,0)
+
=CUMPRINC(0.03/12,12*12,12000,13,24,0)
−
 
+
-869.2062289
−
CUMPRINC returns -11046.6464.
+
=CUMPRINC(0.02/12,10*12,200000,10,20,1)
 +
-16939.2946.
  
−
Consider another example
+
==Related Videos==
  
−
=CUMPRINC(0.02/12,10*12,200000,10,20,1)
+
{{#ev:youtube|1jQp96xzkhY|280|center|CUMPRINC}}
  
−
CUMPRINC returns -16939.2946.
+
==See Also==
 +
*[[Manuals/calci/cumipmt | CUMIPMT]]
 +
*[[Manuals/calci/couppcd | COUPPCD]]
 +
*[[Manuals/calci/coupncd | COUPNCD]]
  
 
==References==
 
==References==
−
 
+
[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_CUMPRINC_function CUMPRINC]
−
 
 
−
 
 
−
 
 
−
 
 
−
 
 
−
 
 
−
 
 
−
 
 
−
 
 
−
UNIQ067d4adc59e17ebd-nowiki-00000004-QINU
 
−
 
 
−
CUMPRINC returns -11046.6464.
 
−
 
 
−
Consider another example
 
−
 
 
−
UNIQ067d4adc59e17ebd-nowiki-00000005-QINU
 
−
 
 
−
CUMPRINC returns -16939.2946.
 
−
 
 
−
</div>
 
−
----
 
−
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
 
−
----
 
−
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
 
−
----
 
−
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
 
−
----
 
−
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
 
−
----
 
−
<div id="5SpaceContent" class="zcontent" align="left">
 
−
 
 
−
{| id="TABLE1" class="SpreadSheet blue"
 
−
|- class="even"
 
−
| class=" SelectTD" |
 
−
<div id="5Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="5Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
 
−
| Column1
 
−
| class="  " | Column2
 
−
| class="  " | Column3
 
−
| class=" " | Column4
 
−
|- class="odd"
 
−
| class=" " | Row1
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="      " |
 
−
| class="sshl_f  " |
 
−
|- class="even"
 
−
| class="  " | Row2
 
−
| class="  " | 15
 
−
| class="        " | 10
 
−
| class="    " |
 
−
| class="sshl_f" | 128
 
−
|- class="odd"
 
−
| Row3
 
−
| class="  " | 200000
 
−
| class="sshl_f" | 200000
 
−
| class="    " |
 
−
| class="sshl_f        " |
 
−
|- class="even"
 
−
| Row4
 
−
| class="sshl_f" | -11046.646138
 
−
| class="sshl_f" | -16939.294642
 
−
| class="sshl_f" | 10000
 
−
| class="      " |
 
−
|- class="odd"
 
−
| class=" " | Row5
 
−
| class="sshl_f  " |
 
−
<div id="5Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
 
−
| 183070.705358
 
−
| 10000
 
−
| 128
 
−
|- class="even"
 
−
| Row6
 
−
| class="sshl_f" |
 
−
| 0.850904
 
−
| 1.619775
 
−
| 0.525322
 
−
|}
 
−
 
 
−
<div align="left">[[Image:calci1.gif]]</div></div>
 
−
----
 

Latest revision as of 13:03, 19 July 2015

CUMPRINC(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

=CUMPRINC(0.03/12,12*12,12000,13,24,0) 

-869.2062289

=CUMPRINC(0.02/12,10*12,200000,10,20,1) 

-16939.2946.

Related Videos

CUMPRINC

See Also

References

CUMPRINC

Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/cumprinc&oldid=202128"