TBILLEQ function
TBILLEQ returns the bond-equivalent yield of a treasury bill. It converts the bill's discount rate into a yield comparable with bonds, on an annual basis.
Example
Read it as a sentence: find the bond-equivalent yield of a Treasury bill from January 1, 2024 to April 1, 2024 at a 4 percent discount rate, which gives 0.040969805814345.
A
B
C
D
1
0.040969805814345
2
3
Syntax
TBILLEQ(settlement, maturity, discount)
-
settlement(required) - Date the security is bought (after issue, before maturity).
-
maturity(required) - Maturity date, no more than one year after settlement.
-
discount(required) - Treasury bill discount rate.
Returns: Bond-equivalent yield of a treasury bill.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=TBILLEQ(DATE(2024,3,31),DATE(2024,6,1),0.0914) | 0.094151494 | Typical |
=TBILLEQ(DATE(2024,3,31),DATE(2025,3,31),0.0914) | 0.099651552 | Maturity exactly 1 year |
=TBILLEQ("2024-03-31","2024-06-01",0.0914) | 0.094151494 | Text dates |
=TBILLEQ(DATE(2024,3,31),DATE(2024,6,1),"0.0914") | 0.094151494 | Text number value |
=TBILLEQ(DATE(2024,3,31),{45444,45500},0.0914) | 0.094151494 | Spill |
=TBILLEQ(DATE(2024,3,31),DATE(2025,4,1),0.0914) | #NUM! | Maturity > 1 year |
=TBILLEQ(DATE(2024,3,31),DATE(2024,3,31),0.0914) | #NUM! | Settlement = maturity |
=TBILLEQ(DATE(2024,6,1),DATE(2024,3,31),0.0914) | #NUM! | Settlement after maturity |
Watch out for
- Maturity must be within a year of settlement or you get #NUM!.
Where it works
- Excel
- TBILLEQ is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Financial functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .