TBILLEQ Function in Google Sheets

Calculate the bond-equivalent yield for a Treasury bill using the TBILLEQ function.

TBILLEQ Function

The TBILLEQ function in Google Sheets calculates the bond-equivalent yield for a Treasury bill.

Syntax

TBILLEQ(settlement, maturity, discount)
  • 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.
  • discount: The discount rate of the Treasury bill. This is a required parameter.

Examples

  1. Basic Calculation

Calculate the bond-equivalent yield for a Treasury bill:

=TBILLEQ(DATE(2023,1,1), DATE(2023,6,30), 0.05)

This will output the bond-equivalent yield.

Notes

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