Returns the discount rate for a security.
Söz dizimi
DISC(settlement, maturity, pr, redemption, [basis])Bağımsız değişkenler
settlementzorunlu
The security's settlement date.
maturityzorunlu
The security's maturity date.
przorunlu
The security's price per $100 face value.
redemptionzorunlu
The security's redemption value per $100 face value.
basisisteğe bağlı
The type of day count basis to use (default is 0).
The DISC function calculates the annual discount rate for a security based on its settlement date, maturity date, price, and redemption value. It is commonly used to determine the yield of treasury bills or other discounted financial instruments.
=DISC("2023-01-01", "2024-01-01", 95, 100)→0.05Calculates the discount rate for a security purchased at 95 with a redemption of 100 over one year.
Prepare input data
Ensure your settlement and maturity dates are in a format Excel recognizes as a date.
Enter the formula
Input the DISC function with the required price and redemption values per $100 of face value.
It determines how the days are counted, such as US (NASD) 30/360 or actual/actual.