You are required to create an Excel spreadsheet to perform the required financial statement analysis (including ratio analysis) on the assigned company which must be submitted for grading. You are required to use Excel formulas to perform all calculations to earn the full number of points. The FIN-5823 Financial Analysis Example template illustrates how to format your analysis and how use formulas for the calculations. Use the FIN-5823 Financial Analysis Example to help you create your Excel spreadsheet to compare the results of the Company your Instructor has chosen for the last two years and perform the following analysis: Prepare a Horizontal Analysis of the Balance Sheet. Prepare a Horizontal Analysis of the Income Statement. Prepare a Component Percentage Balance Sheet. Prepare a Component Percentage Income statement. Calculate the following financial ratios for last year and the current year: Return on Equity. Earnings per Share Total Asset Turnover Ratio Current Ratio Debt to Equity Ratio Price/Earnings (P/E) Ratio