Can you please solve the requirements of this task?

REQUIREMENTS Step One: Collect and input the data related to the available investment opportunities ' By using an Excel spreadsheet, you are required to design an electronic table with 6 independent columns as follow: Discount Unamortized Carrying Amortization Discount 0r Value Interest Interest Or Premium Period Payment Revenue Premium Step Two: Data analysis by using electronic tables (e-tables) o Make sure that the Excel le has the Data Analysis option available in the Tool Bar above the electronic table. . Prepare an electronic table (e-table) for each investment opportunity. ' Calculate all the values in all the columns by using the available Excel formulas. Step Three: Take the necessary investment decision . You have to compare the obtained data analysis for the e-tables related to each investment opportunities. Then, you need to take the appropriate investment decision by selecting one the investment opportunities (You have to learn and understand how choose an investment over other investments by using accounting). Step Four: Prepare a report based on the obtained accounting data produced by the data analysis ' Prepare a report (two pages maximum) that clearly indicates the results you obtained from your evaluation of the two investment opportunities and taking particularly into account the future cash inows or outows of each investment separately, under the following assumptions: 1- The sale of the bond issued by Qatar Modern Electronics Company by the end of 2022 for a sum of $82,500,000. 2- The sale of bond issued by Qatar Intemational Trade Company for a sum of $10,750,000. Submission requirements: (Deadline is Thursday April 30, 2020) You have to submit two documents: 1- The Excel document of your analysis 2- The PDF le including your report Grading Date input: 2 marks Excel electronics table: 4 marks The report: 4 marks