# DISC

Formulas / DISC
Calculate 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.

What does the DISC function do?
The DISC function calculates a bond discount rate.
What are the arguments for the DISC function?
The arguments for the DISC function are settlement, maturity, pr, and redemption.
Are all arguments required for the DISC function?
Yes, all arguments are required for the DISC function.
What is the pr argument for?
The pr argument is the bond price per \$100 face value.
What is the redemption argument for?
The redemption argument is the bond's redemption price per \$100 face value.