 Formula Engine Reference Guide |
|
Back to Class Index
PRICE(S, M, R, Y, RD, F[, B])
Returns the price per $100 face value of a security that pays periodic interest.
Parameters
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
Example
PRICE(DATE(91, 3, 15), DATE(98, 10, 15), 6%, 7%, 100, 2, 0) = 94.1854