Difference between revisions of "Documentation/How Tos/Calc: CUMPRINC function"

From Apache OpenOffice Wiki
Jump to: navigation, search
(Issues:)
(7 intermediate revisions by 3 users not shown)
Line 1: Line 1:
__NOTOC__
+
{{Documentation/MasterTOC
 +
|bookid=1234'''
 +
|booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div>
 +
|ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Financial_functions|<div style="font-size: 140%;">Financial Functions]]
 +
|ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_CUMPRINC_ADD_function
 +
|ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_CUMIPMT_ADD_function
 +
|ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc:_Date_%26_Time_functions
 +
|ShowNextPart=block|NextPart=Documentation/How_Tos/Calc:_Information_functions
 +
|toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div>
 +
 
 +
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Depreciation</div>
 +
* [[Documentation/How_Tos/Calc:_AMORDEGRC_function|<div style="font-size: 120%;">Amordegrc]]
 +
* [[Documentation/How_Tos/Calc:_AMORLINC_function|<div style="font-size: 120%;">Amorlinc]]
 +
* [[Documentation/How_Tos/Calc:_DB_function|<div style="font-size: 120%;">Db]]
 +
* [[Documentation/How_Tos/Calc:_DDB_function|<div style="font-size: 120%;">Ddb]]
 +
* [[Documentation/How_Tos/Calc:_SLN_function|<div style="font-size: 120%;">Sln]]
 +
* [[Documentation/How_Tos/Calc:_SYD_function|<div style="font-size: 120%;">Syd]]
 +
* [[Documentation/How_Tos/Calc:_VDB_function|<div style="font-size: 120%;">Vdb]]
 +
 
 +
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Payment Streams, Annuities, Loans</div>
 +
* [[Documentation/How_Tos/Calc:_CUMIPMT_function|<div style="font-size: 120%;">Cumipmt]]
 +
* [[Documentation/How_Tos/Calc:_CUMIPMT_ADD_function|<div style="font-size: 120%;">Cumipmt Add]]
 +
* [[Documentation/How_Tos/Calc:_CUMPRINC_function|<div style="font-size: 120%; border-style: double; border-color:#778899;">Cumprinc]]
 +
* [[Documentation/How_Tos/Calc:_CUMPRINC_ADD_function|<div style="font-size: 120%;">Cumpinc Add]]
 +
* [[Documentation/How_Tos/Calc:_FV_function|<div style="font-size: 120%;">Fv]]
 +
* [[Documentation/How_Tos/Calc:_FVSCHEDULE_function|<div style="font-size: 120%;">Fvschedule]]
 +
* [[Documentation/How_Tos/Calc:_IPMT_function|<div style="font-size: 120%;">Ipmt]]
 +
* [[Documentation/How_Tos/Calc:_IRR_function|<div style="font-size: 120%;">Irr]]
 +
* [[Documentation/How_Tos/Calc:_ISPMT_function|<div style="font-size: 120%;">Ispmt]]
 +
* [[Documentation/How_Tos/Calc:_MIRR_function|<div style="font-size: 120%;">Mirr]]
 +
* [[Documentation/How_Tos/Calc:_NPER_function|<div style="font-size: 120%;">Nper]]
 +
* [[Documentation/How_Tos/Calc:_NPV_function|<div style="font-size: 120%;">Npv]]
 +
* [[Documentation/How_Tos/Calc:_PMT_function|<div style="font-size: 120%;">Pmt]]
 +
* [[Documentation/How_Tos/Calc:_PPMT_function|<div style="font-size: 120%;">Ppmt]]
 +
* [[Documentation/How_Tos/Calc:_PV_function|<div style="font-size: 120%;">Pv]]
 +
* [[Documentation/How_Tos/Calc:_RATE_function|<div style="font-size: 120%;">Rate]]
 +
* [[Documentation/How_Tos/Calc:_RRI_function|<div style="font-size: 120%;">Rri]]
 +
* [[Documentation/How_Tos/Calc:_XIRR_function|<div style="font-size: 120%;">Xirr]]
 +
* [[Documentation/How_Tos/Calc:_XNPV_function|<div style="font-size: 120%;">Xnpv]]
 +
 
 +
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Securities</div>
 +
* [[Documentation/How_Tos/Calc:_ACCRINT_function|<div style="font-size: 120%;">Accrint]]
 +
* [[Documentation/How_Tos/Calc:_ACCRINTM_function|<div style="font-size: 120%;">Accrintm]]
 +
* [[Documentation/How_Tos/Calc:_DISC_function|<div style="font-size: 120%;">Disc]]
 +
* [[Documentation/How_Tos/Calc:_DURATION_function|<div style="font-size: 120%;">Duration]]
 +
* [[Documentation/How_Tos/Calc:_DURATION_ADD_function|<div style="font-size: 120%;">Duration Add]]
 +
* [[Documentation/How_Tos/Calc:_EFFECTIVE_function|<div style="font-size: 120%;">Effective]]
 +
* [[Documentation/How_Tos/Calc:_EFFECT_ADD_function|<div style="font-size: 120%;">Effect Add]]
 +
* [[Documentation/How_Tos/Calc:_INTRATE_function|<div style="font-size: 120%;">Intrate]]
 +
* [[Documentation/How_Tos/Calc:_MDURATION_function|<div style="font-size: 120%;">Mduration]]
 +
* [[Documentation/How_Tos/Calc:_DURATION_ADD_function|<div style="font-size: 120%;">Duration Add]]
 +
* [[Documentation/How_Tos/Calc:_NOMINAL_function|<div style="font-size: 120%;">Nominal]]
 +
* [[Documentation/How_Tos/Calc:_NOMINAL_ADD_function|<div style="font-size: 120%;">Nominal Add]]
 +
* [[Documentation/How_Tos/Calc:_ODDFPRICE_function|<div style="font-size: 120%;">Oddfprice]]
 +
* [[Documentation/How_Tos/Calc:_ODDFYIELD_function|<div style="font-size: 120%;">Oddfyield]]
 +
 
 +
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Coupons</div>
 +
* [[Documentation/How_Tos/Calc:_COUPDAYBS_function|<div style="font-size: 120%;">Coupdaybs]]
 +
* [[Documentation/How_Tos/Calc:_COUPDAYS_function|<div style="font-size: 120%;">Coupdays]]
 +
* [[Documentation/How_Tos/Calc:_COUPDAYSNC_function|<div style="font-size: 120%;">Coupdaysnc]]
 +
* [[Documentation/How_Tos/Calc:_COUPNCD_function|<div style="font-size: 120%;">Coupncd]]
 +
* [[Documentation/How_Tos/Calc:_COUPNUM_function|<div style="font-size: 120%;">Coupnum]]
 +
* [[Documentation/How_Tos/Calc:_COUPPCD_function|<div style="font-size: 120%;">Couppcd]]
 +
 
 +
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Miscellaneous</div>
 +
 
 +
* [[Documentation/How_Tos/Calc:_DOLLARDE_function|<div style="font-size: 120%;">Coupdaybs]]
 +
* [[Documentation/How_Tos/Calc:_DOLLARFR_function|<div style="font-size: 120%;">Coupdays]]
 +
}}__TOC__
  
 
== CUMPRINC ==
 
== CUMPRINC ==
Line 26: Line 94:
 
:  returns <tt>'''-603.63'''</tt> in currency units. You took out a 2 year loan of 5000 currency units at a yearly interest rate of 5.5%, making monthly payments at the end of the month. The capital you repaid in the 4th-6th months inclusive is 603.63 currency units. It is given as negative because you pay it.
 
:  returns <tt>'''-603.63'''</tt> in currency units. You took out a 2 year loan of 5000 currency units at a yearly interest rate of 5.5%, making monthly payments at the end of the month. The capital you repaid in the 4th-6th months inclusive is 603.63 currency units. It is given as negative because you pay it.
  
{{Documentation/SeeAlso|
+
=== Issues: ===
* [[Documentation/How_Tos/Calc: CUMPRINC_ADD function|CUMPRINC_ADD]],
+
* '''CUMPRINC''' formats the result as currency if the cell has default formatting. It thus displays a real currency amount. The [[Documentation/How_Tos/Calc: CUMPRINC_ADD function|CUMPRINC_ADD]] function is compatible with Excel; it does not apply formatting and can thus show fractional currency amounts, for example 57.5412415... The amount returned by '''CUMPRINC''' may still be fractional - the display rounds this to the nearest real currency. Note that your loan provider might round in a different way (for example always downwards).
* [[Documentation/How_Tos/Calc: CUMIPMT function|CUMIPMT]],
+
* According to the forthcoming ODFF standard, this function is to be removed, and [[Documentation/How_Tos/Calc: CUMPRINC_ADD function|CUMPRINC_ADD]] is to be renamed '''CUMPRINC'''.
* [[Documentation/How_Tos/Calc: CUMIPMT_ADD function|CUMIPMT_ADD]],
+
* In contrast to '''PMT''', '''IMPT''', '''PPMT''', this function has no <tt>'''futurevalue'''</tt> parameter.
* [[Documentation/How_Tos/Calc: IPMT function|IPMT]],
+
 
* [[Documentation/How_Tos/Calc: PMT function|PMT]],
+
 
* [[Documentation/How_Tos/Calc: PPMT function|PPMT]],
+
{{SeeAlso|EN|
 +
* [[Documentation/How_Tos/Calc: CUMPRINC_ADD function|CUMPRINC_ADD]]
 +
* [[Documentation/How_Tos/Calc: CUMIPMT function|CUMIPMT]]
 +
* [[Documentation/How_Tos/Calc: CUMIPMT_ADD function|CUMIPMT_ADD]]
 +
* [[Documentation/How_Tos/Calc: IPMT function|IPMT]]
 +
* [[Documentation/How_Tos/Calc: PMT function|PMT]]
 +
* [[Documentation/How_Tos/Calc: PPMT function|PPMT]]
  
 
* [[Documentation/How_Tos/Calc: Financial functions|Financial functions]]
 
* [[Documentation/How_Tos/Calc: Financial functions|Financial functions]]
Line 38: Line 112:
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 
+
[[Category: Documentation/Reference/Calc/Financial functions]]
=== Issues: ===
+
* '''CUMPRINC''' formats the result as currency if the cell has default formatting. It thus displays a real currency amount. The [[Documentation/How_Tos/Calc: CUMPRINC_ADD function|CUMPRINC_ADD]] function is compatible with Excel; it does not apply formatting and can thus show fractional currency amounts, for example 57.5412415... The amount returned by '''CUMPRINC''' may still be fractional - the display rounds this to the nearest real currency. Note that your loan provider might round in a different way (for example always downwards).
+
* According to the forthcoming ODFF standard, this function is to be removed, and [[Documentation/How_Tos/Calc: CUMPRINC_ADD function|CUMPRINC_ADD]] is to be renamed '''CUMPRINC'''.
+
* In contrast to '''PMT''', '''IMPT''', '''PPMT''', this function has no <tt>'''futurevalue'''</tt> parameter.
+

Revision as of 09:35, 17 July 2018


CUMPRINC

Returns the total capital repaid on a loan in specified periodic payments.

Syntax:

CUMPRINC(rate; numperiods; presentvalue; start; end; type)

rate: the interest rate per period.
numperiods: the total number of payment periods in the term.
presentvalue: the initial sum borrowed.
start: the first period to include. Periods are numbered beginning with 1.
end: the last period to include.
type: when payments are made:
0 - at the end of each period.
1 - at the start of each period (including a payment at the start of the term).


With a fixed rate loan, where you make a constant payment each period to pay off the loan over the term, some of each period payment is interest on the outstanding capital, and some is a repayment of capital. Over time (as you pay off capital), the interest becomes less and the capital repayment becomes more.
IPMT returns the interest in the payment of a specified period. PPMT returns the capital repaid in the payment of that period. Together they add up to the actual payment, given by PMT.
CUMPRINC returns the total capital repaid in payments during the periods start to end inclusive - that is, the sum of PPMT over that time.

Example:

CUMPRINC(5.5%/12; 12*2; 5000; 4; 6; 0)

returns -603.63 in currency units. You took out a 2 year loan of 5000 currency units at a yearly interest rate of 5.5%, making monthly payments at the end of the month. The capital you repaid in the 4th-6th months inclusive is 603.63 currency units. It is given as negative because you pay it.

Issues:

  • CUMPRINC formats the result as currency if the cell has default formatting. It thus displays a real currency amount. The CUMPRINC_ADD function is compatible with Excel; it does not apply formatting and can thus show fractional currency amounts, for example 57.5412415... The amount returned by CUMPRINC may still be fractional - the display rounds this to the nearest real currency. Note that your loan provider might round in a different way (for example always downwards).
  • According to the forthcoming ODFF standard, this function is to be removed, and CUMPRINC_ADD is to be renamed CUMPRINC.
  • In contrast to PMT, IMPT, PPMT, this function has no futurevalue parameter.




See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_CUMPRINC_function&oldid=243606"
Views
Personal tools
Navigation
Tools