Difference between revisions of "Documentation/How Tos/Calc: CUMPRINC function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m |
Javier Lopez (talk | contribs) |
||
Line 1: | Line 1: | ||
− | + | {{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 == |
Revision as of 23:43, 31 May 2013
CALC FUNCTIONS
Depreciation
* Amordegrc*
Amorlinc*
Db*
Ddb*
Sln *
Syd*
Vdb
Payment Streams, Annuities, Loans
* Cumipmt*
< {{#switch:Previous Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} | {{#switch:Next Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} > |
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.