Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Stanley Black & Decker Inc. logo

Stanley Black & Decker Inc.

Sector: Industrials   

Industry: Tools & Accessories

89.32
 
USD
  
0.00
  
(0.00%)
Optionable: Yes  Market Cap: 13,870 M  90-day average vol: 1,320,501

Previous close: 89.32  Open: 89.14  Bid: 88.87  Ask: 89.5
52 week range    
73.87   
   104.21
Peers   
SNA / 
KMT / 
MKTAY / 
LECO / 
ITW / 
MMM / 
TTC / 
GE / 
Last updated: Monday 22nd April 2024
44
MarketXLS Rank
70
Value
15
Technical
47
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

SWK Balance Sheet

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
"""debtc"""403 M8 M8 M12 M983 M379 M340 M2 M2,242 M2,101 M
Accounts payable1,553 M2,320 M3,424 M2,344 M
Accounts receivable1,579 M1,397 M1,332 M1,303 M1,629 M1,608 M1,455 M1,165 M1,482 M1,231 M
Accrued expenses2,772 M2,801 M2,795 M2,742 M3,409 M3,623 M4,065 M4,166 M6,065 M4,465 M
Accumulated depreciation & depletion-1,533 M-1,627 M-1,717 M-1,709 M-1,917 M-2,055 M-2,331 M-2,433 M-2,638 M-2,725 M
Additional paid in capital4,879 M4,727 M4,422 M4,774 M4,643 M4,621 M4,493 M4,968 M4,999 M5,056 M
Cash and equivalents496 M497 M465 M1,132 M638 M289 M298 M1,242 M142 M396 M
CashCashEquivalentsAndShortTermInvestments496 M497 M465 M1,132 M638 M289 M298 M1,242 M142 M396 M
CashEquivalents497 M465 M1,132 M638 M289 M298 M
Common par442 M442 M442 M442 M1,192 M1,192 M1,942 M1,813 M1,063 M442 M
Common stock equity6,799 M6,429 M5,812 M6,367 M8,302 M7,836 M9,136 M11,060 M11,591 M9,712 M
CommonStock442 M442 M442 M442 M442 M442 M442 M442 M442 M442 M
Cost in excess7,563 M7,276 M7,084 M6,694 M8,776 M8,957 M9,238 M8,087 M8,591 M8,503 M
CurrentAccruedExpenses1,220 M1,222 M1,262 M1,102 M1,388 M1,390 M1,978 M1,846 M2,641 M2,121 M
CurrentCapitalLeaseObligation141 M110 M116 M114 M
CurrentDeferredRevenue76 M84 M89 M82 M117 M202 M210 M39 M35 M30 M
CurrentDeferredTaxesAssets238 M246 M206 M147 M
CurrentDeferredTaxesLiabilities918 M759 M639 M588 M250 M531 M624 M316 M239 M33 M
CurrentProvisions46 M39 M
ESOPDebtGuarantee-53 M-44 M-35 M-26 M-19 M-10 M-2 M
EmployeeBenefits744 M750 M669 M644 M630 M595 M609 M629 M474 M354 M
Finished goods1,076 M1,105 M1,085 M1,044 M1,461 M1,707 M1,526 M1,884 M3,486 M3,461 M
Float term debt3,799 M3,840 M3,792 M3,815 M2,828 M3,820 M3,176 M4,245 M4,354 M5,353 M
GoodwillAndOtherIntangibleAssets7,733 M7,420 M7,205 M6,798 M8,864 M9,021 M9,289 M8,106 M8,604 M8,511 M
Gross fixed assets (Plant Property & Equipment)3,012 M3,081 M3,167 M3,160 M3,660 M3,970 M4,291 M4,406 M4,975 M5,078 M
Intangibles170 M144 M121 M104 M88 M64 M51 M19 M13 M8 M
InterestPayable81 M49 M
Inventories1,473 M1,563 M1,526 M1,478 M2,018 M2,374 M2,255 M2,639 M5,420 M5,861 M
Invested capital10,599 M10,269 M9,604 M10,182 M11,130 M11,656 M12,313 M15,305 M15,944 M15,065 M
LongTermCapitalLeaseObligation537 M449 M439 M441 M
LongTermDebtAndCapitalLeaseObligation3,799 M3,840 M3,792 M3,815 M2,828 M3,820 M3,176 M4,245 M4,354 M5,353 M
Minority interest81 M83 M48 M7 M3 M4 M6 M7 M2 M2 M
Net fixed assets (net PP&E)1,479 M1,454 M1,450 M1,451 M1,743 M1,915 M1,960 M1,973 M2,337 M2,353 M
Non-current deferred income taxes900 M993 M826 M735 M436 M705 M731 M501 M711 M709 M
NonCurrentDeferredLiabilities900 M993 M826 M735 M436 M705 M731 M501 M711 M709 M
NonCurrentDeferredTaxesAssets1,407 M1,236 M1,232 M1,259 M1,127 M1,173 M1,702 M1,731 M2,160 M2,327 M
NonCurrentPensionAndOtherPostretirementBenefitPlans744 M750 M669 M644 M630 M595 M609 M629 M474 M354 M
NotesReceivable142 M136 M131 M140 M159 M150 M157 M74 M75 M100 M
Number of employees54200.054200.054200.054200.054200.054200.054200.054200.054200.054200.0
Other current assets298 M312 M166 M683 M40 M59 M54 M664 M976 M46 M
Other equity adjustments-1,270 M-1,694 M-1,922 M-1,589 M-1,814 M-1,885 M-1,714 M
Other fixed assets1,479 M1,973 M2,337 M2,353 M
Other non-current assets440 M419 M390 M402 M513 M482 M1,321 M3,633 M4,031 M1,658 M
Other non-current liabilities976 M923 M1,179 M1,259 M2,507 M2,446 M2,532 M2,403 M2,144 M2,264 M
Other receivable136 M116 M109 M103 M162 M123 M126 M66 M104 M96 M
OtherCurrentBorrowings393 M2 M3 M4 M5 M376 M337 M2 M2,241 M2,100 M
OtherCurrentLiabilities192 M98 M59 M36 M23 M109 M148 M391 M460 M62 M
OtherPayable1,579 M1,533 M1,640 M2,021 M2,233 M2,088 M
Payables1,553 M1,579 M1,533 M1,640 M2,021 M2,233 M2,088 M2,320 M3,424 M2,344 M
Preferred securities of subsidiary trust750 M750 M1,500 M1,370 M620 M
PreferredStock750 M750 M1,500 M1,370 M620 M
Prepaid expenses1,874 M1,849 M1,814 M1,753 M2,484 M2,495 M2,649 M2,597 M3,189 M3,087 M
Raw materials275 M316 M305 M301 M402 M515 M567 M586 M1,539 M2,062 M
RecievablesAdjustmentsAllowances-64 M-61 M-73 M-77 M-80 M-102 M-112 M-111 M-96 M-107 M
Retained earnings2,986 M3,926 M4,492 M5,127 M5,999 M6,219 M6,773 M7,542 M6,897 M7,214 M
Short term debt403 M8 M8 M12 M983 M379 M340 M2 M2,242 M2,101 M
Total assets16,535 M15,849 M15,128 M15,635 M19,098 M19,408 M20,597 M23,566 M28,180 M24,963 M
Total current assets5,720 M5,617 M5,304 M6,349 M6,808 M6,824 M6,710 M8,307 M11,208 M10,620 M
Total current liabilities3,175 M2,809 M2,803 M2,754 M4,392 M4,002 M4,406 M4,558 M8,767 M6,566 M
Total equity6,799 M6,429 M5,812 M6,367 M8,302 M7,836 M9,136 M11,060 M11,591 M9,712 M
Total liabilities9,655 M9,337 M9,269 M9,261 M10,793 M11,568 M11,454 M12,500 M16,588 M15,246 M
Total non-current assets10,815 M10,232 M9,824 M9,286 M12,290 M12,584 M13,886 M15,260 M16,972 M14,343 M
Total non-current liabilities6,480 M6,529 M6,466 M6,507 M6,401 M7,567 M7,049 M7,942 M7,820 M8,680 M
TotalEquityGrossMinority6,881 M6,512 M5,859 M6,373 M8,305 M7,840 M9,142 M11,066 M11,592 M9,714 M
TotalEquityGrossMinorityInterest6,881 M6,512 M5,859 M6,373 M8,305 M7,840 M9,142 M11,066 M11,592 M9,714 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest16,535 M15,849 M15,128 M15,635 M19,098 M19,408 M20,597 M23,566 M28,180 M24,960 M
TotalNonCurrentLiabilitiesNetMinorityInteres6,480 M6,529 M6,466 M6,507 M6,401 M7,567 M7,049 M7,942 M7,820 M8,680 M
Treasury stock-1,454 M-1,353 M-1,815 M-2,030 M-1,924 M-2,371 M-2,185 M-1,549 M-1,368 M-3,000 M
UnearnedIncome1,164 M939 M779 M636 M1,171 M1,165 M1,317 M1,548 M2,000 M1,821 M
Work in progress123 M141 M136 M133 M156 M151 M162 M169 M395 M339 M
Working capital2,545 M2,809 M2,501 M3,595 M2,416 M2,823 M2,305 M3,748 M2,441 M4,054 M
ltinv15 M12 M12 M9 M8 M8 M15 M14 M12 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