The Excel PRICEDISC function 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 Required. The security’s settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.
- Maturity Required. The security’s maturity date. The maturity date is the date when the security expires.
- 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 to use.
|Basis||Day count basis|
|0 or omitted||US (NASD) 30/360|
Example: Let’s look at some Excel PRICEDISC function examples and explore how to use the PRICEDISC function as a worksheet function in Microsoft Excel:
In the following example, the Excel Pricedisc function is used to calculate the price per $100 face value of a discounted security purchased on 15-Jan-2019, with maturity date 15-Apr-2019 and a discounted rate of 6.50%. The redemption value is $100 and the Actual/360 day count basis is used:
- #NUM! error – Occurs if either:
- The settlement date is greater than or equal to maturity date;
- When we provide invalid numbers for the arguments: the rate of discount, redemption or basis. That is, if we have provided a discount rate is less than or equal to zero, a redemption value is less than or equal to less than zero, or a basis that is a number other than 0,1,2,3,4.
- #VALUE! error – Occurs if:
- The given settlement or maturity arguments are invalid Excel dates.
- Any of the given arguments are non-numeric.
- PRICEDISC is calculated as follows: