Excel Function : PRICEDISC

Download now!

Excel Function : PRICEDISC




Returns the price per $100 face value of a discounted security

Microsoft Excel Reference Page


Syntax and Description of the PRICEDISC Excel Function

The syntax for the PRICEDISC function in Microsoft Excel is: PRICEDISC(settlement, maturity, rate, yield, redemption, freq, [basis]) Arguments settlement - The security's settlement date. The settlement date is the date after the issue date when the security is traded to the buyer. maturity - The security's maturity date. The maturity date is the date when the security expires. rate - The security's annual coupon rate. yield - The security's annual yield. redemption - The security's redemption value per $100 face value. freq - The number of coupon payments per year.

About PRICEDISC Excel Function

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