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 income statement, balance sheet, statement of cash flows, horizontal analysis, vertical analysis, and ratio analysis of the company examined.
b) A competitor analysis and comparison to industry averages should be presented.
c) A summary identifying whether the company would be attractive to investors and/or creditors must be included.