=TBILLYIELD(settlement, maturity, discount)One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward.
Need more than a single TBILLYIELD formula? Try our free AI for Excel — it reads your entire spreadsheet, answers questions in plain English, and builds charts and analysis in the same chat.
settlement:
The date when the investment is purchased or the security is settled. This must be a valid Excel date.
maturity:
The date when the investment matures or the security expires. This must also be a valid Excel date and must be later than the settlement date.
discount:
The discount rate of the security expressed as a decimal. This represents the difference between the face value and the purchase price of the security.
The TBILLYIELD function in Excel is a specialized tool used to calculate the yield of a Treasury bill (T-bill) based on its face value, purchase price, and the number of days until maturity. This function is particularly useful for investors and financial analysts who need to evaluate the return on investment for T-bills.
In simpler terms, the TBILLYIELD function helps you determine the yield percentage of a T-bill, allowing you to assess its profitability.
Imagine you are analyzing a T-bill investment, and you have the following data in an Excel spreadsheet:
| Face Value | Purchase Price | Days to Maturity |
|---|---|---|
| 10000 | 9800 | 30 |
| 5000 | 4900 | 60 |
| 15000 | 14500 | 90 |
| 20000 | 19500 | 120 |
| 25000 | 24000 | 180 |
You want to find the yield for the T-bill with a face value of $10,000, a purchase price of $9,800, and 30 days to maturity.
To calculate the yield for this T-bill, you would use the TBILLYIELD formula as follows:
=TBILLYIELD(B2, A2, C2)When you apply the formula, it calculates the yield for the specified T-bill. The output would be:
| T-Bill Yield |
|---|
| 0.0667 |
Here, the yield is calculated based on the provided values, indicating the percentage return on the investment.
The TBILLYIELD function is particularly useful for investors who want to evaluate the profitability of T-bills quickly. It allows you to make informed investment decisions by providing a clear picture of the expected returns.
Understanding how to use the TBILLYIELD function can significantly enhance your investment analysis capabilities in Excel, enabling you to make data-driven decisions regarding T-bill investments.
Happy calculating!
You have a table where Column A contains the face value of various Treasury bills and Column B contains their purchase prices. You can use the TBILLYIELD function to calculate the annualized yield of each Treasury bill based on its face value and purchase price. This allows for efficient assessment of investment returns on short-term government securities, helping investors make informed decisions about their fixed-income portfolios without needing to perform complex yield calculations manually.
Beyond the TBILLYIELD function: Better Analyst is a full Excel AI that goes well past individual formulas. Upload any spreadsheet and ask questions in plain English — you'll get formulas, data analysis, and charts back in seconds. It's a free AI Excel assistant that works with any .xlsx, .xls, or .csv file — no plugins, no Microsoft 365 required.
Don't have a spreadsheet yet? Use our free AI spreadsheet generator to turn a text prompt into a downloadable Excel file — a full AI Excel sheet maker that builds headers, columns, and formulas from your description.
Create a free account for formula help, explanations, and spreadsheet analysis. Usage limits depend on your plan.
Browse our complete library of Excel formula guides
Compare your options
Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose.
AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.