Functions
TBILLEQ
T-bill bond-equivalent yield
Try it
When to use it
When should I use TBILLEQ?
Use TBILLEQ to convert a T-bill discount rate into its bond-equivalent yield — allowing fair comparison of T-bill returns with coupon-bearing bonds quoted on a 365-day basis.
Used in
Syntax
TBILLEQ(settlement, maturity, discount)Examples
=TBILLEQ(DATE(2010,1,2),DATE(2010,12,31),0.09) // => 0.09797107538773103