Functions
YIELDDISC
Annual yield for discounted security
Try it
When to use it
When should I use YIELDDISC?
Use YIELDDISC to compute the annual yield of a discounted security (one that pays no coupon and is sold below face value) — common for Treasury bills, commercial paper, and other short-term discount instruments.
Used in
Syntax
YIELDDISC(settlement, maturity, pr, redemption, [basis])Examples
=YIELDDISC(DATE(2010,1,2),DATE(2010,12,31),98.45,100) // => 0.01578788774755221
=YIELDDISC(DATE(2010,1,2),DATE(2010,12,31),98.45,100,2) // => 0.015613916532703151