How can I use the TBILLEQ function in Google Sheets?

How can I use the TBILLEQ function in Google Sheets?

By /

The TBILLEQ function in Google Sheets is a financial formula that calculates the equivalent annual interest rate for a US Treasury Bill. This function takes into account the purchase price, maturity date, and settlement date of the Treasury Bill, and returns the annualized rate at which the bill is discounted. To use this function, simply input the required values and the formula will automatically calculate the equivalent annual interest rate. This feature is useful for individuals and businesses alike, as it allows for quick and accurate calculation of the return on investment for US Treasury Bills.

TBILLEQ

Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate.

Sample Usage

TBILLEQ(DATE(2010,1,2), DATE(2010,12,31), .09)

TBILLEQ(A2,B2,C2)

Syntax

TBILLEQ(settlement, maturity, discount)

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

  • discount – The discount rate of the bill at time of purchase.

Notes

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

See Also

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

TBILLPRICE: Calculates the price of a US Treasury Bill based on discount rate.

Examples

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

Cite this article

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

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

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

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

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

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

Download Post (.PDF)

Related terms:

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