Difference between revisions of "Documentation/How Tos/Calc: COUPDAYBS function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Initial content) |
(→See also:) |
||
| Line 24: | Line 24: | ||
=== See also: === | === See also: === | ||
| + | [[Documentation/How_Tos/Calc: COUPDAYS function|'''COUPDAYS''']], | ||
[[Documentation/How_Tos/Calc: COUPDAYSNC function|'''COUPDAYSNC''']], | [[Documentation/How_Tos/Calc: COUPDAYSNC function|'''COUPDAYSNC''']], | ||
| − | [[Documentation/How_Tos/Calc: | + | [[Documentation/How_Tos/Calc: COUPNCD function|'''COUPNCD''']], |
| + | [[Documentation/How_Tos/Calc: COUPNUM function|'''COUPNUM''']], | ||
| + | [[Documentation/How_Tos/Calc: COUPPCD function|'''COUPPCD''']] | ||
[[Documentation/How_Tos/Calc: Financial functions|'''Financial functions''']] | [[Documentation/How_Tos/Calc: Financial functions|'''Financial functions''']] | ||
Revision as of 13:32, 28 June 2008
COUPDAYBS
Returns the number of days between the coupon date preceding the settlement, and the settlement date.
This function is only available if the Analysis AddIn is installed.
Syntax:
COUPDAYBS(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 chosen from a list of options and indicates how the year is to be calculated. 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:
COUPDAYBS("2007-01-25"; "2009-11-15"; 2; 1)
- returns 71. 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. 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 ="2007-01-25" - "2006-11-15" also returns 71).
