TBILLYIELD
Formulas / TBILLYIELDCalculate 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?
What are the arguments for the TBILLYIELD function?
- 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?
=TBILLYIELD(settlement, maturity, price per $100 face value)
