Question
GameStop Corp., a Delaware corporation established in 1996, is a leading specialty retailer offering games and entertainment products through its e-commerce properties and thousands of
GameStop Corp., a Delaware corporation established in 1996, is a leading specialty retailer offering games and entertainment products through its e-commerce properties and thousands of stores. You are going are going to prepare a ratio analysis in Excel. Instructions for ratio analysis table: Obtain the necessary financial information using the links below. Put this information in the first spreadsheet of an Excel workbook. 2020 10-K Full Document: tinyurl.com/3hh4vpx2 2020 10-K Interactive Data: tinyurl.com/ywnnb9my -click Financial Statements, or View Excel Doc 2019 10-K Full Document: tinyurl.com/k3sdayhk 2019 10-K Interactive Data: tinyurl.com/3y5ykejd -click Financial Statements, or View Excel Doc In a second spreadsheet of your Excel workbook, prepare a ratio analysis table. Name this spreadsheet ratio analysis. Your table must contain all 17 ratios listed in the Wiley textbook Chapter 5 Appendix 5A for the current year (2020 in this case) and prior year. Set up your table as follows using the following column headings: Column 1: # List the ratio number 1-17. Column 2: Type Indicate the type of ratio - Liquidity, Activity, etc. Column 3: Ratio Indicate the name of the ratio. Column 5: 2019 calculate the 2019 ratio from the financial data you obtained above to 4 decimal places. Column 4: 2020 calculate the 2020 ratio from the financial data you obtained above to 4 decimal places. Column 6: % Change calculate the percentage change from 2011 to 2012. Format as a percentage to 2 decimal places (e.g., 0.1534 = 15.45%) Column 7: Assessment Indicate whether the change is Good, Bad, or N/A as follows: o Good Year-to-year change makes the company seem to be a better investment. o Bad Year-to-year change makes the company seem to be a worse investment. o N/A Not applicable; no year-to-year change. In making this assessment, consider what the year-to-year change indicates about the companys financial improvement or deterioration and its value to a potential investor. Use cell references and formulas to calculate the ratios. You will be graded on your use of Excel.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started