Open the excel workbook for your chosen publicly traded company with the ratios calculated from week 2. Drag and drop the ratios calculated from year 1 (see the instructional video). Take last year's financial statement's common size percentages and ratios and compare the available industry standard. The SIC code within the annual report of your chosen company will inform you of the firm's industry. For the industry average, go to BizStatsLinks to an external site. and search for your firm's industry. Report on the process in your written summary. Notate any difficulties with the data normalization in week 2. Did you encounter any challenges with getting all five years' ratios to display correctly? This is critical for our data upload in the week 4 assignment.

Answer rating: 100% (QA)

To compare your chosen companys financial ratios with industry averages you can follow these steps O... View the full answer