# Google Sheets TBILLPRICE Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/tbillprice-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 TBILLPRICE function calculates the price of a Treasury bill based on its discount rate, maturity date, and face value. ``` TBILLPRICE(settlement, maturity, discount) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the TBILLPRICE you need in plain EnglishGenerate Formula ## Parameters **`settlement`**:\ The date on which the Treasury bill is purchased. This is the date when the buyer takes ownership of the bill. **`maturity`**:\ The date on which the Treasury bill matures and the face value is paid to the holder. This is the date when the bill expires. **`discount`**:\ The discount rate of the Treasury bill expressed as a decimal. This represents the difference between the face value and the purchase price of the bill. ## What is a TBILLPRICE? The *TBILLPRICE* function in Google Sheets is a financial function used to calculate the price of a Treasury bill (T-bill) based on its face value, discount rate, and the number of days until maturity. This function is particularly useful for investors and financial analysts who need to evaluate the current market price of T-bills for investment decisions. In simpler terms, TBILLPRICE allows you to determine how much you would pay for a T-bill given its characteristics, helping you assess the potential return on investment. ## A Practical Example Imagine you are analyzing various T-bills for investment purposes, and you have the following data: ### T-Bill Data Table: | Face Value | Discount Rate | Days to Maturity | | - | - | - | | 1000 | 0.02 | 30 | | 1000 | 0.015 | 60 | | 1000 | 0.025 | 90 | You want to calculate the price of each T-bill based on the provided data. ## TBILLPRICE Formula To achieve this, you would use the TBILLPRICE function as follows: ``` =TBILLPRICE(A2, B2, C2) ``` In this formula: - `A2` is the cell containing the Face Value of the T-bill. - `B2` is the cell containing the Discount Rate. - `C2` is the cell containing the Days to Maturity. ## Result of the Formula When you apply the TBILLPRICE formula to the T-Bill Data Table, the output would look like this: | Face Value | Discount Rate | Days to Maturity | Price | | - | - | - | - | | 1000 | 0.02 | 30 | 998.33 | | 1000 | 0.015 | 60 | 996.88 | | 1000 | 0.025 | 90 | 993.75 | The prices calculated indicate how much you would pay for each T-bill based on the given discount rates and days to maturity. ## Why Use TBILLPRICE? TBILLPRICE is beneficial because it simplifies the process of evaluating T-bills, allowing investors to quickly assess the market price based on essential parameters. This function eliminates the need for manual calculations and provides a straightforward way to analyze potential investments. ## Key Takeaways: - **TBILLPRICE**: A financial function that calculates the price of a Treasury bill based on its face value, discount rate, and days to maturity. - **Investment Analysis**: Essential for investors looking to evaluate T-bills for potential returns. - **Efficiency**: Streamlines the calculation process, saving time and reducing errors in financial analysis. - **Common Use Cases**: Ideal for financial analysts, investors, and anyone involved in government securities trading. TBILLPRICE is an essential function for anyone working with Treasury bills, providing a powerful way to enhance investment analysis and decision-making capabilities. Happy investing! ## Example use case You have a table with investment details, including the face value and days to maturity of Treasury bills. By using the TBILLPRICE formula, you can quickly calculate the price of each T-bill, enabling efficient investment analysis and decision-making. ## 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 Autofit In Google Sheets](https://betteranalyst.com/google-sheets/how-to-autofit-in-google-sheets) - [How To Calculate Percentage In Google Sheets](https://betteranalyst.com/google-sheets/how-to-calculate-percentage-in-google-sheets) - [How To Combine Two Columns In Google Sheets](https://betteranalyst.com/google-sheets/how-to-combine-two-columns-in-google-sheets) - [How To Copy Formula In Google Sheets](https://betteranalyst.com/google-sheets/how-to-copy-formula-in-google-sheets) - [How To Count Unique Values In Google Sheets](https://betteranalyst.com/google-sheets/how-to-count-unique-values-in-google-sheets) - [How To Create A Pivot Table In Google Sheets](https://betteranalyst.com/google-sheets/how-to-create-a-pivot-table-in-google-sheets) - [How To Divide In Google Sheets](https://betteranalyst.com/google-sheets/how-to-divide-in-google-sheets) - [How To Enable Macros In Google Sheets](https://betteranalyst.com/google-sheets/how-to-enable-macros-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.