Google Sheets

TBILLYIELD: Google Sheets Formulae Explained

How do you use TBILLYIELD in Google Sheets?

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.

What is the syntax of TBILLYIELD in Google Sheets?

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

What is an example of how to use TBILLYIELD in Google Sheets?

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).

When should you not use TBILLYIELD in Google Sheets?

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.

What are some similar formulae to TBILLYIELD in Google Sheets?

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.

Move beyond 

Google Sheets

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.