ProductSolutionsTemplatesResources

TBILLYIELD

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

Video field
Financial

TBILLYIELD is a financial function in Google Sheets that calculates the yield of a US Treasury Bill based on its settlement date, maturity date, and price. The yield is expressed as an annual percentage rate (APR).

The function syntax is:

TBILLYIELD(settlement, maturity, price)

settlement: The settlement date of the US Treasury Bill, which is the date on which the buyer takes ownership of the security.

maturity: The maturity date of the US Treasury Bill, which is the date on which the security reaches its maturity and the investor receives the face value of the bill.

price: The purchase price of the US Treasury Bill, per $100 face value.

The TBILLYIELD function assumes that the US Treasury Bill has a par value of $100. It also assumes that the actual number of days between the settlement date and maturity date is used to calculate the yield, based on a 360-day year.

Visit Official Docs

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!