Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
W.W. Grainger Inc. logo

W.W. Grainger Inc.

Sector: Industrials   

Industry: Industrial Distribution

931.94
 
USD
  
8.04
  
(0.87%)
Optionable: Yes  Market Cap: 45,210 M  90-day average vol: 218,045

Previous close: 923.9  Open: 929.74  Bid: 902.6  Ask: 980.0
52 week range    
641.95   
   1,034.18
Peers   
WCC / 
FAST / 
MSM / 
SNA / 
LAWS / 
HSC / 
Last updated: Monday 6th May 2024
46
MarketXLS Rank
35
Value
30
Technical
73
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

GWW Balance Sheet

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
"""debtc"""97 M80 M600 M406 M95 M130 M301 M65 M66 M103 M
Accounts payable511 M554 M583 M650 M731 M678 M719 M779 M816 M1,047 M
Accounts receivable1,102 M1,173 M1,210 M1,223 M1,325 M1,385 M1,425 M1,474 M1,754 M2,133 M
Accrued expenses703 M758 M797 M878 M1,005 M969 M974 M1,128 M1,172 M1,433 M
Accumulated depreciation & depletion-1,733 M-1,791 M-1,939 M-1,991 M-2,053 M-2,089 M-2,093 M-2,142 M-173 M-206 M
Additional paid in capital893 M948 M1,000 M1,030 M1,041 M1,134 M1,182 M1,239 M1,270 M1,310 M
Building & improvements1,259 M1,269 M1,352 M1,313 M
Cash and equivalents431 M227 M290 M274 M327 M538 M360 M585 M241 M325 M
CashCashEquivalentsAndShortTermInvestments431 M227 M290 M274 M327 M538 M360 M585 M241 M325 M
CashEquivalents431 M227 M290 M274 M327 M538 M360 M585 M241 M325 M
Common par55 M55 M55 M55 M55 M55 M55 M55 M55 M55 M
Common stock equity3,250 M3,210 M2,267 M1,798 M1,690 M1,921 M1,855 M1,828 M1,874 M2,440 M
CommonStock55 M55 M55 M55 M55 M55 M55 M55 M55 M55 M
Cost in excess525 M507 M582 M527 M544 M424 M429 M391 M384 M371 M
CurrentAccruedExpenses186 M192 M197 M213 M254 M262 M228 M307 M319 M334 M
CurrentCapitalLeaseObligation68 M66 M67 M59 M64 M65 M58 M57 M66 M68 M
CurrentDeferredAssets76 M61 M
CurrentDeferredTaxesAssets76 M61 M226 M242 M137 M109 M164 M169 M235 M241 M
CurrentDeferredTaxesLiabilities212 M102 M135 M127 M119 M105 M83 M68 M67 M64 M
DividendsPayable4.0316 M329 M357 M370 M
EmployeeBenefits417 M298 M248 M203 M219 M332 M100 M87 M120 M
Float term debt446 M403 M1,388 M1,841 M2,248 M2,090 M1,914 M2,389 M2,362 M2,284 M
GoodwillAndOtherIntangibleAssets525 M771 M1,230 M1,113 M1,113 M884 M733 M619 M622 M603 M
Gross fixed assets (Plant Property & Equipment)2,941 M3,115 M3,370 M3,412 M3,445 M3,441 M3,493 M3,747 M1,990 M2,034 M
IncomeTaxPayable6 M12 M17 M15 M20 M29 M27 M42 M37 M52 M
Intangibles107 M264 M648 M586 M569 M460 M304 M228 M238 M232 M
InterestPayable-79 M-93 M-87 M-93 M
Inventories1,306 M1,356 M1,414 M1,406 M1,429 M1,541 M1,655 M1,733 M1,870 M2,253 M
InventoriesAdjustmentsAllowances-134 M-137 M-168 M-192 M-193 M-154 M
Invested capital3,721 M3,784 M3,731 M3,901 M4,022 M4,107 M3,811 M4,251 M4,243 M4,724 M
Land & improvements277 M338 M324 M356 M
LongTermCapitalLeaseObligation239 M162 M334 M318 M
LongTermDebtAndCapitalLeaseObligation446 M403 M1,388 M1,841 M2,248 M2,090 M1,914 M2,551 M2,696 M2,602 M
LongTermProvisions9 M13 M10 M16 M16 M7 M
Machinery furniture & equipment1,405 M1,508 M1,694 M1,742 M
Minority interest76 M74 M86 M108 M138 M172 M205 M265 M286 M295 M
Net fixed assets (net PP&E)1,209 M1,324 M1,431 M1,421 M1,392 M1,352 M1,400 M1,605 M1,817 M1,828 M
Non-current deferred income taxes38 M95 M154 M126 M111 M103 M106 M110 M121 M121 M
NonCurrentAccruedExpenses219 M245 M267 M290 M314 M269 M318 M248 M290 M474 M
NonCurrentDeferredAssets16 M17 M84 M65 M22 M12 M11 M14 M
NonCurrentDeferredLiabilities95 M154 M126 M111 M103 M106 M110 M121 M121 M
NonCurrentDeferredTaxesAssets16 M17 M84 M65 M22 M12 M11 M222 M305 M312 M
NonCurrentPensionAndOtherPostretirementBenefitPlans417 M298 M248 M203 M219 M332 M100 M87 M120 M
Number of employees23000.023000.023000.023000.023000.023000.023000.023000.023000.023000.0
Other current assets40 M45 M61 M59 M45 M37 M28 M39 M38 M41 M
Other equity adjustments29 M-97 M-221 M-272 M-135 M-171 M-154 M-61 M-96 M-180 M
Other non-current assets472 M204 M64 M75 M71 M68 M306 M152 M142 M180 M
Other non-current liabilities361 M
Other receivable11,221 M11,486 M11,797 M13,022 M15,228 M
OtherCurrentBorrowings67 M57 M353 M386 M56 M49 M55 M
OtherCurrentLiabilities114 M
OtherEquityInterest-2 M
OtherInventories388 M389 M388 M382 M382 M394 M426 M446 M510 M693 M
Payables517 M566 M600 M665 M751 M707 M746 M821 M853 M1,099 M
Preferred securities of subsidiary trust12 M12 M12 M12 M
PreferredStock12 M12 M12 M12 M
Prepaid expenses131 M150 M135 M117 M125 M93 M115 M127 M146 M266 M
RecievablesAdjustmentsAllowances-20 M-22 M-22 M-27 M-29 M-25 M-21 M-30 M-36 M
Retained earnings5,823 M6,336 M6,802 M7,114 M7,405 M7,869 M8,405 M8,779 M9,500 M10,700 M
Short term debt97 M80 M600 M406 M95 M130 M301 M8 M35 M
Total assets5,266 M5,283 M5,858 M5,694 M5,804 M5,873 M6,005 M6,295 M6,592 M7,588 M
Total current assets3,044 M2,968 M3,049 M3,020 M3,206 M3,557 M3,555 M3,919 M4,011 M4,977 M
Total current liabilities914 M838 M1,397 M1,284 M1,100 M1,099 M1,275 M1,193 M1,238 M1,536 M
Total equity3,250 M3,210 M2,267 M1,798 M1,690 M1,921 M1,855 M1,828 M1,874 M2,440 M
Total liabilities1,939 M1,999 M3,505 M3,789 M3,976 M3,780 M3,945 M4,202 M4,432 M4,853 M
Total non-current assets2,222 M2,316 M2,809 M2,674 M2,598 M2,316 M2,450 M2,376 M2,581 M2,611 M
Total non-current liabilities1,026 M1,161 M2,108 M2,505 M2,876 M2,681 M2,670 M3,009 M3,194 M3,317 M
TotalEquityGrossMinority3,327 M3,284 M2,353 M1,906 M1,828 M2,093 M2,060 M2,093 M2,160 M2,735 M
TotalEquityGrossMinorityInterest3,327 M3,284 M2,353 M1,906 M1,828 M2,093 M2,060 M2,093 M2,160 M2,735 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest5,266 M5,283 M5,858 M5,694 M5,804 M5,873 M6,005 M6,295 M6,592 M7,588 M
TotalNonCurrentLiabilitiesNetMinorityInteres1,026 M1,161 M2,108 M2,505 M2,876 M2,681 M2,670 M3,009 M3,194 M3,317 M
TotalTaxPayable6 M12 M17 M15 M20 M29 M27 M42 M37 M52 M
Treasury stock-3,549 M-4,033 M-5,370 M-6,128 M-6,676 M-6,966 M-7,633 M-8,184 M-8,855 M-9,445 M
UnearnedPremiums13 M19 M23 M22 M21 M24 M23 M21 M
Working capital2,131 M2,129 M1,651 M1,736 M2,106 M2,458 M2,280 M2,726 M2,773 M3,441 M
ltinv9 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