DISC


Name of Formula:

DISC(settlementmaturityprice,redemptionbasis)


Definition/Description of Formula:

This Function calculates Discount rates for a security


Syntax:

  • settlement - Enter the date after issuance when the security is delivered to the buyer.
  • maturity - The end date of the security, when it could be redeemed.
  • price - The price at which the security is bought.
  • redemption - The redemption value of the security.
  • basis[ OPTIONAL - 0 by default ] - An indicator of what day count method to use.
    • 0- This assumes 30 day months and 360 day years as per the National Association of Securities Dealers standard
    • 1- This calculates based upon the actual number of days between the specified dates, and the actual number of days in the intervening years.
    • 2- This calculates based on the actual number of days between the speficied dates, but assumes a 360 day year.
    • 3- This calculates based on the actual number of days between the specified dates, but assumes a 365 day year.
    • 4- Similar to 0, this calculates based on a 30 day month and 360 day year, but adjusts end-of-month dates according to European financial conventions.

Use DATETO_DATE formulas to enter the date


Step 1.  To begin to use DISC formula, start with the Excellentable you would like to edit..

Capture 2016-04-02 at 17.25.03.png

                        


Step 2. Then type the DISC formula into the cell you have chosen to display the outcome: 

Capture 2016-04-02 at 16.42.20.png


Step 3. Enter in the values needed to achieve your final outcome. 

Capture 2016-04-02 at 16.53.01.png

Step 4. Once saved, your completed formula will display in a confluence page like this.