Functions
DISC
Discount rate for a security
Try it
When to use it
When should I use DISC?
Use DISC to calculate the annualised discount rate of a zero-coupon or discounted security given its purchase price and redemption value — common for Treasury bills and commercial paper.
Used in
Syntax
DISC(settlement, maturity, pr, redemption, [basis])Examples
=DISC(DATE(2010,1,2),DATE(2039,12,31),90,100) // => 0.003333642003889249
=DISC(DATE(2010,1,2),DATE(2039,12,31),90,100,1) // => 0.0033339422725611983