Function Type: Financial
Description:
Returns the discount rate for a security.
Function Structure:
=DISC(settlement, maturity, pr, redemption, [basis]).
Argument Breakdown:
settlement – Settlement date of the security.
maturity – Maturity date of the security.
pr – Security price per $100 face value.
redemption – Security redemption value per $100 face value.
basis – Day count basis.
Example:

If you need instant expert help with Excel or Google Sheets, please visit my fiverr gig.