Syntax: DISC(S, M, P, R, B)
S = Settlement date
M = Maturity date
P = Price per $100
R = Redemption value per $100
B = (Optional) The day count basis to be used.
0 or omitted | 30/360 |
1 | Actual/actual |
2 | Actual/360 |
3 | Actual/365 |
DISC returns the discount rate of a security.
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
Excel function: N/A