Functions
PRICEDISC
Price of discounted security
Try it
When to use it
When should I use PRICEDISC?
Use PRICEDISC to find the price of a discounted (zero-coupon) security given its discount rate — typical for Treasury bills and short-term instruments that don't pay periodic coupons.
Used in
Syntax
PRICEDISC(settlement, maturity, discount, redemption, [basis])Examples
=PRICEDISC(DATE(2010,1,2),DATE(2039,12,31),3,100) // => -8899.166666666668
=PRICEDISC(DATE(2010,1,2),DATE(2039,12,31),3,100,1) // => -8898.356164383562