ReferenceFunctionsFinancial Functions
TBILLPRICE
TBILLPRICE: Returns price per $100 face value for a US Treasury bill.
Summary
TBILLPRICE computes the dollar price from a discount rate using
price = 100 * (1 - discount * DSM / 360).
Remarks
- Date inputs are spreadsheet serial dates;
maturitymust be aftersettlement. - The T-bill must mature within one year of settlement (DSM <= 365).
discountis a decimal discount rate; must be positive.- Returns
#NUM!for invalid dates, non-positive discount, or DSM out of range.
Examples
Price a 91-day T-bill
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
99.03944444444444
Related functions
FAQ
What does TBILLPRICE quote?
The result is the dollar price per 100 of face value, following Excel's Treasury-bill convention.
Runtime metadata
Category
Financial
Signature
TBILLPRICE(arg1: Number, arg2: Number, arg3: Number)Arity
min 3, max 3
Arguments
arg1Number · Scalar · coercion NumberLenientText
arg2Number · Scalar · coercion NumberLenientText
arg3Number · Scalar · coercion NumberLenientText
Caps
PURE
Source