Apple numbers User Manual
222
Chapter 12
Dictionary of Functions
4 means quarterly payments (four per year).
 day-count: Optional; specifies the number of days per month and days per year used
in the calculations (sometimes called the day count basis).
0 or omitted uses 30/360 (30 days for each month, 360 days in a year).
1 uses actual/actual (the number of days shown on a calendar).
2 uses actual/360 (calendar days for each month but 360 days per year).
3 uses actual/365 (calendar days for each month but 365 days per year).
4 uses 30E/360 (European 30/360).
COUPDAYSNC
The COUPDAYSNC function counts the number of days from the settlement date of a
security to the end of the coupon period in which settlement occurs.
security to the end of the coupon period in which settlement occurs.
COUPDAYBS(settle, maturity, frequency, [day-count])
 settle: The date of the settlement, usually the date when the security was purchased.
 maturity: The date the security matures (expires).
 frequency: The number of coupon payments each year.
 maturity: The date the security matures (expires).
 frequency: The number of coupon payments each year.
1 means annual payments.
2 means semiannual payments (twice per year).
4 means quarterly payments (four per year).
 day-count: Optional; specifies the number of days per month and days per year used
in the calculations (sometimes called the day count basis).
0 or omitted uses 30/360 (30 days for each month, 360 days in a year).
1 uses actual/actual (the number of days shown on a calendar).
Examples
If A1:A4 contain 9/1/2000, 1/1/2001, 4, 0:
COUPDAYS(A1, A2, A3, A4) returns 90 (the number of days in July, August, and September using the
30/360 day count basis).
30/360 day count basis).
COUPDAYS(A1, A2, A3, 1) returns 92 (the number of days in July, August, and September using the
actual/actual day count basis).
actual/actual day count basis).
COUPDAYS(A1, A2, A3, 2) returns 90 (the number of days in July, August, and September using the
actual/360 day count basis).
actual/360 day count basis).
COUPDAYS(A1, A2, A3, 3) returns 91.25 (the number of days in July, August, and September using the
actual/365 day count basis).
actual/365 day count basis).
COUPDAYS(A1, A2, A3, 4) returns 90 (the number of days in July, August, and September using the
30E/360 day count basis).
30E/360 day count basis).