DISC Function
Returns the discount rate of a security sold below face value.
Category
Financial
Available in
All versions, Microsoft 365
Returns
A discount rate
Want to practice DISC in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
Discount securities pay no interest — you buy below face value and receive the full amount at maturity. DISC expresses that gap as an annual rate of the redemption value.
It's (redemption − price) ÷ redemption × (year length ÷ days).
Syntax
=DISC(settlement, maturity, pr, redemption, [basis])
Arguments
| Argument | Required? | What it does |
|---|---|---|
| settlement | Yes | The date the buyer takes ownership (after the issue date). |
| maturity | Yes | The date the security is repaid. |
| pr | Yes | The price per $100 of face value. |
| redemption | Yes | The value paid at maturity per $100 of face value (usually 100). |
| basis | No | Day count: 0 or omitted = US 30/360, 1 = actual/actual, 2 = actual/360, 3 = actual/365, 4 = European 30/360. |
Examples
Example 1 — Rate on a discount note
Northstar parks cash in a six-month discount note settling 3/15/2026 and maturing 9/15/2026, on an actual/360 basis. Price 97.60.
B6fx=DISC(B1,B2,B3,B4,B5)
| A | B | |
|---|---|---|
| 1 | Settlement | 3/15/2026 |
| 2 | Maturity | 9/15/2026 |
| 3 | Price | 97.6 |
| 4 | Redemption | 100 |
| 5 | Basis | 2 |
| 6 | Discount rate | 4.70% |
| 7 | On 30/360 (basis 0) | 4.80% |
Common mistakes
- #VALUE! or #NUM!. A date isn't a real date, settlement is on or after maturity, or frequency isn't 1, 2 or 4.
- Comparing with a bond yield. A discount rate understates the true return. Use YIELDDISC for a like-for-like yield.
Notes
- Enter dates with DATE or as cells holding real dates. Text dates like "3/15/2026" typed straight into the formula can be misread on computers with other regional settings.
- Related functions: PRICEDISC, YIELDDISC, INTRATE, TBILLYIELD.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.