Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Coca-Cola Company (The) logo

Coca-Cola Company (The)

Sector: Consumer Defensive   

Industry: Beverages - Soft Drinks

61.74
 
USD
  
0.19
  
(0.31%)
Optionable: Yes  Market Cap: 261,507 M  90-day average vol: 14,312,606

Previous close: 61.55  Open: 61.87  Bid: 61.52  Ask: 61.56
52 week range    
51.55   
   64.69
Peers   
PEP / 
MNST / 
FIZZ / 
REED / 
DANOY / 
Last updated: Friday 26th April 2024
65
MarketXLS Rank
40
Value
92
Technical
65
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

KO Balance Sheet

Annual
Invalid dateDec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
"""debtc"""7 M8 M16,503 M18,838 M15,247 M2,668 M28 M30 M29 M
Accounts payable162 M252 M8,748 M9,533 M11,312 M11,145 M465 M515 M
Accounts receivable210 M301 M3,667 M3,685 M3,971 M3,144 M506 M55 M68 M
Accrued expenses319 M450 M9,158 M9,944 M11,726 M11,933 M696 M234 M393 M
Accumulated depreciation & depletion-726 M-798 M-8,246 M-8,013 M-8,083 M-8,923 M-1,007 M-1,106 M-1,161 M
Additional paid in capital113 M117 M15,864 M16,520 M17,154 M17,601 M136 M136 M136 M
Cash and equivalents55 M22 M6,006 M9,077 M6,480 M6,795 M142 M198 M635 M
CashCashEquivalentsAndShortTermInvestments55 M22 M20,675 M16,115 M11,175 M10,914 M142 M198 M635 M
CashEquivalents55 M22 M6,006 M8,926 M6,480 M6,795 M
CommercialPaper12,931 M13,063 M10,007 M1,329 M
Common par10 M10 M1,760 M1,760 M1,760 M1,760 M10 M11 M11 M
Common stock equity243 M277 M17,072 M16,981 M18,981 M19,299 M709 M1,115 M1,436 M
CommonStock10 M10 M1,760 M1,760 M1,760 M1,760 M10 M11 M11 M
Cost in excess118 M145 M9,401 M14,109 M16,764 M17,506 M166 M166 M166 M
CurrentAccruedExpenses157 M198 M231 M201 M238 M
CurrentCapitalLeaseObligation7 M8 M130 M144 M281 M322 M28 M30 M29 M
CurrentDeferredRevenue80 M187 M151 M
CurrentDeferredTaxesAssets180 M235 M2,904 M5,065 M5,294 M5,960 M271 M267 M299 M
CurrentDeferredTaxesLiabilities169 M205 M5,095 M4,745 M5,166 M-5,333 M-407 M-417 M-427 M
DeferredFinancingCosts4 M4 M-2 M-1 M-824000.0
DefinedPensionBenefit262 M273 M
DividendsPayable7 M7 M-6,320 M-6,644 M-6,845 M-7,047 M33 M155 M
EmployeeBenefits115 M127 M219 M225 M201 M141 M93 M60 M61 M
Finished goods56 M90 M693 M773 M851 M791 M182 M211 M208 M
Float term debt620 M907 M31,182 M25,376 M27,516 M40,125 M910 M725 M706 M
GoodwillAndOtherIntangibleAssets782 M678 M16,268 M20,842 M26,030 M28,550 M166 M166 M166 M
Gross fixed assets (Plant Property & Equipment)766 M832 M16,449 M17,611 M18,921 M19,700 M2,242 M2,437 M2,609 M
IncomeTaxPayable410 M411 M414 M788 M
Intangibles664 M533 M6,867 M6,733 M9,266 M11,044 M
InterestPayable3 M4 M841 M950 M946 M1,437 M4 M3 M3 M
Inventories89 M144 M2,655 M3,071 M3,379 M3,266 M303 M348 M322 M
Invested capital963 M1,349 M79,436 M67,733 M74,013 M99,549 M2,343 M2,439 M2,741 M
Leases40 M34 M64 M6 M5 M
LineOfCredit27 M30 M38 M38 M38 M
LongTermCapitalLeaseObligation49 M41 M525 M1,392 M1,622 M187 M126 M107 M
LongTermDebtAndCapitalLeaseObligation668 M948 M31,182 M25,376 M27,516 M40,125 M910 M725 M706 M
Minority interest79 M86 M1,905 M2,077 M2,117 M1,985 M
Net fixed assets (net PP&E)40 M34 M8,203 M9,598 M10,838 M10,777 M1,235 M1,331 M1,448 M
NetOtherUnrealizedGainLoss93 M
NetUnrealizedGainLossInvestments25 M
Non-current deferred income taxes147 M175 M2,522 M2,354 M2,284 M1,833 M136 M150 M128 M
NonCurrentAccruedExpenses15 M11 M8 M
NonCurrentDeferredAssets330 M2,674 M2,412 M2,460 M
NonCurrentDeferredLiabilities147 M175 M2,522 M2,354 M2,284 M1,833 M136 M150 M128 M
NonCurrentDeferredRevenue16 M18 M
NonCurrentDeferredTaxesAssets182 M236 M330 M2,674 M2,412 M2,460 M275 M270 M303 M
NonCurrentPensionAndOtherPostretirementBenefitPlans115 M127 M93 M60 M61 M
Notes payable13,205 M13,835 M10,994 M
Number of employees79000.079000.079000.079000.079000.079000.079000.079000.079000.0
Other current assets3 M3 M7,548 M336 M392 M915 M7 M285000.0330000.0
Other equity adjustments-82 M-93 M-10,305 M-12,814 M-13,544 M-14,601 M
Other fixed assets8,203 M9,598 M10,838 M10,777 M1,171 M1,324 M1,443 M
Other non-current assets64 M86 M4,230 M4,148 M6,075 M6,184 M120 M116 M145 M
Other non-current liabilities267 M379 M8,058 M7,646 M8,510 M9,453 M759 M753 M866 M
Other receivable29 M68 M2,053 M1,564 M1,707 M1,025 M58 M6,201 M6,654 M
OtherCurrentBorrowings10,994 M2,183 M
OtherCurrentLiabilities8 M16 M4,025 M-1,604 M9,243 M-750 M111 M127 M147 M
OtherInventories21 M30 M2,655 M3,071 M3,379 M3,266 M303 M348 M322 M
OtherPayable82 M273 M1,675 M1,548 M2,054 M1,177 M
Payables162 M252 M9,158 M9,944 M11,726 M11,933 M465 M33 M155 M
Prepaid expenses53 M64 M2,368 M2,804 M2,622 M1,916 M78 M94 M89 M
Raw materials12 M23 M1,729 M2,025 M2,180 M2,106 M81 M89 M72 M
RecievablesAdjustmentsAllowances-2 M-4 M-524 M-526 M-17 M-16 M-16 M
Restricted cash6,373 M9,318 M6,737 M7,110 M
Retained earnings261 M302 M50,125 M50,420 M52,311 M51,954 M624 M1,028 M1,348 M
Short term debt16,503 M18,838 M15,247 M2,668 M
Total assets1,847 M2,449 M87,896 M83,216 M86,381 M87,296 M3,446 M3,710 M4,289 M
Total current assets435 M594 M36,913 M25,675 M21,147 M19,240 M1,077 M1,246 M1,705 M
Total current liabilities327 M458 M25,661 M28,782 M26,973 M14,601 M835 M905 M1,091 M
Total equity243 M277 M17,072 M16,981 M18,981 M19,299 M709 M1,115 M1,436 M
Total liabilities1,524 M2,086 M68,919 M64,158 M65,283 M66,012 M2,734 M2,594 M2,853 M
Total non-current assets886 M797 M50,983 M57,541 M65,234 M68,056 M1,521 M1,613 M1,759 M
Total non-current liabilities1,198 M1,629 M43,258 M35,376 M38,310 M51,411 M1,899 M1,689 M1,762 M
TotalEquityGrossMinority322 M363 M18,977 M19,058 M21,098 M21,284 M712 M1,114 M1,434 M
TotalEquityGrossMinorityInterest322 M363 M18,977 M19,058 M21,098 M21,284 M712 M1,114 M1,434 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest1,847 M2,449 M87,896 M83,216 M86,381 M87,296 M3,446 M3,710 M4,289 M
TotalNonCurrentLiabilitiesNetMinorityInteres1,198 M1,629 M43,258 M35,376 M38,310 M51,411 M1,899 M1,689 M1,762 M
TotalTaxPayable410 M411 M414 M788 M
Treasury stock-61 M-61 M-50,677 M-51,719 M-52,244 M-52,016 M-61 M-61 M-61 M
UnearnedIncome1,096 M867 M854 M812 M
Working capital108 M136 M11,252 M-3,107 M-5,826 M4,639 M242 M341 M614 M
ltinv22 M20,856 M19,412 M19,025 M20,085 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