Excel Function : DISC
Category
Financial
Description
Returns the discount rate for a security
Microsoft Excel Reference Page
https://support.office.com/en-us/article/DISC-function-71fce9f3-3f05-4acf-a5a3-eac6ef4daa53
Syntax and Description of the DISC Excel Function
The syntax for the DISC function in Excel is: DISC( settlement, maturity, rate, pr, redemption, basis ) The DISC function syntax has the following arguments: Settlement: The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer. The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer. Maturity: The security's maturity date. The maturity date is the date when the security expires. The security's maturity date. The maturity date is the date when the security expires. Rate: The security's annual coupon rate.
About DISC Excel Function
The DISC function in Excel calculates theDiscount Rate for a security. The function uses the following syntax: DISC(settlement, maturity, pr, redemption, basis) The function takes the following arguments: Settlement:The security's settlement date. The settlement date is the date after the issue date when the security is traded to the buyer. Maturity:The security's maturity date. This is the date when the security expires. Pr:The security's price per $100 face value. Redemption:The security's redemption value per $100 face value. Basis:The type of day count basis to use.