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)