Excel Function : PRICEDISC

Download now!

Excel Function : PRICEDISC

Category

Financial

Description

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

Microsoft Excel Reference Page

https://support.office.com/en-us/article/PRICEDISC-function-d06ad7c1-380e-4be7-9fd9-75e3079acfd3

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.