Balance sheet, income statement, and statement of cash flow

Assignment Help Finance Basics
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?

Reviews

Write a Review

Finance Basics Questions & Answers

  Computation of net present value and profitability index

Computation of net present value and profitability index of a project and expected net cash flows of $3,000 a year for 10 years if the project's required return is 12 percent

  Computation of npv and sensitivity analysis

Computation of NPV and sensitivity Analysis and What other factors should be taken into account before Mississippi Delta Inc

  Computation of coupon rate

Its investment bankers have told Donner Company that it can issue a 25 year, 8.1 percent yearly payment bond at par. They also stated that the company can sell an issue of annual payment preferred stock to corporate investors who are in the 40 percen..

  Determination of best alternative

Suppose you are offered two jobs. One initially pays $100,000 annually, and your salary will grow annually at 11.5 percent. The other pays $97,000 yearly but your salary will grow at 12%.

  Determine the real risk-free rate of return

You read in the Wall Street Journal that thirty day T-bills are currently yielding 5.55. your brother-in-law, a broker at Safe and Sound Securities, has given you following estimates of current interest rate premiums;

  Discuss the random walk hypothesis

Discuss the random walk hypothesis? Does research evidence tend to support or deny the validity of this hypothesis?

  Various techniques of inventory management

An investor is thinking of investing in a recurring deposit scheme that offers an interest rate of 12% per annum

  Cash dividends and stock repurchase

Assume instead of paying the cash dividend, the firm used the $2.4 million of excess funds to purchase shares at slightly over the current market value of $64 at a price of $65.20. How many shares could be repurchased?

  Key differences common stock and bonds

Key differences between common stock and bonds include all of the following, All of the following features may be characteristic of preferred stock.

  Prepare the income statement and balance sheet

Make prospective financial statements using the data given below. The National Nursing Home Corporation, has current assets of 147 million dollar and its property plant & machine of 206 million dollar; and other assets totaling $58 million.

  Calculate the roa and roe

Marquez Inc. has declared $50,000 in net income after paying taxes of $26,000 and interest of $20,000. They intend to pay $17,000 of net income as dividends.

  Find the expected return and the standard deviation

Share A has an expected return of 15% and standard deviation of 14 percent. Share B has an expected return of 23 percentand a standard deviation of 18 percent. Correlation between Share A & B is 0.3

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd