Practice free

DISC function

DISC returns the annualized discount rate of a security, such as a treasury bill, from its price and redemption value. It is a discount on face value, not a yield on price.

Example

Read it as a sentence: for a bond bought January 1, 2024 that matures July 1, 2024, costs 97 per 100 of face value, and is redeemed at 100, find the discount rate using basis 0.

Practice this in the app

Syntax

DISC(settlement, maturity, pr, redemption, [basis])

Arguments in [square brackets] are optional.

settlement (required)
Date the security is bought (after issue, before maturity).
maturity (required)
Date the security expires and is repaid.
pr (required)
Price per 100 of face value.
redemption (required)
Redemption value per 100 of face value.
basis (optional)
Day-count convention: 0 or omitted = US 30/360, 1 = actual/actual, 2 = actual/360, 3 = actual/365, 4 = European 30/360.

Returns: Annualised discount rate of a security.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=DISC(DATE(2024,2,15),DATE(2024,8,15),97.975,100,0) 0.0405 Typical
=DISC(DATE(2024,2,15),DATE(2024,8,15),97.975,100) 0.0405 Basis omitted
=DISC(DATE(2024,2,15),DATE(2024,8,15),97.975,100,0) 0.0405 Basis 0
=DISC(DATE(2024,2,15),DATE(2024,8,15),97.975,100,1) 0.040722527 Basis 1
=DISC(DATE(2024,2,15),DATE(2024,8,15),97.975,100,2) 0.040054945 Basis 2
=DISC(DATE(2024,2,15),DATE(2024,8,15),97.975,100,3) 0.040611264 Basis 3
=DISC(DATE(2024,2,15),DATE(2024,2,15),97.975,100,0) #NUM! Settlement = maturity
=DISC(DATE(2024,8,15),DATE(2024,2,15),97.975,100,0) #NUM! Settlement after maturity

Watch out for

  • This is a discount rate on face value, not a yield on price.

Where it works

Excel
DISC is in every version of Excel from 2007 on.
Google Sheets
Same name, same behaviour for everyday use.

Part of Financial functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .