next up previous contents index
Next: YIELDDISC Up: A. Function Reference Previous: YEARFRAC   Contents   Index


YIELD

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

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

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

Example:

YIELD(DATE(91, 3, 15), DATE(98, 10, 15), 6%, 94.1854, 100, 2, 0) = 0.07

Excel function: N/A


next up previous contents index
Next: YIELDDISC Up: A. Function Reference Previous: YEARFRAC   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003