Prepare a horizontal analysis of the balance sheet

Assignment Help Financial Accounting

Reference no: EM133719842

Assignment: Finance Medtronic Plc Financial Statement Analysis Excel Project

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:

A. Prepare a Horizontal Analysis of the Balance Sheet.

B. Prepare a Horizontal Analysis of the Income Statement.

C. Prepare a Component Percentage Balance Sheet.

D. Prepare a Component Percentage Income statement.

E. Calculate the following financial ratios for last year and the current year:

F. Return on Equity.

a. Earnings per Share
b. Total Asset Turnover Ratio
c. Current Ratio
d. Debt to Equity Ratio
e. Price/Earnings (P/E) Ratio.

Reference no: EM133719842

Questions Cloud

Explain the dark figure of crime : What is your personal take on this phenomenon? What do you think we can do in the field to help lower the number of unreported cases?

Conducting a thematic analysis between each genre : Explain the similarities and differences between the authors language purposes for Short Fiction explained on pages 150-151 and playwriters explained

How these countries are similar or different on hofstede : Develop a leadership plan on how you, as the CEO of this company, would insure diversity conscious leadership to promote organizational success

What impact can social workers have on this issue : Discuss your level of knowledge and competence about the issue. How does it relate to social work? What impact can social workers have on this issue?

Prepare a horizontal analysis of the balance sheet : Prepare a Horizontal Analysis of the Balance Sheet. Prepare a Horizontal Analysis of the Income Statement. Prepare a Component Percentage Balance Sheet.

How they differentiate between power and leadership : Interview nurses at various levels and ask them how they differentiate between power and leadership - State the objective of the clinical practicum

Discuss why control procedures over access to the database : Discuss why control procedures over access to the database become more crucial under the database concept than in the flat-file data management environment.

Apply to the crimes committed by colonel russell williams : How does the organized/disorganized offender dichotomy apply to the crimes committed by Colonel Russell Williams? Use course material to back up your response.

Explore how education is the path towards reconciliation : I need to come up with a series of questions based on the First Peoples Principles of Learning to explore how education is the path towards reconciliation.

User Account

All Pages