Excel provides three add-in financial functions for analyzing United States Treasury bills: TBILLEQ, which calculates the bond-equivalent yields; TBILLPRICE, which calculates the price of a Treasury bill; and TBILLYIELD, which calculates the yield on a Treasury bill.

The Treasury bill functions use a set of standard arguments: the settlement date, the maturity date, the discount rate, and the price. The settlement date specifies the date the bill is settled, or purchased. The maturity date specifies the date the bill matures, or expires. (You may enter these date arguments either as text strings enclosed in quotation marks or as serial date values.) The discount rate specifies the annual discount rate used to price the bill. The price specifies the price per $100 of face value.

NOTE: Excel uses only the integer portion of the arguments you supply to the Treasury bill functions. If you enter an argument with decimal values, Excel truncates the argument to just its integer component.

All three functions return an error value if the settlement or maturity date isnt a valid date, if the discount rate is less than zero, if the settlement date falls after the maturity date, or if the maturity date isnt within one year of the settlement date.

TBILLEQ

The TBILLEQ function calculates the bond-equivalent yield for a Treasury bill given its settlement date, maturity date, and a discount rate. It uses the following syntax:

TBILLEQ(settlement,maturity,discount)

For example, if you want to calculate the equivalent bond yield on a Treasury bill if the settlement date is April 8, 2001, the maturity date is July 15, 2001, and the discount rate is 3%, you use the following formula:

=TBILLEQ(4/8/2001,7/15/2001,.03)

The function returns the value .03067, or 3.067%.

TBILLPRICE

The TBILLPRICE function calculates the price per $100 of face value for a Treasury bill given the settlement date, the maturity date, and the discount rate. It uses the following syntax:

TBILLPRICE(settlement,maturity,rate)

For example, if you want to calculate the price on a Treasury bill if the settlement date is April 8, 2001, the maturity date is July 15, 2001, and the discount rate is 3%, you use the following formula:

=TBILLPRICE(4/8/2001,7/15/2001,.03)

The function returns the value 99.1833, which means that you would pay $99.1833 for each $100 of Treasury bill face value.

TBILLYIELD

The TBILLYIELD function calculates the yield delivered by a Treasury bill given the settlement date, maturity date, and price. It uses the following syntax:

TBILLYIELD(settlement,maturity,price)

For example, if you want to calculate the yield on a Treasury bill if the settlement date is April 8, 2001, the maturity date is July 15, 2001, and the price is 99.1833, you use the following formula:

=TBILLYIELD(4/8/2001,7/15/2001,99.1833)

The function returns the value 0.0302482, which is equivalent to 3.0248%.