next up previous contents index
Next: YIELDMAT Up: A. Function Reference Previous: YIELD   Contents   Index


YIELDDISC

Syntax: YIELDDISC(S, M, PR, RD[, B])

S = settlement date
M = maturity date
PR = the price of the security per $100 face value
RD = redemption value of the security at maturity 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

YIELDDISC returns the annual yield for a discounted security. All dates must be entered as serial date value.

Example:

YIELDDISC(DATE(93, 3, 1), DATE(93, 5, 1), 98, 875, 100, 0) = 0.06827

Excel function: N/A


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