|
|
(One intermediate revision by one other user not shown) |
Line 1: |
Line 1: |
− | {{Documentation/MasterTOC | + | {{DISPLAYTITLE: COUPNCD function}} |
− | |bookid=1234'''
| + | {{Documentation/CalcFunc FinancialTOC |
− | |booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div>
| + | |ShowPrevNext=block |
− | |ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Financial_functions|<div style="font-size: 140%;">Financial Functions]]
| + | |PrevPage=Documentation/How_Tos/Calc:_COUPDAYSNC_function |
− | |ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_COUPNUM_function | + | |NextPage=Documentation/How_Tos/Calc:_COUPNUM_function |
− | |ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_COUPDAYSNC_function
| + | }}__NOTOC__ |
− | |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%;">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:_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%; border-style: double; border-color:#778899;">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__ | |
| | | |
| == COUPNCD == | | == COUPNCD == |
Line 87: |
Line 25: |
| | | |
| === Example: === | | === Example: === |
− | <tt>'''COUPNCD("2007-01-25"; "2009-11-15"; 2; 3)'''</tt> | + | <tt>'''COUPNCD("2017-01-25"; "2019-11-15"; 2; 3)'''</tt> |
− | : returns <tt>'''15 May 2007'''</tt> as a [[Documentation/How Tos/Calc: Date & Time functions#Date and Time overview|date-time serial number]]; choose a format to display the date as you prefer. A bond is originally issued on 15 November 1999, with a ten year term; the date of maturity is 15 November 2009. You subsequently purchase it on the secondary market, with a settlement date of 25 January 2007. Interest is paid half-yearly (<tt>'''frequency'''</tt> is 2); thus interest is due on the 15 May and the 15 November each year, during the bond's term. The next interest date after the settlement date 25 January 2007 is therefore 15 May 2007. | + | : returns <tt>'''15 May 2017'''</tt> as a [[Documentation/How Tos/Calc: Date & Time functions#Date and Time overview|date-time serial number]]; choose a format to display the date as you prefer. A bond is originally issued on 15 November 2009, with a ten-year term; the date of maturity is 15 November 2019. You subsequently purchase it on the secondary market, with a settlement date of 25 January 2017. Interest is paid half-yearly (<tt>'''frequency'''</tt> is 2); thus interest is due on the 15 May and the 15 November each year, during the bond's term. The next interest date after the settlement date 25 January 2017 is therefore 15 May 2017. |
| | | |
− | {{Documentation/SeeAlso| | + | {{SeeAlso|EN| |
| * [[Documentation/How_Tos/Calc: COUPDAYBS function|COUPDAYBS]] | | * [[Documentation/How_Tos/Calc: COUPDAYBS function|COUPDAYBS]] |
| * [[Documentation/How_Tos/Calc: COUPDAYS function|COUPDAYS]] | | * [[Documentation/How_Tos/Calc: COUPDAYS function|COUPDAYS]] |