Apple numbers User Manual

    Dictionary of Functions 

 

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

  

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

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

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