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

180.67
 
USD
  
1.24
  
(0.69%)
Optionable: Yes  Market Cap: 247,132 M  90-day average vol: 4,778,546

Previous close: 179.43  Open: 180.65  Bid: 180.89  Ask: 180.89
52 week range    
154.86   
   186.84
Peers   
KO / 
MNST / 
MDLZ / 
K / 
Last updated: Thursday 30th March 2023
58
MarketXLS Rank
60
Value
53
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
Are you?
twitterstocktwits
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-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
Total revenues66,415 M66,683 M63,056 M62,799 M63,525 M64,661 M67,161 M70,372 M79,474 M86,392 M
Cost of sales26,027 M26,080 M26,315 M25,854 M26,427 M26,982 M27,288 M28,771 M33,860 M37,296 M
Gross operating profit37,725 M37,978 M34,325 M34,577 M34,729 M35,280 M37,029 M38,575 M42,399 M45,816 M
Selling Gen & administrative expense25,357 M25,772 M24,613 M24,773 M24,453 M25,170 M26,738 M28,495 M31,237 M34,459 M
Research & development expense0000000000
Operating income9,705 M9,581 M9,712 M9,804 M10,276 M10,110 M10,291 M10,080 M11,162 M11,357 M
floaterest income0000000000
floaterest expense0000000000
Other income net00-1,359 M-19 M233 M298 M-44 M117 M522 M287 M
Pre-tax Income (EBT)8,891 M8,757 M7,442 M8,553 M9,602 M9,189 M9,312 M9,069 M9,821 M10,705 M
Income taxes2,104 M2,199 M1,941 M2,174 M4,694 M-3,370 M1,959 M1,894 M2,142 M1,727 M
Net income from total operations6,787 M6,558 M5,501 M6,379 M4,908 M12,559 M7,353 M7,175 M7,679 M8,978 M
Minority floaterest0000000000
Total net income6,740 M6,513 M5,452 M6,329 M4,857 M12,515 M7,314 M7,120 M7,618 M8,910 M
Preferred dividends1000000100000010000001000000N/AN/AN/AN/AN/AN/A
Net income available for common6,786 M6,557 M5,500 M6,378 M4,908 M12,559 M7,353 M7,175 M7,679 M8,978 M
Depreciation2,663 M2,625 M2,416 M2,368 M2,369 M2,399 M2,844 M3,026 M3,215 M3,280 M
Amortization110 M92 M75 M70 M45 M00000
Operating income before depreciation (EBITDA)12,465 M12,291 M10,828 M12,263 M13,122 M12,807 M13,091 M13,223 M14,899 M14,924 M
Total Income available for floaterest expense (EBIT)0000000000
Basic EPS total4.374.313.714.393.48.845.235.145.516.45
Diluted EPS total4.324.273.674.363.388.785.25.125.496.42
Call: 1-877-778-8358
Ankur Mohan MarketXLS
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and starter sheets.
Get started today