How can I use the TBILLYIELD function in Google Sheets?

How can I use the TBILLYIELD function in Google Sheets?

By /

The TBILLYIELD function is a useful tool in Google Sheets that allows users to calculate the yield or return on a Treasury bill investment. To use this function, simply input the settlement date, maturity date, and discount rate of the Treasury bill into the function syntax. The result will be the annualized yield of the investment. This function can be helpful for investors or financial analysts looking to quickly and accurately calculate the yield on Treasury bills.

TBILLYIELD

Calculates the yield of a US Treasury Bill based on price.

Sample Usage

TBILLYIELD(DATE(2010,1,2), DATE(2010,12,31), 98.45)

TBILLYIELD(A2,B2,C2)

Syntax

TBILLYIELD(settlement, maturity, price)

  • settlement – The settlement date of the security, the date after issuance when the security is delivered to the buyer.

  • maturity – The maturity or end date of the security, when it can be redeemed at face or par value.

  • price – The price at which the security is bought.

Notes

  • TBILLYIELD requires the maturity date to be no more than a year after the settlement date.

  • settlement and maturity should be entered using DATE, TO_DATE or other date parsing functions rather than by entering text.

  • TBILLYIELD is equivalent to using YIELDDISC with US Treasury Bill conventions for the absent parameters.

See Also

YIELDDISC: Calculates the annual yield of a discount (non-interest-bearing) security, based on price.

YIELD: Calculates the annual yield of a security paying periodic interest, such as a US Treasury Bond, based on price.

Examples

[wpcc-iframe height=”300″ src=”https://docs.google.com/spreadsheet/pub?key=0As3tAuweYU9QdHU4bXc5R21BLV9aYXNLNXZyMU9uNlE&output=html” width=”500″]

Cite this article

stats writer (2024). How can I use the TBILLYIELD function in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-tbillyield-function-in-google-sheets/

stats writer. "How can I use the TBILLYIELD function in Google Sheets?." PSYCHOLOGICAL SCALES, 29 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-tbillyield-function-in-google-sheets/.

stats writer. "How can I use the TBILLYIELD function in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-tbillyield-function-in-google-sheets/.

stats writer (2024) 'How can I use the TBILLYIELD function in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-tbillyield-function-in-google-sheets/.

[1] stats writer, "How can I use the TBILLYIELD function in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.

stats writer. How can I use the TBILLYIELD function in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.

Download Post (.PDF)

Related terms:

  1. Let’s learn how to do it in Google SheetsHow can we do it in Google Sheets?
  2. How to use Google Sheets to translate text using the Google Translate function?
  3. How can I use the ERF function in Google Sheets to calculate the error function of a given value?
  4. What is the function of the VLOOKUP function in Google Sheets?
  5. “How can I use the MAP function in Google Sheets to transform the values in a range based on a specified function?”
  6. Count Specific Characters in Google SheetsHow to count specific characters in google sheets?
  7. How do I use the PRICEDISC function in Google Sheets?
  8. How do I use the RECEIVED function in Google Sheets?
  9. How can I use the TBILLEQ function in Google Sheets?
  10. How can I use the YIELDMAT function in Google Sheets?
Slide Up
x
PDF
Scroll to Top