PRICEDISC Function in Excel: Price of a Discounted Security

PRICEDISC Function in Excel: Price 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. PRICEDISC in practice
  5. Where you will use it
  6. Worked example
  7. Mistakes people make
  8. Related functions

PRICEDISC returns the price per 100 of a discounted security such as a T-bill or commercial paper.

Advertisement

Syntax

=PRICEDISC(settlement, maturity, discount, 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(PRICEDISC(DATE(2026,10,1),DATE(2027,1,1),A2,100,3),4)

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

PRICEDISC in practice

Where you will use it

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

Worked example

DiscountFormulaResult
0.065=ROUND(PRICEDISC(DATE(2026,10,1),DATE(2027,1,1),A2,100,3),4)98.3616
0.07=ROUND(PRICEDISC(DATE(2026,10,1),DATE(2027,1,1),A3,100,3),4)98.2356
0.06=ROUND(PRICEDISC(DATE(2026,10,1),DATE(2027,1,1),A4,100,3),4)98.4877

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–ZIMREAL Function in Excel: Real PartExcel Functions A–ZINDIRECT Function in Excel: Build a Reference From TextExcel Functions A–ZATAN Function in Excel: Angle From a Slope
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