BioloMICS logo
×
BioloMICS menu

PRICEDISC

 
Category: Financial Function.
 
Description: Returns the price per $100 face value of a discounted security.
 
Syntax: PRICEDISC(settlement, maturity, discount, redemption, [basis])
 
The PRICEDISC function syntax has the following arguments:
 
Settlement: security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.
 
Maturity: security's maturity date. The maturity date is the date when the security expires.
 
Discount: security's discount rate.
 
Redemption: security's redemption value per $100 face value.
 
Basis: type of day count basis to use.