The PRICEDISC function calculates the price per $100 face value of a discounted security.
PRICEDISC(settlement, maturity, discount, redemption, [basis])
The PRICEDISC function has the following arguments:
settlement – Required. The settlement date of the discounted security. The date comes after the issuance date when the security is traded to a buyer.
maturity – Required. The maturity date of the security. It is the date on which the security expires.
discount – Required. The discount rate for the security.
redemption – Required. The redemption value per $100 face value of the security.
[basis] – Optional. It is the optional argument, uses to specify the type of day count basis for calculation purpose. If omitted, Excel uses 0 i.e. US (NASD) 30/360 by default. Further available options are provided in the table below:
|Basis||Day count basis|
|0 or omitted||US (NASD) 30/360|
Suppose, a 5-year bond issued on June 30, 2019, at the discount rate of 5%. A buyer purchased the bond six months later on December 31, 2019. On June 30, 2024, the expiry date, the bond redeems at $100 face value. The PRICEDISC function calculates the price of the bond mentioned hereunder:
Result. The discounted security with the above terms has the price of $77.5.
|#VALUE!||If the settlement or maturity date is invalid.|
|#NUM!||If the discount rate is equal to or smaller than zero.|
|#NUM!||If the redemption value is equal to or smaller than zero.|
|#NUM!||If the [basis] argument is either smaller than zero or greater than 4.|
|#NUM!||If the settlement date is equal to or after the maturity date.|
The PRICEDISC function belongs to the Financial function category and has following related functions:
PRICE function calculates the price per $100 face value of a security that pays periodic interest.
PRICEMAT function calculates the price per $100 face value of a security (e.g. a bond) that pays interest at maturity.
TBILLPRICE function calculates the price of a Treasury bill.
DOLLARDE function converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number.