Difference between revisions of "Documentation/How Tos/Calc: COUPNUM function"
From Apache OpenOffice Wiki
< Documentation | How Tos
Javier Lopez (Talk | contribs) |
|||
Line 90: | Line 90: | ||
: returns <tt>'''6'''</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. Interest is paid 6 times: on 15 May 2007, 15 November 2007, 15 May 2008, 15 November 2008, 15 May 2009 and 15 November 2009. | : returns <tt>'''6'''</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. Interest is paid 6 times: on 15 May 2007, 15 November 2007, 15 May 2008, 15 November 2008, 15 May 2009 and 15 November 2009. | ||
− | {{ | + | {{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:06, 17 July 2018
CALC FUNCTIONS
- Financial FunctionsDepreciation
- AmordegrcAmorlincDbDdbSlnSydVdbPayment Streams, Annuities, Loans
-