# Google Sheets YIELDDISC Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/yielddisc-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 YIELDDISC function calculates the annual yield of a discounted security based on its face value, purchase price, and maturity date. ``` YIELDDISC(settlement, maturity, price, redemption, [day_count_convention]) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the YIELDDISC you need in plain EnglishGenerate Formula ## Parameters **`settlement`**:\ The date on which the security is purchased or settled. **`maturity`**:\ The date on which the security matures or expires. **`price`**:\ The price of the security expressed as a percentage of its face value. **`redemption`**:\ The redemption value of the security, typically its face value. **`[day_count_convention]`**:\ An optional parameter that specifies the day count convention to use for the calculation. ## What is YIELDDISC? The *YIELDDISC* function in Google Sheets is a financial function used to calculate the annual yield of a discounted security, such as a Treasury bill. This function is particularly useful for investors who want to assess the return on investment for securities that do not pay periodic interest but are sold at a discount to their face value. In simpler terms, YIELDDISC helps you determine how much return you can expect from a discounted security based on its purchase price, face value, and the time until maturity. ## A Practical Example Imagine you are evaluating a Treasury bill with the following details: ### Treasury Bill Details: | Face Value | Purchase Price | Maturity Date | Settlement Date | | - | - | - | - | | 1000 | 950 | 2024-12-31 | 2024-01-01 | You want to calculate the annual yield of this Treasury bill. ## YIELDDISC Formula To achieve this, you would use the YIELDDISC function as follows: ``` =YIELDDISC(A2, B2, C2, D2) ``` In this formula: - `A2` is the cell containing the Face Value of the Treasury bill. - `B2` is the cell containing the Purchase Price. - `C2` is the cell containing the Maturity Date. - `D2` is the cell containing the Settlement Date. ## Result of the Formula When you apply the YIELDDISC formula to the Treasury bill details, the output would give you the annual yield as a percentage. For example, if the calculated yield is 5.26%, it would indicate that the investor can expect a return of 5.26% on the investment over the course of the year. ## Why Use YIELDDISC? YIELDDISC is beneficial because it provides a straightforward way to evaluate the potential return on discounted securities. This function simplifies the process of yield calculation, allowing investors to make informed decisions about their investments without needing complex calculations. ## Key Takeaways: - **YIELDDISC**: A financial function that calculates the annual yield of a discounted security. - **Investment Assessment**: Useful for evaluating Treasury bills and other similar securities. - **Simplified Calculation**: Eliminates the need for complex formulas, making it easier for investors to assess returns. - **Common Use Cases**: Ideal for financial analysts, investors, and anyone involved in the trading of discounted securities. YIELDDISC is an essential function for anyone working with financial data in Google Sheets, providing a powerful way to enhance investment analysis and decision-making capabilities. Happy investing! ## Example use case You have a table with discount rates in Column A and corresponding dates in Column B. Use YIELDDISC to calculate the annual yield of a discount bond based on its face value and purchase price, enabling quick financial analysis for 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 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) - [How To Sort In Google Sheets](https://betteranalyst.com/google-sheets/how-to-sort-in-google-sheets) - [How To Split Cells In Google Sheets](https://betteranalyst.com/google-sheets/how-to-split-cells-in-google-sheets) - [How To Strikethrough In Google Sheets](https://betteranalyst.com/google-sheets/how-to-strikethrough-in-google-sheets) - [How To Subtract In Google Sheets](https://betteranalyst.com/google-sheets/how-to-subtract-in-google-sheets) - [How To Transpose Data In Google Sheets](https://betteranalyst.com/google-sheets/how-to-transpose-data-in-google-sheets) - [How To Unhide Columns In Google Sheets](https://betteranalyst.com/google-sheets/how-to-unhide-all-columns-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.