TBILLEQ
Returns the bond-equivalent yield for a Treasury bill.
FinancialFinance & Accounting
What it does
Calculates bond-equivalent yield for T-bill.
Syntax
TBILLEQ(settlement, maturity, discount)
Arguments
settlement(date) — Settlement.maturity(date) — Maturity.discount(number) — Discount rate.
Examples
T-Bill Yield
Calculate yield.
FORMULA
=TBILLEQ(A2, B2, 0.03)
RESULT
0.0309
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Set | Mat |
| 2 | 2023-01-01 | 2023-03-31 |