Syntax: @YIELDDISC(S, M, PR, RD[, B])
S = settlement date
M = maturity date
PR = the price of the security per $100 face value
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 |
@YIELDDISC returns the annual yield for a discounted security. All dates must be entered as serial date value.
Example:
@YIELDDISC(@DATE(93, 3, 1), @DATE(93, 5, 1), 98, 875, 100, 0) = 0.06827