TBILLYIELD Function in Google Sheets

Calculate the yield of a Treasury bill using the TBILLYIELD function.

TBILLYIELD Function

The TBILLYIELD function in Google Sheets calculates the yield of a Treasury bill.

Syntax

TBILLYIELD(settlement, maturity, price)
  • settlement: The settlement date of the Treasury bill. This is a required parameter.
  • maturity: The maturity date of the Treasury bill. This is a required parameter.
  • price: The price of the Treasury bill. This is a required parameter.

Examples

  1. Basic Calculation

Calculate the yield for a Treasury bill:

=TBILLYIELD(DATE(2023,1,1), DATE(2023,6,30), 98)

This will output the yield.

Notes

  • The settlement date must be before the maturity date.
  • The function assumes a 360-day year.
  • TBILLEQ: Calculate the bond-equivalent yield for a Treasury bill.
  • TBILLPRICE: Calculate the price of a Treasury bill.