Syntax: PRICEMAT(S, M, I, R, Y[, B])
S = settlement date
M = maturity date
I = issue date
R = annual coupon rate of the security
Y = annual yield of the security
B = (Optional) the day count basis to be used:
0 or omitted | 30/360 |
1 | actual/actual |
2 | actual/360 |
3 | actual/365 |
PRICEMAT returns the price per $100 face value of a security that pays interest at maturity.
Example:
PRICEMAT(DATE(93, 3, 1), DATE(93, 6, 15), DATE(92, 11, 1), 6.5%, 0) = 101.8778
Excel function: N/A