Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
PepsiCo Inc. logo

PepsiCo Inc.

Sector: Consumer Defensive   

Industry: Beverages - Soft Drinks

174.13
 
USD
  
1.86
  
(1.08%)
Optionable: Yes  Market Cap: 230,217 M  90-day average vol: 5,837,824

Previous close: 172.27  Open: 172.28  Bid: 173.15  Ask: 174.13
52 week range    
155.83   
   196.88
Peers   
KO / 
MNST / 
MDLZ / 
K / 
Last updated: Monday 22nd April 2024
59
MarketXLS Rank
40
Value
76
Technical
63
Quality

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

K

0.037622 B17.261.77

KO

0.0276262 B30.161.6

MDLZ

0.020993 B2267.48

MNST

46 B30.384.54

UL

Financials

PEP Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
AccretionOnPreferredStock9 M5 M5 M4 M2 M
AccruedPreferredStockDividends-10 M-6 M-5 M-4 M-2 M
Amortization of intangibles92 M75 M214 M224 M204 M166 M18,757 M18,381 M18,202 M17,728 M
Basic EPS from continuing operations4.313.714.393.48.845.235.145.516.456.59
Basic EPS total4.313.714.393.48.845.235.145.516.456.59
Basic weighted shares outstanding1,509 M1,469 M1,439 M1,425 M1,415 M1,399 M1,385 M1,382 M1,380 M1,376 M
Cost of sales30,884 M28,731 M28,209 M28,796 M29,381 M30,132 M31,797 M37,075 M40,576 M41,881 M
Depreciation2,533 M2,341 M2,298 M2,301 M2,330 M2,351 M2,458 M2,619 M2,685 M2,873 M
Depreciation unreconciled92 M75 M70 M
DepreciationAndAmortization92 M75 M2,298 M2,301 M2,330 M2,351 M2,458 M2,619 M2,685 M2,873 M
Diluted EPS total4.273.674.363.388.785.25.125.496.426.56
Diluted normalized net income/share4.273.674.363.388.785.25.125.496.426.56
Diluted weighted shares outstanding1,527 M1,485 M1,452 M1,438 M1,425 M1,407 M1,392 M1,389 M1,387 M1,383 M
Dividends paid per share2.532.762.963.173.593.794.024.254.534.95
Earnings from equity interest95 M
EarningsFromEquityInterestNetOfTax95 M
GainOnSaleOfBusiness140 M3,321 M
GainOnSaleOfSecurity156 M191 M-677 M
GeneralAndAdministrativeExpense26,126 M24,538 M24,805 M24,453 M25,170 M26,738 M28,495 M31,237 M34,459 M36,677 M
Gross operating profit35,799 M34,325 M34,590 M34,729 M35,280 M37,029 M38,575 M42,399 M45,816 M49,590 M
ImpairmentOfCapitalAssets202 M214 M321 M
Income before tax8,757 M7,442 M8,553 M9,602 M9,189 M9,312 M9,069 M9,821 M10,705 M11,417 M
Income restructuring and M&A-2,859 M-2,758 M-3,040 M-2,969 M-3,282 M-4,232 M-4,240 M-4,625 M-5,207 M-5,518 M
Income taxes2,199 M1,941 M2,174 M4,694 M-3,370 M1,959 M1,894 M2,142 M1,727 M2,262 M
Interest income59 M110 M244 M306 M
InterestExpenseNonOperating909 M970 M1,342 M1,151 M1,525 M935 M1,128 M1,863 M939 M819 M
InterestExpenseOperating-925 M-952 M-1,102 M-1,123 M-1,388 M-1,076 M-1,156 M-1,184 M-1,043 M-1,401 M
MarketingExpense3,900 M3,900 M4,200 M4,100 M4,200 M4,700 M4,600 M5,100 M5,200 M5,700 M
MinorityInterests-45 M-49 M-50 M-51 M-44 M-39 M-55 M-61 M-68 M-81 M
MiscOtherSpecialCharges1,894 M1,860 M233 M233 M604 M-44 M117 M522 M132 M250 M
Net income from total operations6,513 M5,452 M6,329 M4,857 M12,515 M7,314 M7,120 M7,618 M8,910 M9,074 M
NetIncomeCommonStockholders48,785 M13,712 M12,708 M9,765 M25,074 M7,314 M7,120 M7,618 M8,910 M9,074 M
NetIncomeContinuousOperations6,513 M5,452 M6,329 M4,857 M12,515 M7,314 M7,120 M7,618 M8,910 M9,074 M
NetIncomeExtraordinary6,558 M5,501 M6,379 M4,908 M12,559 M7,353 M
NetNonOperatingInterestIncomeExpense-909 M-911 M-1,232 M-907 M-1,525 M-935 M-1,128 M-1,863 M-939 M-819 M
Normalized income4,749 M
Operating income9,581 M8,353 M9,785 M10,276 M10,110 M10,291 M10,080 M11,162 M11,512 M11,986 M
Operating income before depreciation (EBITDA)11,366 M9,876 M11,161 M11,999 M11,725 M11,603 M12,067 M13,715 M13,881 M14,353 M
OperatingExpense26,218 M23,213 M24,805 M24,453 M25,170 M26,738 M28,495 M31,237 M34,459 M36,677 M
Other income net-1,894 M-1,860 M-389 M-233 M-604 M44 M-117 M-522 M-287 M677 M
OtherGandA26,126 M24,538 M24,805 M24,453 M25,170 M26,738 M28,495 M31,237 M34,459 M36,677 M
OtherImpairmentOfCapitalAssets41 M3,166 M927 M
OtherOperatingExpenses-349 M-248 M-349 M-309 M-142 M-179 M-128 M-222 M-228 M-225 M
OtherunderPreferredStockDividend-1000000.0-1000000.0
PreferredStockDividends-1000000.0-1000000.0
PromotionAndAdvertising2,300 M2,400 M2,500 M2,400 M2,600 M3,000 M3,000 M3,500 M3,500 M3,800 M
RentAndLandingFees707 M696 M701 M742 M771 M
Research & development expense718 M754 M760 M737 M680 M711 M719 M752 M771 M804 M
ResearchExpense718 M754 M760 M737 M680 M711 M719 M752 M771 M804 M
RestructringAndMnAIncome-2,859 M-2,758 M-3,040 M-2,969 M-3,282 M-4,232 M-4,240 M-4,625 M-5,207 M-5,518 M
Revenue per share92 M75 M214 M224 M204 M166 M19,235 M18,886 M18,719 M18,298 M
SalariesAndWages-75 M-1,400 M-91 M-89 M-45 M-39 M-48 M-57 M-62 M-73 M
Selling Gen & administrative expense26,126 M24,538 M24,805 M24,453 M25,170 M26,738 M28,495 M31,237 M34,459 M36,677 M
SellingAndMarketingExpense6,200 M6,300 M6,700 M6,500 M6,800 M7,700 M7,600 M8,600 M8,700 M9,500 M
Special income/charges2,859 M2,556 M3,040 M2,969 M3,282 M4,232 M4,240 M4,625 M5,207 M5,197 M
Total Income available for interest expense (EBIT)8,741 M7,460 M8,793 M9,630 M9,326 M9,171 M9,041 M10,500 M10,601 M10,835 M
Total common shares outstanding1,482 M1,445 M1,427 M1,420 M1,405 M1,390 M1,380 M1,383 M1,377 M1,374 M
Total net income6,513 M5,452 M6,329 M4,857 M12,515 M7,314 M7,120 M7,618 M8,910 M9,074 M
Total ordinary shares1,374 M1,374 M1,374 M1,374 M1,374 M1,374 M1,374 M1,374 M1,374 M1,374 M
Total revenues66,683 M63,056 M62,799 M63,525 M64,661 M67,161 M70,372 M79,474 M86,392 M91,471 M
TotalExpenses57,102 M51,944 M53,014 M53,249 M54,551 M56,870 M60,292 M68,312 M75,035 M78,558 M
TotalRevenue66,683 M63,056 M62,799 M63,525 M64,661 M67,161 M70,372 M79,474 M86,392 M91,471 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University