TBILLYIELDfunction calculates the yield of a Treasury bill based on its price. It returns the annual yield of a Treasury bill (a type of short-term government security), based on its price, maturity, and settlement dates. This function is commonly used in financial analysis to compare the yield of Treasury bills with other types of investments.
- How to use
- Examples of using
TBILLYIELDformula not working?
- Similar formulas to
TBILLYIELD formula with the syntax shown below, it has 3 required parameters:
- settlement (required):
The settlement date of the Treasury bill, represented as a date or a reference to a cell containing a date value. The settlement date is the date on which the buyer will take possession of the Treasury bill.
- maturity (required):
The maturity date of the Treasury bill, represented as a date or a reference to a cell containing a date value. The maturity date is the date on which the Treasury bill will be redeemed.
- price (required):
The price per $100 face value of the Treasury bill, represented as a number or a reference to a cell containing a number value.
ExamplesHere are a few example use cases that explain how to use the
TBILLYIELDformula in Google Sheets.
Calculating the yield of a Treasury bill
To calculate the yield of a Treasury bill, you can use the
TBILLYIELD function by specifying the settlement date, maturity date, and price of the bill.
Comparing Treasury bill yields
You can use the
TBILLYIELD function to compare the yields of different Treasury bills, or to compare Treasury bills with other types of investments, such as stocks or bonds.
Analyzing short-term government securities
TBILLYIELD function is commonly used in financial analysis to analyze short-term government securities, such as Treasury bills, and to make investment decisions based on their yields.
TBILLYIELDnot working? Here are some common mistakes people make when using the
TBILLYIELDGoogle Sheets Formula:
Incorrect date formatting
Make sure that the dates for settlement and maturity are formatted correctly, using the DATE function if necessary.
Invalid settlement or maturity date
Check that the settlement and maturity dates are valid, and that the maturity date is after the settlement date.
Incorrect price formatting
Ensure that the price is formatted correctly, using the appropriate decimal separator and currency symbol.
Make sure that all three arguments (settlement, maturity, and price) are included in the formula.
Incorrect argument order
Ensure that the arguments are in the correct order (settlement, maturity, price).
The following functions are similar to
TBILLYIELD or are often used with it in a formula:
TRENDformula is used to calculate future values based on historical data. It fits a straight line (using the method of least squares) to the arrays specified in the
known_data_xparameters and then uses that line to calculate new y-values for the array specified in the
bis set to TRUE, then the calculation will include the y-intercept of the line. This formula is commonly used in forecasting and trend analysis.
FORECASTfunction in Google Sheets is a statistical function that predicts a future value along a linear trend. It returns the predicted value for a chosen x value based on the linear regression of a set of known x and y values. This function is commonly used in finance to predict future values.
The YIELD function calculates the yield of a security that pays periodic interest. The yield is the annualized percentage rate returned on the bond, assuming the bond is held until maturity. This function is commonly used in finance and investment analysis.
PRICEfunction calculates the price per $100 face value of a security that pays periodic interest. It is commonly used to determine the current value of a bond. The function takes the settlement date, maturity date, annual coupon rate, yield, redemption value, and frequency of coupon payments as input. It returns the price of the security, which is the sum of the present value of the coupon payments and the present value of the redemption value.
DURATIONfunction calculates the Macauley duration of a security paying periodic interest, such as a US Treasury Bond, based on expected yield. The Macauley duration is a measure of the sensitivity of the price of the security to changes in interest rates. This function is commonly used in finance and investment analysis.
You can learn more about the
TBILLYIELD Google Sheets function on Google Support.