(solution) Please refer to the attachment to answer this question. This

(solution) Please refer to the attachment to answer this question. This

Please refer to the attachment to answer this question. This question was created from Final project /file/7151300/Final-project/ Additional Comments: Compute a Z-score to predict possible financial failure. ? Identify the ratios that are required to be disclosed in a company’s financial report. ? Critically analyze the limitations of financial statement analysis. Module 8: Assignments Final Project 1) Analyze a publicly traded company’s financial statements for the prior five years. Include the following items as supplemental schedules to the analysis, prepared as individual worksheets within an Excel spreadsheet: a) Horizontal analysis of the prior five years’ income statement and balance sheet. b) Vertical analysis of the prior five years’ income statement and balance sheet. c) Calculation of at least five significant liquidity ratios for each of the five years analyzed. d) Calculation of at least five significant profitability ratios for each of the five years analyzed. e) Calculation of at least five significant long-term debt-paying ratios for each of the five years analyzed. f) Calculation of at least five significant investor ratios for each of the five years analyzed. 2) Prepare a paper (10-15 pages) that analyzes the financial strengths and weaknesses of the company examined. a) The analysis should reference significant items found in the