The Excel Pricedisc function computes the price of a special discount security per $100 face value.
Syntax :
=PRICEDISC( settlement, maturity, discount, redemption, [basis] )
Parameters :
settlement –
maturity –
discount –
redemption –
Basis | Day Count Basis |
---|---|
0 (or omitted) | US (NASD) 30/360 |
1 | actual/actual |
2 | actual/360 |
3 | actual/365 |
4 | European 30/360 |
Example :
The Excel Pricedisc function is being used in the following example to compute the price per $100 current prices of a discounted security acquired on 01-Apr-2017, with an expiration of 31-Mar-2021 and a discounts rate of 2.5 percent. The redemption value is $100, and the 30/360 day count basis is utilised in the United States (NASD):
Ask Your Query