# Google Sheets TBILLYIELD Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/tbillyield-function - Author: Better Analyst Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation. [Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst) The TBILLYIELD function calculates the annualized yield of a Treasury bill based on its discount rate and days to maturity. ``` TBILLYIELD(settlement, maturity, price) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the TBILLYIELD you need in plain EnglishGenerate Formula ## Parameters **`settlement`**:\ The date on which the investment is purchased or the security is settled. This must be a valid date. **`maturity`**:\ The date on which the investment matures or the security expires. This must also be a valid date and should be later than the settlement date. **`price`**:\ The price of the investment expressed as a percentage of the face value. This is typically a numeric value representing the price at which the investment is bought. ## What is a TBILLYIELD? The *TBILLYIELD* function in Google Sheets is a financial formula 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 want to assess the return on investment for T-bills, which are short-term government securities. In simpler terms, TBILLYIELD helps you determine how much profit you can expect to earn from a T-bill investment, expressed as an annualized percentage. ## A Practical Example Imagine you are analyzing a T-bill investment with the following details: - **Face Value**: $10,000 - **Purchase Price**: $9,800 - **Days to Maturity**: 30 You want to calculate the yield of this T-bill to understand its profitability. ## TBILLYIELD Formula To achieve this, you would use the TBILLYIELD function as follows: ``` =TBILLYIELD(settlement, maturity, rate, pr) ``` In this formula: - `settlement` is the date when the T-bill is purchased. - `maturity` is the date when the T-bill matures. - `rate` is the annualized discount rate of the T-bill. - `pr` is the purchase price of the T-bill. For our example, assuming the T-bill matures in 30 days, the formula would look like this: ``` =TBILLYIELD(TODAY(), TODAY() + 30, 0, 9800) ``` ## Result of the Formula When you apply the TBILLYIELD formula, it will return the yield of the T-bill as a percentage. For instance, if the yield calculated is 3.00%, it indicates that the annualized return on the investment is 3.00%. ## Why Use TBILLYIELD? TBILLYIELD is beneficial because it provides a straightforward way to evaluate the profitability of T-bill investments. It helps investors make informed decisions by comparing the yields of different T-bills or other investment options. Additionally, it allows for quick calculations without the need for complex financial modeling. ## Key Takeaways: - **TBILLYIELD**: A financial function that calculates the yield of a Treasury bill based on its face value, purchase price, and days to maturity. - **Investment Analysis**: Useful for assessing the profitability of T-bill investments and comparing them with other investment opportunities. - **Simplicity**: Provides a quick and easy way to calculate yields without complex formulas or models. - **Common Use Cases**: Ideal for investors, financial analysts, and anyone involved in government securities trading. TBILLYIELD is an essential function for anyone working with T-bills, providing a powerful way to enhance investment analysis and decision-making capabilities. Happy investing! ## Example use case You have a table with bond prices in Column A and their corresponding maturities in Column B. By using the TBILLYIELD formula, you can calculate the yield of each bond based on its price and maturity, enabling informed investment decisions. ## Need more help with Google Sheets formulas? Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Google Sheets how-to guides - [How To Make A Pie Chart In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-pie-chart-in-google-sheets) - [How To Make A Table In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-table-in-google-sheets) - [How To Merge Cells In Google Sheets](https://betteranalyst.com/google-sheets/how-to-merge-cells-in-google-sheets) - [How To Multiply In Google Sheets](https://betteranalyst.com/google-sheets/how-to-multiply-in-google-sheets) - [How To Password Protect An Google Sheets File](https://betteranalyst.com/google-sheets/how-to-password-protect-an-google-sheets-file) - [How To Remove Blank Rows In Google Sheets](https://betteranalyst.com/google-sheets/how-to-remove-blank-rows-in-google-sheets) - [How To Remove Duplicates In Google Sheets](https://betteranalyst.com/google-sheets/how-to-remove-duplicates-in-google-sheets) - [How To Separate Names In Google Sheets](https://betteranalyst.com/google-sheets/how-to-separate-names-in-google-sheets) ## Explore all Google Sheets formulas Browse our complete library of Google Sheets formula guides Compare your options ## Decide with evidence, not a sales pitch. Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose. 1. [01ChatGPTOpen a balanced comparison prompt in ChatGPT.](https://chatgpt.com/?prompt=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 2. [02ClaudeOpen the same research prompt in Claude.](https://claude.ai/new?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 3. [03PerplexityResearch the comparison with linked web sources.](https://www.perplexity.ai/search?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.