TBILLYIELD
Returns the yield for a Treasury bill.
FinancialFinance & Accounting
What it does
Calculates the yield for a T-bill.
Syntax
TBILLYIELD(settlement, maturity, pr)
Arguments
settlement(date) — Settlement date.maturity(date) — Maturity date.pr(number) — Price per $100.
Examples
T-Bill Yield
Calculate yield.
FORMULA
=TBILLYIELD(A2, B2, 98.5)
RESULT
0.061
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Set | Mat |
| 2 | 2023-01-01 | 2023-03-31 |