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

175.01
 
USD
  
1.44
  
(0.83%)
Optionable: Yes  Market Cap: 237,405 M  90-day average vol: 5,920,317

Previous close: 173.57  Open: 174.76  Bid: 175.03  Ask: 175.81
52 week range    
155.83   
   196.88
Peers   
KO / 
MNST / 
MDLZ / 
K / 
Last updated: Friday 29th March 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

Financials

PEP Cash Flow

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
(Increase) Decrease in inventories-111 M-244 M-75 M-168 M-174 M-190 M-516 M-582 M-1,142 M-261 M
(Increase) Decrease in other working capital-266 M-208 M-125 M-113 M-255 M-350 M-255 M-256 M-224 M-434 M
(Increase) Decrease in payables1,533 M1,747 M1,326 M-137 M1,330 M448 M607 M1,792 M1,899 M730 M
(Increase) Decrease in receivables-343 M-461 M-349 M-202 M-253 M-650 M-420 M-651 M-1,763 M-793 M
Acquisitions-88 M-86 M-212 M-61 M-299 M-2,717 M-6,117 M-65 M-793 M-273 M
AssetImpairmentCharge418 M1,630 M160 M295 M308 M370 M289 M247 M411 M445 M
CapitalExpenditureReported2,859 M2,758 M3,040 M2,969 M3,282 M4,232 M4,240 M4,625 M5,207 M5,518 M
Cash at beginning of period9,375 M6,134 M9,096 M9,169 M10,657 M10,769 M5,570 M8,254 M5,707 M5,100 M
Cash at end of period6,680 M9,137 M9,158 M10,657 M10,769 M5,570 M8,254 M5,707 M5,100 M9,761 M
Cash flow10,506 M10,621 M10,673 M10,030 M9,415 M9,649 M10,358 M11,620 M10,731 M13,401 M
CashFlowFromContinuingInvestingActivities-4,937 M-3,569 M-7,148 M-4,403 M4,564 M-6,437 M-11,364 M-3,273 M-2,350 M-5,454 M
ChangeInAccountPayable1,162 M1,692 M997 M201 M882 M735 M766 M1,762 M1,842 M420 M
ChangeInIncomeTaxPayable371 M55 M329 M-338 M448 M-287 M-159 M30 M57 M310 M
ChangeInPayablesAndAccruedExpense1,533 M1,747 M1,326 M-137 M1,330 M448 M607 M1,792 M1,899 M730 M
ChangeInPrepaidAssets80 M-50 M10 M20 M9 M-87 M26 M159 M118 M-13 M
ChangeInTaxPayable371 M55 M329 M-338 M448 M-287 M-159 M30 M57 M310 M
ChangeInWorkingCapital893 M784 M787 M-600 M657 M-829 M-558 M462 M-1,112 M-771 M
ChangesInAccountReceivables-343 M-461 M-349 M-202 M-253 M-650 M-420 M-651 M-1,763 M-793 M
CommonStockDividendPaid-3,730 M-4,040 M-4,227 M-4,472 M-4,930 M-5,304 M-5,509 M-5,815 M-6,172 M-6,682 M
CommonStockPayments-5,012 M-5,000 M-3,000 M-2,000 M-2,000 M-3,000 M-2,000 M-106 M-1,500 M-1,000 M
Current deferred income taxes-19 M78 M452 M619 M-531 M453 M361 M298 M-873 M-271 M
Deferred income taxes-19 M78 M452 M619 M-531 M453 M361 M298 M-873 M-271 M
Depreciation2,625 M2,416 M2,368 M2,369 M2,399 M2,432 M2,548 M2,710 M2,763 M2,948 M
Depreciation unreconciled2,625 M2,416 M2,368 M2,369 M2,399 M2,432 M3,026 M3,215 M3,280 M3,518 M
DepreciationAndAmortization2,625 M2,416 M2,368 M2,369 M2,399 M2,432 M3,026 M3,215 M3,280 M3,518 M
Effect of exchange rate changes-221 M-252 M47 M-98 M78 M-129 M-114 M-465 M-277 M
ExcessTaxBenefitFromStockBasedCompensation-114 M-133 M-139 M-8 M190 M
FinancingCashFlow-8,264 M-3,828 M-3,211 M-4,186 M-13,769 M-8,489 M3,819 M-10,780 M-8,523 M-3,009 M
Free cash flow7,762 M7,949 M7,732 M7,241 M6,267 M5,587 M6,173 M7,157 M5,855 M8,122 M
GainLossOnSaleOfBusiness55 M
Issuance of debt-1,997 M25 M1,537 M-1,053 M-1,366 M1000000.0414 M45 M-13 M2,293 M
IssuanceOfDebt-331 M4,632 M3,746 M2,050 M-6,962 M-355 M11,293 M-4,132 M-810 M4,770 M
Net cash from financing activities-8,264 M-3,828 M-3,211 M-4,186 M-13,769 M-8,489 M3,819 M-10,780 M-8,523 M-3,009 M
Net cash from investing activities-4,937 M-3,569 M-7,148 M-4,403 M4,564 M-6,437 M-11,364 M-3,269 M-2,430 M-5,495 M
Net cash from operating activities10,506 M10,621 M10,673 M10,030 M9,415 M9,649 M10,358 M11,616 M10,811 M13,442 M
Net change in cash & cash equivalents-2,695 M3,003 M62 M1,488 M112 M-5,199 M2,684 M-2,433 M-142 M4,938 M
Net income from continuing operations6,558 M5,501 M6,379 M4,908 M12,559 M7,353 M7,175 M7,679 M8,978 M9,155 M
NetBusinessPurchaseAndSale115 M-10 M-127 M206 M206 M-2,464 M-6,111 M104 M-744 M-198 M
NetCommonStockIssuance-5,012 M-5,000 M-3,000 M-2,000 M-2,000 M-3,000 M-2,000 M-106 M-1,500 M-1,000 M
NetInvestmentPropertiesPurchaseAndSale-2,308 M-887 M-4,080 M-1,820 M7,506 M89 M-1,068 M1,082 M3,350 M64 M
NetInvestmentPurchaseAndSale-2,308 M-887 M-4,080 M-1,820 M7,506 M89 M-1,068 M1,082 M3,350 M64 M
NetIssuancePaymentsOfDebt-331 M4,632 M3,746 M2,050 M-6,962 M-355 M11,293 M-4,132 M-810 M4,770 M
NetLongTermDebtIssuance1,666 M4,607 M2,209 M3,103 M-5,596 M-356 M10,879 M-4,177 M-797 M2,477 M
NetPPEPurchaseAndSale-2,744 M-2,672 M-2,941 M-2,789 M-3,148 M-4,062 M-4,185 M-4,459 M-4,956 M-5,320 M
NetPreferredStockIssuance-10 M-5 M-7 M-5 M-2 M
Operating (gains) losses12 M262 M-194 M1000000.0-1,487 M-152 M-285 M-838 M-11 M-301 M
Other financing charges net64 M81 M-188 M-221 M-156 M-159 M-144 M-912 M-179 M-213 M
Other investing changes net-10 M-573 M9 M29 M-1,195 M-8 M67 M-53 M3,491 M51 M
Other non-cash items437 M1,580 M881 M2,733 M-4,182 M392 M639 M804 M469 M2,071 M
Payment of cash dividends3,730 M4,040 M4,227 M4,472 M4,930 M5,304 M5,509 M5,815 M6,172 M6,682 M
PensionAndEmployeeBenefitExpense12 M262 M-194 M1000000.0-1,487 M-197 M-154 M-662 M35 M-260 M
PreferredStockPayments-10 M-5 M-7 M-5 M-2 M
ProceedsFromStockOptionExercised755 M504 M465 M462 M281 M329 M179 M185 M138 M116 M
Purchase of Float term investments116 M-4,425 M-12,488 M-18,383 M-5,621 M19 M-1,135 M-291 M-555 M
Purchase of property plant & equipment-2,744 M-2,672 M-2,941 M-2,789 M-3,148 M-4,062 M-4,185 M-4,459 M-4,956 M-5,320 M
Purchase of short term investments3,855 M8,702 M7,818 M7,509 M3,614 M12,709 M-722 M1,661 M5,482 M
PurchaseOfInvestment116 M-4,425 M-12,488 M-18,383 M-5,621 M19 M-1,135 M-291 M-555 M
PurchaseOfPPE-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
Repayment of debt-2,189 M-4,095 M-5,609 M-4,406 M-5,596 M-3,970 M-1,830 M-3,455 M-2,458 M-3,005 M
RepaymentOfDebt-2,199 M-4,138 M-5,636 M-4,534 M-5,613 M-3,972 M-5,384 M-3,852 M-4,409 M-6,111 M
Repurchase of capital stock-5,012 M-5,000 M-3,000 M-2,000 M-2,000 M-3,000 M-2,000 M-106 M-1,500 M-1,000 M
Revenue per share478 M505 M517 M570 M
Sale of Float term investments12 M
Sale of short term investments-2,414 M4,111 M8,399 M16,534 M14,322 M78 M1,135 M150 M556 M
SaleOfBusiness203 M76 M85 M267 M505 M253 M6 M169 M49 M75 M
SaleOfInvestment-2,414 M4,111 M8,399 M16,534 M14,322 M78 M1,135 M150 M568 M
SaleOfPPE115 M86 M99 M180 M134 M170 M55 M166 M251 M198 M
ShortTermDebtIssuance-1,987 M68 M1,564 M-925 M-1,349 M3 M3,968 M442 M1,938 M5,399 M
ShortTermDebtPayments-10 M-43 M-27 M-128 M-17 M-2 M-3,554 M-397 M-1,951 M-3,106 M
StockBasedCompensation297 M295 M284 M292 M256 M237 M264 M301 M343 M380 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.

We respect your privacy and will never share your email.
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