DISC

Calculates the discount rate of a security based on price. Learn more

Video field
Financial

DISC is a financial function in Google Sheets that calculates the discount rate of a security, given the security's settlement date, maturity date, price, and redemption value. It is used to analyze and value bonds and other debt securities.

The syntax for the DISC function is as follows:

DISC(settlement, maturity, price, redemption, [daycountconvention])

settlement: The settlement date of the security, represented as a date or a reference to a cell containing a date. maturity: The maturity date of the security, represented as a date or a reference to a cell containing a date. price: The price at which the security is currently trading, per $100 face value. redemption: The redemption value of the security, per $100 face value. daycountconvention (optional): The day count convention to use in the calculation. This is an optional argument and can be omitted if not needed.

The DISC function returns the annual discount rate of the security as a decimal value.

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes no code required!