YIELDDISC Function in Excel: Yield of a Discounted Security

YIELDDISC Function in Excel: Yield of a Discounted Security 1
⏱ 1 min readUpdated 5 October 2026

FinanceLevel: ExpertAvailable in: Excel 2007+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. YIELDDISC in practice
  5. Where you will use it
  6. Worked example
  7. Mistakes people make
  8. Related functions

YIELDDISC returns the annual yield of a discounted security such as a T-bill.

Advertisement

Syntax

=YIELDDISC(settlement, maturity, pr, redemption, [basis])
Argument What it means
dates Settlement, maturity and other dates as real dates
rates / prices Per 100 of face value where relevant
basis Day-count basis (0 = 30/360, 3 = actual/365)

Examples

Example 1

=ROUND(YIELDDISC(DATE(2026,10,1),DATE(2027,1,1),A2,100,3)*100,3)

Result: 6.451. See the worked example table below for more cases.

YIELDDISC in practice

Where you will use it

  • Treasury and bond desks
  • Valuing debentures and money-market instruments
  • Accrual and audit checks

Worked example

PriceFormulaResult
98.4=ROUND(YIELDDISC(DATE(2026,10,1),DATE(2027,1,1),A2,100,3)*100,3)6.451
96.7=ROUND(YIELDDISC(DATE(2026,10,1),DATE(2027,1,1),A3,100,3)*100,3)13.539
99.2=ROUND(YIELDDISC(DATE(2026,10,1),DATE(2027,1,1),A4,100,3)*100,3)3.2

Results calculated in Excel.

Mistakes people make

MistakeWhat to do instead
Dates as textUse DATE() or real date cells
Wrong basisIndian money-market instruments usually use actual/365 (3)

PRICE · YIELD · DISC

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZATAN Function in Excel: Angle From a SlopeExcel Functions A–ZYEAR Function in Excel: Year From a DateExcel Functions A–ZACCRINTM Function in Excel: Interest Accrued When Paid at Maturity
Advertisement
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong