complete the following for your chosen firm in an Excel spreadsheet:
1) Horizontal and vertical analysis of the Income Statements for the past three years (all yearly balances set as a percentage of total revenues for that year).
2) Horizontal and vertical analysis of the Balance Sheets for the past three years (all yearly balances set as a percentage of total assets for that year).
3) Ratio analysis (eight ratios of your choosing) for the past three years PLUS a measurement for the creditworthiness of your firm as measured by Altman's Z-score.
**Ratios I want to include For part 3 along with the Altman's Z-score**
Gross profit margin, operating income margin, net income margin, Operating Cash Flow/Current Liabilities, Operating Cash Flow/Total Debt, return on equity, net profit margin, and total asset turnover.
Attached is the Balance Sheet, income statement, and statement of cash flows for GameStop Corp. Excel Sheet MUST be able to be edited. Both horizontal and vertical analyses, z-scores, and ratios must be complete for all three years.