TBILLPRICE

Formulas / TBILLPRICE
Calculate the price per $100 face value for a Treasury bill.
TBILLPRICE(settlement, maturity, discount)
  • Settlement - required argument
  • Maturity - required argument
  • Discount - required argument

Examples

  • =TBILLPRICE(4,2.2%,4/20/2021)

    The function can be used to calculate the price of a Treasury bill. For example, if you wanted to calculate the price of a Treasury bill with a term of 4 months, a yield of 2.2%, and a settlement date of April 20, 2021, you could use the formula above.

  • =TBILLPRICE(A2,A3,A4)

    You can also use the function to calculate the price of a Treasury bill in Sourcetable. For example, if you have the term of the bill in cell A2, the yield in cell A3, and the settlement date in cell A4, you could use the preceding formula to calculate the price of the bill.

  • =TBILLPRICE(6,1.7%,DATE(2021,6,15))

    The function can also be used with other Sourcetable functions. For example, if you wanted to calculate the price of a Treasury bill with a term of 6 months, a yield of 1.7%, and a settlement date of June 15, 2021, you could use the DATE function to get the date in the proper format and then use the TBILLPRICE function to calculate the price of the bill.

Summary

The TBILLPRICE function calculates the price per $100 face value for a Treasury bill based on the settlement, maturity, and discount arguments.

  • The TBILLPRICE function calculates the price per $100 face value for a Treasury bill.
  • It is important to note that the TBILLPRICE function only works for Treasury bills and not other types of securities.
  • The TBILLPRICE function is a useful tool for investors who are looking to track the prices of Treasury bills.
  • The function takes two arguments: the settlement date and the maturity date.
  • It is recommended to use the TBILLPRICE function in conjunction with other financial functions in order to get a complete picture of the Treasury bill.


Frequently Asked Questions

What are the arguments for the TBILLPRICE function?
The arguments for the TBILLPRICE function are settlement, maturity, and discount.
Are the arguments required?
Yes, all three arguments are required.
What is the settlement argument?
The settlement argument is the date when the investment is made.
What is the maturity argument?
The maturity argument is the date when the investment will mature.
What is the discount argument?
The discount argument is the rate of return that the investor will receive.

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