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