TBILLPRICE Function in Google Sheets

Calculate the price per $100 face value for a Treasury bill using the TBILLPRICE function.

TBILLPRICE Function

The TBILLPRICE function in Google Sheets calculates the price per $100 face value for a Treasury bill.

Syntax

TBILLPRICE(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 price for a Treasury bill:

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

This will output the price per $100 face value.

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.
  • TBILLYIELD: Calculate the yield of a Treasury bill.