Using the syntax of the AMOUNT.RECEIVED function allows the manipulation of certain parameters such as the acquisition date of a security, the amount of the investment, and a method or basis for counting days. In that sense, we recommend that you read this article with which you will learn to use the syntax of the QUANTITY RECEIVED function in Excel.
What is the AMOUNT RECEIVED function?
The AMOUNT RECEIVED function is one Excel financial tool which allows you to calculate the amount received relative to the value of a fully invested investment that was acquired on a specific date.
Like this feature, it is recommended that you learn how to use all Excel formulas to get the most out of this office tool.
What is the syntax for the QUANTITY.RECIDED function?
The syntax of the AMOUNT.RECEIVED function includes five topics : settlement, maturity, investment, discount and day counting method.
How to use the AMOUNT.RECEIVED function syntax in Excel
To use the QUANTITY RECEIVED function syntax correctly in Excel, you need to know how each of the arguments to this function work and what each means. Also, you will see through an example like apply this tool in your financial operations.
What do the arguments to the AMOUNT.RECIEVED function mean?
The first argument is liquidation. It refers to the date of settlement of the security or the delivery of the security to the buyer. Maturity is the end date of the security when it can be redeemed at par or face value. It is important to note that both liquidation and maturity are date format arguments .
On the other hand the investment is the amount that has been invested, the discount is a rate of the value at which an investment was applied , while the days counting method refers to an indicator ranging from the value 0 (default) to the 4th (a month of 30 days and a year of 360 days).
Read How to download the Windows 10 ISO and install it on a PC from a bootable USB
What are the methods of counting days?
In Excel, you can use any of the five day counting methods . The first of them whose value is 0 refers to months of 30 days and years of 360 days, making an adjustment to the dates that fall at the end of the month. On the other hand, the value 1 means that the method is real / real, i.e. the real number of days and specific dates.
The value 2 refers to the actual / 360 method, which is the actual number of days and dates specified based on 360 days. The value 3 is the real method / 365 and finally the value 4 means that the method 30/360 will be applied.
Are all arguments required?
The AMOUNT RECEIVED function requires four mandatory arguments : settlement, maturity, investment and discount. While the base value is optional and refers to the base or method for counting days.
Uses the syntax of the AMOUNT.RECEIVED function
Assuming you have a settlement or issue date of March 17, 2020, the maturity date is June 17, 2020, the investment value is $ 800.000,00, the percentage or discount rate is 5%, and the base is 2 (real / 360)
Based on this information, you can insert these values into an Excel spreadsheet and proceed to apply the formula to execute the AMOUNT.RECIDED function. Remember that you can also create dynamic tables in Excel with graphics if you need to use these tools.
Apply the RECEIVED AMOUNT function syntax.
apply the syntax of the QUANTITY RECEIVED function you need to place the cursor in a specific cell where the corresponding result will be saved. To do this, type in the formula bar at the top of the Microsoft Excel application window next to "fx":
Read How to remove a person's face in a photo and put another one step by step
= AMOUNT.RECEIVED (the cell that contains the settlement date; the cell that includes the due date; the cell where the investment value was entered; the discount rate cell; the base or method cell ) and press Enter. You can also use the VLOOKUP function if you have a long list of data spread across two tables.