Home › Functions › Financial › PRICEDISC
fx
PRICEDISC
Financial  ·  Since: Excel 2003  ·  9 languages

Returns the price per $100 face value of a discounted security.

🌐 Translations

English PRICEDISC
Deutsch KURSDISAGIO
Français VALEUR.ENCAISSEMENT
Español PRECIO.DESCUENTO
Italiano PREZZO.SCONT
Português PREÇODESC
Nederlands PRIJS.DISCONTO
Polski CENA.DYSK
Русский ЦЕНАСКИДКА

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

PRICEDISC(settlement,maturity,discount,redemption,[basis])

Arguments

settlement (required) — The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.
maturity (required) — The security's maturity date. The maturity date is the date when the security expires.
discount (required) — The security's discount rate.
redemption (required) — The security's redemption value per $100 face value.
basis (optional) — The type of day count basis to use.

▶ Examples

=PRICEDISC(A2,A3,A4,A5,A6)

Related functions

Copied to clipboard