 Formula Engine Reference Guide |
|
Back to Class Index
PRICEMAT(S, M, I, R, Y[, B])
Returns the price per $100 face value of a security that pays interest at maturity.
Parameters
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
Example
PRICEMAT(DATE(93, 3, 1), DATE(93, 6, 15), DATE(92, 11, 1), 6.5%, 0) = 101.8778