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 company’s 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.