top of page
Search


MS Excel: PRICEDISC function to determine price with discount rate
In fixed-income analysis, not all securities pay periodic interest. Instruments like Treasury bills, commercial paper, and zero-coupon bonds are issued at a discount and redeemed at full face value. To determine their price based on a given discount rate, Excel provides the PRICEDISC function.
This article explores the PRICEDISC function from a professional finance perspective, including its purpose, structure, usage examples, and best practices.

Fakhriddinbek
Apr 292 min read
bottom of page