The TBILLYIELD function in Google Sheets is used to calculate the yield on a Treasury bill. The function takes the following parameters:
-issueDate: The date on which the Treasury bill was issued
-maturityDate: The date on which the Treasury bill matures
-faceValue: The face value of the Treasury bill
The function returns the yield on the Treasury bill as a percentage.
The syntax of the TBILLYIELD function in Google Sheets is as follows:
=TBILLYIELD(settlement, maturity, pr, redemption, yld)
settlement is the date of the security's original issue maturity is the date on which the security is redeemed pr is the price of the security at redemption redemption is the price per share of the security at maturity yld is the yield of the security
The TBILLYIELD function in Google Sheets can be used to calculate the yield on a Treasury bill. To use the function, you need to input the following information: the face value of the Treasury bill, the issue date, and the maturity date. The function will then calculate the yield on the Treasury bill. An example of how to use the TBILLYIELD function in Google Sheets is shown below.
In the example, the face value of the Treasury bill is $1,000, the issue date is January 1, 2019, and the maturity date is January 15, 2019. The yield on the Treasury bill is 2.00%. To calculate the yield on the Treasury bill, you would input the following into the TBILLYIELD function in Google Sheets: =TBILLYIELD(1000,1/1/2019,1/15/2019).
There are a few instances when you should not use TBILLYIELD in Google Sheets. First, if you are trying to calculate the yield on a bond that does not have a clean price history, you will not be able to use TBILLYIELD. Additionally, if you are looking to calculate the yield on a bond that has been called, TBILLYIELD will not give you an accurate number. Lastly, TBILLYIELD is not effective for municipal bonds.
There are a few formulae that are similar to TBILLYIELD in Google Sheets. One is BONDYIELD, which calculates the yield on a bond. Another is CDYIELD, which calculates the yield on a certificate of deposit. Finally, there is MONEYMARKET, which calculates the yield on a money market account.
