DISC(S, M, P, R, B)

 

Description

This function returns the discount rate of a security.

 

Parameters

 

S

Settlement date.

 

M

Maturity date.

 

P

Price per $100.

 

R

Redemption value per $100.

 

B

(Optional)  The day count basis to be used:

 

 

Examples

 

DISC(DATE(93, 1, 10), DATE(93, 7, 20), 97.375, 100, 3) = 0.05016

 

DISC(DATE(93, 1, 10), DATE(93, 7, 20), 97.375, 100) = 0.04974