Syntax: @PRICE(S, M, R, Y, RD, F[, B])
S = settlement date
M = maturity date
R = annual coupon rate of the security
Y = annual yield of the security
RD = redemption value of the security at maturity per
$100 face value
F = the number of coupon payments per year
B = (Optional) the day count basis to be used:
0 or omitted | 30/360 |
1 | actual/actual |
2 | actual/360 |
3 | actual/365 |
@PRICE returns the price per $100 face value of a security that pays periodic interest.
Example:
@PRICE(@DATE(91, 3, 15), @DATE(98, 10, 15), 6%, 7%, 100, 2, 0) = 94.1854