Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Williams Companies Inc. (The) logo

Williams Companies Inc. (The)

Sector: Energy   

Industry: Oil & Gas Midstream

40.64
 
USD
  
0.54
  
(1.35%)
Optionable: Yes  Market Cap: 49,567 M  90-day average vol: 6,378,348

Previous close: 40.1  Open: 40.17  Bid: 39.85  Ask: 40.85
52 week range    
28.57   
   41.89
Peers   
EPD / 
ENB / 
TRP / 
EQT / 
SWN / 
SE / 
ENB-CA / 
TRP-CA / 
Last updated: Friday 31st May 2024
60
MarketXLS Rank
55
Value
61
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

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

ENB

0.062686 B18.943.38

ENB-CA

EPD

EQT

8 B-2.421.17

SE

SWN

5 B-1.44.58

TRP

0.05450 B34.951.3

TRP-CA

UGP

UGPA3-BR

Financials

WMB Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
AccruedPreferredStockDividends1000000.03 M3 M3 M3 M3 M
Amortization of intangibles-209 M-353 M-356 M-347 M-333 M-324 M-328 M
Basic EPS from continuing operations2.93-0.76-0.572.63-0.160.710.171.251.685.3
Basic EPS total2.94-0.76-0.572.63-0.160.70.171.251.685.22
Basic weighted shares outstanding719 M749 M751 M826 M974 M1,212 M1,214 M1,215 M1,218 M1,218 M
BasicDiscontinuousOperations0.01-0.01-0.08
Cost of sales3,016 M1,779 M1,725 M2,300 M-17 M3,457 M2,035 M
Depreciation1,176 M1,738 M1,763 M1,736 M1,725 M1,714 M1,721 M1,842 M2,009 M2,071 M
Depreciation unreconciled1,176 M1,738 M1,763 M1,736 M1,725 M1,714 M1,721 M1,842 M2,009 M2,071 M
Diluted EPS total2.92-0.76-0.572.62-0.160.70.171.241.675.2
Diluted normalized net income/share2.92-0.76-0.572.62-0.160.70.171.241.675.28
Diluted weighted shares outstanding724 M749 M751 M829 M974 M1,214 M1,215 M1,218 M1,223 M1,223 M
DilutedDiscontinuousOperations-0.08
Dividends paid per share1.962.451.681.21.361.521.61.641.79
Earnings from equity interest144 M335 M397 M434 M396 M375 M328 M608 M637 M589 M
EarningsFromEquityInterestNetOfTax144 M335 M397 M434 M396 M375 M328 M608 M637 M589 M
ExplorationDevelopmentAndMineralPropertyLeaseExpenses1,492 M1,655 M1,580 M1,576 M1,507 M1,468 M1,326 M1,548 M
GainOnSaleOfBusiness1,095 M129 M
GainOnSaleOfPPE-56 M1,095 M692 M-2 M
GainsLossOnDisposalOfDiscontinuedOperations4 M-15 M-97 M
GeneralAndAdministrativeExpense-232 M-126 M-7 M-62 M-73 M
Gross operating profit4,621 M5,581 M5,774 M5,057 M8,703 M8,201 M7,719 M10,627 M7,508 M8,872 M
ImpairmentOfCapitalAssets1,307 M873 M187 M
Income before tax3,584 M-1,713 M-375 M535 M331 M1,064 M277 M2,073 M2,542 M4,405 M
Income restructuring and M&A-2,544 M-60 M-69 M-141 M-71 M-59 M-65 M-73 M
Income taxes1,249 M-399 M-25 M-1,974 M138 M335 M79 M511 M425 M1,005 M
InsuranceAndClaims-232 M-126 M-7 M-9 M
Interest income43 M27 M63 M282 M187 M107 M8 M7 M16 M108 M
InterestExpenseNonOperating-747 M-1,044 M-1,179 M-1,083 M-1,112 M-1,186 M-1,172 M-1,179 M1,147 M1,236 M
InterestExpenseOperating747 M1,044 M1,179 M1,083 M1,112 M1,186 M1,172 M1,179 M1,147 M1,236 M
MinorityInterests-225 M743 M-74 M-335 M-155 M136 M13 M-45 M2,049 M3,276 M
MiscOtherSpecialCharges31 M102 M74 M-25 M92 M33 M-43 M6 M18 M99 M
Net income from total operations2,339 M-1,314 M-424 M2,509 M193 M850 M211 M1,562 M2,049 M3,179 M
NetIncomeCommonStockholders2,114 M-571 M-424 M2,174 M2,881 M2,913 M1,821 M5,546 M2,046 M3,176 M
NetIncomeContinuousOperations2,339 M-1,314 M-424 M2,509 M193 M850 M211 M1,562 M2,049 M3,179 M
NetIncomeDiscontinuousOperations4 M-15 M-97 M
NetNonOperatingInterestIncomeExpense43 M27 M63 M282 M187 M107 M8 M7 M16 M108 M
NetOperatingInterestIncomeExpense-747 M-1,044 M-1,179 M-1,083 M-1,112 M-1,186 M-1,172 M-1,179 M-1,147 M-1,236 M
NonRecurringOperationExpense-534 M
Normalized income1,640 M
Operating income1,569 M1,533 M1,573 M1,080 M4,835 M4,453 M4,184 M6,665 M3,018 M4,311 M
Operating income before depreciation (EBITDA)4,760 M25 M1,388 M2,271 M2,056 M2,778 M1,998 M3,915 M6,845 M8,948 M
OperatingExpense1,492 M1,655 M1,580 M1,576 M1,507 M1,468 M1,326 M1,548 M1,817 M1,984 M
Other income net-175 M922 M832 M-256 M735 M244 M943 M-612 M-655 M-817 M
OtherGandA-232 M-126 M-7 M-62 M-73 M
OtherImpairmentOfCapitalAssets1,359 M1,303 M1,248 M1,915 M650 M1,228 M2 M
OtherOperatingExpenses-45 M40 M142 M71 M67 M8 M22 M14 M1,845 M1,954 M
OtherunderPreferredStockDividend1000000.03 M3 M3 M3 M3 M
PreferredStockDividends1000000.03 M3 M3 M3 M3 M
RentAndLandingFees-109 M-69 M-64 M-62 M-73 M
RestructringAndMnAIncome-2,544 M-60 M-69 M-141 M-71 M-59 M-65 M-73 M
Selling Gen & administrative expense429 M615 M716 M594 M569 M558 M466 M558 M636 M665 M
SellingAndMarketingExpense661 M741 M723 M594 M569 M558 M466 M558 M636 M665 M
Special income/charges-2,544 M1,307 M-69 M-141 M-71 M-59 M187 M-73 M-534 M
Total Income available for interest expense (EBIT)3,584 M-1,713 M-375 M535 M331 M1,064 M277 M2,073 M4,836 M6,877 M
Total common shares outstanding748 M750 M826 M827 M1,211 M1,212 M1,214 M1,216 M1,219 M1,217 M
Total net income2,339 M-1,314 M-424 M2,509 M193 M850 M211 M1,562 M2,049 M3,179 M
Total ordinary shares1,219 M1,219 M1,219 M1,219 M1,219 M1,219 M1,219 M1,219 M1,219 M1,219 M
Total revenues7,637 M7,360 M7,499 M8,031 M8,686 M8,201 M7,719 M10,627 M10,965 M10,907 M
TotalExpenses4,508 M3,434 M3,305 M3,876 M1,490 M1,468 M1,326 M1,548 M5,274 M4,019 M
TotalRevenue7,637 M7,360 M7,499 M5,312 M5,502 M5,933 M5,924 M6,001 M10,965 M10,907 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