Practice free

PRICEDISC function

PRICEDISC prices a zero-coupon instrument such as a treasury bill from its discount rate, returning the price per 100 of face value. It is the inverse of DISC.

Example

Read it as a sentence: find the price of a discounted security bought January 1, 2024 that matures July 1, 2024, at a 6% discount on 100, using basis 0, which gives 97.

Practice this in the app

Syntax

PRICEDISC(settlement, maturity, discount, 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.
discount (required)
Annual discount rate.
redemption (required)
Redemption value per 100 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: Price per 100 face value of a discounted 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
=PRICEDISC(DATE(2024,2,15),DATE(2024,8,15),0.0525,100,0) 97.375 Typical
=PRICEDISC(DATE(2024,2,15),DATE(2024,8,15),0.0525,100) 97.375 Basis omitted
=PRICEDISC(DATE(2024,2,15),DATE(2024,8,15),0.0525,100,0) 97.375 Basis 0
=PRICEDISC(DATE(2024,2,15),DATE(2024,8,15),0.0525,100,1) 97.38934426 Basis 1
=PRICEDISC(DATE(2024,2,15),DATE(2024,8,15),0.0525,100,2) 97.34583333 Basis 2
=PRICEDISC(DATE(2024,2,15),DATE(2024,8,15),0.0525,100,3) 97.38219178 Basis 3
=PRICEDISC(DATE(2024,2,15),DATE(2024,2,15),0.0525,100,0) #NUM! Settlement = maturity
=PRICEDISC(DATE(2024,8,15),DATE(2024,2,15),0.0525,100,0) #NUM! Settlement after maturity

Watch out for

  • Pass dates with DATE() or cell references; text dates can misbehave and invalid dates return #VALUE!.

Where it works

Excel
PRICEDISC 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 .