PepsiCo Inc Stock Research

Market Summary

USD176.51-0.12

Market Closed

-0.07%

PEP Alerts

2 major insider sales recently.
Big fall in earnings (Y/Y)

PEP Stock Price

PEP RSI Chart

PEP Valuation

Market Cap

243.6B

Price/Earnings (Trailing)

27.34

Price/Sales (Trailing)

2.82

EV/EBITDA

19.07

Price/Free Cashflow

22.53

PEP Price/Sales (Trailing)

PEP Profitability

EBT Margin

12.39%

Return on Equity

51.96%

Return on Assets

9.67%

Free Cashflow Yield

4.44%

PEP Fundamentals

PEP Revenue

Revenue (TTM)

86.4B

Revenue Y/Y

10.88%

Revenue Q/Q

27.42%

PEP Earnings

Earnings (TTM)

8.9B

Earnings Y/Y

-60.82%

Earnings Q/Q

-80.83%

Price Action

52 Week Range

154.86186.62

(Low)(High)

Last 7 days

2.0%

Last 30 days

-0.6%

Last 90 days

-2.0%

Trailing 12 Months

11.9%

PEP Financial Health

Current Ratio

0.8

Debt/Equity

2.11

Debt/Cashflow

0.3

PEP Investor Care

Dividend Yield

2.56%

Dividend/Share (TTM)

4.53

Buy Backs (1Y)

0.14%

Diluted EPS (TTM)

6.42

Peers (Alternatives to PepsiCo)

View All Peers In Detail

Name	Mkt Capsorted ascending	Revenue	Price %, 1M	Returns, 1Y	P/E	P/S	Rev 1-Yr	Inc 1-Yr
LARGE-CAP
KO	260.8B	43.0B	-0.28%	3.56%	27.33	6.06	11.25%	-2.34%
PEP	243.6B	86.4B	-0.64%	11.86%	27.34	2.82	8.70%	16.96%
PM	147.9B	80.7B	-7.26%	8.04%	16.34	1.83	-1.89%	-0.67%
MNST	54.0B	6.3B	-1.79%	36.32%	45.32	8.56	13.89%	-13.49%
KDP	49.4B	14.1B	-2.08%	-5.00%	34.43	3.52	10.83%	-33.08%
TAP	11.2B	12.8B	0.17%	3.10%	-63.67	0.87	2.87%	-117.43%
MID-CAP
CELH	6.5B	653.6M	-14.69%	85.35%	-34.74	9.95	107.97%	-4902.10%
SAM	3.9B	2.2B	-15.87%	-12.12%	57.73	1.75	1.18%	362.19%
MGPI	2.1B	782.4M	-3.56%	16.91%	18.89	2.63	24.83%	19.88%
SMALL-CAP
REED	365.3M	50.8M	3480.11%	988.71%	-20.12	7.19	6.92%	-22.73%
WTER	23.4M	73.3M	-28.89%	-79.55%	-0.76	0.32	32.40%	6.88%
FIZZ	4.9M	1.2B	11.94%	26.39%	0.03	0	4.98%	-14.14%
JVA	12.0M	67.9M	-13.15%	-51.44%	30.49	0.18	6.35%	-24.82%

Financials for PepsiCo

* denotes actual numbers (not divided by Millions)
Income Statement (Last 12 Months)					(In Millions)
Description	(%) Q/Q	2022Q4	2022Q3	2022Q2	2022Q1	2021Q4
Revenue	3.3%	86,392	83,644	81,862	80,854	79,474
Gross Profit	3.3%	45,816	44,358	43,490	43,017	42,399
S&GA Expenses	4.2%	34,459	33,060	32,401	32,222	31,237
EBITDA	-11.5%	14,407	16,286	16,165	17,358	-
EBITDA Margin	-14.4%	0.17*	0.19*	0.20*	0.21*	-
Earnings Before Taxes	-9.2%	10,705	11,787	11,633	12,808	9,821
EBT Margin	-12.1%	0.12*	0.14*	0.14*	0.16*	-
Interest Expenses	-47.8%	939	1,798	1,840	1,845	1,863
Net Income	-8.3%	8,910	9,714	9,236	10,165	7,618
Net Income Margin	-11.2%	0.10*	0.12*	0.11*	0.13*	-
Free Cahsflow	-4.2%	10,811	11,288	11,157	12,161	-

Balance Sheet					(In Millions)
Description	(%) Q/Q	2022Q4	2022Q3	2022Q2	2022Q1	2021Q4
Assets	-2.4%	92,187	94,461	93,103	92,962	92,377
Current Assets	-8.5%	21,539	23,543	22,633	22,342	21,783
Cash Equivalents	-22.8%	4,954	6,415	5,405	6,561	5,596
Inventory	4.0%	5,222	5,019	5,287	4,762	4,347
Net PPE	6.5%	24,291	22,800	22,694	22,017	22,407
Goodwill	-1.0%	18,202	18,388	18,547	18,112	18,381
Liabilities	-0.5%	74,914	75,326	74,429	74,642	76,226
Current Liabilities	4.4%	26,785	25,653	27,223	25,824	26,220
. Short Term Borrowings	-48.5%	3,109	6,032	5,459	4,308	-
Long Term Debt	8.7%	36,136	33,247	34,590	36,026	-
LT Debt, Current	30.8%	1,700	1,300	-	-	-
LT Debt, Non Current	-1.0%	35,657	36,026	-	-	-
Shareholder's Equity	-9.6%	17,149	18,977	18,553	18,202	16,043
Retained Earnings	-1.6%	67,800	68,872	67,763	67,934	65,165
Additional Paid-In Capital	2.4%	4,134	4,036	3,970	3,893	4,001
Accumulated Depreciation	0.4%	25,300	25,208	24,516	24,421	-
Shares Outstanding	-0.1%	1,380	1,382	1,383	-	-
Minority Interest	-21.5%	124	158	121	118	108

Cashflow (Last 12 Months)					(In Millions)
Description	(%) Q/Q	2022Q4	2022Q3	2022Q2	2022Q1	2021Q4
Cashflow From Operations	-4.2%	10,811	11,288	11,157	12,161	11,616
Share Based Compensation	7.5%	343	319	313	303	301
Cashflow From Investing	-25.9%	-2,430	-1,930	-981	-408	-3,269
Cashflow From Financing	7.0%	-8,523	-9,166	-9,968	-10,672	-10,780
Dividend Payments	1.6%	6,172	6,073	5,970	5,891	5,815
Buy Backs	29.8%	1,500	1,156	699	193	106

Risks for PEP

What is the probability of a big loss on PEP?

19.2%

Probability that PepsiCo stock will be more than 20% underwater in next one year

Probability that PepsiCo stock will be more than 30% underwater in next one year.

Probability that PepsiCo stock will be more than 40% underwater in next one year.

*Calculated based on probability distribution of losses observed in actual data in the last 5 years.

How does PEP drawdown profile look like?

Y-axis is the maximum loss one would have experienced if PepsiCo was unfortunately bought at previous high price.

Drawdowns

Returns for PEP

Cumulative Returns on PEP

11.6%

10-Year Cumulative Returns

11.2%

7-Year Cumulative Returns

12.4%

5-Year Cumulative Returns

13.9%

3-Year Cumulative Returns

What are the long-term rolling returns for PEP?

FIve years rolling returns for PepsiCo.

Annualized Returns

Which funds bought or sold PEP recently?

View All Details

Datesorted ascending	Fund Name	Type	% Chg	$ Change	$ Held	% Portfolio
2023-03-15	B. Riley Wealth Advisors, Inc.	added	0.18	1,867,990	18,244,000	0.51%
2023-03-13	Claro Advisors LLC	added	10.35	569,064	3,469,060	1.14%
2023-03-10	VICTORY CAPITAL MANAGEMENT INC	added	1.5	38,149,000	347,794,000	0.38%
2023-03-10	MATHER GROUP, LLC.	added	32.66	498,722	1,565,720	0.03%
2023-03-10	Flagstone Financial Management	new	-	217,536	217,536	0.13%
2023-03-10	BAILLIE GIFFORD & CO	reduced	-1.64	9,402,680	115,678,000	0.12%
2023-03-08	Capital Asset Advisory Services LLC	added	1.85	463,938	3,807,940	0.30%
2023-03-08	SHEETS SMITH WEALTH MANAGEMENT	reduced	-1.42	1,741,930	20,900,900	3.27%
2023-03-07	Great Lakes Retirement, Inc.	new	-	1,411,450	1,411,450	0.36%
2023-03-06	OLD MISSION CAPITAL LLC	sold off	-100	-887,000	-	-%

Latest Funds Activity

Are funds buying PEP calls or puts?

Calls

Puts

Are funds bullish or bearish(Calls - Puts)?

Net Call Options

No. of funds that own PEP

No. of Funds

PepsiCo News

Schedule 13G FIlings of PepsiCo

Date Filed	Name of Filer	Percent of Class	No. of Shares	Form Type
Feb 09, 2023	vanguard group inc	9.47%	130,504,608	SC 13G/A
Feb 03, 2023	blackrock inc.	8.0%	110,125,154	SC 13G/A
Feb 09, 2022	vanguard group inc	8.87%	122,600,602	SC 13G/A
Feb 01, 2022	blackrock inc.	7.6%	105,501,759	SC 13G/A
Dec 17, 2021	pepsico inc	6.7%	4,586,075	SC 13G
Feb 10, 2021	vanguard group inc	8.79%	121,406,565	SC 13G/A
Jan 29, 2021	blackrock inc.	7.2%	100,057,368	SC 13G/A
Feb 12, 2020	vanguard group inc	8.22%	114,672,157	SC 13G/A
Feb 05, 2020	blackrock inc.	7.6%	106,385,603	SC 13G/A

PEP Fair Value

PepsiCo fair value in different scenarios

The table shows the Fair Value estimates for PepsiCo for various scenarios. Disclaimer: These are just estimations from a model. None of the models are good at predicting the future. Please dont buy or sell stocks based on these outputs.

Fair Value	Very Pessimistic	Pessimistic	Base Case	Optimistic	Very Optimistic
Very Low Inflation	68.84 -61.00%	104.33 -40.89%	136.46 -22.69%	180.67 2.36%	216.51 22.66%
Current Inflation	64.47 -63.48%	93.68 -46.93%	119.84 -32.11%	157.16 -10.96%	186.84 5.85%
Very High Inflation	58.92 -66.62%	80.95 -54.14%	100.57 -43.02%	130.15 -26.26%	153.06 -13.29%

Historical PepsiCo Fair Value Estimates

Very Pessimistic Case

Pessimistic Case

Fair Value

Optimistic Case

Very Optimistic Case

Closing Stock Price

Recent SEC filings of PepsiCo

View All Filings

Date Filed	Form Type	Document
Mar 13, 2023	4	Insider Trading
Mar 09, 2023	4	Insider Trading
Mar 09, 2023	4	Insider Trading
Mar 03, 2023	4	Insider Trading
Mar 03, 2023	4	Insider Trading
Mar 03, 2023	4	Insider Trading
Mar 03, 2023	4	Insider Trading
Mar 03, 2023	4	Insider Trading
Mar 03, 2023	4	Insider Trading
Mar 03, 2023	4	Insider Trading

Latest Insider Trading transactions for PEP

Filter Transactions

Datesorted ascending	Name	Buy/Sell	$ Value	Avg. Price	# Shares	Title
2023-03-09	POHLAD ROBERT C	acquired	16,337	181	90.2118	-
2023-03-09	POHLAD ROBERT C	sold	-12,935,100	172	-75,000	-
2023-03-07	Krishnan Ramkumar	sold	-2,905,960	172	-16,827	ceo intl beverages & cco
2023-03-07	Willemsen Eugene	gifted	-	-	12,553	ceo, amesa
2023-03-07	Willemsen Eugene	gifted	-	-	-12,553	ceo, amesa
2023-03-01	Willemsen Eugene	sold (taxes)	-2,150,080	170	-12,589	ceo, amesa
2023-03-01	Flavell David	acquired	-	-	8,687	evp, gen counsel & corp sec
2023-03-01	Williams Steven C	acquired	-	-	33,039	ceo, pfna
2023-03-01	Santilli Paula	sold (taxes)	-1,653,420	170	-9,681	ceo, latin america
2023-03-01	Schellekens Ronald	acquired	-	-	20,542	evp & chief hr officer

About PepsiCo

Ramon L. Laguarta

www.pepsico.com

65535

PepsiCo, Inc. manufactures, markets, distributes, and sells various beverages and convenient foods worldwide. The company operates through seven segments: Frito-Lay North America; Quaker Foods North America; PepsiCo Beverages North America; Latin America; Europe; Africa, Middle East and South Asia; and Asia Pacific, Australia and New Zealand and China Region. It provides dips, cheese-flavored snacks, and spreads, as well as corn, potato, and tortilla chips; cereals, rice, pasta, mixes and syrups, granola bars, grits, oatmeal, rice cakes, simply granola, and side dishes; beverage concentrates, fountain syrups, and finished goods; ready-to-drink tea, coffee, and juices; dairy products; and sparkling water makers and related products. It serves wholesale and other distributors, foodservice customers, grocery stores, drug stores, convenience stores, discount/dollar stores, mass merchandisers, membership stores, hard discounters, e-commerce retailers and authorized independent bottlers, and others through a network of direct-store-delivery, customer warehouse, and distributor networks, as well as directly to consumers through e-commerce platforms and retailers. The company was founded in 1898 and is headquartered in Purchase, New York.

PEP Income Statement

2022-09-03

CONDENSED CONSOLIDATED STATEMENT OF INCOME - USD ($) shares in Millions, $ in Millions	3 Months Ended		8 Months Ended
	Sep. 03, 2022	Sep. 04, 2021	Sep. 03, 2022	Sep. 04, 2021
Net Revenue	$ 21,971	$ 20,189	$ 58,396	$ 54,226
Cost of sales	10,308	9,394	27,156	24,945
Gross profit	11,663	10,795	31,240	29,281
Selling, general and administrative expenses	8,295	7,636	22,262	20,681
Gain associated with the Juice Transaction	14	0	(3,321)	0
Impairment of Intangible Assets (Excluding Goodwill)	1	0	1,602	0
Operating Profit	3,353	3,159	10,697	8,600
Other pension and retiree medical benefits income	36	118	168	364
Net interest expense and other	(190)	(232)	(666)	(731)
Income before income taxes	3,199	3,045	10,199	8,233
Provision for income taxes	475	802	1,756	1,895
Net income	2,724	2,243	8,443	6,338
Net Income (Loss) Attributable to Noncontrolling Interest	22	19	51	42
Net Income Attributable to PepsiCo	$ 2,702	$ 2,224	$ 8,392	$ 6,296
Net Income Attributable to PepsiCo per Common Share
Earnings Per Share, Basic (in USD per share)	$ 1.96	$ 1.61	$ 6.07	$ 4.56
Earnings Per Share, Diluted (in USD per share)	$ 1.95	$ 1.60	$ 6.04	$ 4.54
Weighted-average common shares outstanding
Weighted Average Number of Shares Outstanding, Basic (in shares)	1,380	1,382	1,382	1,381
Weighted Average Number of Shares Outstanding, Diluted (in shares)	1,387	1,389	1,389	1,388
Income Statement Additional Disclosure
Disposal Group, Including Discontinued Operation, Consideration	$ 3,500		$ 3,500
Tropicana JV
Income Statement Additional Disclosure
Equity Method Investment, Ownership Percentage	39.00%		39.00%

PEP Balance Sheet

2022-09-03

CONDENSED CONSOLIDATED BALANCE SHEET - USD ($) $ in Millions	Sep. 03, 2022	Dec. 25, 2021
Current Assets
Cash and cash equivalents	$ 6,415	$ 5,596
Short-term investments	327	392
Accounts and notes receivable, less allowance: 9/22 - $165 and 12/21 - $147	10,739	8,680
Inventories:
Raw materials and packaging	2,303	1,898
Work-in-process	150	151
Finished goods	2,566	2,298
Inventory, Net, Total	5,019	4,347
Prepaid expenses and other current assets	1,043	980
Assets held for sale	0	1,788
Total Current Assets	23,543	21,783
Property, plant and equipment	48,100	46,828
Accumulated depreciation	(25,300)	(24,421)
Property, Plant and Equipment, net	22,800	22,407
Amortizable Intangible Assets, net	1,314	1,538
Goodwill	18,388	18,381
Other Indefinite-Lived Intangible Assets	15,838	17,127
Investments in Noncontrolled Affiliates	3,224	2,350
Deferred Income Taxes	4,324	4,310
Other Assets	5,030	4,481
Total Assets	94,461	92,377
Current Liabilities
Short-term debt obligations	3,109	4,308
Accounts payable and other current liabilities	22,544	21,159
Liabilities held for sale	0	753
Total Current Liabilities	25,653	26,220
Long-Term Debt Obligations	36,136	36,026
Deferred Income Taxes	4,724	4,826
Other Liabilities	8,813	9,154
Total Liabilities	75,326	76,226
PepsiCo Common Shareholders’ Equity
Common stock, par value 12/3¢ per share (authorized 3,600 shares; issued, net of repurchased common stock at par value: 1,379 and 1,383 shares, respectively)	23	23
Capital in excess of par value	4,036	4,001
Retained earnings	68,872	65,165
Accumulated other comprehensive loss	(14,743)	(14,898)
Repurchased common stock, in excess of par value (488 and 484 shares, respectively)	(39,211)	(38,248)
Total PepsiCo Common Shareholders’ Equity	18,977	16,043
Noncontrolling interests	158	108
Total Equity	19,135	16,151
Total Liabilities and Equity	$ 94,461	$ 92,377