ExcelFlux

TBILLEQ function

the bond-equivalent yield for a Treasury bill.

Financial

Where can you use it?

Budgeting, treasury and finance teams. When reviewing a scenario with cash flows, payment periods and rate assumptions, compare the input and output units in the example.

Scenario in the workbook

Convert a Treasury bill discount rate to its bond-equivalent yield. The examples use short maturities.

A worked example from the workbook

RowAB
6First inputSecond input
74602346203
84602346143
94602346113
Record 1
=TBILLEQ(A7,B7,0.1)

Expected result0.1067251462

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=TBILLEQ(A7,B7,0.1)
Turkish Excel · tr-TR
=HTAHEŞ(A7;B7;0,1)

Worked examples

Convert a Treasury bill discount rate to its bond-equivalent yield. The examples use short maturities.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B
6 First input Second input
7 46023 46203
8 46023 46143
9 46023 46113
Case Formula Expected result
Record 1 =TBILLEQ(A7,B7,0.1) 0.1067251462
Record 2 =TBILLEQ(A8,B8,0.1) 0.1048850575
Record 3 =TBILLEQ(A9,B9,0.1) 0.103988604
Microsoft Excel reference