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

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

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%

2017
Net profit Margin = Net Income/ Total Revenues 4857000 7.65%
63525000
Operating income Margin = Operating Expenses/ Total Revenues 10578000 16.65%
63525000