Calculates the price of a discount (non-interest-bearing) security, based on expected yield.

How To Use in Sheets

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

External Links

Excel PRICEDISC function - how to use PRICEDISC function

The Excel Pricedisc function calculates the price, per $100 face value of a discounted security.

0Better Sheets Tutorials

No videos yet. Stay tuned!