Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

PEP Stock Forecast, Price Targets, Chart, Dividends & Analysis

PepsiCo Inc. logo

PepsiCo Inc.

Sector: Consumer Defensive   

Industry: Beverages - Soft Drinks

142.84
 
USD
  
2.75
  
(1.96%)
Previous close: 140.09  Open: 140.34  Bid: 142.65  Ask: 143.05
52 week range    
138.33   
   183.41
Mkt Cap: 195,905 M  Avg Vol (90 Days): 7,357,145
Last updated: Sunday 20th April 2025

Stock Rankings

58
MarketXLS Rank
80
Value
18
Technical
76
Quality
How are these ranks calculated?
Search for a stock

Metrics

Growth

Peers

StockDividendMarket Cap (B)PEPrice ($)
Financials

PEP Income Statement

Annual
Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23Dec-24
AccretionOnPreferredStock5 M5 M4 M2 M
AccruedPreferredStockDividends-6 M-5 M-4 M-2 M
Amortization of intangibles75 M214 M224 M204 M166 M18,757 M18,381 M18,202 M17,728 M17,534 M
Basic EPS from continuing operations3.714.393.48.845.235.145.516.456.596.97
Basic EPS total3.714.393.48.845.235.145.516.456.596.97
Basic weighted shares outstanding1,469 M1,439 M1,425 M1,415 M1,399 M1,385 M1,382 M1,380 M1,376 M1,373 M
Cost of sales28,731 M28,209 M28,796 M29,381 M30,132 M31,797 M37,075 M40,576 M41,881 M41,744 M
Depreciation2,341 M2,298 M2,301 M2,330 M2,351 M2,458 M2,619 M2,685 M2,873 M3,086 M
Depreciation unreconciled75 M70 M
DepreciationAndAmortization75 M2,298 M2,301 M2,330 M2,351 M2,458 M2,619 M2,685 M2,873 M3,086 M
Diluted EPS total3.674.363.388.785.25.125.496.426.566.95
Diluted normalized net income/share3.674.363.388.785.25.125.496.426.566.95
Diluted weighted shares outstanding1,485 M1,452 M1,438 M1,425 M1,407 M1,392 M1,389 M1,387 M1,383 M1,378 M
Dividends paid per share2.762.963.173.593.794.024.254.534.955.33
Earnings from equity interest95 M
EarningsFromEquityInterestNetOfTax95 M
GainOnSaleOfBusiness140 M3,321 M
GainOnSaleOfSecurity156 M191 M-677 M
GeneralAndAdministrativeExpense24,538 M24,805 M24,453 M25,170 M26,738 M28,495 M31,237 M34,459 M36,677 M37,190 M
Gross operating profit34,325 M34,590 M34,729 M35,280 M37,029 M38,575 M42,399 M45,816 M49,590 M50,110 M
ImpairmentOfCapitalAssets202 M214 M321 M
Income before tax7,442 M8,553 M9,602 M9,189 M9,312 M9,069 M9,821 M10,705 M11,417 M11,946 M
Income restructuring and M&A-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-5,318 M
Income taxes1,941 M2,174 M4,694 M-3,370 M1,959 M1,894 M2,142 M1,727 M2,262 M2,320 M
Interest income59 M110 M244 M306 M
InterestExpenseNonOperating970 M1,342 M1,151 M1,525 M935 M1,128 M1,863 M939 M819 M919 M
InterestExpenseOperating-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-1,585 M
MarketingExpense3,900 M4,200 M4,100 M4,200 M4,700 M4,600 M5,100 M5,200 M5,700 M5,900 M
MinorityInterests-49 M-50 M-51 M-44 M-39 M-55 M-61 M-68 M-81 M-48 M
MiscOtherSpecialCharges1,860 M233 M233 M604 M-44 M117 M522 M132 M250 M-22 M
Net income from total operations5,452 M6,329 M4,857 M12,515 M7,314 M7,120 M7,618 M8,910 M9,074 M9,578 M
NetIncomeCommonStockholders13,712 M12,708 M9,765 M25,074 M7,314 M7,120 M7,618 M8,910 M9,074 M9,578 M
NetIncomeContinuousOperations5,452 M6,329 M4,857 M12,515 M7,314 M7,120 M7,618 M8,978 M9,155 M9,626 M
NetIncomeExtraordinary5,501 M6,379 M4,908 M12,559 M7,353 M
NetNonOperatingInterestIncomeExpense-911 M-1,232 M-907 M-1,525 M-935 M-1,128 M-1,863 M-939 M-819 M-919 M
Normalized income6,542 M
Operating income8,353 M9,785 M10,276 M10,110 M10,291 M10,080 M11,162 M11,512 M11,986 M12,887 M
Operating income before depreciation (EBITDA)9,876 M11,161 M11,999 M11,725 M11,603 M13,223 M14,899 M14,924 M15,754 M16,058 M
OperatingExpense23,213 M24,805 M24,453 M25,170 M26,738 M28,495 M31,237 M34,459 M36,677 M37,190 M
Other income net-1,860 M-389 M-233 M-604 M44 M-117 M-522 M287 M677 M55 M
OtherGandA24,538 M24,805 M24,453 M25,170 M26,738 M28,495 M31,237 M34,459 M36,677 M37,190 M
OtherImpairmentOfCapitalAssets41 M3,166 M927 M33 M
OtherOperatingExpenses-248 M-349 M-309 M-142 M-179 M-128 M-222 M-228 M-225 M-210 M
OtherunderPreferredStockDividend-1000000.0
PreferredStockDividends-1000000.0
PromotionAndAdvertising2,400 M2,500 M2,400 M2,600 M3,000 M3,000 M3,500 M3,500 M3,800 M3,900 M
RentAndLandingFees696 M701 M742 M771 M
Research & development expense754 M760 M737 M680 M711 M719 M752 M771 M804 M813 M
ResearchExpense754 M760 M737 M680 M711 M719 M752 M771 M804 M813 M
RestructringAndMnAIncome-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-5,318 M
Revenue per share75 M214 M224 M204 M166 M19,235 M18,886 M18,719 M18,298 M18,189 M
SalariesAndWages-1,400 M-91 M-89 M-45 M-39 M-48 M-57 M-62 M-73 M-68 M
Selling Gen & administrative expense24,538 M24,805 M24,453 M25,170 M26,738 M28,495 M31,237 M34,459 M36,677 M37,190 M
SellingAndMarketingExpense6,300 M6,700 M6,500 M6,800 M7,700 M7,600 M8,600 M8,700 M9,500 M9,800 M
Special income/charges2,556 M3,040 M2,969 M3,282 M4,232 M4,240 M4,625 M5,207 M5,197 M5,318 M
Total Income available for interest expense (EBIT)7,460 M8,793 M9,630 M9,326 M9,171 M10,197 M11,684 M11,644 M12,236 M12,898 M
Total common shares outstanding1,445 M1,427 M1,420 M1,405 M1,390 M1,380 M1,383 M1,377 M1,374 M1,371 M
Total net income5,452 M6,329 M4,857 M12,515 M7,314 M7,120 M7,618 M8,910 M9,074 M9,578 M
Total ordinary shares1,371 M1,371 M1,371 M1,371 M1,371 M1,371 M1,371 M1,371 M1,371 M1,371 M
Total revenues63,056 M62,799 M63,525 M64,661 M67,161 M70,372 M79,474 M86,392 M91,471 M91,854 M
TotalExpenses51,944 M53,014 M53,249 M54,551 M56,870 M60,292 M68,312 M75,035 M78,558 M78,934 M
TotalRevenue63,056 M62,799 M63,525 M64,661 M67,161 M70,372 M79,474 M86,392 M91,471 M91,854 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 provides all the tools I need for in-depth stock analysis. It's user-friendly and constantly improving. A must-have for serious investors.

John D.

Financial Analyst

I have been using MarketXLS for the last 6+ years and they really enhanced the product every year and now in the journey of bringing in AI...

Kirubakaran K.

Investment Professional

MarketXLS is a powerful tool for financial modeling. It integrates seamlessly with Excel and provides real-time data.

David L.

Financial Analyst

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

Lloyd L.

Professional Trader