You are required to create an Excel spreadsheet to perform the required analysis

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