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.