You are required to create an Excel spreadsheet to perform the required analysis on your 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 illustrates how to format your analysis and how to use formulas for the calculations.

Use the FIN$-5823$ Financial Analysis Example to help you create your won Excel spreadsheet to compare the results of your company 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