Need Horizontal Analysis and Vertical Analysis formula for excel; Name: Apple 20

Question

Need Horizontal Analysis and Vertical Analysis formula for excel;

Name: Apple 2014 and 2013 Name: (In millions) Horizontal Analysis Increase or %Change Comm Ana on Size lysis Sept 27 Sept 28 Sept. 29 (Decrease from '13 to '14 Fiscal Year Ended Dollars 2014 2013 Total Net Revenue Cost of Sales Gross Margin S 182,795 S 170,910 S 156,508 $ 112,258 S 106,606 S87,846 S 70,537 S 64,304 S 68,662 3,381 Selling, General & Administrative 11,993 S 10,830 S 10,040 Total Selling& Administrative expenses 18,034 S 15,305 13,421 S 52,503 S 48,999S55,241 522 S 53,483 S 50,155 S 55,763 $ 13,973 13.118 S 14,030 $ 39.510 $ 37,037 S41,733 Research & development 6,041 $ 4,475 S Operating Income Other Income & Expense Income before income taxes Provision for Income Taxes Net Income 1,156 S

Explanation / Answer

2014 2013 2012 Dollars % change 2014 2013 Total net revenue 182795 170910 156508 11885 6.95% 100.00% 100.00% Cost of sales 112258 106606 87846 5652 5.30% 61.41% 62.38% Gross margin 70537 64304 68662 6233 9.69% 38.59% 37.62% Reasearch and development 6041 4475 3381 1566 34.99% 3.30% 2.62% Selling general and admin 11993 10830 10040 1163 10.74% 6.56% 6.34% Total selling and admin expense 18034 15305 13421 2729 17.83% 9.87% 8.96% Operating income 52503 48999 55241 3504 7.15% 28.72% 28.67% Other income and expense 980 1156 522 -176 -15.22% 0.54% 0.68% Income before income taxes 53483 50155 55763 3328 6.64% 29.26% 29.35% Provision for income taxes 13973 13118 14030 855 6.52% 7.64% 7.68% Net income 39510 37037 41733 2473 6.68% 21.61% 21.67%

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.