My company is GameStop here is the link to the annual report http:/ews.gamestop.com/static-files/7ac64c74-a026-49ab-b549-185e10a70ebc
The idea of the report is you acquainted annual project to get with the information available in a company's annual report, as well as, improve your skills using Excel. You will need to do the following to receive full credit: In Excel, re-create the comparative Income Statement and Balance Sheet from your 2017 or 2016 annual report. You only need to do the latest two years (for example, PepsiCo's annual report gives income for 2016, 2015, and 2014, therefore, you would only need to use the 2016 and 2015 information). Once you have recreated the financial statements, apply vertical analysis to both statements. Refer to your homework for an example of vertical analysis Compute the following 4 ratios for the most recent year (Show vour work) o Current Ratio, Profit Margin, Return on Assets, & Return on Equity Answer the following 2 questions: Who is the CEO of your company? Who was the independent auditor for your company? o 2 o GRADING AND OTHER REQUIREMENTS This project will be worth a total of 35 points. Please print out your annual report's Income Statement& Balance Sheet (should be about 2-3 pages), as well as, the independent auditors report on the company. Make sure that you use the appropriate formulas when applying vertical analysis. Failure to use formulas will result in a reduction of 15 points. Make sure that your financial statements are in proper format (order, headings, lines, dollar amounts, etc.) Round percents to 2 decimal places. Please "lit" your financial statements to one page each. A total of 5 pages plus your 3-5 printed off pages should be turned in as follows (in this order) 1 page with your Income Statement numbers 1 page with your Income Statement formulas (use CTRL+ 1 page with your Balance Sheet numbers 1 page with your Balance Sheet formulas ( use CTRL +") 1 page with your four ratios and two questions on it (Excel not required). page of the independent auditors report (print page of annual report). 1-2 pages of the actual Income Statement (print page of annual report). 1 o Ignore the Statement of Comprehensive Income 1-2 pages of the actual Balance Sheet (print page of annual report). . YOU DO NOT HAVE TO PRINT OUT THE ENTIRE ANNUAL REPORT; PRINT ONLY THE ITEMS REQUESTED: Independent Auditors Report, Income Statement, & Balance Sheet. The idea of the report is you acquainted annual project to get with the information available in a company's annual report, as well as, improve your skills using Excel. You will need to do the following to receive full credit: In Excel, re-create the comparative Income Statement and Balance Sheet from your 2017 or 2016 annual report. You only need to do the latest two years (for example, PepsiCo's annual report gives income for 2016, 2015, and 2014, therefore, you would only need to use the 2016 and 2015 information). Once you have recreated the financial statements, apply vertical analysis to both statements. Refer to your homework for an example of vertical analysis Compute the following 4 ratios for the most recent year (Show vour work) o Current Ratio, Profit Margin, Return on Assets, & Return on Equity Answer the following 2 questions: Who is the CEO of your company? Who was the independent auditor for your company? o 2 o GRADING AND OTHER REQUIREMENTS This project will be worth a total of 35 points. Please print out your annual report's Income Statement& Balance Sheet (should be about 2-3 pages), as well as, the independent auditors report on the company. Make sure that you use the appropriate formulas when applying vertical analysis. Failure to use formulas will result in a reduction of 15 points. Make sure that your financial statements are in proper format (order, headings, lines, dollar amounts, etc.) Round percents to 2 decimal places. Please "lit" your financial statements to one page each. A total of 5 pages plus your 3-5 printed off pages should be turned in as follows (in this order) 1 page with your Income Statement numbers 1 page with your Income Statement formulas (use CTRL+ 1 page with your Balance Sheet numbers 1 page with your Balance Sheet formulas ( use CTRL +") 1 page with your four ratios and two questions on it (Excel not required). page of the independent auditors report (print page of annual report). 1-2 pages of the actual Income Statement (print page of annual report). 1 o Ignore the Statement of Comprehensive Income 1-2 pages of the actual Balance Sheet (print page of annual report). . YOU DO NOT HAVE TO PRINT OUT THE ENTIRE ANNUAL REPORT; PRINT ONLY THE ITEMS REQUESTED: Independent Auditors Report, Income Statement, & Balance Sheet
