Portfolio Fin 400.xlsx - Pepsi Co Inc Income Statement All numbers in thousands Revenue $63,525,000 $62,799,000 $63,056,000 28,785,000 28,209,000

Portfolio Fin 400.xlsx - Pepsi Co Inc Income Statement All...

This preview shows page 1 - 4 out of 6 pages.

Pepsi Co, Inc. Income Statement All numbers in thousands Revenue 12/30/2017 12/31/2016 12/26/2015 Total Revenue $63,525,000 $62,799,000 $63,056,000 Cost of Revenue 28,785,000 28,209,000 28,731,000 Gross Profit $34,740,000 $34,590,000 $34,325,000 Operating Expenses Research Development 737,000 760,000 754,000 Selling General and Administrative 23,425,000 23,347,000 23,562,000 Total Operating Expenses 52,947,000 52,316,000 53,047,000 Operating Income or Loss 10,578,000 10,483,000 10,009,000 Income from Continuing Operations Total Other Income/Expenses Net -976,000 -1,930,000 -2,567,000 Earnings Before Interest and Taxes 10,578,000 10,483,000 10,009,000 Interest Expense -1,151,000 -1,342,000 -970,000 Income Before Tax 9,602,000 8,553,000 7,442,000 Income Tax Expense 4,694,000 2,174,000 1,941,000 Minority Interest 92,000 104,000 107,000 Net Income From Continuing Ops 4,908,000 6,379,000 5,501,000 Net Income Net Income 4,857,000 6,329,000 5,452,000 Net Income Applicable To Common Shares $4,853,000 $6,323,000 $5,446,000
Image of page 1

Subscribe to view the full document.

Vertical Analysis Horizontal Analysis 2017 2016 2015 2017 2016 2015 1.2% -0.4% 100.00% 45.3% 44.9% 45.6% 2.0% -1.8% 100.00% 54.7% 55.1% 54.4% 0.4% 0.8% 100.00% 1.2% 1.2% 1.2% -3.0% 0.8% 100.00% 36.9% 37.2% 37.4% 0.3% -0.9% 100.00% 83.3% 83.3% 84.1% 1.2% -1.4% 100.00% 16.7% 16.7% 15.9% 0.9% 4.7% 100.00% 0.0% 0.0% 0.0% -1.5% -3.1% -4.1% -49.4% -24.8% 100.00% 16.7% 16.7% 15.9% 0.9% 4.7% 100.00% -1.8% -2.1% -1.5% -14.2% 38.4% 100.00% 15.1% 13.6% 11.8% 12.3% 14.9% 100.00% 7.4% 3.5% 3.1% 115.9% 12.0% 100.00% 0.1% 0.2% 0.2% -11.5% -2.8% 100.00% 7.7% 10.2% 8.7% -23.1% 16.0% 100.00% 7.6% 10.1% 8.6% -23.3% 16.1% 100.00% 7.6% 10.1% 8.6% -23.2% 16.1% 100.00%
Image of page 2
2017 Net profit Margin = Net Income/ Total Revenues 4857000 7.65% 63525000 Operating income Margin = Operating Expenses/ Total Revenues 10578000 16.65% 63525000
Image of page 3

Subscribe to view the full document.

Image of page 4
  • Spring '14
  • dena

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes