Financial Statement Analysis General Description: In order to reinforce the concepts and provide practical application of concepts learned in class, a project requiring students to complete a Financial Statement Analysis is included as part of this course. Specific Requirements: The Financial Statement (F/S) analysis should involve downloading a companys financial statements and providing an in-depth report on the companys economic condition through ratio analysis and answering of specific questions. You choose a company from the internet- maybe one which you always wanted to know about. Be careful to not become bogged down in the volume of data in an annual Report/ Financial Statement. Choose carefully. o Create an in-depth Financial Statement analysis report with the following elements (use chapter 17 as a guide for this project): Perform a Horizontal Analysis of the financial statements (Balance Sheet Assets/ Liabilities and Equity; Current Assets; Comparative Income statement and Retained Earnings) as illustrated in the text Chapter 17 (pages 686 - 717) summary Exhibit 17.18 page 707. A minimum of 20 ratios must be calculated- show work in a separate schedule. Approximate worth 20% Perform a Vertical Analysis of the financial statements (Balance Sheet Assets/ Liabilities and Equity; Current Assets; Comparative Income statement) Chapter 17 (pages 686-717) summary Exhibit 17.18 page 707. A minimum of 20 ratios must be calculated- show work in a separate schedule. Approximate worth 20% Perform a Solvency and Profitability Analysis of the financial statements. Calculate at least 10 ratios. Approximate worth 20% Create an in-depth Financial Statement Analysis report discussing the above F/S analyses. This report must convey the results of the Horizontal Analysis, Vertical Analysis, the Solvency Analysis and Profitability Analysis of the financial statements. Detail the following expected future results and perceived issues of the chosen corporation. Approximate worth 40% Work output: 1. Excel spreadsheet with clear ratio analysis performed so it can be graded 2. Word document - in-depth Financial Statement analysis report