Open the excel workbook for your chosen publicly traded company with the ratios calculated from week 2.
Question:
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.
Intermediate Accounting
ISBN: 978-1260481952
10th edition
Authors: J. David Spiceland, James Sepe, Mark Nelson, Wayne Thomas