Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Reporting Financial Statement Analysis And Valuation A Strategic Perspective

Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

9th Edition

1337614689, 1337614688, 9781337668262, 978-1337614689

More Books

Students also viewed these Accounting questions

Question

=+What is the response variable?

Answered: 1 week ago