YIELDDISC
Returns the annual yield for a discounted security
Syntax
YIELDDISC(settlement, maturity, pr, redemption, [basis])
Parameters
- settlement: Required. The security's settlement date
- maturity: Required. The security's maturity date
- pr: Required. The security's price per $100 face value
- redemption: Required. The security's redemption value per $100 face value
- basis: Optional. The type of day count basis
Example
=YIELDDISC("02/16/2024", "03/01/2024", 99.795, 100, 2)