DISC
Formulas / DISCCalculate the discount rate for a security.
DISC(settlement, maturity, pr, redemption, [basis])
- Settlement - required, the date of the security
- Maturity - required, the date the security reaches maturity
- Pr - required, security price per $100 face value
- Redemption - required, security redemption value per $100 face value
- Basis - [OPTIONAL] determines the day count basis
Examples
=DISC(A2,A3,A4,A5,A6)The DISC function can be used to calculate the bond discount rate for a bond with the terms in the table. For example, the formula above would be used to calculate the discount rate when the bond's face value, maturity date, interest rate, and issue date are specified in cells A2, A3, A4, and A5, respectively.
=DISC(B2,B3,B4,B5,B6)The DISC function can also be used to calculate the bond discount rate for a bond with the terms in the table. For example, the preceding formula would be used to calculate the discount rate when the bond's face value, maturity date, interest rate, and issue date are specified in cells B2, B3, B4, and B5, respectively, and the settlement date is specified in cell B6.
Summary
The DISC function in Sourcetable is used to calculate the discount rate for a security, by using dates stored as sequential numbers.
- The DISC function is a Sourcetable formula used to calculate the discount rate for a security.
Need help with Formulas?
Frequently Asked Questions
What does the DISC function do?
What are the arguments for the DISC function?
Are all arguments required for the DISC function?
What is the pr argument for?
What is the redemption argument for?
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.