Friday 5 May 2017

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 

















No comments:

Post a Comment