Difference between revisions of "Documentation/How Tos/Calc: COUPDAYBS function"
From Apache OpenOffice Wiki
< Documentation | How Tos
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
m |
||
(3 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
− | __NOTOC__ | + | {{DISPLAYTITLE: COUPDAYBS function}} |
+ | {{Documentation/CalcFunc FinancialTOC | ||
+ | |ShowPrevNext=block | ||
+ | |PrevPage=Documentation/How_Tos/Calc:_ODDLYIELD_function | ||
+ | |NextPage=Documentation/How_Tos/Calc:_COUPDAYS_function | ||
+ | }}__NOTOC__ | ||
== COUPDAYBS == | == COUPDAYBS == | ||
Line 21: | Line 26: | ||
=== Example: === | === Example: === | ||
<tt>'''COUPDAYBS("2007-01-25"; "2009-11-15"; 2; 1)'''</tt> | <tt>'''COUPDAYBS("2007-01-25"; "2009-11-15"; 2; 1)'''</tt> | ||
− | : returns <tt>'''71'''</tt>. 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. Using basis 1, there are 71 (actual) days in the interest period directly before the settlement date, 15 November 2006 to 25 January 2007 (so <tt>'''="2007-01-25" - "2006-11-15"'''</tt> also returns <tt>'''71'''</tt>). | + | : returns <tt>'''71'''</tt>. 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. Using basis 1, there are 71 (actual) days in the interest period directly before the settlement date, 15 November 2006 to 25 January 2007 (so <tt>'''="2007-01-25" - "2006-11-15"'''</tt> also returns <tt>'''71'''</tt>). |
− | {{ | + | {{SeeAlso|EN| |
* [[Documentation/How_Tos/Calc: COUPDAYS function|COUPDAYS]] | * [[Documentation/How_Tos/Calc: COUPDAYS function|COUPDAYS]] | ||
* [[Documentation/How_Tos/Calc: COUPDAYSNC function|COUPDAYSNC]] | * [[Documentation/How_Tos/Calc: COUPDAYSNC function|COUPDAYSNC]] | ||
Line 36: | Line 41: | ||
* [[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]] | + | [[Category: Documentation/Reference/Calc/Financial functions]] |
Latest revision as of 12:16, 31 January 2024
- Financial FunctionsDepreciation
- AMORDEGRCAMORLINCDBDDBSLNSYDVDBPayment Streams, Annuities, Loans
- CUMIPMTCUMIPMT_ADDCUMPRINCCUMPRINC ADDFVFVSCHEDULEIPMTIRRISPMTMIRRNPERNPVPMTPPMTPVRATERRIXIRRXNPVSecurities
-