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