Recreate the comparative Income Statement and Balance Sheet in excel for the Company game stop using there annual report here is the link http:/ews.gamestop.com/static-files/7ac64c74-a026-49ab-b549-185e10a70ebc
SPRING 2018 BUS2101 ANNUAL REPORT PROJECT OVERVIEW The idea of the annual report project is to get you acquainted 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 vear(Show your work): Current Ratio, Profit Margin, Return on Assets, & Return on Equity o Answer the following 2 questions: Who is the CEO of your company? Who was the independent auditor for your company? o 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 fortmat (order, headings, lines, dollar amounts, etc.). Round percents to 2 decimal places. Please "fit" 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). .1 page of the independent auditors report (print page of annual report). . 1-2 pages of the actual Income Statement (print page of annual report). ?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 This project is due on or before the start of your class on Wednesday, April 4 2018 CHEATING/COPYING: All individuals involved in turning in the same report/project will have their grade divided amongst the involved individuals. Feel free to turn it in early, just to be safe! HAVE FUN & GOOD LUCK!! SPRING 2018 BUS2101 ANNUAL REPORT PROJECT OVERVIEW The idea of the annual report project is to get you acquainted 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 vear(Show your work): Current Ratio, Profit Margin, Return on Assets, & Return on Equity o Answer the following 2 questions: Who is the CEO of your company? Who was the independent auditor for your company? o 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 fortmat (order, headings, lines, dollar amounts, etc.). Round percents to 2 decimal places. Please "fit" 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). .1 page of the independent auditors report (print page of annual report). . 1-2 pages of the actual Income Statement (print page of annual report). ?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 This project is due on or before the start of your class on Wednesday, April 4 2018 CHEATING/COPYING: All individuals involved in turning in the same report/project will have their grade divided amongst the involved individuals. Feel free to turn it in early, just to be safe! HAVE FUN & GOOD LUCK
