Difference between revisions of "Template:Documentation/CalcFunc FinancialTOC"

From Apache OpenOffice Wiki
Jump to: navigation, search
(Created page with "{{Documentation/MasterTOC |bookid=CalcFunctions |booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">Documentation/Reference/...")
 
m
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
{{Documentation/MasterTOC
 
{{Documentation/MasterTOC
 +
|ShowPrevPage={{{ShowPrevPage}}}
 +
|PrevPage={{{PrevPage}}}
 +
|ShowNextPage={{{ShowNextPage}}}
 +
|NextPage={{{NextPage}}}
 
|bookid=CalcFunctions
 
|bookid=CalcFunctions
 
|booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">[[Documentation/Reference/Calc_functions|CALC FUNCTIONS]]</div>
 
|booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">[[Documentation/Reference/Calc_functions|CALC FUNCTIONS]]</div>
Line 13: Line 17:
 
|toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div>
 
|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>
+
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#0E85CD;">Depreciation</div>
−
* [[Documentation/How_Tos/Calc:_AMORDEGRC_function|<div style="font-size: 120%;">Amordegrc]]
+
* [[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:_AMORLINC_function|<div style="font-size: 120%;">AMORLINC]]
−
* [[Documentation/How_Tos/Calc:_DB_function|<div style="font-size: 120%;">Db]]
+
* [[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:_DDB_function|<div style="font-size: 120%;">DDB]]
−
* [[Documentation/How_Tos/Calc:_SLN_function|<div style="font-size: 120%;">Sln]]  
+
* [[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:_SYD_function|<div style="font-size: 120%;">SYD]]
−
* [[Documentation/How_Tos/Calc:_VDB_function|<div style="font-size: 120%;">Vdb]]
+
* [[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>
+
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#0E85CD;">Payment Streams, Annuities, Loans</div>
−
* [[Documentation/How_Tos/Calc:_CUMIPMT_function|<div style="font-size: 120%;">Cumipmt]]
+
* [[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:_CUMIPMT_ADD_function|<div style="font-size: 120%;">CUMIPMT_ADD]]
−
* [[Documentation/How_Tos/Calc:_CUMPRINC_function|<div style="font-size: 120%;">Cumprinc]]
+
* [[Documentation/How_Tos/Calc:_CUMPRINC_function|<div style="font-size: 120%;">CUMPRINC]]
−
* [[Documentation/How_Tos/Calc:_CUMPRINC_ADD_function|<div style="font-size: 120%;">Cumpinc Add]]
+
* [[Documentation/How_Tos/Calc:_CUMPRINC_ADD_function|<div style="font-size: 120%;">CUMPRINC ADD]]
−
* [[Documentation/How_Tos/Calc:_FV_function|<div style="font-size: 120%;">Fv]]  
+
* [[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:_FVSCHEDULE_function|<div style="font-size: 120%;">FVSCHEDULE]]
−
* [[Documentation/How_Tos/Calc:_IPMT_function|<div style="font-size: 120%;">Ipmt]]
+
* [[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:_IRR_function|<div style="font-size: 120%;">IRR]]
−
* [[Documentation/How_Tos/Calc:_ISPMT_function|<div style="font-size: 120%;">Ispmt]]
+
* [[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:_MIRR_function|<div style="font-size: 120%;">MIRR]]
−
* [[Documentation/How_Tos/Calc:_NPER_function|<div style="font-size: 120%;">Nper]]
+
* [[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:_NPV_function|<div style="font-size: 120%;">NPV]]  
−
* [[Documentation/How_Tos/Calc:_PMT_function|<div style="font-size: 120%;">Pmt]]
+
* [[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:_PPMT_function|<div style="font-size: 120%;">PPMT]]
−
* [[Documentation/How_Tos/Calc:_PV_function|<div style="font-size: 120%;">Pv]]
+
* [[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:_RATE_function|<div style="font-size: 120%;">RATE]]
−
* [[Documentation/How_Tos/Calc:_RRI_function|<div style="font-size: 120%;">Rri]]
+
* [[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:_XIRR_function|<div style="font-size: 120%;">XIRR]]
−
* [[Documentation/How_Tos/Calc:_XNPV_function|<div style="font-size: 120%;">Xnpv]]  
+
* [[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>
+
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#0E85CD;">Securities</div>
−
* [[Documentation/How_Tos/Calc:_ACCRINT_function|<div style="font-size: 120%;">Accrint]]
+
* [[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:_ACCRINTM_function|<div style="font-size: 120%;">ACCRINTM]]
−
* [[Documentation/How_Tos/Calc:_DISC_function|<div style="font-size: 120%;">Disc]]
+
* [[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_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:_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:_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:_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:_INTRATE_function|<div style="font-size: 120%;">INTRATE]]
−
* [[Documentation/How_Tos/Calc:_MDURATION_function|<div style="font-size: 120%;">Mduration]]
+
* [[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_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:_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:_ODDFPRICE_function|<div style="font-size: 120%;">Oddfprice]]
+
* [[Documentation/How_Tos/Calc:_ODDFYIELD_function|<div style="font-size: 120%;">ODDFYIELD]]
−
* [[Documentation/How_Tos/Calc:_ODDFYIELD_function|<div style="font-size: 120%;">Oddfyield]]
+
* [[Documentation/How_Tos/Calc:_ODDLPRICE_function|<div style="font-size: 120%;">ODDLPRICE]]
 +
* [[Documentation/How_Tos/Calc:_ODDLYIELD_function|<div style="font-size: 120%;">ODDLYIELD]]
  
−
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Coupons</div>
+
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#0E85CD;">Coupons</div>
−
* [[Documentation/How_Tos/Calc:_COUPDAYBS_function|<div style="font-size: 120%;">Coupdaybs]]
+
* [[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:_COUPDAYS_function|<div style="font-size: 120%;">COUPDAYS]]
−
* [[Documentation/How_Tos/Calc:_COUPDAYSNC_function|<div style="font-size: 120%;">Coupdaysnc]]
+
* [[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:_COUPNCD_function|<div style="font-size: 120%;">COUPNCD]]
−
* [[Documentation/How_Tos/Calc:_COUPNUM_function|<div style="font-size: 120%;">Coupnum]]
+
* [[Documentation/How_Tos/Calc:_COUPNUM_function|<div style="font-size: 120%;">COUPNUM]]
−
* [[Documentation/How_Tos/Calc:_COUPPCD_function|<div style="font-size: 120%;">Couppcd]]
+
* [[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>
+
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#0E85CD;">Miscellaneous</div>
−
* [[Documentation/How_Tos/Calc:_DOLLARDE_function|<div style="font-size: 120%;">Coupdaybs]]
+
* [[Documentation/How_Tos/Calc:_DOLLARDE_function|<div style="font-size: 120%;">DOLLARDE]]
−
* [[Documentation/How_Tos/Calc:_DOLLARFR_function|<div style="font-size: 120%;">Coupdays]]
+
* [[Documentation/How_Tos/Calc:_DOLLARFR_function|<div style="font-size: 120%;">DOLLARFR]]
−
}}
+
}}__NOTOC__
−
==Financial Functions==
+
−
The Financial functions provide common business calculations.
+
−
 
+
−
{| border="0" cellpadding="0" cellspacing="10" align="left"
+
−
|-valign="top"
+
−
|colspan="2"|'''<big> Depreciation</big>'''
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: AMORDEGRC function|'''AMORDEGRC''']]
+
−
|Returns depreciation for a period using degressive depreciation (French system).
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: AMORLINC function|'''AMORLINC''']]
+
−
|Returns depreciation for a period using linear depreciation (French system).
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: DB function|'''DB''']]
+
−
|Returns the depreciation of an asset for a given year using the fixed rate declining-balance method.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: DDB function|'''DDB''']]
+
−
|Returns the depreciation of an asset for a given year using the double (or other factor) declining-balance method.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: SLN function|'''SLN''']]
+
−
|Returns the depreciation of an asset in a single period using the straight-line depreciation method.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: SYD function|'''SYD''']]
+
−
|Returns the depreciation of an asset for a given year using the sum-of-years'-digits method.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: VDB function|'''VDB''']]
+
−
|Returns the depreciation of an asset for a given year using a variable declining-balance method.
+
−
 
+
−
|-valign="top"
+
−
|colspan="2"|'''<big> Payment Streams, Annuities, Loans</big>'''
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: CUMIPMT function|'''CUMIPMT''']]
+
−
|Returns the total interest paid on a loan in specified periodic payments.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: CUMIPMT_ADD function|'''CUMIPMT_ADD''']]
+
−
|Returns the total interest paid on a loan in specified periodic payments.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: CUMPRINC function|'''CUMPRINC''']]
+
−
|Returns the total capital repaid on a loan in specified periodic payments.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: CUMPRINC_ADD function|'''CUMPRINC_ADD''']]
+
−
|Returns the total capital repaid on a loan in specified periodic payments.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: FV function|'''FV''']]
+
−
|Returns the future value of an initial sum with a subsequent stream of payments.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: FVSCHEDULE function|'''FVSCHEDULE''']]
+
−
|Returns the future value of an initial sum, with changing future interest rates.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: IPMT function|'''IPMT''']]
+
−
|Returns the portion of the periodic payment which is interest for a fixed rate loan or annuity. 
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: IRR function|'''IRR''']]
+
−
|Calculates the internal rate of return of a series of cash flows.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: ISPMT function|'''ISPMT''']]
+
−
|Returns the interest paid in a period for a fixed rate loan.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: MIRR function|'''MIRR''']]
+
−
|Returns the modified internal rate of return of a series of cash flows.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: NPER function|'''NPER''']]
+
−
|Returns the number of payment periods for an annuity.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: NPV function|'''NPV''']]
+
−
|Returns the net present value of an investment with regular cash payments.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: PMT function|'''PMT''']]
+
−
|Returns the payment per period for a fixed rate loan.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: PPMT function|'''PPMT''']]
+
−
|Returns the portion of the periodic payment which is repaid capital for a fixed rate loan or annuity.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: PV function|'''PV''']]
+
−
|Returns the present value of a stream of future payments with a final lump sum.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: RATE function|'''RATE''']]
+
−
|Calculates the interest rate for an annuity.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: RRI function|'''RRI''']]
+
−
|Returns an equivalent interest rate when an investment increases in value.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: XIRR function|'''XIRR''']]
+
−
|Calculates the internal rate of return of a series of irregular cash flows.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: XNPV function|'''XNPV''']]
+
−
|Returns the net present value of an investment with irregular cash payments.
+
−
 
+
−
|-valign="top"
+
−
|colspan="2"|'''<big> Securities</big>'''
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: ACCRINT function|'''ACCRINT''']]
+
−
|Calculates the accrued interest for a security with periodic interest payments.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: ACCRINTM function|'''ACCRINTM''']]
+
−
|Calculates the accrued interest for a security that pays at maturity.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: DISC function|'''DISC''']]
+
−
|Returns the discount rate of a security.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: DURATION function|'''DURATION''']]
+
−
|Returns the number of periods needed for an investment to reach a certain value.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: DURATION_ADD function|'''DURATION_ADD''']]
+
−
|Returns the Macaulay duration of a security.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: EFFECTIVE function|'''EFFECTIVE''']]
+
−
|Returns the effective compounded interest rate given a nominal interest rate.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: EFFECT_ADD function|'''EFFECT_ADD''']]
+
−
|Returns the effective compounded interest rate given a nominal interest rate.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: INTRATE function|'''INTRATE''']]
+
−
|Returns the equivalent annual interest rate for an investment bought at one price and sold at another.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: MDURATION function|'''MDURATION''']]
+
−
|Returns the modified Macaulay duration of a security.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: NOMINAL function|'''NOMINAL''']]
+
−
|Returns a nominal interest rate given the effective compounded interest rate.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: NOMINAL_ADD function|'''NOMINAL_ADD''']]
+
−
|Returns a nominal interest rate given the effective compounded interest rate.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: ODDFPRICE function|'''ODDFPRICE''']]
+
−
|Returns the value of a security per 100 currency units of face value, where the time to the first
+
−
interest payment is not a whole period.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: ODDFYIELD function|'''ODDFYIELD''']]
+
−
|Returns the yield of a security, where the time to the first interest payment is not a whole period.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: ODDLPRICE function|'''ODDLPRICE''']]
+
−
|Returns the value of a security per 100 currency units of face value, where the last interest payment
+
−
is not a whole period.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: ODDLYIELD function|'''ODDLYIELD''']]
+
−
|Returns the yield of a security, where the last interest payment is not a whole period. 
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: PRICE function|'''PRICE''']]
+
−
|Calculates a quoted price for an interest paying security, per 100 currency units par value.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: PRICEDISC function|'''PRICEDISC''']]
+
−
|Calculates a price for a non-interest paying discounted bond.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: PRICEMAT function|'''PRICEMAT''']]
+
−
|Calculates a price (per 100 currency units par value) for a bond that pays interest on maturity.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: RECEIVED function|'''RECEIVED''']]
+
−
|Calculates the amount received at maturity for a zero coupon bond.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: TBILLEQ function|'''TBILLEQ''']]
+
−
|Returns the bond-equivalent-yield (BEY) for a US Treasury bill.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: TBILLPRICE function|'''TBILLPRICE''']]
+
−
|Returns the issue price for a US Treasury bill, per $100 par value, given a discount rate.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: TBILLYIELD function|'''TBILLYIELD''']]
+
−
|Returns the yield for a US Treasury bill.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: YIELD function|'''YIELD''']]
+
−
|Calculates the yield for an interest paying security.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: YIELDDISC function|'''YIELDDISC''']]
+
−
|Calculates the yield for a non-interest paying discounted bond.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: YIELDMAT function|'''YIELDMAT''']]
+
−
|Calculates the yield for a bond that pays interest on maturity.
+
−
+
−
|-valign="top"
+
−
|colspan="2"|'''<big> Coupons</big>'''
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: COUPDAYBS function|'''COUPDAYBS''']]
+
−
|Returns the number of days between the coupon date preceding the settlement, and the settlement date.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: COUPDAYS function|'''COUPDAYS''']]
+
−
|Returns the number of days in the coupon period that contains the settlement date.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: COUPDAYSNC function|'''COUPDAYSNC''']]
+
−
|Returns the number of days between the settlement date and the next coupon date.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: COUPNCD function|'''COUPNCD''']]
+
−
|Returns the coupon date next after the settlement date.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: COUPNUM function|'''COUPNUM''']]
+
−
|Returns the number of coupons (interest payments) between the settlement
+
−
date and maturity.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: COUPPCD function|'''COUPPCD''']]
+
−
|Returns the coupon (interest payment) date which precedes the settlement date.
+
−
 
+
−
|-valign="top"
+
−
|colspan="2"|'''<big> Miscellaneous</big>'''
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: DOLLARDE function|'''DOLLARDE''']]
+
−
|Converts a fractional number representation of a number into a decimal number.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: DOLLARFR function|'''DOLLARFR''']]
+
−
|Converts a decimal number into a fractional representation of that number.
+
−
|}
+
−
<br style="clear:both;" />
+
−
<!-- why on earth is this necessary? -->
+
−
 
+
−
{{SeeAlso|EN|
+
−
* [[Documentation/How_Tos/Calc: Derivation of Financial Formulas|Derivation of Financial Formulas]]
+
−
* [[Documentation/How_Tos/Calc: Date & Time functions#Financial date systems|Financial date systems]]
+
−
 
+
−
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]],
+
−
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]
+
−
}}
+
  
 
[[Category: Documentation/Reference/Calc]]
 
[[Category: Documentation/Reference/Calc]]
 
[[nl:NL/Documentation/How_Tos/Calc:_Financiële_functies]]
 
[[nl:NL/Documentation/How_Tos/Calc:_Financiële_functies]]

Latest revision as of 12:14, 31 January 2024

Retrieved from "https://wiki.openoffice.org/w/index.php?title=Template:Documentation/CalcFunc_FinancialTOC&oldid=259777"
Views
Personal tools
Navigation
Tools
In other languages