PLS HELP: I am trying to create a Vertical Analyses of 2013 and 2014 Income Stat

Question

PLS HELP: I am trying to create a Vertical Analyses of 2013 and 2014 Income Statements and a Horizontal Analyses of 2013 and 2014 Income Statements. BASED ON 2014 Annual Report of Intel Corporation.

Here is the link to 2014 Annual Report of Intel Corporation: http://www.intc.com/intel-annual-report/2014/files/Intel_2014_Annual_Report.pdf

This where you find the answers. Thank you in advance!

Fiscal 2013 Fiscal 2012 Vertical Analysis of 2013 and 2014 income statements Exhibit 13.4 Ch 13 Net Sales Revenue Cost of Sales Gross Profit Operating & Other Expense Interest Expense Income Tax Expense Amount Percent Amount Percent Net Income Horizontal Analysis of 2013 and 2014 income statements | Exhibit 13.2 Ch 13 Year Ended: Net Sales Revenue Cost of Sales Gross Profit Operating and Other Expenses Interest Expense Income Tax Expense Net Income Earnings Per Share 1/1/2014 2/1/2013 Fiscal 2013 Fiscal 2012) Amount Percent*

Explanation / Answer

Vertical analysis

For vertical analysis, we will divide each item by net sales revenue

2013

Percentage

2012

Percentage

Net Sales revenue

52708

100.00%

53341

100.00%

cost of sales

21187

40.20%

20190

37.85%

gross profit

31521

59.80%

33151

62.15%

Operating and other exp

19230

36.48%

18513

34.71%

interest exp

0

0.00%

0

0.00%

income tax exp

2991

5.67%

3868

7.25%

net income

16239

30.81%

14645

27.46%

Horizontal analysis

For horizontal analysis, we calculate the difference between the values of two years and divide it by former year:

2013

2012

Difference

percentage

Net Sales revenue

52708

53341

-633

-1.19%

cost of sales

21187

20190

997

4.94%

gross profit

31521

33151

-1630

-4.92%

Operating and other exp

19230

18513

717

3.87%

interest exp

0

0

0

0.00%

income tax exp

2991

3868

-877

-22.67%

net income

16239

14645

1594

10.88%

2013

Percentage

2012

Percentage

Net Sales revenue

52708

100.00%

53341

100.00%

cost of sales

21187

40.20%

20190

37.85%

gross profit

31521

59.80%

33151

62.15%

Operating and other exp

19230

36.48%

18513

34.71%

interest exp

0

0.00%

0

0.00%

income tax exp

2991

5.67%

3868

7.25%

net income

16239

30.81%

14645

27.46%

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

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