Difference between revisions of "Documentation/How Tos/Calc: COUPDAYSNC function"
From Apache OpenOffice Wiki
< Documentation | How Tos
Javier Lopez (Talk | contribs) |
|||
Line 90: | Line 90: | ||
: returns <tt>'''110'''</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 4, there are 110 days from the settlement date 25 January 2007 until the next interest payment on 15 May 07. | : returns <tt>'''110'''</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 4, there are 110 days from the settlement date 25 January 2007 until the next interest payment on 15 May 07. | ||
− | {{ | + | {{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]] |
Revision as of 09:07, 17 July 2018
CALC FUNCTIONS
- Financial FunctionsDepreciation
- AmordegrcAmorlincDbDdbSlnSydVdbPayment Streams, Annuities, Loans
-