Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Search for stocks (e.g., AAPL, GOOGL, AMZN)
PEP logo

PEP

NGS
PepsiCo Inc.
Consumer DefensiveBeverages - Soft Drinks
Watchlists:
Last updated: Thursday 10th July 2025
134.48
-0.56 (-0.41%)
Prev Close:135.04
Open:134.9
Bid:134.2
Ask:134.6
52 Week Range
127.60
180.91
Volume:9,071,460
Mkt Cap:185,151 M
Price Target
$154.65
+15.0%
Financials

Financial Statements

PEP - Balance Sheet (Annual)

Dec-24Dec-23Dec-22Dec-21Dec-20Dec-19Dec-18Dec-17Dec-16Dec-15
Accounts Payable24,454 M25,137 M23,371 M9,834 M19,592 M17,541 M18,112 M15,017 M14,243 M13,507 M
Accumulated Depreciation & Depletion-27,997 M-27,400 M-25,493 M-24,421 M-24,971 M-23,698 M-22,575 M-21,866 M-20,227 M-19,430 M
Cash And Equivalents8,505 M9,711 M4,954 M5,596 M8,185 M5,509 M8,721 M10,610 M9,158 M9,096 M
Cash Cash Equivalents And Short Term Investments9,266 M10,003 M5,348 M5,988 M9,551 M5,738 M8,993 M19,510 M16,125 M12,009 M
Cash Equivalents5,596 M8,185 M5,509 M10,718 M10,610 M
Commercial Paper400 M1,385 M2,257 M770 M
Common Stock23 M23 M23 M23 M23 M23 M23 M-173 M-168 M210 M
Current Accrued Expenses3,087 M
Current Capital Lease Obligation642 M556 M483 M446 M460 M442 M459 M452 M423 M387 M
Current Deferred Taxes Assets3,522 M3,551 M3,276 M3,231 M1,952 M2,741 M2,816 M
Current Deferred Taxes Liabilities4,038 M3,463 M3,008 M2,366 M5,194 M7,175 M7,084 M
Defined Pension Benefit1,260 M
Dividends Payable1,885 M1,767 M1,610 M1,508 M1,430 M1,351 M1,329 M1,161 M1,097 M1,041 M
Employee Benefits302 M263 M235 M250 M290 M289 M299 M
Float Term Debt37,224 M37,595 M35,657 M36,026 M40,370 M29,148 M28,295 M33,796 M30,053 M29,213 M
Goodwill And Other Intangible Assets32,335 M32,657 M33,788 M37,046 M38,072 M31,544 M30,633 M28,582 M27,863 M27,258 M
Land & Improvements1,123 M
Long Term Capital Lease Obligation1,598 M1,233 M1,118 M
Long Term Debt And Capital Lease Obligation37,224 M37,595 M35,657 M36,026 M40,370 M29,148 M28,295 M33,796 M30,053 M29,213 M
Minority Interest130 M134 M124 M108 M98 M82 M84 M92 M104 M107 M
Net Other Unrealized Gain Loss-2,714 M-2,719 M-2,361 M-2,750 M-3,520 M-2,988 M-3,271 M-2,804 M-2,645 M-2,329 M
Net Unrealized Gain Loss Foreign Currency-15,217 M-13,255 M-12,948 M-12,309 M-11,940 M-11,290 M-11,918 M-10,277 M-11,386 M-11,080 M
Net Unrealized Gain Loss Investments2 M-4 M64 M88 M
Non Current Accounts Receivable111 M
Non Current Deferred Assets4,362 M4,474 M4,204 M4,429 M4,372 M4,359 M4,364 M
Non Current Deferred Liabilities3,484 M3,895 M4,133 M4,826 M4,284 M4,091 M3,499 M3,242 M4,434 M4,959 M
Non Current Deferred Taxes Assets4,362 M4,474 M4,204 M4,310 M4,372 M4,359 M4,364 M3,115 M3,851 M3,952 M
Non Current Prepaid Assets1,190 M1,057 M948 M1,260 M910 M846 M269 M374 M53 M60 M
Other Current Borrowings7,082 M6,510 M3,414 M3,908 M3,780 M2,920 M4,026 M5,485 M6,892 M4,071 M
Other Current Liabilities5,216 M4,969 M4,390 M4,713 M3,855 M3,135 M3,277 M2,954 M2,774 M2,842 M
Other Equity Interest2,750 M3,520 M2,988 M3,271 M2,804 M2,645 M2,329 M
Other Inventories5,306 M5,334 M5,222 M4,347 M4,172 M3,338 M3,128 M2,947 M2,723 M2,720 M
Other Payable21,159 M19,592 M17,541 M18,112 M15,017 M
Payables24,454 M25,137 M23,371 M11,342 M19,592 M17,541 M18,112 M15,017 M14,243 M13,507 M
Preferred Stock199 M41 M41 M41 M
Raw Materials2,440 M2,388 M2,366 M1,898 M1,720 M1,395 M1,312 M1,344 M1,315 M1,312 M
Recievables Adjustments Allowances-356 M-175 M-150 M-147 M-201 M-105 M-101 M-129 M-134 M-130 M
Retained Earnings54,654 M54,501 M52,498 M65,165 M47,967 M47,646 M44,828 M39,782 M38,599 M37,153 M
Total Capitalization92,489 M93,693 M88,463 M88,095 M94,194 M73,082 M105,394 M111,238 M102,669 M99,906 M
Total Equity Gross Minority18,171 M18,637 M17,273 M16,151 M13,552 M14,868 M48,888 M43,738 M42,667 M41,587 M
Total Equity Gross Minority Interest18,171 M18,637 M17,273 M16,151 M13,552 M14,868 M48,888 M43,738 M42,667 M41,587 M
Total Liabilities And Total Equity Gross Minority Interest99,467 M100,495 M92,187 M92,654 M92,918 M78,547 M111,934 M112,561 M73,490 M69,667 M
Total Non Current Liabilities Net Minority Interes49,760 M50,211 M48,129 M50,006 M55,994 M43,218 M40,908 M48,321 M41,156 M40,059 M
Working Capital-5,710 M-4,697 M-5,246 M-4,437 M-371 M-2,816 M-245 M10,525 M5,315 M5,453 M
Accrec10,333 M10,815 M10,163 M7,172 M8,404 M7,822 M7,142 M7,024 M6,694 M6,437 M
Addpaid4,385 M4,261 M4,134 M4,001 M3,910 M3,886 M3,953 M3,996 M4,091 M4,076 M
Build10,279 M
Capstk23 M23 M23 M23 M23 M23 M23 M-132 M-127 M251 M
Comstkeqty18,041 M18,503 M17,149 M16,043 M13,454 M14,786 M48,804 M43,646 M42,563 M41,480 M
Constr3,940 M
Curdebt7,082 M6,510 M3,414 M4,308 M3,780 M2,920 M4,026 M5,485 M6,892 M4,071 M
Curdebtcaplease7,082 M6,510 M3,414 M4,754 M3,780 M2,920 M4,026 M5,485 M6,892 M4,071 M
Fingds2,762 M2,842 M2,742 M2,298 M2,247 M1,743 M1,638 M1,436 M1,258 M1,247 M
Gainlossnoearn-14,898 M-15,476 M-14,300 M-15,119 M-13,057 M
Goodwill17,534 M17,728 M18,202 M18,381 M18,757 M15,501 M14,808 M14,744 M14,430 M14,177 M
Grosppe56,005 M54,439 M49,784 M48,848 M46,340 M43,003 M40,164 M39,106 M36,818 M35,747 M
Inv5,306 M5,334 M5,222 M4,347 M4,172 M3,338 M3,128 M2,947 M2,723 M2,720 M
Invadv3,331 M4,330 M3,886 M2,627 M2,792 M2,683 M2,409 M2,042 M1,950 M2,311 M
Mach31,486 M
Netppe28,008 M27,039 M24,291 M24,427 M21,369 M19,305 M17,589 M17,240 M16,591 M16,317 M
Noncurdefliab3,484 M3,895 M4,133 M4,826 M4,284 M4,091 M3,499 M3,242 M4,434 M4,959 M
Othca821 M780 M833 M1,900 M1,621 M1,395 M1,440 M2,212 M1,885 M1,547 M
Othintang14,801 M14,929 M15,586 M18,665 M19,315 M16,043 M15,825 M13,838 M13,433 M13,081 M
Othnca6,951 M6,661 M5,292 M694 M3,312 M3,011 M760 M913 M636 M750 M
Othncl9,052 M8,721 M8,339 M9,154 M11,340 M9,979 M9,114 M11,283 M6,669 M5,887 M
Othprop28,008 M27,039 M24,291 M2,020 M21,369 M19,305 M17,589 M17,240 M16,591 M16,317 M
Othrec1,655 M1,713 M1,480 M1,164 M1,197 M1,119 M1,070 M
Payacc24,454 M25,137 M23,371 M14,429 M19,592 M17,541 M18,112 M15,017 M14,243 M13,507 M
Prepaid921 M798 M806 M980 M874 M747 M633 M1,546 M908 M1,865 M
Restcash5,707 M8,254 M5,570 M1,997 M10,657 M
Totassets99,467 M100,495 M92,187 M92,654 M92,918 M78,547 M77,648 M79,804 M73,490 M69,667 M
Totca25,826 M26,950 M21,539 M21,783 M23,001 M17,645 M21,893 M31,027 M26,450 M23,031 M
Totcl31,536 M31,647 M26,785 M26,220 M23,372 M20,461 M22,138 M20,502 M21,135 M17,578 M
Toteqty18,041 M18,503 M17,149 M16,043 M13,454 M14,786 M48,804 M43,646 M42,563 M41,480 M
Totliab81,296 M81,858 M74,914 M76,226 M79,366 M63,679 M63,046 M68,823 M62,291 M57,637 M
Totnca74,987 M75,161 M71,461 M70,594 M69,917 M60,902 M55,755 M48,777 M47,040 M46,636 M
Totncl49,760 M50,211 M48,129 M50,006 M55,994 M43,218 M40,908 M48,321 M41,156 M40,059 M
Treastk-41,021 M-40,282 M-39,506 M-38,248 M-38,446 M-36,769 M-1000000.0-29,186 M
Trustpref199 M41 M41 M41 M
Wip104 M104 M114 M151 M205 M200 M178 M167 M150 M161 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