Instructions: Following the requirements below, please complete a report showing your findings. The report must be completed in Excel and only submit one copy per team. Handwritten copies will not be accepted!

Requirements:

For Amazon and Apple annual financial statements for 2015, please complete and SHOW the following: (Use finance.yahoo.com) to view the Financial Statements.

Perform a Horizontal and Vertical Analysis on the Income Statement of each company, for the years 2015 and 2014. (For example, to complete a Horizontal Analysis for 2014, 2013 data will be required)

Compare the Horizontal and Vertical Analysis for both companies and answer the following questions?

Which company had the higher increase in total revenue from 2014 to 2015?

Which company had the higher increase in net income from 2014 to 2015?

For every dollar of revenue, Amazon has a profit of ____________? For every dollar of revenue, Apple has a profit of________________________?

Cost of Revenue (COGS) is what percentage of total revenue for the year 2015 for Apple? Amazon?

Apple 2013:

Apple 2013:

Apple 2014 & 2015:

Amazon 2014 & 2015:

Consolidated Balance Sheets (USD Current assets Cash and Cash Eguivalents Short-term Investments Net Receivables nventories Other Current Assets Total current assets Long-term Investments Prope ant and ment Goodwi ntangible assets Accumulated Amortization Other assets Total assets Current liabilities Accounts able Short/Current Long Term Debt Other Current Liabilities Total current liabilities Long-term debt Other liabilities Deferred Long Term Liab Charges nterest Negative Goodw Total abilities Shareholders uit Common stoc Retained earnings Treasury Stock Capital Su us Other Stockholders' Egui Total shareholders' equity Total abilities and shareholders Sep. 28, 2013 14,259,000 26.287.000 13,102,000 1.764,000 17,874.000 73,286,000 106,215,000 16,597,000 1,577,000 4,179,000 5,146,000 207,000,000 22,367,000 3,856.000 7,435,000 43.658.000 9,585.000 20.208.000 2,625,000 83,451,000 19,764.000 104,256,000 -47 1,000 123,549,000 $207,000,000