Financial Ratio Analysis

profileJoann211684
Assignmentweek3.xlsx

Sheet1

Obtain the most current SEC Form 10-K (annual financial report) from the company's web site (Do not use the Annual Report that is sent to shareholders):
Company - Apple Inc and Microsoft Corporation
Need to show how the answers were calculated to better understand the steps or what excel functions were used to solve the problem the assignments
You can complete the assignment in Excel. ­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­
All ratios should be calculated using data from the company's financial statements in the 10-K Report.
Specify what year financial data is being used (indicate the dates of the company's fiscal year).
Compare and contrast between the companies and provide 250 words analysis of the differences
Apple Inc Microsoft Corporation
2016 2015 2016 2015
Income Statement Data Income Statement Data
Balance Sheet Data Balance Sheet Data

Sheet2

Sheet3