# Excel RECEIVED Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/excel/received-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 RECEIVED formula calculates the present value of a bond's cash flows using issue number, dates, and discount rate. ```excel =RECEIVED(issue_num, issue_date, maturity_date, discount_rate, [basis]) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the RECEIVED you need in plain EnglishGenerate Formula Need more than a single RECEIVED formula? Try our free [AI for Excel](https://betteranalyst.com/excel-ai) — it reads your entire spreadsheet, answers questions in plain English, and builds charts and analysis in the same chat. ## Parameters **`issue_num`**:\ The number of the security that you want to evaluate, typically represented as a numeric value. **`issue_date`**:\ The date when the security was issued, represented as a date value. **`maturity_date`**:\ The date when the security matures, represented as a date value. **`discount_rate`**:\ The annual discount rate for the security, represented as a decimal value. **`basis`**:\ (Optional) The type of day count basis to use for the calculation, represented as a numeric value. If omitted, Excel uses the default basis of 0 (US (NASD) 30/360). ## What is a RECEIVED Formula in Excel? The *RECEIVED* function in Excel is a financial function that calculates the amount of money received from an investment based on the interest rate, the number of periods, and the present value of the investment. It helps you determine how much you will receive at the end of a specified period given a certain interest rate. In simpler terms, the RECEIVED function assists you in understanding the returns on your investments, making it easier to evaluate financial decisions. ## A Practical Example Imagine you are evaluating an investment in a bond, and you have the following data in an Excel spreadsheet: ### Investment Data Table: | Investment | Present Value | Interest Rate | Periods | | - | - | - | - | | Bond A | 1000 | 5% | 3 | | Bond B | 1500 | 4% | 5 | | Bond C | 2000 | 6% | 2 | You want to find out how much you will receive from Bond A after 3 periods at a 5% interest rate. ## RECEIVED Formula To calculate the amount received from Bond A, you would use the RECEIVED formula as follows: ```excel =RECEIVED(B2, C2, D2) ``` ### Breakdown of the Formula: - **B2**: This is the present value of the investment (1000 for Bond A). - **C2**: This is the interest rate (5% for Bond A). - **D2**: This is the number of periods (3 for Bond A). ## Result of the Formula When you apply the formula, it calculates the total amount received from Bond A after 3 periods at a 5% interest rate. The output would be: | Total Amount Received from Bond A | | - | | 1157.63 | Here, the total amount received is calculated based on the present value, interest rate, and number of periods. ## Why Use RECEIVED? The RECEIVED function is particularly useful when you need to evaluate the returns on investments over time. It allows you to quickly assess the profitability of different investment options and make informed financial decisions. ## Key Takeaways: - **RECEIVED**: Calculates the amount received from an investment based on interest rate, present value, and periods. - **Investment Evaluation**: Helps you quickly assess the returns on various investment options. - **Common Use Cases**: Ideal for financial planning, investment analysis, and any scenario where you need to evaluate future cash flows. Understanding how to use the RECEIVED function can significantly enhance your financial analysis capabilities in Excel, enabling you to make better investment decisions. Happy investing! ## Example use case You have a table where Column A contains the names of clients and Column B contains the amounts of money received from each client for a specific service. You can use the RECEIVED function to determine the total amount received from a particular client over a specified period. This allows for efficient tracking of client payments and helps in managing cash flow and financial planning without the need for complex accounting software. **Beyond the RECEIVED function:** Better Analyst is a full [Excel AI](https://betteranalyst.com/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](https://betteranalyst.com/excel-ai) 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](https://betteranalyst.com/ai-excel-spreadsheet-generator) to turn a text prompt into a downloadable Excel file — a full [AI Excel sheet maker](https://betteranalyst.com/ai-excel-spreadsheet-generator) that builds headers, columns, and formulas from your description. ## Need more help with Excel formulas? Create a free account for formula help, explanations, and spreadsheet analysis. Usage limits depend on your plan. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Excel how-to guides - [How To Make A Line Graph In Excel](https://betteranalyst.com/excel/how-to-make-a-line-graph-in-excel) - [How To Make A Pie Chart In Excel](https://betteranalyst.com/excel/how-to-make-a-pie-chart-in-excel) - [How To Make A Table In Excel](https://betteranalyst.com/excel/how-to-make-a-table-in-excel) - [How To Merge Cells In Excel](https://betteranalyst.com/excel/how-to-merge-cells-in-excel) - [How To Multiply In Excel](https://betteranalyst.com/excel/how-to-multiply-in-excel) - [How To Password Protect An Excel File](https://betteranalyst.com/excel/how-to-password-protect-an-excel-file) - [How To Remove Blank Rows In Excel](https://betteranalyst.com/excel/how-to-remove-blank-rows-in-excel) - [How To Remove Duplicates In Excel](https://betteranalyst.com/excel/how-to-remove-duplicates-in-excel) ## Explore all Excel formulas Browse our complete library of Excel 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.