Easy Explanation Notes with Examples

PRICEDISC function in Excel

Use

The PRICEDISC function calculates the price per $100 face value of a discounted security.

Syntax

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:

BasisDay count basis
0 or omittedUS (NASD) 30/360
1Actual/actual
2Actual/360
3Actual/365
4European 30/360

Example

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.

Function Errors

ErrorOccurs
#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. 

Related Functions

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.




Copyright © 2016 - 2018 Explainry.com | All Rights Reserved