30 Year Financial Data of PepsiCo Inc (NAS:PEP)

PEP- NAS (USA) Also traded in: Argentina, Austria, Belgium, Brazil, Chile, Germany, Mexico, Netherlands, Switzerland, UK
PepsiCo Inc

Currently 2/5

Business Predictability Rank: 2-Star (On Watch)
Back Testing Results:
Average gain of all 2-Star stocks: 6% per year.
% of Stocks that are in still loss if held for 10yrs: 16%.
Read more:
What is Predictability Rank?
Performances of real portfolio
Top Ranked Predictable Companies

$146.99

0.52(0.36%) Volume: 3,549,307 11:08PM EST

Avg Vol (1m): 4,115,810

3 Medium Warning Signs 2 Good Signs

Market Cap : 204.25 B	Enterprise Value : 231.1 B	P/E (TTM) : 16.78	P/B : 13.86

RSS

Manual of Stocks™ Web APP

Manual of Stocks™

Sorry. Only PremiumPlus Member can access this feature.

Free Trial

Also traded in: Argentina, Austria, Belgium, Brazil, Chile, Germany, Mexico, Netherlands, Switzerland, UK

Annual Rates (per share)	10 yrs*	5 yrs*	12 months*
Revenue Growth (%)	3.70	1.90	5.00
EBITDA Growth (%)	3.20	4.10	-0.70
Operating Income Growth (%)	3.60	3.10	2.90
EPS without NRI Growth (%)	N/A	N/A	-100.00
Free Cash Flow Growth (%)	4.10	-5.80	-10.70
Book Value Growth (%)	-4.20	0.40	1.80

*12-month growth rate is calculated with the quarterly per share revenue (EBITDA, FCF, earnings) of the last 12 months over the per share revenue (EBITDA, FCF, earnings) over the previous 12 months. 5-year and 10-year growth rates are calculated with least-square regression based on the 6-year and 11-year annual numbers. Please click Growth Rate Calculation Example (GuruFocus) to see how GuruFocus calculates Wal-Mart Stores Inc (WMT)'s revenue growth rate. You can apply the same method to get the growth rate you want.

Trendline:

Embed

Subscribe to see/download 30-Year Financial data in one page.

7-Day Free Trial

* All numbers are in millions except for per share data, ratios, and percentage data * All shares outstanding data and per share data are split adjusted * Empty lines (lines with only 0's) are hidden by default * Preliminary data is from the companies' press releases. 10-Q/K data is not available yet. Preliminary data is not used in the calculation of Ratios,Scores or Rankings * Financial Statement Template: Manufacturing / Mining / Transportation / Utility / Others * Cash Flow from Operations Template: Indirect Method * For latest financial page display change, please click GuruFocus 30-Y Financials Page Item Changes

30-Y Financial Download

API Excel Add-In Video Tutorial

Standard View
Add View

A+ A- Show empty lines Hide the embedded charts

Export Excel file Export CSV file PDF

Set Default Questions

Fiscal Period	Trend	Dec05	Dec06	Dec07	Dec08	Dec09	Dec10	Dec11	Dec12	Dec13	Dec14	Dec15	Dec16	Dec17	Dec18	Dec19	TTM	Dec18	Mar19	Jun19	Sep19	Dec19
Per Share Data	Annuals (USD $)View: $ % YOY																	Quarterly

Revenue per Share													43.25	44.18	45.38	47.67	47.83	13.76	9.12	11.67	12.23	14.80
EBITDA per Share													8.45	9.13	9.20	9.14	9.17	2.34	1.86	2.40	2.50	2.40
EBIT per Share													6.82	7.48	7.52	7.41	7.44	1.80	1.51	2.01	2.09	1.83
Earnings per Share (Diluted)													4.36	3.38	8.78	--	8.76	4.83	1.00	1.44	1.49	--
EPS without NRI													4.36	3.38	8.78	--	8.76	4.83	1.00	1.44	1.49	--
Owner Earnings per Share (TTM)													5.64	5.47	9.30	5.35	5.35	9.30	9.09	8.61	8.43	5.35
Free Cash Flow per Share													5.25	4.91	4.30	3.85	3.87	2.10	-0.56	0.72	2.05	1.66
Operating Cash Flow per Share													7.34	6.98	6.61	6.85	6.89	3.30	-0.24	1.23	2.62	3.29
Dividends per Share													2.96	3.17	3.59	--	2.84	0.93	0.93	0.96	0.96	--
Book Value per Share													7.74	7.64	10.30	10.49	10.60	10.30	10.12	9.98	10.13	10.60
Tangible Book per Share													-11.77	-12.49	-11.44	-11.89	-12.02	-11.44	-11.91	-12.35	-12.21	-12.02
Total Debt per Share													25.87	27.66	22.94	23.07	23.31	22.94	22.61	22.30	23.35	23.31
Month End Stock Price													104.63	119.92	110.48	136.67	146.99	110.48	122.55	131.13	137.10	136.67

Ratios	AnnualsView: $ % YOY																	Quarterly
Fiscal Period		Dec05	Dec06	Dec07	Dec08	Dec09	Dec10	Dec11	Dec12	Dec13	Dec14	Dec15	Dec16	Dec17	Dec18	Dec19	TTM	Dec18	Mar19	Jun19	Sep19	Dec19

ROE %													54.94	44.15	98.50	49.92	51.08	221.06	39.36	57.82	59.83	48.86
ROE % Adjusted to Book Value													4.06	2.81	9.19	3.83	3.69	20.62	3.25	4.40	4.42	3.79
ROA %													8.84	6.34	15.90	9.37	9.52	36.25	7.38	10.81	11.01	9.06
Return-on-Tangible-Equity								Negative Tangible Equity	Negative Tangible Equity	Negative Tangible Equity	Negative Tangible Equity	Negative Tangible Equity	Negative Tangible Equity	Negative Tangible Equity	Negative Tangible Equity	Negative Tangible Equity	Negative Tangible Equity	Negative Tangible Equity	Negative Tangible Equity	Negative Tangible Equity	Negative Tangible Equity	Negative Tangible Equity
Return-on-Tangible-Asset													14.38	10.03	25.48	15.56	15.99	59.06	12.35	18.41	18.63	15.14
ROC (Joel Greenblatt) %													60.14	63.57	61.52	54.35	57.39	59.91	48.61	64.65	66.94	53.13
ROIC %													22.39	16.73	40.24	20.42	20.03	99.25	15.55	21.11	21.85	21.04
WACC %													5.72	5.46	5.80	4.60	4.37	5.80	5.43	4.95	4.39	4.60
Effective Interest Rate on Debt %													3.82	3.02	4.26	3.50	3.54	7.37	3.33	3.32	3.29	4.24

Gross Margin %													55.06	54.67	54.56	55.13	55.13	54.23	55.85	54.99	55.24	54.72
Operating Margin %													15.61	16.18	15.64	15.32	15.32	12.45	15.59	16.59	16.61	13.08
Net Margin %													10.08	7.65	19.35	10.89	10.89	35.11	10.97	12.37	12.22	8.56
FCF Margin %													12.14	11.12	9.48	8.07	8.07	15.26	-6.11	6.13	16.77	11.21

Debt-to-Equity													3.33	3.61	2.23	2.20	2.20	2.23	2.24	2.24	2.30	2.20
Equity-to-Asset													0.15	0.14	0.19	0.19	0.19	0.19	0.19	0.19	0.18	0.19
Debt-to-Asset													0.50	0.49	0.42	0.41	0.41	0.42	0.42	0.42	0.42	0.41
Gross-Profit-to-Asset %													48.31	45.31	44.81	47.41	48.19	55.99	37.60	48.06	49.80	57.92

Asset Turnover													0.88	0.83	0.82	0.86	0.87	0.26	0.17	0.22	0.23	0.27
Dividend Payout Ratio													0.68	0.94	0.41	--	0.73	0.19	0.93	0.66	0.64	--

Days Sales Outstanding													33.18	34.22	34.31	35.04	35.04	28.41	54.66	47.79	46.98	28.50
Days Payable													79.64	85.27	89.61	97.06	97.06	73.66	253.46	202.80	204.07	78.24
Days Inventory													35.20	35.93	37.73	39.16	42.82	32.01	53.60	46.48	45.39	34.20
Cash Conversion Cycle													-11.26	-15.12	-17.57	-22.86	-19.20	-13.24	-145.20	-108.53	-111.70	-15.54

Inventory Turnover													10.37	10.16	9.67	9.32	8.52	2.85	1.70	1.96	2.01	2.67
COGS-to-Revenue													0.45	0.45	0.45	0.45	0.45	0.46	0.44	0.45	0.45	0.45
Inventory-to-Revenue													0.04	0.05	0.05	0.05	0.05	0.16	0.26	0.23	0.22	0.17

Income Statement	Annual (USD $) View: $%/share% YOY																	Quarterly
Fiscal Period		Dec05	Dec06	Dec07	Dec08	Dec09	Dec10	Dec11	Dec12	Dec13	Dec14	Dec15	Dec16	Dec17	Dec18	Dec19	TTM	Dec18	Mar19	Jun19	Sep19	Dec19

Revenue													62,799	63,525	64,661	67,161	67,161	19,524	12,884	16,449	17,188	20,640
Cost of Goods Sold													28,222	28,796	29,381	30,132	30,132	8,936	5,688	7,404	7,694	9,346
Gross Profit													34,577	34,729	35,280	37,029	37,029	10,588	7,196	9,045	9,494	11,294
Gross Margin %													55.06	54.67	54.56	55.13	55.13	54.23	55.85	54.99	55.24	54.72

Selling, General, & Admin. Expense													24,773	24,453	25,170	26,738	26,738	8,157	5,188	6,316	6,639	8,595
Research & Development													--	--	--	--	--	--	--	--	--	--
Other Operating Expense													--	--	--	--	--	--	--	--	--	--
Operating Income													9,804	10,276	10,110	10,291	10,291	2,431	2,008	2,729	2,855	2,699
Operating Margin %													15.61	16.18	15.64	15.32	15.32	12.45	15.59	16.59	16.61	13.08

Interest Income													110	244	306	200	200	58	63	38	38	61
Interest Expense													-1,342	-1,151	-1,525	-1,135	-1,135	-621	-267	-261	-262	-345
Net Interest Income													-1,232	-907	-1,219	-935	-935	-563	-204	-223	-224	-284
Other Income (Expense)													-19	233	298	-44	-44	67	64	61	38	-207
Other Income (Minority Interest)													-50	-51	-44	-39	-39	-13	-9	-8	-10	-12
Pre-Tax Income													8,553	9,602	9,189	9,312	9,312	1,935	1,868	2,567	2,669	2,208
Tax Provision													-2,174	-4,694	3,370	-1,959	-1,959	4,932	-446	-524	-559	-430
Tax Rate %													25.42	48.89	-36.67	21.04	21.04	-254.88	23.88	20.41	20.94	19.47
Net Income (Continuing Operations)													6,379	4,908	12,559	7,353	7,353	6,867	1,422	2,043	2,110	1,778
Net Income (Discontinued Operations)													--	--	--	--	--	--	--	--	--	--
Net Income													6,329	4,857	12,515	7,314	7,314	6,854	1,413	2,035	2,100	1,766
Net Margin %													10.08	7.65	19.35	10.89	10.89	35.11	10.97	12.37	12.22	8.56

Preferred Dividends													1	--	--	--	--	--	--	--	--	--
EPS (Basic)													4.39	3.40	8.84	--	8.82	4.86	1.01	1.45	1.50	--
EPS (Diluted)													4.36	3.38	8.78	--	8.76	4.83	1.00	1.44	1.49	--
Shares Outstanding (Diluted Average)													1,452.0	1,438.0	1,425.0	1,409.0	1,394.4	1,419.0	1,413.0	1,409.0	1,405.0	1,394.4

Depreciation, Depletion and Amortization													2,368	2,369	2,399	2,432	2,432	763	498	558	578	798
EBITDA													12,263	13,122	13,113	12,879	12,879	3,319	2,633	3,386	3,509	3,351

Balance Sheet	Annuals (USD $)View: $%/share% YOY																	Quarterly
Fiscal Period		Dec05	Dec06	Dec07	Dec08	Dec09	Dec10	Dec11	Dec12	Dec13	Dec14	Dec15	Dec16	Dec17	Dec18	Dec19	Latest Q.	Dec18	Mar19	Jun19	Sep19	Dec19

Cash And Cash Equivalents													9,158	10,610	8,721	5,509	5,509	8,721	5,072	3,293	5,494	5,509
Marketable Securities													6,967	8,900	272	229	229	272	289	291	287	229
Cash, Cash Equivalents, Marketable Securities													16,125	19,510	8,993	5,738	5,738	8,993	5,361	3,584	5,781	5,738
Accounts Receivable													5,709	5,956	6,079	6,447	6,447	6,079	7,717	8,615	8,849	6,447
Notes Receivable													--	--	--	--	--	--	--	--	--	--
Loans Receivable													--	--	--	--	--	--	--	--	--	--
Other Current Receivables													985	1,068	1,063	1,375	1,375	1,063	-113	-113	-114	1,375
Total Receivables													6,694	7,024	7,142	7,822	7,822	7,142	7,604	8,502	8,735	7,822
Inventories, Raw Materials & Components													1,315	1,344	1,312	1,395	1,395	1,312	1,438	1,589	1,509	1,395
Inventories, Work In Process													150	167	178	200	200	178	257	384	316	200
Inventories, Inventories Adjustments													--	--	--	--	--	--	--	--	--	--
Inventories, Finished Goods													1,258	1,436	1,638	1,743	1,743	1,638	1,859	2,015	1,842	1,743
Inventories, Other													--	--	--	--	--	--	--	--	--	--
Total Inventories													2,723	2,947	3,128	3,338	3,338	3,128	3,554	3,988	3,667	3,338
Other Current Assets													908	1,546	2,630	747	747	2,630	1,398	1,138	1,015	747
Total Current Assets													26,450	31,027	21,893	17,645	17,645	21,893	17,917	17,212	19,198	17,645

Investments And Advances													1,950	2,042	2,409	2,683	2,683	2,409	2,476	2,510	2,690	2,683
Land And Improvements													1,153	1,148	1,078	1,130	1,130	1,078	--	--	--	1,130
Buildings And Improvements													8,306	8,796	8,941	9,314	9,314	8,941	--	--	--	9,314
Machinery, Furniture, Equipment													25,277	27,018	27,715	29,390	29,390	27,715	--	--	--	29,390
Construction In Progress													2,082	2,144	2,430	3,169	3,169	2,430	--	--	--	3,169
Other Gross PPE													--	--	--	1,548	1,548	--	40,245	40,264	40,645	1,548
Gross Property, Plant and Equipment													36,818	39,106	40,164	44,551	44,551	40,164	40,245	40,264	40,645	44,551
Accumulated Depreciation													-20,227	-21,866	-22,575	-23,698	-23,698	-22,575	-22,695	-22,822	-23,059	-23,698
Property, Plant and Equipment													16,591	17,240	17,589	20,853	20,853	17,589	17,550	17,442	17,586	20,853
Intangible Assets													27,863	28,582	30,633	31,544	31,544	30,633	30,920	31,213	31,150	31,544
Goodwill													14,430	14,744	14,808	15,501	15,501	14,808	14,945	15,632	15,338	15,501
Other Long Term Assets													636	913	5,124	5,822	5,822	5,124	6,603	6,707	6,820	5,822
Total Assets													73,490	79,804	77,648	78,547	78,547	77,648	75,466	75,084	77,444	78,547

Accounts Payable													6,158	6,727	7,213	8,013	8,013	7,213	15,799	16,455	17,207	8,013
Total Tax Payable													--	--	--	--	--	--	--	--	--	--
Other Current Payables													1,097	1,161	3,326	1,409	1,409	3,326	--	--	--	1,409
Current Accrued Expense													2,444	2,390	2,541	2,765	2,765	2,541	--	--	--	2,765
Accounts Payable & Accrued Expense													9,699	10,278	13,080	12,187	12,187	13,080	15,799	16,455	17,207	12,187
Short-Term Debt													6,892	5,485	4,026	2,920	2,920	4,026	3,291	3,473	2,924	2,920
Short-Term Capital Lease Obligation													--	--	--	442	442	--	--	--	--	442
Short-Term Debt & Capital Lease Obligation													6,892	5,485	4,026	3,362	3,362	4,026	3,291	3,473	2,924	3,362
Current Deferred Revenue													--	--	--	--	--	--	--	--	--	--
Current Deferred Taxes Liabilities													--	--	--	--	--	--	--	--	--	--
DeferredTaxAndRevenue													--	--	--	--	--	--	--	--	--	--
Other Current Liabilities													4,544	4,739	5,032	4,912	4,912	5,032	--	--	--	4,912
Total Current Liabilities													21,135	20,502	22,138	20,461	20,461	22,138	19,090	19,928	20,131	20,461

Long-Term Debt													30,053	33,796	28,295	29,148	29,148	28,295	28,458	27,712	29,630	29,148
Long-Term Capital Lease Obligation													--	--	--	--	--	--	--	--	--	--
Long-Term Debt & Capital Lease Obligation													30,053	33,796	28,295	29,148	29,148	28,295	28,458	27,712	29,630	29,148
Debt-to-Equity													3.33	3.61	2.23	2.20	2.20	2.23	2.24	2.24	2.30	2.20
PensionAndRetirementBenefit													--	--	--	--	--	--	--	--	--	--
NonCurrent Deferred Liabilities													4,434	3,242	3,499	4,091	4,091	3,499	3,619	3,658	3,643	4,091
Other Long-Term Liabilities													6,669	11,283	9,114	9,979	9,979	9,114	10,003	9,749	9,816	9,979
Total Liabilities													62,291	68,823	63,046	63,679	63,679	63,046	61,170	61,047	63,220	63,679

Common Stock													24	24	23	23	23	23	23	23	23	23
Preferred Stock													41	41	--	--	--	--	--	--	--	--
Retained Earnings													52,518	52,839	59,947	61,946	61,946	59,947	60,060	60,752	61,514	61,946
Accumulated other comprehensive income (loss)													-13,919	-13,057	-15,119	-14,300	-14,300	-15,119	-14,656	-14,984	-15,126	-14,300
Additional Paid-In Capital													3,899	3,799	3,953	3,886	3,886	3,953	3,753	3,796	3,842	3,886
Treasury Stock													-31,468	-32,757	-34,286	-36,769	-36,769	-34,286	-34,978	-35,635	-36,124	-36,769
Other Stockholders Equity													--	--	--	--	--	--	--	--	--	--
Total Stockholders Equity													11,095	10,889	14,518	14,786	14,786	14,518	14,202	13,952	14,129	14,786
Minority Interest													104	92	84	82	82	84	94	85	95	82
Total Equity													11,199	10,981	14,602	14,868	14,868	14,602	14,296	14,037	14,224	14,868
Equity-to-Asset													0.15	0.14	0.19	0.19	0.19	0.19	0.19	0.19	0.18	0.19

Cashflow Statement	Annuals (USD $)View: $%/share% YOY																	Quarterly
Fiscal Period		Dec05	Dec06	Dec07	Dec08	Dec09	Dec10	Dec11	Dec12	Dec13	Dec14	Dec15	Dec16	Dec17	Dec18	Dec19	TTM	Dec18	Mar19	Jun19	Sep19	Dec19

Net Income From Continuing Operations													6,379	4,908	12,559	7,353	7,353	6,867	1,422	2,043	2,110	1,778
Depreciation, Depletion and Amortization													2,368	2,369	2,399	2,432	2,432	763	498	558	578	798
Change In Receivables													-349	-202	-253	-650	-650	1,046	-406	-966	-344	1,066
Change In Inventory													-75	-168	-174	-190	-190	188	-435	-437	299	383
Change In Prepaid Assets													10	20	9	-87	-87	167	-382	46	72	177
Change In Payables And Accrued Expense													1,310	-137	1,330	448	448	540	-1,087	768	746	21
Change In Working Capital													896	-487	912	-479	-479	1,941	-2,310	-589	773	1,647
Change In DeferredTax													452	3,070	-559	445	445	-804	187	5	-26	279
Stock Based Compensation													284	292	256	237	237	53	57	61	51	68
Asset Impairment Charge													--	--	--	--	--	--	--	--	--	--
Cash from Discontinued Operating Activities													--	--	--	--	--	--	--	--	--	--
Cash Flow from Others													284	-122	-6,152	-339	-339	-4,137	-199	-345	189	16
Cash Flow from Operations													10,663	10,030	9,415	9,649	9,649	4,683	-345	1,733	3,675	4,586

Purchase Of Property, Plant, Equipment													-3,040	-2,969	-3,282	-4,232	-4,232	-1,704	-442	-725	-792	-2,273
Sale Of Property, Plant, Equipment													99	180	134	170	170	15	2	40	21	107
Purchase Of Business													-212	-61	-1,496	-2,717	-2,717	-1,243	-1,863	-561	-204	-89
Sale Of Business													85	267	505	253	464	211	--	270	-17	--
Purchase Of Investment													-12,504	-18,385	-5,637	--	--	--	--	--	--	--
Sale Of Investment													8,415	16,536	14,338	97	97	1,685	9	5	10	73
Net Intangibles Purchase And Sale													--	--	--	--	--	--	--	--	--	--
Cash From Discontinued Investing Activities													--	--	--	--	--	--	--	--	--	--
Cash From Other Investing Activities													7	29	2	-8	-8	2	-6	--	-32	30
Cash Flow from Investing													-7,150	-4,403	4,564	-6,437	-6,437	-1,034	-2,300	-971	-1,014	-2,152

Issuance of Stock													--	--	--	--	--	--	--	--	--	--
Repurchase of Stock													-3,000	-2,000	-2,000	-3,000	-3,000	-558	-940	-786	-542	-732
Net Issuance of Preferred Stock													-7	-5	-2	--	--	--	--	--	--	--
Net Issuance of Debt													3,746	2,050	-6,962	-355	-355	-3,057	-612	-561	1,417	-599
Cash Flow for Dividends													-4,227	-4,472	-4,930	-5,304	-5,304	-1,309	-1,332	-1,303	-1,336	-1,333
Other Financing													277	241	125	170	170	26	8	87	71	4
Cash Flow from Financing													-3,211	-4,186	-13,769	-8,489	-8,489	-4,898	-2,876	-2,563	-390	-2,660

Effect of Exchange Rate Changes													-252	47	-98	78	78	-25	57	-33	-35	89
Net Change in Cash													50	1,488	112	-5,199	-5,199	-1,274	-5,464	-1,834	2,236	-137
Capital Expenditure													-3,040	-2,969	-3,282	-4,232	-4,232	-1,704	-442	-725	-792	-2,273
Free Cash Flow													7,623	7,061	6,133	5,417	5,417	2,979	-787	1,008	2,883	2,313

Valuation Ratios	AnnualsView: $ % YOY																	Quarterly
Fiscal Period		Dec05	Dec06	Dec07	Dec08	Dec09	Dec10	Dec11	Dec12	Dec13	Dec14	Dec15	Dec16	Dec17	Dec18	Dec19	Current	Dec18	Mar19	Jun19	Sep19	Dec19


PE Ratio
Price-to-Owner-Earnings
PB Ratio
Price-to-Tangible-Book
Price-to-Free-Cash-Flow
Price-to-Operating-Cash-Flow
PS Ratio
PEG Ratio
EV-to-Revenue
EV-to-EBITDA
EV-to-EBIT
Earnings Yield (Joel Greenblatt) %
Forward Rate of Return (Yacktman) %

Value Screens

Downloads | Tools

Strategies

Market Valuation

By Country

Articles

Submit Articles

Categories

Subscribe to see/download 30-Year Financial data in one page.