Syntax: PRICEDISC(S, M, D, RD[, B])
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:
0 or omitted | 30/360 |
1 | actual/actual |
2 | actual/360 |
3 | actual/365 |
PRICEDISC returns the price per $100 face value of a discounted security.
Example:
PRICEDISC(DATE(93, 2, 1), DATE(93, 6, 1), 6.5%, 100, 0) = 97.8333
Excel function: N/A