Excel - Microsoft Excel Pricedisc Function

Description

The Excel Pricedisc function calculates the price, per $100 face value of a discounted security. 

The syntax of the function is : 

PRICEDISC( settlement, maturity, discount, redemption, [basis] ) 

Where the arguments are as follows: 

Excel Pricedisc Function Example

In the following example, the Excel Pricedisc function is used to calculate the price per $100 face value of a discounted security purchased on 01-Apr-2011, with maturity date 31-Mar-2015 and a discounted rate of 2.5%. The redemption value is $100 and the US (NASD) 30/360 day count basis is used: 

Pricedisc Function Errors

If you get an error from the Pricedisc function, this is likely to be one of the following: 

Common Errors