TBILLYIELD

Formulas / TBILLYIELD
Calculate the yield for a Treasury bill.
==TBILLYIELD(settlement,maturity,priceper)
  • settlement - required date of the security
  • maturity - required date when the security expires
  • priceper - required security's price

Examples

  • =TBILLYIELD(A2,A3,A4)

    The TBILLYIELD function is used to calculate the yield of a Treasury bill. The function takes three arguments: the settlement date, the maturity date, and the discount rate. For example, this returns the yield for the Treasury bill using the terms in A2, A3, and A4 (0.0914, or 9.14%).

  • =TBILLYIELD("1/1/2018","4/1/2018",0.06)

    The settlement date is the date at which the investment is made. The maturity date is the date at which the investment matures. The discount rate is the annual rate of interest for the Treasury bill. For example, this returns the yield for a Treasury bill with a settlement date of January 1, 2018, a maturity date of April 1, 2018, and a discount rate of 0.06 (or 6%).

  • =TBILLYIELD("1/1/2018","4/1/2018",0.06)-TBILLYIELD("1/1/2019","4/1/2019",0.07)

    The TBILLYIELD function can be used to compare the yields of different Treasury bills. For example, if a Treasury bill with a settlement date of January 1, 2018, a maturity date of April 1, 2018, and a discount rate of 0.06 has a yield of 0.05 (or 5%), and a Treasury bill with a settlement date of January 1, 2019, a maturity date of April 1, 2019, and a discount rate of 0.07 has a yield of 0.06 (or 6%), then the TBILLYIELD function can be used to compare the yields of the two bills. This returns the difference in yield between the two Treasury bills (0.01, or 1%).


Summary

The TBILLYIELD function is used to calculate the yield for a Treasury bill, providing an efficient and accurate method for investors and financial analysts.

  • The TBILLYIELD function is used to calculate the yield of a Treasury bill in Sourcetable.
  • The arguments required for the TBILLYIELD function are settlement date, maturity date, and price.
  • The settlement date is the date that the Treasury bill is purchased, the maturity date is the date when the Treasury bill matures, and the price is the price of the Treasury bill.

Frequently Asked Questions

What is the TBILLYIELD function?
The TBILLYIELD function is used to calculate the yield of a U.S. Treasury bill, given the settlement date, maturity date, and price per $100 face value.
What are the arguments for the TBILLYIELD function?
The arguments for the TBILLYIELD function are as follows:
  • Settlement: This is the settlement date of the Treasury bill, in the form of a serial number.
  • Maturity: This is the maturity date of the Treasury bill, in the form of a serial number.
  • Price per $100 face value: This is the price of the Treasury bill, per $100 face value.
How do I use the TBILLYIELD function?
To use the TBILLYIELD function, enter the following formula into a cell:
=TBILLYIELD(settlement, maturity, price per $100 face value)
Replace the placeholders with the appropriate values for the settlement date, maturity date, and price per $100 face value. Then press Enter to see the yield of the Treasury bill.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV