Navigation:  Formula Reference > Spreadsheet Formula Functions >

YIELDDISC

Previous pageReturn to chapter overviewNext page

 

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

ODDLYIELD

YIELD

YIELDMAT