Company Profile

PepsiCo is leading in the food and beverage multinational company, well known for its product diversification selling products in around 200 countries and territories. Their products caters to the tastes of their customers young and adults. They faced the challenge of providing their consumers nutritious food and beverages. Its main competitors is The Coca-Cola Company.

PepsiCo was founded by Caleb Bradham, headquartered in Purchase, Harrison, New York, United States. It is a public company registered under NASDAQ with ticker symbol PEP.

 

PepsiCo (PEP) Extended Graph Analysis

 

1. PEP CASH FLOW

	2015	2016	2017	2018	2019	TTM
Net cash flow provided by operating activites	10,580,000,000	10,404,000,000	9,994,000,000	9,415,000,000	9,649,000,000	9,649,000,000
Net cash used for investing activities	-3,569,000,000	-7,148,000,000	-4,403,000,000	4,564,000,000	-6,437,000,000	-6,437,000,000
Net cash provided by (used for) financing activities	-3,828,000,000	-2,942,000,000	-4,186,000,000	-13,769,000,000	-8,489,000,000	-8,489,000,000
Capital expenditure	-2,758,000,000	-3,040,000,000	-2,969,000,000	-3,282,000,000	-4,232,000,000	-4,232,000,000
Free cash flow	7,822,000,000	7,364,000,000	7,025,000,000	6,133,000,000	5,417,000,000	5,417,000,000
Working Capital	5,453,000,000	5,954,000,000	10,525,000,000	-245,000,000	-2,816,000,000	-2,816,000,000

Facts:

• Cash from operating activities was $9.649 billion in the trailing twelve months.
• Cash used for investing activities was -$6.437 billion in the trailing twelve months.
• Net cash from financing activities was -$8.489 billion in the trailing twelve months.
• Capital expenditure was -$4.232 billion in the trailing twelve months.
• Free cash flow was $5.417 billion in the trailing twelve months.
• Working capital was -$2.816 billion in the trailing twelve months.

Explanation:

• Cash from operating increased 2.49% from 2018 to trailing twelve months.
• Investing activities were purchase of property, plant and equipment and acquisitions.
• Financing activities were debt repayment, common stock repurchased and dividend payments.
• Capital expenditure was investment in property, plant and equipment.
• Free cash flow decreased 12 percent from 2018.
• Working capital was negative from 2018, current liabilities were higher than the current assets.

Interpretation

The company was able to provide cash from its operating activities in the last five years. PEP had a number of business acquisitions in recent years as one of their strategic moves.

 

2. PEP BALANCE SHEET

	2015	2016	2017	2018	2019
Total cash	12,009,000,000	16,125,000,000	19,510,000,000	8,993,000,000	5,738,000,000
Current Assets	23,031,000,000	27,089,000,000	31,027,000,000	21,893,000,000	17,645,000,000
Net property, plant and equipment	16,317,000,000	16,591,000,000	17,240,000,000	17,589,000,000	20,853,000,000
Total non-current assets	46,636,000,000	47,040,000,000	48,777,000,000	55,755,000,000	60,902,000,000
Total assets	69,667,000,000	74,129,000,000	79,804,000,000	77,648,000,000	78,547,000,000
Current liabilities	17,578,000,000	21,135,000,000	20,502,000,000	22,138,000,000	20,461,000,000
Non-current liabilities	40,166,000,000	41,899,000,000	48,413,000,000	40,992,000,000	43,300,000,000
Total liabilities	57,744,000,000	63,034,000,000	68,915,000,000	63,130,000,000	63,761,000,000
Retained earnings	50,472,000,000	52,518,000,000	52,839,000,000	59,947,000,000	61,946,000,000
Stockholders equity	11,923,000,000	11,095,000,000	10,889,000,000	14,518,000,000	14,786,000,000

Facts:

• Total cash was $5.738 billion in 2019.
• Current assets were $17.645 billion in 2019.
• Net property, plant and equipment was $20.853 in 2019.
• Total non-current assets were $60.902 billion in 2019.
• Total assets were $78.547 billion in 2019.
• Current liabilities were $20.641 billion in 2019.
• Non-current liabilities were $43.300 in 2019.
• Total liabilities were $63.761 in 2019.
• Retained earnings were $61.946 in 2019.
• Stockholders equity was $14.786 in 2019

Explanation:

• Total cash represents 7.31% of total assets.
• Current assets represent 22.46% of total assets.
• Net property, plant and equipment represents 26.55% of total assets.
• Total non-current assets represent 77.54% of total assets.
• Total assets grew 13% in five years.
• Current liabilities represent 32% of total liabilities.
• Non-current liabilities represent 68% of total liabilities.
• Total liabilities represents 81% to total liabilities and equity.
• Stockholder equity represents 19% of total liabilities and equity.

Interpretation

The company is highly leveraged, using four-fifth of creditors money in its business operation, nearly 20% of investors money is utilized in the operation. In other words, the creditors have more stake than the investors. 

 

3. PEP INCOME AND MARKET

	2015	2016	2017	2018	2019	2020
Revenue	63,056,000,000	62,799,000,000	63,525,000,000	64,661,000,000	67,161,000,000	67,161,000,000
EBIT	9,712,000,000	9,785,000,000	10,509,000,000	10,110,000,000	10,291,000,000	10,291,000,000
Net Income	5,452,000,000	6,329,000,000	4,857,000,000	12,515,000,000	7,314,000,000	7,314,000,000
EBITDA	10,828,000,000	12,263,000,000	13,122,000,000	13,113,000,000	12,879,000,000	12,879,000,000
Market Capitalization	144,684,000,000	150,059,000,000	170,543,000,000	155,666,000,000	190,108,000,000	197,550,000,000
Intrinsic Value	209,836,396,353	745,025,154,189	839,073,420,473	2,631,653,205,144	4,029,094,790,996	4,718,747,139,220

Facts:

• Revenue was $67.161 billion in trailing twelve months.
• EBIT was $10.291 billion in the trailing twelve months.
• Net income was $7.314 billion in the trailing twelve months.
• EBITDA was $12.879 billion in the trailing twelve months.
• The market capitalization was $197.550 billion.
• Intrinsic value was $4.719 trillion in the trailing twelve months.

Explanation:

• Revenue grew 7% in five years and from 2018 it grows 3.87%.
• EBIT grew 6% in five years and shows an increase of 1.79% from 2018.
• Net income grew 34% in five years. It has a negative growth of 41.56% from 2018.
• EBITDA grew 19% in five years. It has a negative growth from 2018 at 1.78%.
• Market capitalization was erratic in movement in the last five years and it increased 4% from 2019 to the last quarter.
• The calculated intrinsic value shows a very high value at $4.719 trillion.

Interpretation

The company is investing heavily in advertising and marketing, the reason its sales, general and administrative expense was high at 72% of gross profit which impacted the net income.

 

4. PEP FINANCIAL RATIOS

	2015	2016	2017	2018	2019	2020
Asset turnover (average)	0.90	0.87	0.83	0.82	0.86	0.86
Return on assets %	7.77	8.79	6.31	15.89	9.37	9.37
Return on equity %	37.20	55.14	44.32	98.66	49.92	49.92
Debt/Equity	2.46	2.72	3.12	1.95	1.97	1.97
Return on invested capital %	13.38	15.55	11.00	27.64	17.11	17.11
Interest coverage	8.67	7.37	9.34	7.03	9.20	9.20

Facts:

• Asset turnover was 0.86 in the trailing twelve months.
• Return on asset was 9.37% in the trailing twelve months.
• Return on equity was 49.92% in the trailing twelve months.
• Return on invested capital was 17.11% in the trailing twelve months.
• Interest coverage was 9.20 in the trailing twelve months.

Explanation:

• Asset turnover means that the company is generating $0.86 of sales for every $1 investment in assets.
• Return on assets means for every $1 invested in assets the company generates 9.37 cents of net income.
• Return on equity indicates that for every $1 of shareholders equity, PEP generated 49 or 50 cents in profit.
• Return on invested capital indicates that the invested capital yielded 17.11 percent of return.
• Interest coverage indicates that the company earns 9 times earnings than its current interest payment.

Interpretation

The company’s financial ratios show acceptable ratios. The company is liquid

 

5. PEP KEY EXECUTIVE COMPENSATION

Name/Title	2014	2015	2016	2017	2018
Key Executive Compensation	37,399,250	48,405,262	56,275,124	63,116,455	65,489,721
Indra K. Nooy/ Chairman of the Board and Chief Executive Officer	22,485,574	26,444,990	29,783,416	31,082,648	24,491,117
Ramon L Laquarta/Chairman of the Board and CEO		5,655,039	6,113,574	10,157,245	10,827,396
Albert P. Carey/CEO North America	7,712,149	7,744,388	10,071,299	10,160,310	7,868,118
Laxman Narasimhan/Global Chief Commercial Officer and CEO Latin America					7,009,990
Silviu Popovici/CEO Europe Sub Saharan Africa					6,151,034
Hugh F. Johnston/Vice Chairman, Executive Vice President and Chief Financial Officer	7,201,527	8,560,845	10,306,835	11,716,252	9,142,066

Facts:

• The key executive compensation was $65,489,721 in 2018.
• The CEO compensation was $24,491,117 in 2018.
• Chairman of the Board and CEO compensation was $10,827,396 in 2018.
• CEO North America compensation was $7,868,118 in 2018.
• Chief Commercial Officer and CEO Latin America compensation was $7,009,990 in 2018.
• CEO Europe Sub Saharan Africa compensation was 6,151,034 in 2018.
• Vice Chairman, Executive Vice President and Chief Financial Officer compensation was $9,142,066 in 2018.

Explanation:

• The total key executive compensation represents 0.90% of net income.
• CEO compensation represents 37.40% of the total key executive compensation.
• Chairman of the Board and CEO compensation represents 16.53% of the total key executive compensation.
• CEO North America compensation represents 12% of the total key executive compensation.
• Chief Commercial Officer and CEO Latin America compensation represents 11% of the total key executive compensation.
• CEO Europe Sub Saharan Africa compensation represents 9.39% of the total key executive compensation.
• Vice Chairman, Executive Vice President and Chief Financial Officer compensation represents 14% of the total key executive compensation.

Interpretation

The company’s key executive compensation represents 0.90% of the net income.

 

6. PEP LOBBYING AND CONTRIBUTIONS

Period	USD	Period	USD
1998	960,000	2009	9,373,000
1999	1,300,000	2010	6,874,800
2000	1,320,000	2011	3,260,000
2001	1,035,000	2012	3,330,000
2002	960,000	2013	3,720,000
2003	860,000	2014	3,510,000
2004	720,000	2015	4,470,000
2005	740,000	2016	3,140,000
2006	880,318	2017	2,880,000
2007	1,000,636	2018	3,470,000
2008	1,096,000	2019	3,490,000

Explanation:

PepsiCo has been spending annual lobbying and contributions since 1998. The amount varies annually. NOTE: Figures on this page are calculations by the Center for Responsive Politics based on data from the Senate Office of Public Records. Data for the most recent year was downloaded on January 23, 2020 and includes spending from January 1 – December 31. Prior years include spending from January through December.

Source: OpenSecret.org Center for Responsive Politics

 

6. PEP FINANCIAL STRENGTH

DATA

Working capital	-$2,816,000,000
Total assets	$78,547,000,000
Sales	$67,161,000,000
EBIT	$10,291,000,000
Market value of equity	$197,550,000,000
Book value of total liabilities	$63,761,000,000
Retained earnings	$61,946,000,000

 

CALCULATION

	Ratio	Score	Result
A – Working Capital / Total Assets	-0.0359	1.20	-0.04
B – Retained Earnings / Total Assets	0.79	1.40	1.10
C – EBIT / Total Assets	0.13	3.30	0.43
D – Market Value of Equity / Book Value of Total Liabilities	3.10	0.60	1.86
E – Sales / Total Assets	0.86	1.0	0.86
Z-Score			4.21

 

Formula: Z-Score = 1.2A + 1.4B + 3.3C + 0.6D + 1.0E

 

Explanation

Z-Score is a statistical measurement that compares data points from different sets of data to find correlations. This measurement by Dr. Edward Altman is a significant measure in determining the financial strength of the company because it relies on different weighted financial liquidity and profitability metrics to come up with the overall score. This measure indicates the probability of bankruptcy.

Interpretation

The overall Z-Score of PEP was 4.21, the grading scale for 3.00 and over according to Altman indicates that the company will not declare bankruptcy. This measurement is not calculated for the purpose of estimating the company will declare bankruptcy but it helps in comparing other companies that have become insolvent.

Conclusion

PepsiCo was liquid and has great potential for accelerating its revenue in the long run due to its diversification strategy. The company manufactures and sells a variety of food and beverages that caters to young people and adults. Although the company is highly leveraged, PEP is stable and has a strong financial strength.

CITATION

https://www.opensecrets.org/federal-lobbying/firms/summary?cycle=1998&id=D000000200

https://www.pepsico.com/about/about-the-company

https://www.morningstar.com/stocks/xnas/pep/quote

Researched and written by Criselda