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.

If you can please help correct my mistakes Here is a screenshot of what I have done so far (Note: I need help in getting the Percent for Horizontal analyses:)

Here is a link to the 2014 Annual Report of Intel (Pls use this to help me): http://www.intc.com/intel-annual-report/2014/files/Intel_2014_Annual_Report.pdf

thank you in advance!

Explanation / Answer

In horizontal analysis,each item is expressed as an percentage of the base year.So, figures for 2013 will be decided based on 2012 numbers.

Like Net sales for 2013 = 52708/53341 * 100 = 98%

Fiscal 2013 Net sales 98% Cost of sales 105% Gross profit 95% Operating and other expenses 84% Interest Exp 334% Income Tax Expens 77% Net income 87% Earning Per share 89%

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

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