Spread.Sheets Documentation
YIELDDISC
Spread.Sheets Documentation > Formula Reference > Formula Functions > YIELDDISC

This function calculates the annual yield for a discounted security.

Syntax

YIELDDISC(settle,maturity,price,redeem,basis)

Arguments

This function has these arguments:

Argument Description
settle Settlement date for the security
maturity Maturity date for the security
price Price per $100 face value for the security
redeem Redemption value per $100 face value
basis [Optional] Integer representing the basis for day count (Refer to Day Count Basis.)

Remarks

This function returns a #VALUE! error when settle or maturity is invalid. If price or redeem is less than or equal to 0, a #NUM! error is returned. If basis is less than 0 or greater than 4, a #NUM! error is returned. If settle is greater than or equal to maturity, a #NUM! error is returned. Settle, maturity, and basis are truncated to integers.

Data Types

Accepts numeric data and dates. Returns numeric data.

Examples

YIEDDISC(B1,B2,B3,B4,B5)

See Also