Apple Numbers '08 Manual do Utilizador descarregar pdf (Página 260)

260 Chapter 12 Dictionary of Functions

PRICEDISC

The PRICEDISC function calculates the price of a discounted security per $100 par value.

PRICEDISC(settle, maturity, discount, value, [day-count])

Â settle: The settlement date.

Â maturity: The date when the security expires.

Â discount: The discount rate.

Â value: The redemption value on the maturity date. Expressed per $100 par value.

Â 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).

PRICEMAT

The PRICEMAT function calculates the price of a security that pays interest at maturity

per $100 par value.

PRICEMAT(settle, maturity, issue, rate, yield, [day-count])

Â settle: The settlement date.

Â maturity: The date when the security expires.

Â issue: The issue date of the security.

Â rate: The redemption value on the maturity date. Expressed per $100 par value.

Â yield: The annual yield.

Â 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).

Examples

If cells A1:D1 contain 1/1/2000, 1/1/2001, 0.1, 100:

PRICEDISC(A1, B1, C1, D1) returns 90.

1 2 ... 255 256 257 258 259 260 261 262 263 264 265 ... 294 295

Sem comentários

Apple Numbers '08 Manual do Utilizador Página 260