10-Q Filing

SHERWIN WILLIAMS CO CIK: 89800 Q3 2023

Filing Information

Form Type	10-Q
Accession Number	`0000089800-23-000031`
Period End Date	20230930
Filing Date	20231024
Fiscal Year	2023
Fiscal Period	Q3
XBRL Instance	shw-20230930_htm.xml

Filing Contents

This filing contains the following financial statements:

Balance Sheet 104 Income Statement 76 Cash Flow Statement 97 Stockholders Equity 65 Comprehensive Income 44

Balance Sheet 104 line items

Line Item	Tag	Value	Unit	Period
Common stock, par value (in dollars per share)	`CommonStockParOrStatedValuePerShare`	$0.33	USD	Point-in-time
Common stock, par value (in dollars per share)	`CommonStockParOrStatedValuePerShare`	$0.33	USD	Point-in-time
Common stock, par value (in dollars per share)	`CommonStockParOrStatedValuePerShare`	$0.33	USD	Point-in-time
Common stock, shares outstanding (in shares)	`CommonStockSharesOutstanding`	259.10M	shares	Point-in-time
Common stock, shares outstanding (in shares)	`CommonStockSharesOutstanding`	258.90M	shares	Point-in-time
Common stock, shares outstanding (in shares)	`CommonStockSharesOutstanding`	256.00M	shares	Point-in-time
Cash and cash equivalents	`CashAndCashEquivalentsAtCarryingValue`	$198.80M	USD	Point-in-time
Cash and cash equivalents	`CashAndCashEquivalentsAtCarryingValue`	$130.50M	USD	Point-in-time
Cash and cash equivalents	`CashAndCashEquivalentsAtCarryingValue`	$503.40M	USD	Point-in-time
Accounts receivable, net	`AccountsReceivableNetCurrent`	$2.56B	USD	Point-in-time
Accounts receivable, net	`AccountsReceivableNetCurrent`	$2.90B	USD	Point-in-time
Accounts receivable, net	`AccountsReceivableNetCurrent`	$2.94B	USD	Point-in-time
Inventories	`InventoryNet`	$2.63B	USD	Point-in-time
Inventories	`InventoryNet`	$2.24B	USD	Point-in-time
Inventories	`InventoryNet`	$2.55B	USD	Point-in-time
Other current assets	`OtherAssetsCurrent`	$541.30M	USD	Point-in-time
Other current assets	`OtherAssetsCurrent`	$518.80M	USD	Point-in-time
Other current assets	`OtherAssetsCurrent`	$510.20M	USD	Point-in-time
Total current assets	`AssetsCurrent`	$5.91B	USD	Point-in-time
Total current assets	`AssetsCurrent`	$6.12B	USD	Point-in-time
Total current assets	`AssetsCurrent`	$6.20B	USD	Point-in-time
Property, plant and equipment, net	`PropertyPlantAndEquipmentNet`	$2.21B	USD	Point-in-time
Property, plant and equipment, net	`PropertyPlantAndEquipmentNet`	$2.58B	USD	Point-in-time
Property, plant and equipment, net	`PropertyPlantAndEquipmentNet`	$2.04B	USD	Point-in-time
Goodwill	`Goodwill`	$7.41B	USD	Point-in-time
Goodwill	`Goodwill`	$7.32B	USD	Point-in-time
Goodwill	`Goodwill`	$7.58B	USD	Point-in-time
Intangible assets	`IntangibleAssetsNetExcludingGoodwill`	$3.96B	USD	Point-in-time
Intangible assets	`IntangibleAssetsNetExcludingGoodwill`	$3.82B	USD	Point-in-time
Intangible assets	`IntangibleAssetsNetExcludingGoodwill`	$4.00B	USD	Point-in-time
Operating lease right-of-use assets	`OperatingLeaseRightOfUseAsset`	$1.85B	USD	Point-in-time
Operating lease right-of-use assets	`OperatingLeaseRightOfUseAsset`	$1.87B	USD	Point-in-time
Operating lease right-of-use assets	`OperatingLeaseRightOfUseAsset`	$1.87B	USD	Point-in-time
Other assets	`OtherAssetsNoncurrent`	$1.03B	USD	Point-in-time
Other assets	`OtherAssetsNoncurrent`	$957.90M	USD	Point-in-time
Other assets	`OtherAssetsNoncurrent`	$1.11B	USD	Point-in-time
Total assets	`Assets`	$22.59B	USD	Point-in-time
Total assets	`Assets`	$23.00B	USD	Point-in-time
Total assets	`Assets`	$22.25B	USD	Point-in-time
Short-term borrowings	`ShortTermBorrowings`	$978.10M	USD	Point-in-time
Short-term borrowings	`ShortTermBorrowings`	$338.60M	USD	Point-in-time
Short-term borrowings	`ShortTermBorrowings`	$945.20M	USD	Point-in-time
Accounts payable	`AccountsPayableCurrent`	$2.42B	USD	Point-in-time
Accounts payable	`AccountsPayableCurrent`	$2.44B	USD	Point-in-time
Accounts payable	`AccountsPayableCurrent`	$2.81B	USD	Point-in-time
Compensation and taxes withheld	`EmployeeRelatedLiabilitiesCurrent`	$650.60M	USD	Point-in-time
Compensation and taxes withheld	`EmployeeRelatedLiabilitiesCurrent`	$784.50M	USD	Point-in-time
Compensation and taxes withheld	`EmployeeRelatedLiabilitiesCurrent`	$768.30M	USD	Point-in-time
Accrued taxes	`TaxesPayableCurrent`	$205.30M	USD	Point-in-time
Accrued taxes	`TaxesPayableCurrent`	$197.40M	USD	Point-in-time
Accrued taxes	`TaxesPayableCurrent`	$379.80M	USD	Point-in-time
Current portion of long-term debt	`LongTermDebtCurrent`	$600.00K	USD	Point-in-time
Current portion of long-term debt	`LongTermDebtCurrent`	$600.00K	USD	Point-in-time
Current portion of long-term debt	`LongTermDebtCurrent`	$1.10B	USD	Point-in-time
Current portion of operating lease liabilities	`OperatingLeaseLiabilityCurrent`	$425.30M	USD	Point-in-time
Current portion of operating lease liabilities	`OperatingLeaseLiabilityCurrent`	$418.10M	USD	Point-in-time
Current portion of operating lease liabilities	`OperatingLeaseLiabilityCurrent`	$441.10M	USD	Point-in-time
Other accruals	`OtherLiabilitiesCurrent`	$1.14B	USD	Point-in-time
Other accruals	`OtherLiabilitiesCurrent`	$1.17B	USD	Point-in-time
Other accruals	`OtherLiabilitiesCurrent`	$1.07B	USD	Point-in-time
Total current liabilities	`LiabilitiesCurrent`	$5.96B	USD	Point-in-time
Total current liabilities	`LiabilitiesCurrent`	$6.10B	USD	Point-in-time
Total current liabilities	`LiabilitiesCurrent`	$6.62B	USD	Point-in-time
Long-term debt	`LongTermDebtNoncurrent`	$8.50B	USD	Point-in-time
Long-term debt	`LongTermDebtNoncurrent`	$9.59B	USD	Point-in-time
Long-term debt	`LongTermDebtNoncurrent`	$9.59B	USD	Point-in-time
Postretirement benefits other than pensions	`OtherPostretirementDefinedBenefitPlanLiabilitiesNoncurrent`	$256.50M	USD	Point-in-time
Postretirement benefits other than pensions	`OtherPostretirementDefinedBenefitPlanLiabilitiesNoncurrent`	$139.30M	USD	Point-in-time
Postretirement benefits other than pensions	`OtherPostretirementDefinedBenefitPlanLiabilitiesNoncurrent`	$139.30M	USD	Point-in-time
Deferred income taxes	`DeferredIncomeTaxLiabilitiesNet`	$691.80M	USD	Point-in-time
Deferred income taxes	`DeferredIncomeTaxLiabilitiesNet`	$648.40M	USD	Point-in-time
Deferred income taxes	`DeferredIncomeTaxLiabilitiesNet`	$681.60M	USD	Point-in-time
Long-term operating lease liabilities	`OperatingLeaseLiabilityNoncurrent`	$1.49B	USD	Point-in-time
Long-term operating lease liabilities	`OperatingLeaseLiabilityNoncurrent`	$1.50B	USD	Point-in-time
Long-term operating lease liabilities	`OperatingLeaseLiabilityNoncurrent`	$1.51B	USD	Point-in-time
Other long-term liabilities	`OtherLiabilitiesNoncurrent`	$1.81B	USD	Point-in-time
Other long-term liabilities	`OtherLiabilitiesNoncurrent`	$1.52B	USD	Point-in-time
Other long-term liabilities	`OtherLiabilitiesNoncurrent`	$1.61B	USD	Point-in-time
Common stock - $0.33-1/3 par value: 0.0 million, 258.9 million and 259.1 million shares outstanding at September 30, 2023, December 31, 2022 and September 30, 2022, respectively	`CommonStockValue`	$91.20M	USD	Point-in-time
Common stock - $0.33-1/3 par value: 0.0 million, 258.9 million and 259.1 million shares outstanding at September 30, 2023, December 31, 2022 and September 30, 2022, respectively	`CommonStockValue`	$91.10M	USD	Point-in-time
Common stock - $0.33-1/3 par value: 0.0 million, 258.9 million and 259.1 million shares outstanding at September 30, 2023, December 31, 2022 and September 30, 2022, respectively	`CommonStockValue`	$91.70M	USD	Point-in-time
Other capital	`AdditionalPaidInCapital`	$3.92B	USD	Point-in-time
Other capital	`AdditionalPaidInCapital`	$4.10B	USD	Point-in-time
Other capital	`AdditionalPaidInCapital`	$3.96B	USD	Point-in-time
Retained earnings	`RetainedEarningsAccumulatedDeficit`	$3.29B	USD	Point-in-time
Retained earnings	`RetainedEarningsAccumulatedDeficit`	$5.09B	USD	Point-in-time
Retained earnings	`RetainedEarningsAccumulatedDeficit`	$3.52B	USD	Point-in-time
Treasury stock, at cost	`TreasuryStockValue`	$3.78B	USD	Point-in-time
Treasury stock, at cost	`TreasuryStockValue`	$3.64B	USD	Point-in-time
Treasury stock, at cost	`TreasuryStockValue`	$4.75B	USD	Point-in-time
Accumulated other comprehensive loss	`AccumulatedOtherComprehensiveIncomeLossNetOfTax`	$-756.40M	USD	Point-in-time
Accumulated other comprehensive loss	`AccumulatedOtherComprehensiveIncomeLossNetOfTax`	$-1.06B	USD	Point-in-time
Accumulated other comprehensive loss	`AccumulatedOtherComprehensiveIncomeLossNetOfTax`	$-700.60M	USD	Point-in-time
Total shareholders' equity	`StockholdersEquity`	$3.10B	USD	Point-in-time
Total shareholders' equity	`StockholdersEquity`	$3.17B	USD	Point-in-time
Total shareholders' equity	`StockholdersEquity`	$3.63B	USD	Point-in-time
Total shareholders' equity	`StockholdersEquity`	$2.23B	USD	Point-in-time
Total shareholders' equity	`StockholdersEquity`	$2.22B	USD	Point-in-time
Total shareholders' equity	`StockholdersEquity`	$2.60B	USD	Point-in-time
Total shareholders' equity	`StockholdersEquity`	$3.78B	USD	Point-in-time
Total shareholders' equity	`StockholdersEquity`	$2.44B	USD	Point-in-time
Total liabilities and shareholders equity	`LiabilitiesAndStockholdersEquity`	$22.59B	USD	Point-in-time
Total liabilities and shareholders equity	`LiabilitiesAndStockholdersEquity`	$22.25B	USD	Point-in-time
Total liabilities and shareholders equity	`LiabilitiesAndStockholdersEquity`	$23.00B	USD	Point-in-time

Income Statement 76 line items

Line Item	Tag	Value	Unit	Period
Net sales	`RevenueFromContractWithCustomerExcludingAssessedTax`	$17.80B	USD	3 Qtrs
Net sales	`RevenueFromContractWithCustomerExcludingAssessedTax`	$6.05B	USD	1 Quarter
Net sales	`RevenueFromContractWithCustomerExcludingAssessedTax`	$16.92B	USD	3 Qtrs
Net sales	`RevenueFromContractWithCustomerExcludingAssessedTax`	$6.12B	USD	1 Quarter
Cost of goods sold	`CostOfGoodsAndServicesSold`	$3.20B	USD	1 Quarter
Cost of goods sold	`CostOfGoodsAndServicesSold`	$9.59B	USD	3 Qtrs
Cost of goods sold	`CostOfGoodsAndServicesSold`	$9.83B	USD	3 Qtrs
Cost of goods sold	`CostOfGoodsAndServicesSold`	$3.46B	USD	1 Quarter
Gross profit	`GrossProfit`	$7.09B	USD	3 Qtrs
Gross profit	`GrossProfit`	$2.92B	USD	1 Quarter
Gross profit	`GrossProfit`	$8.21B	USD	3 Qtrs
Gross profit	`GrossProfit`	$2.59B	USD	1 Quarter
Percent to net sales	`GrossProfitPercentage`	0.46	pure	3 Qtrs
Percent to net sales	`GrossProfitPercentage`	0.42	pure	3 Qtrs
Percent to net sales	`GrossProfitPercentage`	0.48	pure	1 Quarter
Percent to net sales	`GrossProfitPercentage`	0.43	pure	1 Quarter
Selling, general and administrative expenses	`SellingGeneralAndAdministrativeExpense`	$1.61B	USD	1 Quarter
Selling, general and administrative expenses	`SellingGeneralAndAdministrativeExpense`	$4.69B	USD	3 Qtrs
Selling, general and administrative expenses	`SellingGeneralAndAdministrativeExpense`	$1.76B	USD	1 Quarter
Selling, general and administrative expenses	`SellingGeneralAndAdministrativeExpense`	$5.21B	USD	3 Qtrs
Percent to net sales	`SellingGeneralAdministrativeExpenseAsPercentNetSales`	0.29	pure	1 Quarter
Percent to net sales	`SellingGeneralAdministrativeExpenseAsPercentNetSales`	0.27	pure	1 Quarter
Percent to net sales	`SellingGeneralAdministrativeExpenseAsPercentNetSales`	0.29	pure	3 Qtrs
Percent to net sales	`SellingGeneralAdministrativeExpenseAsPercentNetSales`	0.28	pure	3 Qtrs
Other general expense (income) - net	`OtherOperatingIncomeExpenseNet`	$7.50M	USD	3 Qtrs
Other general expense (income) - net	`OtherOperatingIncomeExpenseNet`	$14.40M	USD	1 Quarter
Other general expense (income) - net	`OtherOperatingIncomeExpenseNet`	$-39.90M	USD	3 Qtrs
Other general expense (income) - net	`OtherOperatingIncomeExpenseNet`	$-61.90M	USD	1 Quarter
Impairment	`AssetImpairmentCharges`	-	USD	1 Quarter
Impairment	`AssetImpairmentCharges`	-	USD	3 Qtrs
Impairment	`AssetImpairmentCharges`	$34.00M	USD	3 Qtrs
Impairment	`AssetImpairmentCharges`	-	USD	1 Quarter
Interest expense	`InterestExpense`	$101.20M	USD	1 Quarter
Interest expense	`InterestExpense`	$101.90M	USD	1 Quarter
Interest expense	`InterestExpense`	$282.50M	USD	3 Qtrs
Interest expense	`InterestExpense`	$322.90M	USD	3 Qtrs
Interest income	`InvestmentIncomeNet`	$5.10M	USD	1 Quarter
Interest income	`InvestmentIncomeNet`	$15.80M	USD	3 Qtrs
Interest income	`InvestmentIncomeNet`	$2.60M	USD	1 Quarter
Interest income	`InvestmentIncomeNet`	$4.80M	USD	3 Qtrs
Other (income) expense - net	`OtherNonoperatingIncomeExpense`	$8.00M	USD	1 Quarter
Other (income) expense - net	`OtherNonoperatingIncomeExpense`	$17.00M	USD	3 Qtrs
Other (income) expense - net	`OtherNonoperatingIncomeExpense`	$-18.10M	USD	1 Quarter
Other (income) expense - net	`OtherNonoperatingIncomeExpense`	$-49.90M	USD	3 Qtrs
Income before income taxes	`IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest`	$2.08B	USD	3 Qtrs
Income before income taxes	`IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest`	$877.20M	USD	1 Quarter
Income before income taxes	`IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest`	$2.64B	USD	3 Qtrs
Income before income taxes	`IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest`	$1.01B	USD	1 Quarter
Income taxes	`IncomeTaxExpenseBenefit`	$247.50M	USD	1 Quarter
Income taxes	`IncomeTaxExpenseBenefit`	$603.30M	USD	3 Qtrs
Income taxes	`IncomeTaxExpenseBenefit`	$444.40M	USD	3 Qtrs
Income taxes	`IncomeTaxExpenseBenefit`	$192.10M	USD	1 Quarter
Net income	`NetIncomeLoss`	$577.90M	USD	1 Quarter
Net income	`NetIncomeLoss`	$2.03B	USD	3 Qtrs
Net income	`NetIncomeLoss`	$685.10M	USD	1 Quarter
Net income	`NetIncomeLoss`	$761.50M	USD	1 Quarter
Net income	`NetIncomeLoss`	$477.40M	USD	1 Quarter
Net income	`NetIncomeLoss`	$1.63B	USD	3 Qtrs
Net income	`NetIncomeLoss`	$793.70M	USD	1 Quarter
Net income	`NetIncomeLoss`	$370.80M	USD	1 Quarter
Basic (in dollars per share)	`EarningsPerShareBasic`	$6.33	USD	3 Qtrs
Basic (in dollars per share)	`EarningsPerShareBasic`	$2.98	USD	1 Quarter
Basic (in dollars per share)	`EarningsPerShareBasic`	$2.66	USD	1 Quarter
Basic (in dollars per share)	`EarningsPerShareBasic`	$7.94	USD	3 Qtrs
Diluted (in dollars per share)	`EarningsPerShareDiluted`	$6.23	USD	3 Qtrs
Diluted (in dollars per share)	`EarningsPerShareDiluted`	$7.85	USD	3 Qtrs
Diluted (in dollars per share)	`EarningsPerShareDiluted`	$2.95	USD	1 Quarter
Diluted (in dollars per share)	`EarningsPerShareDiluted`	$2.62	USD	1 Quarter
Basic (in shares)	`WeightedAverageNumberOfSharesOutstandingBasic`	255.90M	shares	3 Qtrs
Basic (in shares)	`WeightedAverageNumberOfSharesOutstandingBasic`	258.20M	shares	3 Qtrs
Basic (in shares)	`WeightedAverageNumberOfSharesOutstandingBasic`	257.70M	shares	1 Quarter
Basic (in shares)	`WeightedAverageNumberOfSharesOutstandingBasic`	255.10M	shares	1 Quarter
Diluted (in shares)	`WeightedAverageNumberOfDilutedSharesOutstanding`	258.40M	shares	1 Quarter
Diluted (in shares)	`WeightedAverageNumberOfDilutedSharesOutstanding`	258.80M	shares	3 Qtrs
Diluted (in shares)	`WeightedAverageNumberOfDilutedSharesOutstanding`	262.20M	shares	3 Qtrs
Diluted (in shares)	`WeightedAverageNumberOfDilutedSharesOutstanding`	261.10M	shares	1 Quarter

Cash Flow Statement 97 line items

Line Item	Tag	Value	Unit	Period
Net income	`NetIncomeLoss`	$577.90M	USD	1 Quarter
Net income	`NetIncomeLoss`	$2.03B	USD	3 Qtrs
Net income	`NetIncomeLoss`	$685.10M	USD	1 Quarter
Net income	`NetIncomeLoss`	$761.50M	USD	1 Quarter
Net income	`NetIncomeLoss`	$477.40M	USD	1 Quarter
Net income	`NetIncomeLoss`	$1.63B	USD	3 Qtrs
Net income	`NetIncomeLoss`	$793.70M	USD	1 Quarter
Net income	`NetIncomeLoss`	$370.80M	USD	1 Quarter
Depreciation	`Depreciation`	$194.80M	USD	3 Qtrs
Depreciation	`Depreciation`	$218.00M	USD	3 Qtrs
Non-cash lease expense	`OperatingLeasesNoncashExpense`	$333.40M	USD	3 Qtrs
Non-cash lease expense	`OperatingLeasesNoncashExpense`	$310.50M	USD	3 Qtrs
Amortization of intangible assets	`AmortizationOfIntangibleAssets`	$250.20M	USD	3 Qtrs
Amortization of intangible assets	`AmortizationOfIntangibleAssets`	$237.80M	USD	3 Qtrs
Gain on divestiture of businesses	`GainLossOnSaleOfBusiness`	$20.10M	USD	3 Qtrs
Gain on divestiture of businesses	`GainLossOnSaleOfBusiness`	-	USD	3 Qtrs
Impairment	`AssetImpairmentCharges`	-	USD	1 Quarter
Impairment	`AssetImpairmentCharges`	-	USD	3 Qtrs
Impairment	`AssetImpairmentCharges`	$34.00M	USD	3 Qtrs
Impairment	`AssetImpairmentCharges`	-	USD	1 Quarter
Stock-based compensation expense	`ShareBasedCompensation`	$80.00M	USD	3 Qtrs
Stock-based compensation expense	`ShareBasedCompensation`	$72.80M	USD	3 Qtrs
Amortization of non-traded investments	`AmortizationOfNonTradedInvestments`	$60.30M	USD	3 Qtrs
Amortization of non-traded investments	`AmortizationOfNonTradedInvestments`	$31.70M	USD	3 Qtrs
Gain on sale or disposition of assets	`GainLossOnSaleOfPropertyPlantEquipment`	$11.50M	USD	3 Qtrs
Gain on sale or disposition of assets	`GainLossOnSaleOfPropertyPlantEquipment`	$8.10M	USD	3 Qtrs
Provisions for environmental-related matters	`EnvironmentalRemediationExpense`	$39.40M	USD	1 Quarter
Provisions for environmental-related matters	`EnvironmentalRemediationExpense`	$52.70M	USD	3 Qtrs
Provisions for environmental-related matters	`EnvironmentalRemediationExpense`	$11.10M	USD	3 Qtrs
Provisions for environmental-related matters	`EnvironmentalRemediationExpense`	$6.40M	USD	1 Quarter
Other postretirement benefit plan net cost	`OtherPostretirementBenefitExpense`	-	USD	3 Qtrs
Other postretirement benefit plan net cost	`OtherPostretirementBenefitExpense`	$-13.50M	USD	3 Qtrs
Deferred income taxes	`DeferredIncomeTaxExpenseBenefit`	$-89.10M	USD	3 Qtrs
Deferred income taxes	`DeferredIncomeTaxExpenseBenefit`	$-108.80M	USD	3 Qtrs
Other	`OtherNoncashIncomeExpense`	$-27.40M	USD	3 Qtrs
Other	`OtherNoncashIncomeExpense`	$-37.40M	USD	3 Qtrs
Change in working capital accounts - net	`IncreaseDecreaseInOperatingCapital`	$818.20M	USD	3 Qtrs
Change in working capital accounts - net	`IncreaseDecreaseInOperatingCapital`	$-194.60M	USD	3 Qtrs
Change in operating lease liabilities	`IncreaseDecreaseInOperatingLeaseLiabilities`	$-312.80M	USD	3 Qtrs
Change in operating lease liabilities	`IncreaseDecreaseInOperatingLeaseLiabilities`	$-335.20M	USD	3 Qtrs
Costs incurred for environmental-related matters	`PaymentsForEnvironmentalLiabilities`	$19.30M	USD	3 Qtrs
Costs incurred for environmental-related matters	`PaymentsForEnvironmentalLiabilities`	$24.10M	USD	3 Qtrs
Other	`OtherOperatingActivitiesCashFlowStatement`	$12.40M	USD	3 Qtrs
Other	`OtherOperatingActivitiesCashFlowStatement`	$-182.60M	USD	3 Qtrs
Net operating cash	`NetCashProvidedByUsedInOperatingActivities`	$2.60B	USD	3 Qtrs
Net operating cash	`NetCashProvidedByUsedInOperatingActivities`	$1.28B	USD	3 Qtrs
Capital expenditures	`PaymentsToAcquireProductiveAssets`	$568.90M	USD	3 Qtrs
Capital expenditures	`PaymentsToAcquireProductiveAssets`	$410.70M	USD	3 Qtrs
Acquisitions of businesses, net of cash acquired	`PaymentsToAcquireBusinessesNetOfCashAcquired`	$626.80M	USD	3 Qtrs
Acquisitions of businesses, net of cash acquired	`PaymentsToAcquireBusinessesNetOfCashAcquired`	$23.20M	USD	3 Qtrs
Proceeds from divestiture of businesses	`ProceedsFromDivestitureOfBusinesses`	-	USD	3 Qtrs
Proceeds from divestiture of businesses	`ProceedsFromDivestitureOfBusinesses`	$103.70M	USD	3 Qtrs
Proceeds from sale of assets	`ProceedsFromSaleOfProductiveAssets`	$49.00M	USD	3 Qtrs
Proceeds from sale of assets	`ProceedsFromSaleOfProductiveAssets`	$33.20M	USD	3 Qtrs
Other	`PaymentsForProceedsFromOtherInvestingActivities`	$69.60M	USD	3 Qtrs
Other	`PaymentsForProceedsFromOtherInvestingActivities`	$46.20M	USD	3 Qtrs
Net investing cash	`NetCashProvidedByUsedInInvestingActivities`	$-1.05B	USD	3 Qtrs
Net investing cash	`NetCashProvidedByUsedInInvestingActivities`	$-509.00M	USD	3 Qtrs
Net (decrease) increase in short-term borrowings	`RepaymentsOfShortTermDebt`	$639.20M	USD	3 Qtrs
Net (decrease) increase in short-term borrowings	`ProceedsFromShortTermDebt`	$184.50M	USD	3 Qtrs
Proceeds from long-term debt	`ProceedsFromIssuanceOfLongTermDebt`	-	USD	3 Qtrs
Proceeds from long-term debt	`ProceedsFromIssuanceOfLongTermDebt`	$999.70M	USD	3 Qtrs
Payments of long-term debt	`RepaymentsOfLongTermDebt`	$260.30M	USD	3 Qtrs
Payments of long-term debt	`RepaymentsOfLongTermDebt`	$600.00K	USD	3 Qtrs
Payments for credit facility and debt issuance costs	`PaymentsOfDebtIssuanceCosts`	-	USD	3 Qtrs
Payments for credit facility and debt issuance costs	`PaymentsOfDebtIssuanceCosts`	$7.30M	USD	3 Qtrs
Payments of cash dividends	`PaymentsOfDividends`	$462.90M	USD	3 Qtrs
Payments of cash dividends	`PaymentsOfDividends`	$468.40M	USD	3 Qtrs
Proceeds from stock options exercised	`ProceedsFromStockOptionsExercised`	$38.90M	USD	3 Qtrs
Proceeds from stock options exercised	`ProceedsFromStockOptionsExercised`	$66.20M	USD	3 Qtrs
Treasury stock purchased	`PaymentsForRepurchaseOfEquity`	$751.10M	USD	3 Qtrs
Treasury stock purchased	`PaymentsForRepurchaseOfEquity`	$946.00M	USD	3 Qtrs
Proceeds from treasury stock issued	`ProceedsFromSaleOfTreasuryStock`	-	USD	3 Qtrs
Proceeds from treasury stock issued	`ProceedsFromSaleOfTreasuryStock`	$22.00M	USD	3 Qtrs
Proceeds from treasury stock issued	`ProceedsFromSaleOfTreasuryStock`	$22.00M	USD	Point-in-time
Proceeds from real estate financing transactions	`ProceedsFromRealEstateFinancingTransactions`	-	USD	3 Qtrs
Proceeds from real estate financing transactions	`ProceedsFromRealEstateFinancingTransactions`	$227.60M	USD	3 Qtrs
Other	`ProceedsFromPaymentsForOtherFinancingActivities`	$-24.70M	USD	3 Qtrs
Other	`ProceedsFromPaymentsForOtherFinancingActivities`	$-27.10M	USD	3 Qtrs
Net financing cash	`NetCashProvidedByUsedInFinancingActivities`	$-1.79B	USD	3 Qtrs
Net financing cash	`NetCashProvidedByUsedInFinancingActivities`	$-263.60M	USD	3 Qtrs
Effect of exchange rate changes on cash	`EffectOfExchangeRateOnCashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	$-4.60M	USD	3 Qtrs
Effect of exchange rate changes on cash	`EffectOfExchangeRateOnCashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	-	USD	3 Qtrs
Net increase (decrease) in cash and cash equivalents	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalentsPeriodIncreaseDecreaseIncludingExchangeRateEffect`	$-35.20M	USD	3 Qtrs
Net increase (decrease) in cash and cash equivalents	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalentsPeriodIncreaseDecreaseIncludingExchangeRateEffect`	$304.60M	USD	3 Qtrs
Cash and cash equivalents at beginning of year	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	$165.70M	USD	Point-in-time
Cash and cash equivalents at beginning of year	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	$503.40M	USD	Point-in-time
Cash and cash equivalents at beginning of year	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	$198.80M	USD	Point-in-time
Cash and cash equivalents at beginning of year	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	$130.50M	USD	Point-in-time
Cash and cash equivalents at end of period	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	$165.70M	USD	Point-in-time
Cash and cash equivalents at end of period	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	$503.40M	USD	Point-in-time
Cash and cash equivalents at end of period	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	$198.80M	USD	Point-in-time
Cash and cash equivalents at end of period	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	$130.50M	USD	Point-in-time
Income taxes paid	`IncomeTaxesPaid`	$430.20M	USD	3 Qtrs
Income taxes paid	`IncomeTaxesPaid`	$523.00M	USD	3 Qtrs
Interest paid	`InterestPaidNet`	$324.10M	USD	3 Qtrs
Interest paid	`InterestPaidNet`	$266.90M	USD	3 Qtrs

Stockholders Equity 65 line items

Line Item	Tag	Value	Unit	Period
Cash dividends (in dollars per share)	`CommonStockDividendsPerShareCashPaid`	$0.60	USD	1 Quarter
Cash dividends (in dollars per share)	`CommonStockDividendsPerShareCashPaid`	$1.81	USD	3 Qtrs
Cash dividends (in dollars per share)	`CommonStockDividendsPerShareCashPaid`	$0.60	USD	1 Quarter
Cash dividends (in dollars per share)	`CommonStockDividendsPerShareCashPaid`	$0.60	USD	1 Quarter
Cash dividends (in dollars per share)	`CommonStockDividendsPerShareCashPaid`	$1.80	USD	3 Qtrs
Cash dividends (in dollars per share)	`CommonStockDividendsPerShareCashPaid`	$0.60	USD	1 Quarter
Cash dividends (in dollars per share)	`CommonStockDividendsPerShareCashPaid`	$0.60	USD	1 Quarter
Cash dividends (in dollars per share)	`CommonStockDividendsPerShareCashPaid`	$0.60	USD	1 Quarter
Beginning balance	`StockholdersEquity`	$3.10B	USD	Point-in-time
Beginning balance	`StockholdersEquity`	$3.17B	USD	Point-in-time
Beginning balance	`StockholdersEquity`	$3.63B	USD	Point-in-time
Beginning balance	`StockholdersEquity`	$2.23B	USD	Point-in-time
Beginning balance	`StockholdersEquity`	$2.22B	USD	Point-in-time
Beginning balance	`StockholdersEquity`	$2.60B	USD	Point-in-time
Beginning balance	`StockholdersEquity`	$3.78B	USD	Point-in-time
Beginning balance	`StockholdersEquity`	$2.44B	USD	Point-in-time
Net income	`NetIncomeLoss`	$577.90M	USD	1 Quarter
Net income	`NetIncomeLoss`	$2.03B	USD	3 Qtrs
Net income	`NetIncomeLoss`	$685.10M	USD	1 Quarter
Net income	`NetIncomeLoss`	$761.50M	USD	1 Quarter
Net income	`NetIncomeLoss`	$477.40M	USD	1 Quarter
Net income	`NetIncomeLoss`	$1.63B	USD	3 Qtrs
Net income	`NetIncomeLoss`	$793.70M	USD	1 Quarter
Net income	`NetIncomeLoss`	$370.80M	USD	1 Quarter
Other comprehensive income (loss)	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$-147.90M	USD	1 Quarter
Other comprehensive income (loss)	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$14.50M	USD	1 Quarter
Other comprehensive income (loss)	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$34.80M	USD	1 Quarter
Other comprehensive income (loss)	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$-364.10M	USD	3 Qtrs
Other comprehensive income (loss)	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$-105.10M	USD	1 Quarter
Other comprehensive income (loss)	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$-55.80M	USD	3 Qtrs
Other comprehensive income (loss)	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$-172.60M	USD	1 Quarter
Other comprehensive income (loss)	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$-43.60M	USD	1 Quarter
Treasury stock purchased	`TreasuryStockValueAcquiredParValueMethod`	$410.10M	USD	1 Quarter
Treasury stock purchased	`TreasuryStockValueAcquiredParValueMethod`	$47.60M	USD	1 Quarter
Treasury stock purchased	`TreasuryStockValueAcquiredParValueMethod`	$296.40M	USD	1 Quarter
Treasury stock purchased	`TreasuryStockValueAcquiredParValueMethod`	$301.70M	USD	1 Quarter
Treasury stock purchased	`TreasuryStockValueAcquiredParValueMethod`	$407.10M	USD	1 Quarter
Treasury stock purchased	`TreasuryStockValueAcquiredParValueMethod`	$234.20M	USD	1 Quarter
Treasury stock issued	`StockIssuedDuringPeriodValueTreasuryStockReissued`	$22.00M	USD	1 Quarter
Stock-based compensation activity	`StockholdersEquityValueStockBasedCompensationActivity`	$41.50M	USD	1 Quarter
Stock-based compensation activity	`StockholdersEquityValueStockBasedCompensationActivity`	$39.00M	USD	1 Quarter
Stock-based compensation activity	`StockholdersEquityValueStockBasedCompensationActivity`	$57.60M	USD	1 Quarter
Stock-based compensation activity	`StockholdersEquityValueStockBasedCompensationActivity`	$10.40M	USD	1 Quarter
Stock-based compensation activity	`StockholdersEquityValueStockBasedCompensationActivity`	$47.50M	USD	1 Quarter
Stock-based compensation activity	`StockholdersEquityValueStockBasedCompensationActivity`	$5.60M	USD	1 Quarter
Other adjustments	`StockholdersEquityOther`	$3.90M	USD	1 Quarter
Other adjustments	`StockholdersEquityOther`	$900.00K	USD	1 Quarter
Other adjustments	`StockholdersEquityOther`	$-300.00K	USD	1 Quarter
Other adjustments	`StockholdersEquityOther`	$-600.00K	USD	1 Quarter
Other adjustments	`StockholdersEquityOther`	$-300.00K	USD	1 Quarter
Other adjustments	`StockholdersEquityOther`	$-400.00K	USD	1 Quarter
Cash dividends	`DividendsCash`	$156.50M	USD	1 Quarter
Cash dividends	`DividendsCash`	$150.90M	USD	1 Quarter
Cash dividends	`DividendsCash`	$156.30M	USD	1 Quarter
Cash dividends	`DividendsCash`	$155.80M	USD	1 Quarter
Cash dividends	`DividendsCash`	$156.20M	USD	1 Quarter
Cash dividends	`DividendsCash`	$155.60M	USD	1 Quarter
Ending balance	`StockholdersEquity`	$3.10B	USD	Point-in-time
Ending balance	`StockholdersEquity`	$3.17B	USD	Point-in-time
Ending balance	`StockholdersEquity`	$3.63B	USD	Point-in-time
Ending balance	`StockholdersEquity`	$2.23B	USD	Point-in-time
Ending balance	`StockholdersEquity`	$2.22B	USD	Point-in-time
Ending balance	`StockholdersEquity`	$2.60B	USD	Point-in-time
Ending balance	`StockholdersEquity`	$3.78B	USD	Point-in-time
Ending balance	`StockholdersEquity`	$2.44B	USD	Point-in-time

Comprehensive Income 44 line items

Line Item	Tag	Value	Unit	Period
Net income	`NetIncomeLoss`	$577.90M	USD	1 Quarter
Net income	`NetIncomeLoss`	$2.03B	USD	3 Qtrs
Net income	`NetIncomeLoss`	$685.10M	USD	1 Quarter
Net income	`NetIncomeLoss`	$761.50M	USD	1 Quarter
Net income	`NetIncomeLoss`	$477.40M	USD	1 Quarter
Net income	`NetIncomeLoss`	$1.63B	USD	3 Qtrs
Net income	`NetIncomeLoss`	$793.70M	USD	1 Quarter
Net income	`NetIncomeLoss`	$370.80M	USD	1 Quarter
Foreign currency translation adjustments	`OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax`	$-364.70M	USD	3 Qtrs
Foreign currency translation adjustments	`OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax`	$-39.50M	USD	3 Qtrs
Foreign currency translation adjustments	`OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax`	$-99.60M	USD	1 Quarter
Foreign currency translation adjustments	`OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax`	$-148.00M	USD	1 Quarter
Amounts reclassified from AOCI	`OtherComprehensiveIncomeLossReclassificationAdjustmentFromAOCIPensionAndOtherPostretirementBenefitPlansNetOfTax`	$-4.60M	USD	1 Quarter
Amounts reclassified from AOCI	`OtherComprehensiveIncomeLossReclassificationAdjustmentFromAOCIPensionAndOtherPostretirementBenefitPlansNetOfTax`	$-13.60M	USD	3 Qtrs
Amounts reclassified from AOCI	`OtherComprehensiveIncomeLossReclassificationAdjustmentFromAOCIPensionAndOtherPostretirementBenefitPlansNetOfTax`	$1.00M	USD	1 Quarter
Amounts reclassified from AOCI	`OtherComprehensiveIncomeLossReclassificationAdjustmentFromAOCIPensionAndOtherPostretirementBenefitPlansNetOfTax`	$3.50M	USD	3 Qtrs
Foreign currency translation adjustments	`OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax`	$-364.70M	USD	3 Qtrs
Foreign currency translation adjustments	`OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax`	$-39.50M	USD	3 Qtrs
Foreign currency translation adjustments	`OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax`	$-99.60M	USD	1 Quarter
Foreign currency translation adjustments	`OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax`	$-148.00M	USD	1 Quarter
Amounts reclassified from AOCI	`OtherComprehensiveIncomeLossCashFlowHedgeGainLossReclassificationAfterTax`	$2.70M	USD	3 Qtrs
Amounts reclassified from AOCI	`OtherComprehensiveIncomeLossCashFlowHedgeGainLossReclassificationAfterTax`	$900.00K	USD	1 Quarter
Pension and other postretirement benefit adjustments, amounts reclassified from other comprehensive income, tax	`OtherComprehensiveIncomeLossReclassificationAdjustmentFromAOCIPensionAndOtherPostretirementBenefitPlansTax`	$-1.60M	USD	1 Quarter
Amounts reclassified from AOCI	`OtherComprehensiveIncomeLossCashFlowHedgeGainLossReclassificationAfterTax`	$2.90M	USD	3 Qtrs
Amounts reclassified from AOCI	`OtherComprehensiveIncomeLossCashFlowHedgeGainLossReclassificationAfterTax`	$900.00K	USD	1 Quarter
Pension and other postretirement benefit adjustments, amounts reclassified from other comprehensive income, tax	`OtherComprehensiveIncomeLossReclassificationAdjustmentFromAOCIPensionAndOtherPostretirementBenefitPlansTax`	$1.10M	USD	3 Qtrs
Pension and other postretirement benefit adjustments, amounts reclassified from other comprehensive income, tax	`OtherComprehensiveIncomeLossReclassificationAdjustmentFromAOCIPensionAndOtherPostretirementBenefitPlansTax`	$-4.60M	USD	3 Qtrs
Pension and other postretirement benefit adjustments, amounts reclassified from other comprehensive income, tax	`OtherComprehensiveIncomeLossReclassificationAdjustmentFromAOCIPensionAndOtherPostretirementBenefitPlansTax`	$300.00K	USD	1 Quarter
Other comprehensive loss	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$-147.90M	USD	1 Quarter
Other comprehensive loss	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$14.50M	USD	1 Quarter
Unrealized net gains on cash flow hedges, amounts reclassified from other comprehensive income, tax	`OtherComprehensiveIncomeLossCashFlowHedgeGainLossReclassificationTax`	$1.00M	USD	3 Qtrs
Other comprehensive loss	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$34.80M	USD	1 Quarter
Other comprehensive loss	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$-364.10M	USD	3 Qtrs
Other comprehensive loss	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$-105.10M	USD	1 Quarter
Unrealized net gains on cash flow hedges, amounts reclassified from other comprehensive income, tax	`OtherComprehensiveIncomeLossCashFlowHedgeGainLossReclassificationTax`	$300.00K	USD	1 Quarter
Other comprehensive loss	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$-55.80M	USD	3 Qtrs
Unrealized net gains on cash flow hedges, amounts reclassified from other comprehensive income, tax	`OtherComprehensiveIncomeLossCashFlowHedgeGainLossReclassificationTax`	$900.00K	USD	3 Qtrs
Other comprehensive loss	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$-172.60M	USD	1 Quarter
Unrealized net gains on cash flow hedges, amounts reclassified from other comprehensive income, tax	`OtherComprehensiveIncomeLossCashFlowHedgeGainLossReclassificationTax`	$300.00K	USD	1 Quarter
Other comprehensive loss	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$-43.60M	USD	1 Quarter
Comprehensive income	`ComprehensiveIncomeNetOfTax`	$656.40M	USD	1 Quarter
Comprehensive income	`ComprehensiveIncomeNetOfTax`	$1.98B	USD	3 Qtrs
Comprehensive income	`ComprehensiveIncomeNetOfTax`	$537.20M	USD	1 Quarter
Comprehensive income	`ComprehensiveIncomeNetOfTax`	$1.27B	USD	3 Qtrs

Data is extracted from SEC EDGAR XBRL filings. Values shown are as reported in the filing.