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 5/5

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

$134.71

0.77(0.57%) Volume: 6,443,587 10:08PM EDT

Avg Vol (1m): 4,203,061

4 Medium Warning Signs 2 Good Signs

Market Cap : 188.35 B	Enterprise Value : 216.03 B	P/E (TTM) : 14.93	P/B : 13.56

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 (%)	4.80	1.10	2.50
EBITDA Growth (%)	4.10	3.60	-2.00
Operating Income Growth (%)	4.50	3.10	-2.00
EPS without NRI Growth (%)	4.50	9.00	181.00
Free Cash Flow Growth (%)	6.30	-0.70	7.60
Book Value Growth (%)	-2.50	-2.50	39.50

*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	Dec04	Dec05	Dec06	Dec07	Dec08	Dec09	Dec10	Dec11	Dec12	Dec13	Dec14	Dec15	Dec16	Dec17	Dec18	TTM	Jun18	Sep18	Dec18	Mar19	Jun19
Per Share Data	Annuals (USD $)View: $ % YOY																	Quarterly

Revenue per Share													42.46	43.25	44.18	45.38	46.13	11.28	11.58	13.76	9.12	11.67
EBITDA per Share													7.29	8.45	9.13	9.20	9.11	2.65	2.50	2.34	1.86	2.40
EBIT per Share													5.67	6.82	7.48	7.52	7.43	2.25	2.11	1.80	1.51	2.01
Earnings per Share (Diluted)													3.67	4.36	3.38	8.78	9.02	1.28	1.75	4.83	1.00	1.44
EPS without NRI													3.67	4.36	3.38	8.78	9.02	1.28	1.75	4.83	1.00	1.44
Owner Earnings per Share (TTM)													4.73	5.64	5.47	9.22	8.52	5.88	5.79	9.22	9.00	8.52
Free Cash Flow per Share													5.46	5.25	4.91	4.30	4.37	1.26	2.12	2.10	-0.56	0.72
Operating Cash Flow per Share													7.32	7.34	6.98	6.61	6.85	1.68	2.56	3.30	-0.24	1.23
Dividends per Share													2.76	2.96	3.17	3.59	3.74	0.93	0.93	0.93	0.93	0.96
Book Value per Share													8.09	7.70	7.61	10.27	9.93	7.12	7.26	10.27	10.08	9.93
Tangible Book per Share													-10.47	-11.71	-12.44	-11.39	-12.29	-12.75	-12.35	-11.39	-11.87	-12.29
Total Debt per Share													22.66	25.73	27.56	22.85	22.20	28.59	24.77	22.85	22.53	22.20
Month End Stock Price													99.92	104.63	119.92	110.48	134.71	108.87	111.80	110.48	122.55	131.13

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

ROE %													37.10	54.94	44.15	98.50	101.48	69.35	97.98	221.06	39.36	57.82
ROE % Adjusted to Book Value													3.00	4.04	2.80	9.15	7.48	4.54	6.36	20.54	3.24	4.38
ROA %													7.78	8.84	6.34	15.90	16.82	9.06	13.12	36.25	7.38	10.81
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
Return-on-Tangible-Asset													13.00	14.38	10.03	25.48	27.61	14.03	20.74	59.06	12.35	18.41
ROC (Joel Greenblatt) %													50.13	60.14	63.57	61.52	61.23	75.70	72.04	59.91	48.61	64.65
ROIC %													20.22	22.39	16.73	40.24	38.42	22.95	32.92	99.25	15.55	21.11
WACC %													6.05	5.72	5.46	5.80	4.42	5.64	6.08	5.80	5.43	4.95
Effective Interest Rate on Debt %													3.12	3.82	3.02	4.26	4.24	2.93	3.19	7.37	3.33	3.32

Gross Margin %													54.44	55.06	54.67	54.56	54.77	54.86	54.34	54.23	55.85	54.99
Operating Margin %													15.40	15.61	16.18	15.64	15.32	18.82	17.25	12.45	15.59	16.59
Net Margin %													8.65	10.08	7.65	19.35	19.59	11.31	15.15	35.11	10.97	12.37
FCF Margin %													12.86	12.14	11.12	9.48	9.51	11.21	18.27	15.26	-6.11	6.13

Debt-to-Equity													2.79	3.33	3.61	2.23	2.24	4.02	3.41	2.23	2.24	2.24
Equity-to-Asset													0.17	0.15	0.14	0.19	0.19	0.13	0.14	0.19	0.19	0.19
Debt-to-Asset													0.48	0.50	0.49	0.42	0.42	0.52	0.48	0.42	0.42	0.42
Gross-Profit-to-Asset %													48.97	48.31	45.31	44.81	47.02	43.97	47.04	55.99	37.60	48.06

Asset Turnover													0.90	0.88	0.83	0.82	0.86	0.20	0.22	0.26	0.17	0.22
Dividend Payout Ratio													0.75	0.68	0.94	0.41	0.41	0.73	0.53	0.19	0.93	0.66

Days Sales Outstanding													31.82	33.18	34.22	34.31	48.12	45.17	44.81	28.41	54.66	47.79
Days Payable													70.46	79.64	85.27	89.61	203.22	183.47	184.63	73.66	253.46	202.80
Days Inventory													37.24	35.20	35.93	37.73	42.74	42.88	40.21	32.01	53.60	46.48
Cash Conversion Cycle													-1.40	-11.26	-15.12	-17.57	-112.36	-95.42	-99.61	-13.24	-145.20	-108.53

Inventory Turnover													9.80	10.37	10.16	9.67	8.54	2.13	2.27	2.85	1.70	1.96
COGS-to-Revenue													0.46	0.45	0.45	0.45	0.45	0.45	0.46	0.46	0.44	0.45
Inventory-to-Revenue													0.05	0.04	0.05	0.05	0.05	0.21	0.20	0.16	0.26	0.23

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

Revenue													63,056	62,799	63,525	64,661	65,342	16,090	16,485	19,524	12,884	16,449
Cost of Goods Sold													28,731	28,222	28,796	29,381	29,555	7,263	7,527	8,936	5,688	7,404
Gross Profit													34,325	34,577	34,729	35,280	35,787	8,827	8,958	10,588	7,196	9,045
Gross Margin %													54.44	55.06	54.67	54.56	54.77	54.86	54.34	54.23	55.85	54.99

Selling, General, & Admin. Expense													24,613	24,773	24,453	25,170	25,775	5,799	6,114	8,157	5,188	6,316
Research & Development													--	--	--	--	--	--	--	--	--	--
Other Operating Expense													--	--	--	--	--	--	--	--	--	--
Operating Income													9,712	9,804	10,276	10,110	10,012	3,028	2,844	2,431	2,008	2,729
Operating Margin %													15.40	15.61	16.18	15.64	15.32	18.82	17.25	12.45	15.59	16.59

Interest Income													59	110	244	306	240	98	81	58	63	38
Interest Expense													-970	-1,342	-1,151	-1,525	-1,451	-308	-302	-621	-267	-261
Net Interest Income													-911	-1,232	-907	-1,219	-1,211	-210	-221	-563	-204	-223
Other Income (Expense)													-1,359	-19	233	298	266	82	74	67	64	61
Other Income (Minority Interest)													-49	-50	-51	-44	-41	-10	-11	-13	-9	-8
Pre-Tax Income													7,442	8,553	9,602	9,189	9,067	2,900	2,697	1,935	1,868	2,567
Tax Provision													-1,941	-2,174	-4,694	3,370	3,774	-1,070	-188	4,932	-446	-524
Tax Rate %													26.08	25.42	48.89	-36.67	-41.62	36.90	6.97	-254.88	23.88	20.41
Net Income (Continuing Operations)													5,501	6,379	4,908	12,559	12,841	1,830	2,509	6,867	1,422	2,043
Net Income (Discontinued Operations)													--	--	--	--	--	--	--	--	--	--
Net Income													5,452	6,329	4,857	12,515	12,800	1,820	2,498	6,854	1,413	2,035
Net Margin %													8.65	10.08	7.65	19.35	19.59	11.31	15.15	35.11	10.97	12.37

Preferred Dividends													1	1	--	--	--	--	--	--	--	--
EPS (Basic)													3.71	4.39	3.40	8.84	9.09	1.28	1.77	4.86	1.01	1.45
EPS (Diluted)													3.67	4.36	3.38	8.78	9.02	1.28	1.75	4.83	1.00	1.44
Shares Outstanding (Diluted Average)													1,485.0	1,452.0	1,438.0	1,425.0	1,409.0	1,426.0	1,424.0	1,419.0	1,413.0	1,409.0

Depreciation, Depletion and Amortization													2,416	2,368	2,369	2,399	2,385	574	566	763	498	558
EBITDA													10,828	12,263	13,122	13,113	12,903	3,782	3,565	3,319	2,633	3,386

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

Cash And Cash Equivalents													9,096	9,158	10,610	8,721	3,293	13,858	11,991	8,721	5,072	3,293
Marketable Securities													2,913	6,967	8,900	272	291	4,271	1,907	272	289	291
Cash, Cash Equivalents, Marketable Securities													12,009	16,125	19,510	8,993	3,584	18,129	13,898	8,993	5,361	3,584
Accounts Receivable													5,497	5,709	5,956	6,079	8,615	7,965	8,095	6,079	7,717	8,615
Notes Receivable													--	--	--	--	--	--	--	--	--	--
Other Current Receivables													940	985	1,068	1,063	-113	-124	-120	1,063	-113	-113
Total Receivables													6,437	6,694	7,024	7,142	8,502	7,841	7,975	7,142	7,604	8,502
Inventories, Raw Materials & Components													1,312	1,315	1,344	1,312	1,589	1,520	1,401	1,312	1,438	1,589
Inventories, Work In Process													161	150	167	178	384	231	164	178	257	384
Inventories, Inventories Adjustments													--	--	--	--	--	--	--	--	--	--
Inventories, Finished Goods													1,247	1,258	1,436	1,638	2,015	1,740	1,577	1,638	1,859	2,015
Inventories, Other													--	--	--	--	--	--	--	--	--	--
Total Inventories													2,720	2,723	2,947	3,128	3,988	3,491	3,142	3,128	3,554	3,988
Other Current Assets													1,865	908	1,546	2,630	1,138	909	827	2,630	1,398	1,138
Total Current Assets													23,031	26,450	31,027	21,893	17,212	30,370	25,842	21,893	17,917	17,212

Investments And Advances													2,311	1,950	2,042	2,409	2,510	2,401	2,394	2,409	2,476	2,510
Land And Improvements													1,184	1,153	1,148	1,078	--	--	--	1,078	--	--
Buildings And Improvements													8,061	8,306	8,796	8,941	--	--	--	8,941	--	--
Machinery, Furniture, Equipment													24,764	25,277	27,018	27,715	--	--	--	27,715	--	--
Construction In Progress													1,738	2,082	2,144	2,430	--	--	--	2,430	--	--
Other Gross PPE													--	--	--	--	40,264	38,974	38,878	--	40,245	40,264
Gross Property, Plant and Equipment													35,747	36,818	39,106	40,164	40,264	38,974	38,878	40,164	40,245	40,264
Accumulated Depreciation													-19,430	-20,227	-21,866	-22,575	-22,822	-22,212	-22,337	-22,575	-22,695	-22,822
Property, Plant and Equipment													16,317	16,591	17,240	17,589	17,442	16,762	16,541	17,589	17,550	17,442
Intangible Assets													27,258	27,863	28,582	30,633	31,213	28,221	27,798	30,633	30,920	31,213
Goodwill													14,177	14,430	14,744	14,808	15,632	14,540	14,332	14,808	14,945	15,632
Other Long Term Assets													750	636	913	5,124	6,707	977	1,057	5,124	6,603	6,707
Total Assets													69,667	73,490	79,804	77,648	75,084	78,731	73,632	77,648	75,466	75,084

Accounts Payable													5,546	6,158	6,727	7,213	16,455	14,603	15,230	7,213	15,799	16,455
Total Tax Payable													--	--	--	--	--	--	--	--	--	--
Other Current Payables													1,041	1,097	1,161	3,326	--	--	--	3,326	--	--
Current Accrued Expense													2,319	2,444	2,390	2,541	--	--	--	2,541	--	--
Accounts Payable & Accrued Expense													8,906	9,699	10,278	13,080	16,455	14,603	15,230	13,080	15,799	16,455
Short-Term Debt													4,071	6,892	5,485	4,026	3,473	9,955	4,474	4,026	3,291	3,473
Short-Term Capital Lease Obligation													--	--	--	--	--	--	--	--	--	--
Short-Term Debt & Capital Lease Obligation													4,071	6,892	5,485	4,026	3,473	9,955	4,474	4,026	3,291	3,473
Current Deferred Revenue													--	--	--	--	--	--	--	--	--	--
Current Deferred Taxes Liabilities													--	--	--	--	--	--	--	--	--	--
DeferredTaxAndRevenue													--	--	--	--	--	--	--	--	--	--
Other Current Liabilities													4,601	4,544	4,739	5,032	--	--	--	5,032	--	--
Total Current Liabilities													17,578	21,135	20,502	22,138	19,928	24,558	19,704	22,138	19,090	19,928

Long-Term Debt													29,213	30,053	33,796	28,295	27,712	30,638	30,643	28,295	28,458	27,712
Long-Term Capital Lease Obligation													--	--	--	--	--	--	--	--	--	--
Long-Term Debt & Capital Lease Obligation													29,213	30,053	33,796	28,295	27,712	30,638	30,643	28,295	28,458	27,712
Debt-to-Equity													2.79	3.33	3.61	2.23	2.24	4.02	3.41	2.23	2.24	2.24
PensionAndRetirementBenefit													--	--	--	--	--	--	--	--	--	--
NonCurrent Deferred Liabilities													4,959	4,434	3,242	3,499	3,658	3,346	3,358	3,499	3,619	3,658
Other Long-Term Liabilities													5,887	6,669	11,283	9,114	9,749	9,968	9,538	9,114	10,003	9,749
Total Liabilities													57,637	62,291	68,823	63,046	61,047	68,510	63,243	63,046	61,170	61,047

Common Stock													24	24	24	23	23	24	24	23	23	23
Preferred Stock													41	41	41	--	--	--	--	--	--	--
Retained Earnings													50,472	52,518	52,839	59,947	60,752	53,223	54,404	59,947	60,060	60,752
Accumulated other comprehensive income (loss)													-13,319	-13,919	-13,057	-15,119	-14,984	-13,580	-14,253	-15,119	-14,656	-14,984
Additional Paid-In Capital													3,890	3,899	3,799	3,953	3,796	3,915	3,939	3,953	3,753	3,796
Treasury Stock													-29,185	-31,468	-32,757	-34,286	-35,635	-33,471	-33,828	-34,286	-34,978	-35,635
Other Stockholders Equity													--	--	--	--	--	--	--	--	--	--
Total Stockholders Equity													11,923	11,095	10,889	14,518	13,952	10,111	10,286	14,518	14,202	13,952
Minority Interest													107	104	92	84	85	110	103	84	94	85
Total Equity													12,030	11,199	10,981	14,602	14,037	10,221	10,389	14,602	14,296	14,037
Equity-to-Asset													0.17	0.15	0.14	0.19	0.19	0.13	0.14	0.19	0.19	0.19

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

Net Income													5,452	6,329	4,857	12,515	12,800	1,820	2,498	6,854	1,413	2,035
Net Foreign Currency Exchange Gain													--	--	--	--	--	--	--	--	--	--
Net Income From Continuing Operations													5,501	6,379	4,908	12,559	12,841	1,830	2,509	6,867	1,422	2,043
Depreciation, Depletion and Amortization													2,416	2,368	2,369	2,399	2,385	574	566	763	498	558
Change In Receivables													-461	-349	-202	-253	-606	-857	-280	1,046	-406	-966
Change In Inventory													-244	-75	-168	-174	-409	-254	275	188	-435	-437
Change In Prepaid Assets													-50	10	20	9	-103	123	66	167	-382	46
Change In Payables And Accrued Expense													1,747	1,310	-137	1,215	1,046	722	899	466	-1,087	768
Change In Working Capital													992	896	-487	797	-72	-266	960	1,867	-2,310	-589
Change In DeferredTax													78	452	3,070	-559	-978	561	-366	-804	187	5
Stock Based Compensation													295	284	292	256	228	66	57	53	57	61
Asset Impairment Charge													1,359	--	--	--	--	--	--	--	--	--
Cash Flow from Discontinued Operations													--	--	--	--	--	--	--	--	--	--
Cash Flow from Others													223	284	-122	-6,037	-4,688	-369	-81	-4,063	-199	-345
Cash Flow from Operations													10,864	10,663	10,030	9,415	9,716	2,396	3,645	4,683	-345	1,733

Purchase Of Property, Plant, Equipment													-2,758	-3,040	-2,969	-3,282	-3,504	-593	-633	-1,704	-442	-725
Sale Of Property, Plant, Equipment													86	99	180	134	133	34	76	15	2	40
Purchase Of Business													-654	-212	-61	-1,496	-3,732	-152	-65	-1,243	-1,863	-561
Sale Of Business													76	85	267	505	495	238	14	211	--	270
Purchase Of Investment													-4,428	-12,504	-18,385	-5,637	-2,221	-2,128	-93	--	--	--
Sale Of Investment													4,114	8,415	16,536	14,338	4,171	5,032	2,472	1,685	9	5
Net Intangibles Purchase And Sale													--	--	--	--	--	--	--	--	--	--
Cash From Discontinued Investing Activities													--	--	--	--	--	--	--	--	--	--
Cash From Other Investing Activities													-5	7	29	2	-4	--	--	2	-6	--
Cash Flow from Investing													-3,569	-7,150	-4,403	4,564	-2,534	2,431	1,771	-1,034	-2,300	-971

Issuance of Stock													--	--	--	--	--	--	--	--	--	--
Repurchase of Stock													-5,000	-3,000	-2,000	-2,000	-2,742	-491	-458	-558	-940	-786
Net Issuance of Preferred Stock													-5	-7	-5	-2	--	--	--	--	--	--
Net Issuance of Debt													4,632	3,746	2,050	-6,962	-9,707	-2,718	-5,477	-3,057	-612	-561
Cash Flow for Dividends													-4,040	-4,227	-4,472	-4,930	-5,260	-1,145	-1,316	-1,309	-1,332	-1,303
Other Financing													301	277	241	125	159	14	38	26	8	87
Cash Flow from Financing													-4,112	-3,211	-4,186	-13,769	-17,550	-4,340	-7,213	-4,898	-2,876	-2,563

Effect of Exchange Rate Changes													-221	-252	47	-98	-55	-68	-54	-25	57	-33
Net Change in Cash													3,183	302	1,441	210	-10,368	487	-1,797	-1,249	-5,521	-1,801
Capital Expenditure													-2,758	-3,040	-2,969	-3,282	-3,504	-593	-633	-1,704	-442	-725
Free Cash Flow													8,106	7,623	7,061	6,133	6,212	1,803	3,012	2,979	-787	1,008

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


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.