TBILLPRICE
Returns the price per $100 face value for a Treasury bill.
FinancialFinance & Accounting
What it does
Calculates T-bill price.
Syntax
TBILLPRICE(settlement, maturity, discount)
Arguments
settlement(date) — Settlement.maturity(date) — Maturity.discount(number) — Discount rate.
Examples
T-Bill Price
Price per $100.
FORMULA
=TBILLPRICE(A2, B2, 0.03)
RESULT
99.25
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Set | Mat |
| 2 | 2023-01-01 | 2023-03-31 |