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


YIELDMAT

Syntax: YIELDMAT(S, M, I, R, PR[, B])

S = settlement date
M = maturity date
I = issue date
R = interest rate at date of issue
PR = the price of the security per $100 face value
B = (Optional) the day count basis to be used:

0 or omitted 30/360
1 Actual/actual
2 Actual/360
3 Actual/365

YIELDMAT returns the annual yield of a security which pays interest at maturity. All dates must be expressed as serial date values.

Examples:

YIELDMAT(DATE(93, 3, 1), DATE(93, 10, 1), DATE(92, 11, 5), 6.5%, 99.875, 0) = 0.06585

Excel function: N/A


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