Formualizer Docs
ReferenceFunctionsFinancial Functions

TBILLYIELD

TBILLYIELD: Returns the yield for a US Treasury bill.

Summary

TBILLYIELD computes the discount-rate yield from a T-bill's price using yield = (100 - price) / price * (360 / DSM).

Remarks

  • Date inputs are spreadsheet serial dates; maturity must be after settlement.
  • The T-bill must mature within one year of settlement (DSM <= 365).
  • price is the dollar price per $100 face value; must be positive.
  • Returns #NUM! for invalid dates, non-positive price, or DSM out of range.

Examples

Yield from quoted T-bill price
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.060244324203715074

FAQ

Is TBILLYIELD the same as bond-equivalent yield?

No. TBILLYIELD gives the bill's discount-rate yield, while TBILLEQ converts that pricing into a bond-equivalent yield.

Runtime metadata

Category

Financial

Signature

TBILLYIELD(arg1: Number, arg2: Number, arg3: Number)

Arity

min 3, max 3

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

arg3

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/financial/bonds.rs

TBILLPRICE

TBILLPRICE: Returns price per $100 face value for a US Treasury bill.

XIRR

XIRR: Calculates annualized internal rate of return for irregularly dated cash flows.

On this page

SummaryRemarksExamplesRelated functionsFAQIs TBILLYIELD the same as bond-equivalent yield?Runtime metadata