Use the “ACC 543 Financial Ratio Data – Spring 2021” file to answer the following questions. Please see the word document for further instruction. There are total 7 questions in this project.1)Review and think through each of the following twelve financial ratios (formulas provided in Appendix 1).
Create a summary that provides the benefit of analyzing each ratio and whether a higher or lower ratio amount is better for a company’s financial position. The first item is shown as an example. Complete the information for the other ratios.
2)Create the financial ratio calculations for each ratio provided in Appendix 1.3)Create a pivot table to show the averages of the ratios by Industry.
4)Use graphics to analyze the comparison of ratios across industries?
5)Create a bar chart comparing the industry average and the Clorsol’s ratio results for each ratio. Clorsol is in the Manufacturing industry.
6)?Identify three other ratios that you could analyze and explain why they would be important to include in the analysisWhat information would you need for each ratio calculation?
7)Provide a discussion of additional data that you would like to have from Clorsol to expand your analysis.List at least three data items you would want and what you would do with the data (why you need it).
Requirements: in the excel
