Apple Numbers '08 Manual de usuario descargar pdf (Pagina 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.

1 2 ... 201 202 203 204 205 206 207 208 209 210 211 ... 294 295

Sin comentarios

Apple Numbers '08 Manual de usuario Pagina 206