Example :

The Excel Disc function is used in the following example to compute the discount rate of a security acquired on 01-Apr-2016 with a maturity date of 31-Mar-2021. The price per $100 face value is $95, the redemption value is $100, and the 30/360 day count basis is utilised in the United States (NASD):
The value 0.01 is returned by the preceding code. In other words, the discount rate for a security with the aforementioned parameters is 1.0 percent. Take note of the following in the above example:
The date inputs were passed to the Disc method as pointers to cells holding dates, as advised.
Because the [basis] parameter is missing, the method uses the default value 0 (which represents the US (NADS) 30/360 day count basis.