Difference between revisions of "Documentation/How Tos/Calc: COUPPCD function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→See also:) |
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
||
| Line 23: | Line 23: | ||
: returns <tt>'''15 November 2006'''</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 interest payment date just before 25 January 2007 is 15 November 2006. | : returns <tt>'''15 November 2006'''</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 interest payment date just before 25 January 2007 is 15 November 2006. | ||
| − | + | {{Documentation/SeeAlso| | |
| − | [[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: COUPDAYSNC function| | + | * [[Documentation/How_Tos/Calc: COUPDAYSNC function|COUPDAYSNC]], |
| − | [[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: 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]]}} |
Revision as of 13:38, 25 February 2009
COUPPCD
Returns the coupon (interest payment) date which precedes the settlement date.
This function is only available if the Analysis AddIn is installed.
Syntax:
COUPPCD(settlement; maturity; frequency; basis)
- settlement: the date of purchase of the security.
- maturity: the date on which the security matures (expires).
- frequency: number of interest payments per year (1, 2 or 4).
- basis: is the calendar system to use. Defaults to 0 if omitted.
- 0 - US method (NASD), 12 months of 30 days each
- 1 - Actual number of days in months, actual number of days in year
- 2 - Actual number of days in month, year has 360 days
- 3 - Actual number of days in month, year has 365 days
- 4 - European method, 12 months of 30 days each
Example:
COUPPCD("2007-01-25"; "2009-11-15"; 2; 1)
- returns 15 November 2006 as a 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 (frequency is 2); thus interest is due on the 15 May and the 15 November each year, during the bond's term. The interest payment date just before 25 January 2007 is 15 November 2006.
