Apple Numbers '08 - Manual (Page 206)

206 Chapter 12 Dictionary of Functions
3 uses actual/365 (calendar days for each month but 365 days per year).
4 uses 30E/360 (European 30/360).
ACCRINTM
The ACCRINTM function calculates the total accrued interest for a security that pays
interest at maturity.
ACCRINTM(issue, settle, rate, par, [day-count])
 issue: The date when the security was issued.
 settle: The date of the settlement, usually the date when the security was purchased.
 rate: The coupon rate of the security, expressed as a percentage from 0 to 1.
 par: The face value of the security.
 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).
ACOS
The ACOS function calculates the inverse cosine (arccosine) of a number. While the COS
function takes an angle and returns its cosine, the ACOS function does the opposite; it
takes a cosine value and returns a corresponding angle. The resulting angle is
expressed in radians, in the range 0 to pi.
ACOS(cos)
 cos: A cosine value in the range –1 through 1.
Examples
If A1:A7 contain 1/1/2000, 3/1/2000, 7/1/2000, 0.10, 1000, 2, 0:
ACCRINT(A1, A2, A3, A4, A5, A6, A7) returns 50.
Examples
If A1:A5 contain 1/1/2000, 10/1/2000, 0.10, 1000, 0:
ACCRINTM(A1, A2, A3, A4, A5) returns 75.