Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

ITW Stock Annual Balance Sheet. Download in Excel

Illinois Tool Works Inc. logo

Illinois Tool Works Inc.

Sector: Industrials   

Industry: Diversified Industrials

269.85
 
USD
  
3.47
  
(1.30%)
Previous close: 266.38  Open: 266.38  Bid: 265.21  Ask: 273.77
52 week range    
232.77   
   277.58
Mkt Cap: 78,686 M  Avg Vol (90 Days): 822,303
Peers   
DOV / 
FLS / 
GGG / 
LECO / 
PH / 
NDSN / 
MIDD / 
IR / 
MMM / 
Last updated: Friday 22nd November 2024

Stock Rankings

65
MarketXLS Rank
80
Value
61
Technical
55
Quality
How are these ranks calculated?
Ad slot not ready
Search for a stock

Financials

ITW Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Accounts payable512 M449 M511 M590 M524 M472 M534 M585 M594 M581 M
Accrued expenses2,049 M1,842 M2,108 M2,203 M2,191 M2,079 M2,239 M2,692 M2,869 M2,850 M
Accumulated depreciation & depletion-3,113 M-3,078 M-3,131 M-3,383 M-3,442 M-3,498 M-3,816 M-3,891 M-3,904 M-4,075 M
Additional paid in capital1,096 M1,135 M1,188 M1,218 M1,253 M1,304 M1,362 M1,432 M1,501 M1,588 M
Building & improvements1,200 M1,272 M1,297 M1,370 M1,368 M1,357 M1,432 M1,462 M1,414 M1,490 M
Cash and equivalents3,990 M3,090 M2,472 M3,094 M1,504 M1,981 M2,564 M1,527 M708 M1,065 M
CashCashEquivalentsAndShortTermInvestments3,990 M3,090 M2,472 M3,094 M1,504 M1,981 M2,564 M1,527 M708 M1,065 M
CashEquivalents418 M428 M442 M442 M429 M441 M454 M449 M433 M436 M
CommercialPaper1,413 M498 M849 M210 M1,053 M464 M
Common par6 M6 M6 M6 M6 M6 M6 M6 M6 M6 M
Common stock equity6,819 M5,224 M4,254 M4,585 M3,254 M3,026 M3,181 M3,625 M3,088 M3,012 M
CommonStock6 M6 M6 M6 M6 M6 M6 M6 M6 M6 M
Construction in progress230 M76 M104 M123 M154 M133 M133 M142 M259 M294 M
Cost in excess4,667 M4,439 M4,558 M4,752 M4,633 M4,492 M4,690 M4,965 M4,864 M4,909 M
CurrentAccruedExpenses1,473 M1,336 M1,428 M1,524 M1,599 M1,559 M1,645 M2,030 M2,128 M2,082 M
CurrentCapitalLeaseObligation105 M98 M104 M88 M67 M51 M55 M61 M55 M58 M
CurrentDeferredAssets212 M
CurrentDeferredRevenue205 M
CurrentDeferredTaxesAssets1,353 M1,336 M1,477 M1,153 M654 M666 M764 M884 M932 M1,027 M
CurrentDeferredTaxesLiabilities-1,186 M-1,246 M-1,162 M-812 M-807 M-818 M-819 M-986 M-922 M-874 M
Deferred revenues8 M
DividendsPayable-716 M-756 M-846 M-982 M-1,186 M-1,335 M-1,398 M-1,483 M-1,560 M-1,634 M
Finished goods677 M622 M629 M703 M731 M670 M681 M888 M1,050 M848 M
Float term debt5,943 M6,896 M7,177 M7,478 M6,029 M7,754 M7,772 M6,909 M6,173 M6,339 M
GoodwillAndOtherIntangibleAssets6,466 M5,999 M6,021 M6,024 M5,717 M5,343 M5,471 M5,937 M5,632 M5,566 M
Gross fixed assets (Plant Property & Equipment)4,799 M4,655 M4,783 M5,161 M5,233 M5,227 M5,593 M5,700 M5,752 M6,051 M
IncomeTaxPayable64 M57 M169 M89 M68 M48 M60 M77 M147 M187 M
Intangibles1,799 M1,560 M1,463 M1,272 M1,084 M851 M781 M972 M768 M657 M
InterestPayable186 M200 M226 M266 M328 M342 M361 M382 M400 M419 M
Inventories1,180 M1,086 M1,076 M1,220 M1,318 M1,164 M1,189 M1,694 M2,054 M1,707 M
Invested capital18,705 M19,016 M18,608 M19,541 M15,312 M18,534 M18,725 M17,443 M15,434 M15,690 M
Land & improvements177 M179 M186 M203 M194 M186 M204 M198 M188 M197 M
Leases158 M156 M160 M164 M165 M
LineOfCredit330 M296 M
LongTermCapitalLeaseObligation179 M188 M194 M186 M224 M
LongTermDebtAndCapitalLeaseObligation5,943 M6,896 M7,177 M7,478 M6,029 M7,754 M7,772 M6,909 M6,173 M6,339 M
LongTermProvisions-7 M7 M7 M3 M5 M6 M7 M3 M5 M6 M
Machinery furniture & equipment3,034 M2,972 M3,036 M3,301 M3,517 M3,551 M3,824 M3,898 M3,891 M4,070 M
Minority interest5 M4 M5 M4 M4 M4 M1000000.01000000.01000000.01000000.0
Net fixed assets (net PP&E)1,686 M1,577 M1,652 M1,778 M1,791 M1,729 M1,777 M1,809 M1,848 M1,976 M
NetOtherUnrealizedGainLoss393 M379 M405 M291 M364 M390 M331 M196 M293 M327 M
NetUnrealizedGainLossForeignCurrency265 M-1,100 M-1,400 M-1,000 M-1,300 M-1,300 M1,300 M1,300 M1,500 M1,500 M
Non-current deferred income taxes171 M256 M134 M164 M707 M668 M588 M654 M484 M326 M
NonCurrentAccruedExpenses614 M495 M462 M413 M365 M273 M151 M
NonCurrentDeferredAssets338 M346 M449 M505 M554 M516 M533 M552 M494 M479 M
NonCurrentDeferredLiabilities171 M256 M134 M164 M707 M668 M588 M654 M484 M326 M
NonCurrentDeferredTaxesAssets338 M346 M449 M505 M554 M516 M533 M552 M494 M479 M
NonCurrentPensionAndOtherPostretirementBenefitPlans257 M251 M252 M219 M203 M215 M241 M235 M173 M170 M
NonCurrentPrepaidAssets165 M191 M131 M
Other current assets218 M259 M210 M285 M297 M296 M346 M360 M8 M329 M
Other equity adjustments-658 M-1,504 M-1,807 M-1,287 M-1,677 M-1,705 M-1,642 M-1,502 M
Other fixed assets1,686 M1,577 M1,652 M1,778 M1,791 M1,729 M1,777 M1,809 M1,848 M1,976 M
Other non-current assets1,111 M1,087 M956 M1,195 M1,030 M1,578 M1,308 M1,405 M1,178 M1,262 M
Other non-current liabilities1,002 M981 M871 M882 M839 M1,000 M1,068 M1,053 M943 M1,014 M
Other receivable2,293 M2,203 M2,357 M2,628 M2,622 M2,461 M2,506 M2,840 M3,171 M3,123 M
OtherCurrentBorrowings1,476 M526 M652 M850 M1,351 M4 M350 M778 M1,590 M1,825 M
OtherCurrentLiabilities441 M363 M379 M411 M391 M71 M335 M460 M1000000.0423 M
OtherEquityInterest393 M379 M405 M291 M364 M390 M331 M196 M
OtherInventories1,180 M1,086 M1,076 M1,220 M1,318 M1,164 M1,189 M1,694 M2,054 M1,707 M
OtherPayable361 M284 M453 M297 M364 M326 M236 M731 M412 M
Payables576 M506 M680 M679 M592 M520 M594 M662 M741 M768 M
Preferred securities of subsidiary trust300000.0300000.0300000.0300000.0300000.0300000.0300000.0
PreferredStock300000.0300000.0300000.0300000.0300000.0300000.0300000.0
Prepaid expenses401 M341 M218 M336 M334 M296 M264 M313 M329 M340 M
Raw materials458 M415 M407 M465 M523 M452 M454 M716 M887 M742 M
RecievablesAdjustmentsAllowances-43 M-42 M-43 M-43 M-21 M-20 M-29 M-28 M-26 M-29 M
Retained earnings16,515 M16,812 M17,698 M18,923 M19,540 M20,698 M21,472 M22,823 M23,958 M25,288 M
Short term debt1,476 M526 M652 M850 M1,351 M4 M350 M778 M1,590 M1,825 M
TaxesReceivable129 M147 M55 M121 M98 M77 M72 M84 M92 M99 M
Total assets17,465 M15,729 M15,201 M16,780 M14,870 M15,068 M15,612 M16,077 M15,422 M15,518 M
Total current assets7,864 M6,720 M6,123 M7,278 M5,778 M5,902 M6,523 M6,374 M6,270 M6,235 M
Total current liabilities3,525 M2,368 M2,760 M3,053 M3,542 M2,154 M2,589 M3,470 M4,460 M4,675 M
Total equity6,819 M5,224 M4,254 M4,585 M3,254 M3,026 M3,181 M3,625 M3,088 M3,012 M
Total liabilities10,641 M10,501 M10,942 M12,191 M11,612 M12,038 M12,430 M12,451 M12,333 M12,505 M
Total non-current assets9,601 M9,009 M9,078 M9,502 M9,092 M9,166 M9,089 M9,703 M9,152 M9,283 M
Total non-current liabilities7,116 M8,133 M8,182 M9,138 M8,070 M9,884 M9,841 M8,981 M7,873 M7,830 M
TotalEquityGrossMinority6,824 M5,228 M4,259 M4,589 M3,258 M3,030 M3,182 M3,626 M3,089 M3,013 M
TotalEquityGrossMinorityInterest6,824 M5,228 M4,259 M4,589 M3,258 M3,030 M3,182 M3,626 M3,089 M3,013 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest17,465 M15,729 M15,201 M16,780 M14,870 M15,068 M15,612 M16,077 M15,422 M15,518 M
TotalNonCurrentLiabilitiesNetMinorityInteres7,116 M8,133 M8,182 M9,138 M8,070 M9,884 M9,841 M8,981 M7,873 M7,830 M
TotalTaxPayable64 M57 M169 M89 M68 M48 M60 M77 M147 M187 M
Treasury stock-10,798 M-12,729 M-14,638 M-15,562 M-17,545 M-18,982 M-19,659 M-20,636 M-22,377 M-23,870 M
Work in progress133 M130 M126 M141 M161 M131 M136 M208 M228 M234 M
Working capital4,339 M4,352 M3,363 M4,225 M2,236 M3,748 M3,934 M2,904 M1,810 M1,560 M
debtc1,476 M526 M652 M850 M1,351 M4 M350 M778 M1,590 M1,825 M
ltinv141 M113 M73 M53 M51 M51 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