PRICEDISC(S, M, D, RD [, B])

 

Description

This function returns the price per $100 face value of a discounted security.

 

Parameters

 

S

Settlement date.

 

M

Maturity date.

 

D

Discount rate of the security.

 

RD

Redemption value of the security at maturity per $100 face value.

 

B

(Optional.)  The day count basis to be used:

 

 

Examples

 

PRICEDISC(DATE(93, 2, 1), DATE(93, 6, 1), 6.5%, 100, 0) = 97.8333