Balance sheet, income statement, and statement of cash flow

Reference no: EM13153172

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.

Reference no: EM13153172

Questions Cloud

Find probability that injured person is female and hurt : Find the probability that the injured person is female. P( P( )=? E. Find the probability that the injured person is female and was hurt at work. P( P( )=? F.

What is the final concentration of cl2 : We place 1.32 mol PCl5 in a 1.0L flask and allow it to reach equilibrium at a given temperature. What is the final concentration of Cl2 in the flask? PCl5 = PCl3 + Cl2 K= .47

What is the density of a substance at room temperature : What is the density of a substance if a 2.50mL sample has a mass of 0.880g at room temperature? ( show calculations) What is the specific gravity of the substance?

How many if two of the men refuse to serve together : How many, if 2 of the men refuse to serve together? = 56 (c): How many, if 2 of the women refuse to serve together? = 50 (d): How many, if 1 man and 1 woman refuse to serve together?

Balance sheet, income statement, and statement of cash flow : 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.

What is the electron source that helps reduce carbon dioxide : The light-independent reactions of plants function to make organic molecules using carbon dioxide as a carbon source. What is the electron source that helps reduce carbon dioxide to sugars and other organic molecules?

Problem related to realization principle : Describe how revenue is recognized as it pertains to the realization principle.

Define density is an example of intensive physical property : Density is an example of intensive physical propery of matter. What does this statement mean?

Explain conjunction fallacy in independent events : Assume that the event "Mary takes Mathematics 23 and Government 35" is more likely than the event "Mary takes Mathematics 23." Why are we not making this fallacy here?

User Account

All Pages