SheetFX
≡
<< Go back to all functions

TBILLEQ

The TBILLEQ function in Google Sheets is a powerful tool to calculate the equivalent annualized rate of return of a US Treasury Bill based on the discount rate. Whether you're analyzing investments or determining the profitability of a particular treasury bill, the TBILLEQ function simplifies the task. Dive into our comprehensive guide to master its application.

Function Syntax and Parameters

Syntax: TBILLEQ(settlement, maturity, discount)

Parameters:

  • settlement: The settlement date of the treasury bill.
  • maturity: The maturity date of the treasury bill.
  • discount: The discount rate of the treasury bill.

Step-by-Step Tutorial

  1. Using TBILLEQ to calculate the equivalent annualized rate of return:
    • Example: =TBILLEQ("1/1/2021", "6/30/2021", 0.05)
    • Result: 0.2822

Use Cases and Scenarios

  1. Investment Analysis: Calculate the annualized rate of return for a US Treasury Bill.
  2. Financial Planning: Evaluate the profitability of treasury bill investments.
  3. Risk Assessment: Determine the potential returns of different treasury bills.

Related Functions

  • TBILLPRICE: Calculate the price per $100 face value for a US Treasury Bill.
  • TBILLYIELD: Calculate the yield of a US Treasury Bill.

Related Articles