EXCEL PRICEDISC FUNCTION

The Excel Pricedisc function computes the price of a special discount security per $100 face value.

Syntax :

=PRICEDISC( settlementmaturitydiscountredemption[basis] )

Parameters :

  • The following parameter are:

settlement –

  • The ministry’s settling date

maturity –

  • The ministry’s maturation date (i.e. the date that the coupon expires).

discount –

  • The fraction interest amount of the security.

redemption –

  • The redeem value of the securities per $100 face value.
    [basis] – An optional integer input that sets the security’s financial day count basis. Possible values include:
BasisDay Count Basis
0 (or omitted)US (NASD) 30/360
1actual/actual
2actual/360
3actual/365
4European 30/360

Step By Step Guide of PRICEDISC Function

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):

  • #NUM! – Occurs if any of the following conditions are met: The settlement date; Invalid values are given for the discount, redeem, or [basis] arguments (i.e. if either: discount 0; restitution 0; or [basis] would be any value other than 0, 1, 2, 3, or 4).
  • #VALUE! – Occurs if any of the following conditions are met: the given settlement or maturity arguments are not valid Excel dates; or any of the supplied arguments is non-numeric.

Related Functions

HLOOKUP Function

HLOOKUP Function

Explore Now

VLOOKUP Function

VLOOKUP Function

Explore Now

INDEX Function

INDEX Function

Explore Now

MATCH Function

MATCH Function

Explore Now

DATE Function

DATE Function

Explore Now

IF Function

IF Function

Explore Now

OR Function

OR Function

Explore Now

AND Function

AND Function

Explore Now

RANK Function

RANK Function

Explore Now

SUMIF Function

SUMIF Function

Explore Now

XIRR Function

XIRR Function

Explore Now

WORKDAYS Function

WORKDAYS Function

Explore Now