YIELD(S, M, R, PR, RD, F[, B])

Description
Returns the yield at maturity of a security that pays periodic interest. All dates must be entered as serial date value.

Parameters
S
settlement date

M
maturity date

R
annual coupon rate of the security

PR
the price of the security per $100 face value

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
YIELD(DATE(91, 3, 15), DATE(98, 10, 15), 6%, 94.1854, 100, 2, 0) = 0.07