Difference between revisions of "Documentation/How Tos/Calc: COUPDAYSNC function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→See also:) |
m |
||
(7 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
− | __NOTOC__ | + | {{DISPLAYTITLE: COUPDAYSNC function}} |
+ | {{Documentation/CalcFunc FinancialTOC | ||
+ | |ShowPrevNext=block | ||
+ | |PrevPage=Documentation/How_Tos/Calc:_COUPDAYS_function | ||
+ | |NextPage=Documentation/How_Tos/Calc:_COUPNCD_function | ||
+ | }}__NOTOC__ | ||
== COUPDAYSNC == | == COUPDAYSNC == | ||
Line 20: | Line 25: | ||
=== Example: === | === Example: === | ||
− | <tt>'''COUPDAYSNC(" | + | <tt>'''COUPDAYSNC("2017-01-25"; "2019-11-15"; 2; 4)'''</tt> |
− | : returns <tt>'''110'''</tt>. A bond is originally issued on 15 November | + | : returns <tt>'''110'''</tt>. 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. Using basis 4, there are 110 days from the settlement date 25 January 2017 until the next interest payment on 15 May 17. |
− | + | {{SeeAlso|EN| | |
− | [[Documentation/How_Tos/Calc: COUPDAYBS function| | + | * [[Documentation/How_Tos/Calc: COUPDAYBS function|COUPDAYBS]] |
− | [[Documentation/How_Tos/Calc: COUPDAYS function| | + | * [[Documentation/How_Tos/Calc: COUPDAYS function|COUPDAYS]] |
− | [[Documentation/How_Tos/Calc: COUPNCD function| | + | * [[Documentation/How_Tos/Calc: COUPNCD function|COUPNCD]] |
− | [[Documentation/How_Tos/Calc: COUPNUM function| | + | * [[Documentation/How_Tos/Calc: COUPNUM function|COUPNUM]] |
− | [[Documentation/How_Tos/Calc: COUPPCD function| | + | * [[Documentation/How_Tos/Calc: COUPPCD function|COUPPCD]] |
− | [[Documentation/How_Tos/Calc: Date & Time functions#Financial date systems| | + | * [[Documentation/How_Tos/Calc: Date & Time functions#Financial date systems|Financial date systems]] |
− | [[Documentation/How_Tos/Calc: Financial functions| | + | * [[Documentation/How_Tos/Calc: Financial functions|Financial functions]] |
− | [[Documentation/How_Tos/Calc: Functions listed alphabetically| | + | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] |
− | [[Documentation/How_Tos/Calc: Functions listed by category| | + | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} |
+ | [[Category: Documentation/Reference/Calc/Financial functions]] |
Latest revision as of 12:20, 31 January 2024
- Financial FunctionsDepreciation
- AMORDEGRCAMORLINCDBDDBSLNSYDVDBPayment Streams, Annuities, Loans
- CUMIPMTCUMIPMT_ADDCUMPRINCCUMPRINC ADDFVFVSCHEDULEIPMTIRRISPMTMIRRNPERNPVPMTPPMTPVRATERRIXIRRXNPVSecurities
-