1horizontal and vertical analysis of the income statements

Question

Part 1:Please 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 credit worthiness of your firm as measured by Altman's Z-score.

Part 2:The Paper:
5-6 pages in length.
Include a proper introduction and conclusion.

Your paper should provide your reader with an overall understanding of the financial health of your chosen firm including the following:
o Discussion of the ratio analysis results, including rationale for the ratios chosen.
o Discussion of all horizontal and vertical analysis.
o Discussion of four items from the management discussion of the firm that support the conclusion formed in your discussion of the financial results.

Answer 1

Choose a firm of your preference and by using excel sheet, perform the following task: Complete the given for your preferred firm in the Excel spreadsheet: 1) Horizontal and vertical assessment of the Income Statements for the past 3 years (all annual balances set as a percentage of net revenues for that year). 2) Horizontal and vertical assessment of the Balance Sheets for the past 3 years (all annual balances set as a percentage of net assets for that year). 3) Ratio analysis (8 ratios of your choosing) for the past 3 years plus a measurement for the credit value of your firm as measured by the Altman's Z-score.