Syntax: YIELDMAT(S, M, I, R, PR[, B])
S = settlement date
M = maturity date
I = issue date
R = interest rate at date of issue
PR = the price of the security 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 |
YIELDMAT returns the annual yield of a security which pays interest at maturity. All dates must be expressed as serial date values.
Examples:
YIELDMAT(DATE(93, 3, 1), DATE(93, 10, 1), DATE(92, 11, 5), 6.5%, 99.875, 0) = 0.06585
Excel function: N/A