COUPDAYSNC function
From Apache OpenOffice Wiki
< Documentation | How Tos
Depreciation
Payment Streams, Annuities, Loans
Securities
Coupons
Miscellaneous
< {{#switch:Previous Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} | {{#switch:Next Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} > |
COUPDAYSNC
Returns the number of days between the settlement date and the next coupon date.
This function is only available if the Analysis AddIn is installed.
Syntax:
COUPDAYSNC(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:
COUPDAYSNC("2017-01-25"; "2019-11-15"; 2; 4)
- returns 110. A bond is originally issued on 15 November 2009, with a ten-year term; the date of maturity is 15 November 2019. You subsequently purchase it on the secondary market, with a settlement date of 25 January 2017; 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 4, there are 110 days from the settlement date 25 January 2017 until the next interest payment on 15 May 17.
{{#switch:EN
| RU = Смотрите также:
| UA = Дивіться також:
| EN = See Also
| PT = Ver também
| #default = See Also
}}