TBILLEQ

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

Video field
Financial

TBILLEQ is a function in Google Sheets that calculates the equivalent annualized yield of a US Treasury bill, given its settlement date, maturity date, and discount rate. The function returns a decimal number representing the annualized yield of the Treasury bill as a percentage.

The settlement date is the date on which the Treasury bill is purchased, while the maturity date is the date on which it matures. The discount rate is the rate at which the Treasury bill is sold at a discount to its face value.

The TBILLEQ function uses an iterative method to calculate the yield, which means that it will keep calculating until it finds a solution that is accurate within a certain tolerance. This function is useful for investors who want to compare the yields of different Treasury bills and make informed investment decisions.

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes no code required!

Client Portal | Internal Tools | Web App Builder | Free Website Builder Made with Softr