Company Financials PepsiCo Inc (www.pepsico.com)

Company Financials
PepsiCo Inc (www.pepsico.com)
Industry NAICS code: 312111 (Soft Drinks (Including Bottled Carbonated and Flavored
Water, Bottled Coffee & Tea, Sodas, Pop and Energy Drinks) Manufacturing)
Income Statement
Fiscal Year ends
in December.
$USD, In whole
numbers,
except marked *
or %
Dec 2017 Dec 2016 Dec 2015 Dec 2014 Dec 2013
Column Name – – – – –
Total Revenue 63,525,000,000 62,799,000,000 63,056,000,000 66,683,000,000 66,415,000,000
Cost Of Revenue 28,785,000,000 28,209,000,000 28,384,000,000 30,884,000,000 31,243,000,000
Gross Profit 34,740,000,000 34,590,000,000 34,672,000,000 35,799,000,000 35,172,000,000
Operating
Expenses
General &
Administrative
Costs
– – – – –
SGA Expense 24,231,000,000 24,735,000,000 24,885,000,000 26,126,000,000 25,357,000,000
R&D Expense – – – – –
Other
Operating
Expenses
0 70,000,000 75,000,000 92,000,000 110,000,000
Restructuring
and
Merger/Acquisition
Costs
– – – – –
Amortization – 70,000,000 75,000,000 92,000,000 110,000,000
Total
Operating
Expenses
24,231,000,000 24,805,000,000 24,960,000,000 26,218,000,000 25,467,000,000
Operating Income 10,509,000,000 9,785,000,000 9,712,000,000 9,581,000,000 9,705,000,000
Misc Other Special
Charges – – – – –
Interest Expense 1,151,000,000 1,342,000,000 970,000,000 909,000,000 911,000,000
Gain On Sale Of
Security – – – – –
Other Income
(expense) – – (1,359,000,000) – –
Pre-Tax Income 9,602,000,000 8,553,000,000 7,442,000,000 8,757,000,000 8,891,000,000
Income Taxes 4,694,000,000 2,174,000,000 1,941,000,000 2,199,000,000 2,104,000,000
Net Income from
Continuous
Operations
4,908,000,000 6,379,000,000 5,501,000,000 6,558,000,000 6,787,000,000
Net Income for
Common
Stockholders
4,853,000,000 6,323,000,000 5,446,000,000 6,503,000,000 6,732,000,000
Earnings per
Share
Basic Earnings
per Share 3.40 4.39 3.71 4.31 4.37
Diluted
Earnings per
Share
3.38 4.36 3.67 4.27 4.32
Weighted Average
Shares
– 1 –
Plunkett Research Ltd. Copyright (C) All Rights Reserved www.plunkettresearch.com
Basic Average
Shares 1,425,000,000 1,439,000,000 1,469,000,000 1,509,000,000 1,541,000,000
Diluted
Average Shares 1,438,000,000 1,452,000,000 1,485,000,000 1,527,000,000 1,560,000,000
Common Dividend 3.17 2.96 2.76 2.53 2.24
Balance Sheet
Fiscal Year ends
in December.
$USD, In whole
numbers,
except marked *
or %
Dec 2017 Dec 2016 Dec 2015 Dec 2014 Dec 2013
Assets
Current Assets
Cash – – – – –
Cash And
Cash Equivalents 10,610,000,000 9,158,000,000 9,095,999,000 6,134,000,000 9,375,000,000
Short-Term
Investments 8,900,000,000 6,967,000,000 2,913,000,000 2,592,000,000 303,000,000
Total Cash 19,510,000,000 16,125,000,000 12,008,999,000 8,726,000,000 9,678,000,000
Receivables 7,024,000,000 6,694,000,000 6,437,000,000 6,651,000,000 6,954,000,000
Inventory 2,947,000,000 2,723,000,000 2,720,000,000 3,143,000,000 3,409,000,000
Deferred
Income Taxes – – – – –
Prepaid
Expenses 1,546,000,000 1,547,000,000 1,865,000,000 2,143,000,000 2,162,000,000
Other Current
Assets – – – – –
Total Current
Assets 31,027,000,000 27,089,000,000 23,031,000,000 20,663,000,000 22,203,000,000
Non-Current
Assets
Gross
Property, Plant &
Equipment
39,106,000,000 36,818,000,000 35,747,000,000 36,300,000,000 36,961,000,000
Accumulated
Depreciation (21,866,000,000) (20,227,000,000) (19,430,000,000) (19,056,000,000) (18,386,000,000)
Net
Property, Plant
& Equipment
17,240,000,000 16,591,000,000 16,317,000,000 17,244,000,000 18,575,000,000
Goodwill 14,744,000,000 14,430,000,000 14,177,000,000 14,965,000,000 16,613,000,000
Intangible
Assets 13,838,000,000 13,433,000,000 13,081,000,000 14,088,000,000 16,039,000,000
Other Long
Term Assets – – – – –
Total Non
Current Assets 48,777,000,000 47,040,000,000 46,636,000,000 49,846,000,000 55,275,000,000
Total Assets 79,804,000,000 74,129,000,000 69,667,000,000 70,509,000,000 77,478,000,000
Liabilities and
stockholders’
equity
Liabilities
Current
Liabilities
Short-Term
Debt 5,485,000,000 6,892,000,000 4,071,000,000 5,076,000,000 5,306,000,000
– 2 –
Plunkett Research Ltd. Copyright (C) All Rights Reserved www.plunkettresearch.com
Accounts
Payable 6,727,000,000 6,158,000,000 5,546,000,000 5,127,000,000 4,874,000,000
Deferred
Revenues – – – – –
Accrued
Liabilities 2,954,000,000 2,774,000,000 2,842,000,000 2,912,000,000 2,748,000,000
Total
Current Liabilities 20,502,000,000 21,135,000,000 17,578,000,000 18,092,000,000 17,839,000,000
Non-Current
Liabilities
Long Term
Debt 33,796,000,000 30,053,000,000 29,213,000,000 23,821,000,000 24,333,000,000
Deferred
Tax Liability – – – – –
Minority
Interest 92,000,000 104,000,000 107,000,000 110,000,000 110,000,000
Pensions &
Other Benefits – – – – –
Other Non
Current Liabilities 11,283,000,000 6,669,000,000 5,887,000,000 5,744,000,000 4,931,000,000
Total Non
Current Liabilities – – – – –
Total Liabilities – – – – –
Stockholders’
Equity
Common Stock 24,000,000 24,000,000 24,000,000 25,000,000 25,000,000
Additional Paid
In Capital 3,799,000,000 3,899,000,000 3,890,000,000 3,934,000,000 3,924,000,000
Retained
Earnings 52,839,000,000 52,518,000,000 50,472,000,000 49,092,000,000 46,420,000,000
Preferred Stock 41,000,000 41,000,000 41,000,000 41,000,000 41,000,000
Treasury Stock (32,757,000,000) (31,468,000,000) (29,185,000,000) (24,985,000,000) (21,004,000,000)
Total
Stockholders’
Equity
10,889,000,000 11,095,000,000 11,923,000,000 17,438,000,000 24,279,000,000
Total Liabilities &
Shareholders’
Equity
10,889,000,000 11,095,000,000 11,923,000,000 17,438,000,000 24,279,000,000
Cash Flow
Fiscal Year ends in
December.
$USD, In whole
numbers,
except marked *
or %
Dec 2017 Dec 2016 Dec 2015 Dec 2014 Dec 2013
Operating Cash Flow 9,994,000,000 10,404,000,000 10,580,000,000 10,506,000,000 9,688,001,000
Net Income – – – – –
Depreciation And
Amortization 2,369,000,000 2,368,000,000 2,416,000,000 2,625,000,000 2,663,000,000
Investment/Asset
Impairment 0 0 1,359,000,000 – –
Deferred Income
Taxes 3,070,000,000 452,000,000 78,000,000 (19,000,000) (1,058,000,000)
Stock Based
Compensation 292,000,000 284,000,000 295,000,000 297,000,000 303,000,000
Accounts
Receivable (202,000,000) (349,000,000) (461,000,000) (343,000,000) (88,000,000)
Cash From
– 3 –
Plunkett Research Ltd. Copyright (C) All Rights Reserved www.plunkettresearch.com
Discontinued
Operating
Activities
– – – – –
Change In
Inventory (168,000,000) (75,000,000) (244,000,000) (111,000,000) 4,000,000
Change In
Account Payable 201,000,000 997,000,000 1,692,000,000 1,162,000,000 1,007,000,000
Prepaid Expenses 20,000,000 10,000,000 (50,000,000) 80,000,000 (51,000,000)
Accrued
Liabilities – – – – –
Income Tax
Payable (338,000,000) 329,000,000 55,000,000 371,000,000 86,000,000
Other Working
Capital (487,000,000) 912,000,000 992,000,000 1,159,000,000 958,000,000
Other Non
CashItems (159,000,000) 342,000,000 (190,000,000) (117,000,000) (360,000,000)
Operating Cash
Flow 9,994,000,000 10,404,000,000 10,580,000,000 10,506,000,000 9,688,001,000
Cash Flow from
Investing (4,403,000,000) (7,148,000,000) (3,569,000,000) (4,937,000,000) (2,625,000,000)
Purchase of
Property, Plants &
Equipment
– – – – –
Net Investment
Purchase & Sale (1,849,000,000) (4,089,000,000) (314,000,000) (2,298,000,000) 61,000,000
Acquisitions, net 206,000,000 (127,000,000) (578,000,000) 115,000,000 21,000,000
Purchase Of
Investments (18,385,000,000) (12,504,000,000) (4,428,000,000) (6,305,000,000) –
Sales/Maturities
of Investments 16,536,000,000 8,415,000,000 4,114,000,000 4,007,000,000 61,000,000
Net Other
Investing Changes 29,000,000 9,000,000 (5,000,000) (10,000,000) (21,000,000)
Cash Flow from
Investing (4,403,000,000) (7,148,000,000) (3,569,000,000) (4,937,000,000) (2,625,000,000)
Financing Cash
Flow (4,186,000,000) (2,942,000,000) (3,828,000,000) (8,264,000,000) (3,789,000,000)
Issuance Of Debt 7,600,000,000 9,382,000,000 8,770,000,000 3,905,000,000 5,852,000,000
Repayment Of
Debt (5,550,000,000) (5,636,000,000) (4,138,000,000) (4,236,000,000) (4,386,000,000)
Common Stock
Issued – – – – –
Cash Dividends
Paid (4,472,000,000) (4,227,000,000) (4,040,000,000) (3,730,000,000) (3,434,000,000)
Other Financing
Activities (221,000,000) 81,000,000 81,000,000 64,000,000 64,000,000
Effect of Changes
in Currency
Exchange Rates
47,000,000 (252,000,000) (221,000,000) (546,000,000) (196,000,000)
Net Change in
Cash 1,405,000,000 314,000,000 3,183,000,000 (2,695,000,000) 3,274,000,000
Beginning Cash
Position 9,158,000,000 9,095,999,000 6,134,000,000 9,375,000,000 6,297,000,000
End Cash
Position 10,610,000,000 9,158,000,000 9,095,999,000 6,134,000,000 9,375,000,000
Free Cash Flow
Operating Cash
Flow 9,994,000,000 10,404,000,000 10,580,000,000 10,506,000,000 9,688,001,000
– 4 –
Plunkett Research Ltd. Copyright (C) All Rights Reserved www.plunkettresearch.com
Capital
Expenditure (2,969,000,000) (3,040,000,000) (2,758,000,000) (2,859,000,000) (2,795,000,000)
Free Cash Flow 7,025,000,000 7,364,000,000 7,822,000,000 7,647,000,000 6,893,000,000
Ratios
Fiscal Year ends in December.
$USD, Dec 2017 Dec 2016 Dec 2015 Dec 2014 Dec 2013
Profitability Ratios
EBITDA Margin 0.21 0.20 0.17 0.18 0.19
EBIT Margin 0.17 0.16 0.13 0.14 0.15
Gross Margin % 54.69 55.08 54.99 53.69 52.96
Operating Margin % 16.54 15.58 15.40 14.37 14.61
Tax Rate % 48.89 25.42 26.08 25.11 23.66
Book Value PerShare – – – – –
Net Margin % 7.64 10.07 8.64 9.75 10.14
Assets Turnover 0.83 0.87 0.90 0.90 0.87
Return on Assets (ROA) % 6.31 8.79 7.77 8.79 8.85
Return on Equity (ROE) % 44.32 55.14 37.20 31.24 28.96
Return on Invested Capital (ROIC) % 11.00 15.55 13.38 14.22 14.07
Growth Ratios
Revenue %
Year over Year % 1.16 -0.41 -5.44 0.40 1.41
3-Year Average % -1.60 -1.85 -1.26 0.09 4.72
5-Year Average % -0.61 -1.14 1.74 9.05 8.96
10-Year Average % 4.87 5.98 6.83 8.59 9.43
Operating Income %
Year over Year % 7.40 0.75 1.37 -1.28 6.51
3-Year Average % 3.13 0.27 2.15 -0.18 5.22
5-Year Average % 2.89 0.31 3.11 3.56 6.95
10-Year Average % 3.90 4.27 5.07 5.88 6.88
Net Income %
Year over Year % -23.26 16.09 -16.29 -3.37 9.10
3-Year Average % -9.32 -2.08 -4.08 0.36 2.17
5-Year Average % -4.70 -0.36 -2.91 1.84 5.56
10-Year Average % -1.51 1.16 2.95 4.46 6.57
Diluted Earnings Per Share %
Year over Year % -22.48 18.80 -14.05 -1.16 10.20
3-Year Average % -7.50 0.31 -2.17 1.95 3.38
5-Year Average % -2.92 1.59 -1.26 2.52 6.12
10-Year Average % -0.09 2.70 4.38 5.76 7.74
Dividend %
Year over Year % 7.01 7.15 9.08 13.06 5.29
3-Year Average % 7.74 9.74 9.10 7.74 5.83
5-Year Average % 8.29 7.89 7.89 7.37 6.30
10-Year Average % 8.32 9.82 10.59 11.54 13.52
Cash Flow Ratios
Operating Cash Flow
Year over Year % -3.94 -1.66 0.70 8.44 14.26
Free Cash Flow
Year over Year % -4.60 -5.86 2.29 10.94 19.57
Capital Expenditures to Sales 0.05 0.05 0.04 0.04 0.04
– 5 –
Plunkett Research Ltd. Copyright (C) All Rights Reserved www.plunkettresearch.com
Free Cash Flow to Sales 0.11 0.12 0.12 0.11 0.10
Free Cash Flow to Net Income 1.45 1.16 1.43 1.17 1.02
Efficiency
Days in Sales 33.51 32.57 32.75 32.83 34.05
Days in Inventory 35.95 35.21 37.70 38.72 40.83
Days in Payment 81.69 75.72 68.62 59.10 54.47
Sales per Employee $ 241,540 237,875 239,757 246,063 242,391
Cash Conversion Cycle -12.23 -7.94 1.82 12.45 20.41
Receivables Turnover 10.89 11.21 11.15 11.12 10.72
Inventory Turnover 10.15 10.37 9.68 9.43 8.94
Fixed Assets Turnover 3.76 3.82 3.76 3.72 3.52
Assets Turnover 0.83 0.87 0.90 0.90 0.87
Capital Expenditures to Sales 0.05 0.05 0.04 0.04 0.04
Liquidity / Financial Health
Current Ratio 1.51 1.28 1.31 1.14 1.24
Quick Ratio 1.29 1.08 1.05 0.85 0.93
Financial Leverage 7.36 6.71 5.86 4.05 3.20
Debt Equity Ratio 3.12 2.72 2.46 1.37 1.00
– 6 –
Plunkett Research Ltd. Copyright (C) All Rights Reserved www.plunkettresearch.com