10-Q Filing

SHERWIN WILLIAMS CO CIK: 89800 Q3 2020

Filing Information

Form Type	10-Q
Accession Number	`0000089800-20-000024`
Period End Date	20200930
Filing Date	20201027
Fiscal Year	2020
Fiscal Period	Q3
XBRL Instance	shw-20200930_htm.xml

Filing Contents

This filing contains the following financial statements:

Balance Sheet 107 Income Statement 80 Cash Flow Statement 89 Stockholders Equity 65 Comprehensive Income 52

Balance Sheet 107 line items

Line Item	Tag	Value	Unit	Period
Common stock, par value (in dollars per share)	`CommonStockParOrStatedValuePerShare`	$1.00	USD	Point-in-time
Common stock, par value (in dollars per share)	`CommonStockParOrStatedValuePerShare`	$1.00	USD	Point-in-time
Common stock, par value (in dollars per share)	`CommonStockParOrStatedValuePerShare`	$1.00	USD	Point-in-time
Common stock, shares outstanding (in shares)	`CommonStockSharesOutstanding`	92.30M	shares	Point-in-time
Common stock, shares outstanding (in shares)	`CommonStockSharesOutstanding`	92.10M	shares	Point-in-time
Common stock, shares outstanding (in shares)	`CommonStockSharesOutstanding`	90.80M	shares	Point-in-time
Cash and cash equivalents	`CashAndCashEquivalentsAtCarryingValue`	$619.90M	USD	Point-in-time
Cash and cash equivalents	`CashAndCashEquivalentsAtCarryingValue`	$189.60M	USD	Point-in-time
Cash and cash equivalents	`CashAndCashEquivalentsAtCarryingValue`	$161.80M	USD	Point-in-time
Accounts receivable, net	`AccountsReceivableNetCurrent`	$2.45B	USD	Point-in-time
Accounts receivable, net	`AccountsReceivableNetCurrent`	$2.09B	USD	Point-in-time
Accounts receivable, net	`AccountsReceivableNetCurrent`	$2.48B	USD	Point-in-time
Inventories	`InventoryNet`	$1.89B	USD	Point-in-time
Inventories	`InventoryNet`	$1.67B	USD	Point-in-time
Inventories	`InventoryNet`	$1.82B	USD	Point-in-time
Other current assets	`OtherAssetsCurrent`	$414.10M	USD	Point-in-time
Other current assets	`OtherAssetsCurrent`	$491.40M	USD	Point-in-time
Other current assets	`OtherAssetsCurrent`	$428.40M	USD	Point-in-time
Total current assets	`AssetsCurrent`	$5.18B	USD	Point-in-time
Total current assets	`AssetsCurrent`	$4.91B	USD	Point-in-time
Total current assets	`AssetsCurrent`	$4.63B	USD	Point-in-time
Property, plant and equipment, net	`PropertyPlantAndEquipmentNet`	$1.84B	USD	Point-in-time
Property, plant and equipment, net	`PropertyPlantAndEquipmentNet`	$1.80B	USD	Point-in-time
Property, plant and equipment, net	`PropertyPlantAndEquipmentNet`	$1.78B	USD	Point-in-time
Goodwill	`Goodwill`	$6.96B	USD	Point-in-time
Goodwill	`Goodwill`	$7.00B	USD	Point-in-time
Goodwill	`Goodwill`	$7.01B	USD	Point-in-time
Intangible assets	`IntangibleAssetsNetExcludingGoodwill`	$4.50B	USD	Point-in-time
Intangible assets	`IntangibleAssetsNetExcludingGoodwill`	$4.73B	USD	Point-in-time
Intangible assets	`IntangibleAssetsNetExcludingGoodwill`	$4.89B	USD	Point-in-time
Operating lease right-of-use assets	`OperatingLeaseRightOfUseAsset`	$1.74B	USD	Point-in-time
Operating lease right-of-use assets	`OperatingLeaseRightOfUseAsset`	$1.69B	USD	Point-in-time
Operating lease right-of-use assets	`OperatingLeaseRightOfUseAsset`	$1.66B	USD	Point-in-time
Other assets	`OtherAssetsNoncurrent`	$611.20M	USD	Point-in-time
Other assets	`OtherAssetsNoncurrent`	$604.40M	USD	Point-in-time
Other assets	`OtherAssetsNoncurrent`	$651.30M	USD	Point-in-time
Total assets	`Assets`	$20.81B	USD	Point-in-time
Total assets	`Assets`	$20.86B	USD	Point-in-time
Total assets	`Assets`	$20.50B	USD	Point-in-time
Short-term borrowings	`ShortTermBorrowings`	$200.00K	USD	Point-in-time
Short-term borrowings	`ShortTermBorrowings`	$435.70M	USD	Point-in-time
Short-term borrowings	`ShortTermBorrowings`	$204.70M	USD	Point-in-time
Accounts payable	`AccountsPayableCurrent`	$2.06B	USD	Point-in-time
Accounts payable	`AccountsPayableCurrent`	$1.88B	USD	Point-in-time
Accounts payable	`AccountsPayableCurrent`	$2.03B	USD	Point-in-time
Compensation and taxes withheld	`EmployeeRelatedLiabilitiesCurrent`	$538.90M	USD	Point-in-time
Compensation and taxes withheld	`EmployeeRelatedLiabilitiesCurrent`	$552.70M	USD	Point-in-time
Compensation and taxes withheld	`EmployeeRelatedLiabilitiesCurrent`	$654.50M	USD	Point-in-time
Accrued taxes	`TaxesPayableCurrent`	$95.00M	USD	Point-in-time
Accrued taxes	`TaxesPayableCurrent`	$85.70M	USD	Point-in-time
Accrued taxes	`TaxesPayableCurrent`	$165.20M	USD	Point-in-time
Current portion of long-term debt	`LongTermDebtCurrent`	$429.80M	USD	Point-in-time
Current portion of long-term debt	`LongTermDebtCurrent`	$24.10M	USD	Point-in-time
Current portion of long-term debt	`LongTermDebtCurrent`	$429.60M	USD	Point-in-time
California litigation accrual	`LossContingencyAccrualAtCarryingValue`	$12.00M	USD	Point-in-time
California litigation accrual	`LossContingencyAccrualAtCarryingValue`	$12.00M	USD	Point-in-time
California litigation accrual	`LossContingencyAccrualAtCarryingValue`	$12.00M	USD	Point-in-time
Current portion of operating lease liabilities	`OperatingLeaseLiabilityCurrent`	$364.40M	USD	Point-in-time
Current portion of operating lease liabilities	`OperatingLeaseLiabilityCurrent`	$379.50M	USD	Point-in-time
Current portion of operating lease liabilities	`OperatingLeaseLiabilityCurrent`	$371.60M	USD	Point-in-time
Other accruals	`OtherLiabilitiesCurrent`	$1.07B	USD	Point-in-time
Other accruals	`OtherLiabilitiesCurrent`	$961.80M	USD	Point-in-time
Other accruals	`OtherLiabilitiesCurrent`	$989.10M	USD	Point-in-time
Total current liabilities	`LiabilitiesCurrent`	$4.52B	USD	Point-in-time
Total current liabilities	`LiabilitiesCurrent`	$4.36B	USD	Point-in-time
Total current liabilities	`LiabilitiesCurrent`	$4.87B	USD	Point-in-time
Long-term debt	`LongTermDebtNoncurrent`	$8.05B	USD	Point-in-time
Long-term debt	`LongTermDebtNoncurrent`	$8.27B	USD	Point-in-time
Long-term debt	`LongTermDebtNoncurrent`	$8.04B	USD	Point-in-time
Postretirement benefits other than pensions	`OtherPostretirementDefinedBenefitPlanLiabilitiesNoncurrent`	$261.00M	USD	Point-in-time
Postretirement benefits other than pensions	`OtherPostretirementDefinedBenefitPlanLiabilitiesNoncurrent`	$262.30M	USD	Point-in-time
Postretirement benefits other than pensions	`OtherPostretirementDefinedBenefitPlanLiabilitiesNoncurrent`	$263.00M	USD	Point-in-time
Deferred income taxes	`DeferredIncomeTaxLiabilitiesNet`	$1.10B	USD	Point-in-time
Deferred income taxes	`DeferredIncomeTaxLiabilitiesNet`	$956.70M	USD	Point-in-time
Deferred income taxes	`DeferredIncomeTaxLiabilitiesNet`	$969.90M	USD	Point-in-time
Long-term operating lease liabilities	`OperatingLeaseLiabilityNoncurrent`	$1.35B	USD	Point-in-time
Long-term operating lease liabilities	`OperatingLeaseLiabilityNoncurrent`	$1.42B	USD	Point-in-time
Long-term operating lease liabilities	`OperatingLeaseLiabilityNoncurrent`	$1.37B	USD	Point-in-time
Other long-term liabilities	`OtherLiabilitiesNoncurrent`	$1.34B	USD	Point-in-time
Other long-term liabilities	`OtherLiabilitiesNoncurrent`	$1.20B	USD	Point-in-time
Other long-term liabilities	`OtherLiabilitiesNoncurrent`	$1.22B	USD	Point-in-time
Common stock	`CommonStockValue`	$120.40M	USD	Point-in-time
Common stock	`CommonStockValue`	$119.40M	USD	Point-in-time
Common stock	`CommonStockValue`	$119.20M	USD	Point-in-time
Other capital	`AdditionalPaidInCapital`	$3.08B	USD	Point-in-time
Other capital	`AdditionalPaidInCapital`	$3.37B	USD	Point-in-time
Other capital	`AdditionalPaidInCapital`	$3.15B	USD	Point-in-time
Retained earnings	`RetainedEarningsAccumulatedDeficit`	$7.37B	USD	Point-in-time
Retained earnings	`RetainedEarningsAccumulatedDeficit`	$8.62B	USD	Point-in-time
Retained earnings	`RetainedEarningsAccumulatedDeficit`	$7.22B	USD	Point-in-time
Treasury stock, at cost	`TreasuryStockValue`	$7.11B	USD	Point-in-time
Treasury stock, at cost	`TreasuryStockValue`	$5.63B	USD	Point-in-time
Treasury stock, at cost	`TreasuryStockValue`	$5.84B	USD	Point-in-time
Accumulated other comprehensive loss	`AccumulatedOtherComprehensiveIncomeLossNetOfTax`	$-767.10M	USD	Point-in-time
Accumulated other comprehensive loss	`AccumulatedOtherComprehensiveIncomeLossNetOfTax`	$-679.50M	USD	Point-in-time
Accumulated other comprehensive loss	`AccumulatedOtherComprehensiveIncomeLossNetOfTax`	$-792.30M	USD	Point-in-time
Total shareholders' equity	`StockholdersEquity`	$4.02B	USD	Point-in-time
Total shareholders' equity	`StockholdersEquity`	$3.73B	USD	Point-in-time
Total shareholders' equity	`StockholdersEquity`	$4.12B	USD	Point-in-time
Total shareholders' equity	`StockholdersEquity`	$3.29B	USD	Point-in-time
Total shareholders' equity	`StockholdersEquity`	$3.75B	USD	Point-in-time
Total shareholders' equity	`StockholdersEquity`	$3.46B	USD	Point-in-time
Total shareholders' equity	`StockholdersEquity`	$3.87B	USD	Point-in-time
Total shareholders' equity	`StockholdersEquity`	$4.21B	USD	Point-in-time
Total liabilities and shareholders equity	`LiabilitiesAndStockholdersEquity`	$20.81B	USD	Point-in-time
Total liabilities and shareholders equity	`LiabilitiesAndStockholdersEquity`	$20.86B	USD	Point-in-time
Total liabilities and shareholders equity	`LiabilitiesAndStockholdersEquity`	$20.50B	USD	Point-in-time

Income Statement 80 line items

Line Item	Tag	Value	Unit	Period
Net sales	`RevenueFromContractWithCustomerExcludingAssessedTax`	$5.12B	USD	1 Quarter
Net sales	`RevenueFromContractWithCustomerExcludingAssessedTax`	$4.87B	USD	1 Quarter
Net sales	`RevenueFromContractWithCustomerExcludingAssessedTax`	$13.79B	USD	3 Qtrs
Net sales	`RevenueFromContractWithCustomerExcludingAssessedTax`	$13.87B	USD	3 Qtrs
Cost of goods sold	`CostOfGoodsAndServicesSold`	$2.67B	USD	1 Quarter
Cost of goods sold	`CostOfGoodsAndServicesSold`	$7.64B	USD	3 Qtrs
Cost of goods sold	`CostOfGoodsAndServicesSold`	$7.32B	USD	3 Qtrs
Cost of goods sold	`CostOfGoodsAndServicesSold`	$2.64B	USD	1 Quarter
Gross profit	`GrossProfit`	$2.46B	USD	1 Quarter
Gross profit	`GrossProfit`	$6.14B	USD	3 Qtrs
Gross profit	`GrossProfit`	$6.55B	USD	3 Qtrs
Gross profit	`GrossProfit`	$2.23B	USD	1 Quarter
Percent to net sales	`GrossProfitPercentage`	0.46	pure	1 Quarter
Percent to net sales	`GrossProfitPercentage`	0.47	pure	3 Qtrs
Percent to net sales	`GrossProfitPercentage`	0.48	pure	1 Quarter
Percent to net sales	`GrossProfitPercentage`	0.45	pure	3 Qtrs
Selling, general and administrative expenses	`SellingGeneralAndAdministrativeExpense`	$4.01B	USD	3 Qtrs
Selling, general and administrative expenses	`SellingGeneralAndAdministrativeExpense`	$1.35B	USD	1 Quarter
Selling, general and administrative expenses	`SellingGeneralAndAdministrativeExpense`	$3.92B	USD	3 Qtrs
Selling, general and administrative expenses	`SellingGeneralAndAdministrativeExpense`	$1.41B	USD	1 Quarter
Percent to net sales	`SellingGeneralAdministrativeExpenseAsPercentNetSales`	0.28	pure	1 Quarter
Percent to net sales	`SellingGeneralAdministrativeExpenseAsPercentNetSales`	0.29	pure	3 Qtrs
Percent to net sales	`SellingGeneralAdministrativeExpenseAsPercentNetSales`	0.28	pure	1 Quarter
Percent to net sales	`SellingGeneralAdministrativeExpenseAsPercentNetSales`	0.28	pure	3 Qtrs
Other general expense - net	`OtherGeneralIncomeExpenseNet`	$-18.70M	USD	3 Qtrs
Other general expense - net	`OtherGeneralIncomeExpenseNet`	$-10.50M	USD	1 Quarter
Other general expense - net	`OtherGeneralIncomeExpenseNet`	$-12.00M	USD	1 Quarter
Other general expense - net	`OtherGeneralIncomeExpenseNet`	$-13.10M	USD	3 Qtrs
Amortization	`AmortizationOfIntangibleAssets`	$77.50M	USD	1 Quarter
Amortization	`AmortizationOfIntangibleAssets`	$234.20M	USD	3 Qtrs
Amortization	`AmortizationOfIntangibleAssets`	$78.70M	USD	1 Quarter
Amortization	`AmortizationOfIntangibleAssets`	$234.40M	USD	3 Qtrs
Interest expense	`InterestExpense`	$85.30M	USD	1 Quarter
Interest expense	`InterestExpense`	$257.60M	USD	3 Qtrs
Interest expense	`InterestExpense`	$265.50M	USD	3 Qtrs
Interest expense	`InterestExpense`	$83.30M	USD	1 Quarter
Interest and net investment income	`InvestmentIncomeNet`	$600.00K	USD	1 Quarter
Interest and net investment income	`InvestmentIncomeNet`	$1.60M	USD	3 Qtrs
Interest and net investment income	`InvestmentIncomeNet`	$2.60M	USD	3 Qtrs
Interest and net investment income	`InvestmentIncomeNet`	$1.40M	USD	1 Quarter
California litigation expense	`GainLossRelatedToLitigationSettlement`	-	USD	1 Quarter
California litigation expense	`GainLossRelatedToLitigationSettlement`	-	USD	3 Qtrs
California litigation expense	`GainLossRelatedToLitigationSettlement`	$34.70M	USD	3 Qtrs
California litigation expense	`GainLossRelatedToLitigationSettlement`	$34.70M	USD	1 Quarter
Other expense - net	`OtherNonoperatingIncomeExpense`	$-1.80M	USD	1 Quarter
Other expense - net	`OtherNonoperatingIncomeExpense`	$-54.90M	USD	3 Qtrs
Other expense - net	`OtherNonoperatingIncomeExpense`	$-31.10M	USD	1 Quarter
Other expense - net	`OtherNonoperatingIncomeExpense`	$-30.60M	USD	3 Qtrs
Income before income taxes	`IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments`	$2.02B	USD	3 Qtrs
Income before income taxes	`IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments`	$875.60M	USD	1 Quarter
Income before income taxes	`IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments`	$709.80M	USD	1 Quarter
Income before income taxes	`IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments`	$1.68B	USD	3 Qtrs
Income taxes	`IncomeTaxExpenseBenefit`	$391.90M	USD	3 Qtrs
Income taxes	`IncomeTaxExpenseBenefit`	$133.30M	USD	1 Quarter
Income taxes	`IncomeTaxExpenseBenefit`	$391.70M	USD	3 Qtrs
Income taxes	`IncomeTaxExpenseBenefit`	$169.80M	USD	1 Quarter
Net income	`NetIncomeLoss`	$595.90M	USD	1 Quarter
Net income	`NetIncomeLoss`	$705.80M	USD	1 Quarter
Net income	`NetIncomeLoss`	$245.20M	USD	1 Quarter
Net income	`NetIncomeLoss`	$321.70M	USD	1 Quarter
Net income	`NetIncomeLoss`	$1.29B	USD	3 Qtrs
Net income	`NetIncomeLoss`	$576.50M	USD	1 Quarter
Net income	`NetIncomeLoss`	$471.00M	USD	1 Quarter
Net income	`NetIncomeLoss`	$1.62B	USD	3 Qtrs
Basic (in dollars per share)	`EarningsPerShareBasic`	$14.07	USD	3 Qtrs
Basic (in dollars per share)	`EarningsPerShareBasic`	$7.80	USD	1 Quarter
Basic (in dollars per share)	`EarningsPerShareBasic`	$6.28	USD	1 Quarter
Basic (in dollars per share)	`EarningsPerShareBasic`	$17.90	USD	3 Qtrs
Diluted (in dollars per share)	`EarningsPerShareDiluted`	$13.82	USD	3 Qtrs
Diluted (in dollars per share)	`EarningsPerShareDiluted`	$6.16	USD	1 Quarter
Diluted (in dollars per share)	`EarningsPerShareDiluted`	$17.60	USD	3 Qtrs
Diluted (in dollars per share)	`EarningsPerShareDiluted`	$7.66	USD	1 Quarter
Basic (in shares)	`WeightedAverageNumberOfSharesOutstandingBasic`	90.54M	shares	1 Quarter
Basic (in shares)	`WeightedAverageNumberOfSharesOutstandingBasic`	90.69M	shares	3 Qtrs
Basic (in shares)	`WeightedAverageNumberOfSharesOutstandingBasic`	91.85M	shares	3 Qtrs
Basic (in shares)	`WeightedAverageNumberOfSharesOutstandingBasic`	91.82M	shares	1 Quarter
Diluted (in shares)	`WeightedAverageNumberOfDilutedSharesOutstanding`	92.26M	shares	3 Qtrs
Diluted (in shares)	`WeightedAverageNumberOfDilutedSharesOutstanding`	92.11M	shares	1 Quarter
Diluted (in shares)	`WeightedAverageNumberOfDilutedSharesOutstanding`	93.51M	shares	3 Qtrs
Diluted (in shares)	`WeightedAverageNumberOfDilutedSharesOutstanding`	93.60M	shares	1 Quarter

Cash Flow Statement 89 line items

Line Item	Tag	Value	Unit	Period
Net income	`NetIncomeLoss`	$595.90M	USD	1 Quarter
Net income	`NetIncomeLoss`	$705.80M	USD	1 Quarter
Net income	`NetIncomeLoss`	$245.20M	USD	1 Quarter
Net income	`NetIncomeLoss`	$321.70M	USD	1 Quarter
Net income	`NetIncomeLoss`	$1.29B	USD	3 Qtrs
Net income	`NetIncomeLoss`	$576.50M	USD	1 Quarter
Net income	`NetIncomeLoss`	$471.00M	USD	1 Quarter
Net income	`NetIncomeLoss`	$1.62B	USD	3 Qtrs
Depreciation	`Depreciation`	$195.00M	USD	3 Qtrs
Depreciation	`Depreciation`	$200.00M	USD	3 Qtrs
Non-cash lease expense	`OperatingLeasesNoncashExpense`	$275.70M	USD	3 Qtrs
Non-cash lease expense	`OperatingLeasesNoncashExpense`	$276.10M	USD	3 Qtrs
Amortization of intangible assets	`AmortizationOfIntangibleAssets`	$77.50M	USD	1 Quarter
Amortization of intangible assets	`AmortizationOfIntangibleAssets`	$234.20M	USD	3 Qtrs
Amortization of intangible assets	`AmortizationOfIntangibleAssets`	$78.70M	USD	1 Quarter
Amortization of intangible assets	`AmortizationOfIntangibleAssets`	$234.40M	USD	3 Qtrs
Loss on extinguishment of debt	`GainsLossesOnExtinguishmentOfDebt`	$-21.30M	USD	3 Qtrs
Loss on extinguishment of debt	`GainsLossesOnExtinguishmentOfDebt`	$-14.80M	USD	1 Quarter
Loss on extinguishment of debt	`GainsLossesOnExtinguishmentOfDebt`	$-14.80M	USD	3 Qtrs
Amortization of credit facility and debt issuance costs	`AmortizationOfFinancingCosts`	$5.50M	USD	3 Qtrs
Amortization of credit facility and debt issuance costs	`AmortizationOfFinancingCosts`	$7.30M	USD	3 Qtrs
Stock-based compensation expense	`ShareBasedCompensation`	$72.90M	USD	3 Qtrs
Stock-based compensation expense	`ShareBasedCompensation`	$70.90M	USD	3 Qtrs
Provisions for environmental-related matters	`EnvironmentalRemediationExpense`	$20.80M	USD	3 Qtrs
Provisions for environmental-related matters	`EnvironmentalRemediationExpense`	$10.10M	USD	1 Quarter
Provisions for environmental-related matters	`EnvironmentalRemediationExpense`	$10.60M	USD	1 Quarter
Provisions for environmental-related matters	`EnvironmentalRemediationExpense`	$17.90M	USD	3 Qtrs
Defined benefit pension plans net cost	`PensionExpense`	$5.80M	USD	3 Qtrs
Defined benefit pension plans net cost	`PensionExpense`	$40.40M	USD	3 Qtrs
Deferred income taxes	`DeferredIncomeTaxExpenseBenefit`	$-43.40M	USD	3 Qtrs
Deferred income taxes	`DeferredIncomeTaxExpenseBenefit`	$2.10M	USD	3 Qtrs
Other	`OtherNoncashIncomeExpense`	$16.90M	USD	3 Qtrs
Other	`OtherNoncashIncomeExpense`	$4.00M	USD	3 Qtrs
Change in working capital accounts - net	`IncreaseDecreaseInOperatingCapital`	$259.60M	USD	3 Qtrs
Change in working capital accounts - net	`IncreaseDecreaseInOperatingCapital`	$-312.20M	USD	3 Qtrs
Change in operating lease liabilities	`IncreaseDecreaseInOperatingLeaseLiabilities`	$-270.60M	USD	3 Qtrs
Change in operating lease liabilities	`IncreaseDecreaseInOperatingLeaseLiabilities`	$-272.30M	USD	3 Qtrs
Costs incurred for environmental-related matters	`PaymentsForEnvironmentalLiabilities`	$20.00M	USD	3 Qtrs
Costs incurred for environmental-related matters	`PaymentsForEnvironmentalLiabilities`	$24.20M	USD	3 Qtrs
Other	`OtherOperatingActivitiesCashFlowStatement`	$88.30M	USD	3 Qtrs
Other	`OtherOperatingActivitiesCashFlowStatement`	$124.50M	USD	3 Qtrs
Net operating cash	`NetCashProvidedByUsedInOperatingActivities`	$1.66B	USD	3 Qtrs
Net operating cash	`NetCashProvidedByUsedInOperatingActivities`	$2.56B	USD	3 Qtrs
Capital expenditures	`PaymentsToAcquireProductiveAssets`	$224.80M	USD	3 Qtrs
Capital expenditures	`PaymentsToAcquireProductiveAssets`	$193.80M	USD	3 Qtrs
Acquisitions of businesses, net of cash acquired	`PaymentsToAcquireBusinessesNetOfCashAcquired`	-	USD	3 Qtrs
Acquisitions of businesses, net of cash acquired	`PaymentsToAcquireBusinessesNetOfCashAcquired`	$72.60M	USD	3 Qtrs
Proceeds from sale of assets	`ProceedsFromSaleOfProductiveAssets`	$38.80M	USD	3 Qtrs
Proceeds from sale of assets	`ProceedsFromSaleOfProductiveAssets`	$6.90M	USD	3 Qtrs
(Increase) decrease in other investments	`PaymentsForProceedsFromOtherInvestingActivities`	$-2.00M	USD	3 Qtrs
(Increase) decrease in other investments	`PaymentsForProceedsFromOtherInvestingActivities`	$21.60M	USD	3 Qtrs
Net investing cash	`NetCashProvidedByUsedInInvestingActivities`	$-288.50M	USD	3 Qtrs
Net investing cash	`NetCashProvidedByUsedInInvestingActivities`	$-176.60M	USD	3 Qtrs
Net (decrease) increase in short-term borrowings	`RepaymentsOfShortTermDebt`	$204.50M	USD	3 Qtrs
Net (decrease) increase in short-term borrowings	`ProceedsFromShortTermDebt`	$109.00M	USD	3 Qtrs
Proceeds from long-term debt	`ProceedsFromIssuanceOfLongTermDebt`	$1.33B	USD	3 Qtrs
Proceeds from long-term debt	`ProceedsFromIssuanceOfLongTermDebt`	$999.00M	USD	3 Qtrs
Payments of long-term debt	`RepaymentsOfLongTermDebt`	$1.88B	USD	3 Qtrs
Payments of long-term debt	`RepaymentsOfLongTermDebt`	$1.20B	USD	3 Qtrs
Payments for credit facility and debt issuance costs	`PaymentsOfDebtIssuanceCosts`	$13.00M	USD	3 Qtrs
Payments for credit facility and debt issuance costs	`PaymentsOfDebtIssuanceCosts`	$10.00M	USD	3 Qtrs
Payments of cash dividends	`PaymentsOfDividends`	$314.90M	USD	3 Qtrs
Payments of cash dividends	`PaymentsOfDividends`	$367.80M	USD	3 Qtrs
Proceeds from stock options exercised	`ProceedsFromStockOptionsExercised`	$135.70M	USD	3 Qtrs
Proceeds from stock options exercised	`ProceedsFromStockOptionsExercised`	$111.20M	USD	3 Qtrs
Treasury stock purchased	`PaymentsForRepurchaseOfEquity`	$577.80M	USD	3 Qtrs
Treasury stock purchased	`PaymentsForRepurchaseOfEquity`	$1.29B	USD	3 Qtrs
Proceeds from treasury stock issued	`ProceedsFromSaleOfTreasuryStock`	-	USD	3 Qtrs
Proceeds from treasury stock issued	`ProceedsFromSaleOfTreasuryStock`	$57.40M	USD	3 Qtrs
Other	`ProceedsFromPaymentsForOtherFinancingActivities`	$-26.60M	USD	3 Qtrs
Other	`ProceedsFromPaymentsForOtherFinancingActivities`	$-113.30M	USD	3 Qtrs
Net financing cash	`NetCashProvidedByUsedInFinancingActivities`	$-1.92B	USD	3 Qtrs
Net financing cash	`NetCashProvidedByUsedInFinancingActivities`	$-1.34B	USD	3 Qtrs
Effect of exchange rate changes on cash	`EffectOfExchangeRateOnCashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	$2.90M	USD	3 Qtrs
Effect of exchange rate changes on cash	`EffectOfExchangeRateOnCashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	$-12.90M	USD	3 Qtrs
Net increase in cash and cash equivalents	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalentsPeriodIncreaseDecreaseIncludingExchangeRateEffect`	$458.10M	USD	3 Qtrs
Net increase in cash and cash equivalents	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalentsPeriodIncreaseDecreaseIncludingExchangeRateEffect`	$34.10M	USD	3 Qtrs
Cash and cash equivalents at beginning of year	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	$155.50M	USD	Point-in-time
Cash and cash equivalents at beginning of year	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	$619.90M	USD	Point-in-time
Cash and cash equivalents at beginning of year	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	$161.80M	USD	Point-in-time
Cash and cash equivalents at beginning of year	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	$189.60M	USD	Point-in-time
Cash and cash equivalents at end of period	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	$155.50M	USD	Point-in-time
Cash and cash equivalents at end of period	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	$619.90M	USD	Point-in-time
Cash and cash equivalents at end of period	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	$161.80M	USD	Point-in-time
Cash and cash equivalents at end of period	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	$189.60M	USD	Point-in-time
Income taxes paid	`IncomeTaxesPaid`	$300.90M	USD	3 Qtrs
Income taxes paid	`IncomeTaxesPaid`	$310.10M	USD	3 Qtrs
Interest paid	`InterestPaidNet`	$243.00M	USD	3 Qtrs
Interest paid	`InterestPaidNet`	$246.80M	USD	3 Qtrs

Stockholders Equity 65 line items

Line Item	Tag	Value	Unit	Period
Cash dividends (in dollars per share)	`CommonStockDividendsPerShareCashPaid`	$1.13	USD	1 Quarter
Cash dividends (in dollars per share)	`CommonStockDividendsPerShareCashPaid`	$1.34	USD	3 Qtrs
Cash dividends (in dollars per share)	`CommonStockDividendsPerShareCashPaid`	$1.13	USD	1 Quarter
Cash dividends (in dollars per share)	`CommonStockDividendsPerShareCashPaid`	$1.13	USD	3 Qtrs
Cash dividends (in dollars per share)	`CommonStockDividendsPerShareCashPaid`	$1.13	USD	1 Quarter
Cash dividends (in dollars per share)	`CommonStockDividendsPerShareCashPaid`	$1.34	USD	1 Quarter
Cash dividends (in dollars per share)	`CommonStockDividendsPerShareCashPaid`	$1.34	USD	1 Quarter
Cash dividends (in dollars per share)	`CommonStockDividendsPerShareCashPaid`	$1.34	USD	1 Quarter
Beginning balance	`StockholdersEquity`	$4.02B	USD	Point-in-time
Beginning balance	`StockholdersEquity`	$3.73B	USD	Point-in-time
Beginning balance	`StockholdersEquity`	$4.12B	USD	Point-in-time
Beginning balance	`StockholdersEquity`	$3.29B	USD	Point-in-time
Beginning balance	`StockholdersEquity`	$3.75B	USD	Point-in-time
Beginning balance	`StockholdersEquity`	$3.46B	USD	Point-in-time
Beginning balance	`StockholdersEquity`	$3.87B	USD	Point-in-time
Beginning balance	`StockholdersEquity`	$4.21B	USD	Point-in-time
Net income	`NetIncomeLoss`	$595.90M	USD	1 Quarter
Net income	`NetIncomeLoss`	$705.80M	USD	1 Quarter
Net income	`NetIncomeLoss`	$245.20M	USD	1 Quarter
Net income	`NetIncomeLoss`	$321.70M	USD	1 Quarter
Net income	`NetIncomeLoss`	$1.29B	USD	3 Qtrs
Net income	`NetIncomeLoss`	$576.50M	USD	1 Quarter
Net income	`NetIncomeLoss`	$471.00M	USD	1 Quarter
Net income	`NetIncomeLoss`	$1.62B	USD	3 Qtrs
Other comprehensive income (loss)	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$74.90M	USD	1 Quarter
Other comprehensive income (loss)	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$-136.30M	USD	1 Quarter
Other comprehensive income (loss)	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$6.00M	USD	1 Quarter
Other comprehensive income (loss)	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$1.40M	USD	1 Quarter
Other comprehensive income (loss)	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$33.90M	USD	1 Quarter
Other comprehensive income (loss)	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$-221.60M	USD	1 Quarter
Other comprehensive income (loss)	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$-112.80M	USD	3 Qtrs
Other comprehensive income (loss)	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$-128.90M	USD	3 Qtrs
Treasury stock purchased	`TreasuryStockValueAcquiredParValueMethod`	$305.10M	USD	1 Quarter
Treasury stock purchased	`TreasuryStockValueAcquiredParValueMethod`	$127.30M	USD	1 Quarter
Treasury stock purchased	`TreasuryStockValueAcquiredParValueMethod`	$404.40M	USD	1 Quarter
Treasury stock purchased	`TreasuryStockValueAcquiredParValueMethod`	$890.30M	USD	1 Quarter
Treasury stock purchased	`TreasuryStockValueAcquiredParValueMethod`	$145.40M	USD	1 Quarter
Treasury stock issued	`StockIssuedDuringPeriodValueTreasuryStockReissued`	$57.40M	USD	Point-in-time
Treasury stock issued	`StockIssuedDuringPeriodValueTreasuryStockReissued`	$57.40M	USD	1 Quarter
Treasury stock transferred to qualified replacement plan	`TreasuryStockValueTransferredFromDefinedBenefitPlan`	$131.80M	USD	1 Quarter
Stock-based compensation activity	`StockIssuedDuringPeriodValueShareBasedCompensation`	$26.60M	USD	1 Quarter
Stock-based compensation activity	`StockIssuedDuringPeriodValueShareBasedCompensation`	$67.60M	USD	1 Quarter
Stock-based compensation activity	`StockIssuedDuringPeriodValueShareBasedCompensation`	$65.20M	USD	1 Quarter
Stock-based compensation activity	`StockIssuedDuringPeriodValueShareBasedCompensation`	$24.20M	USD	1 Quarter
Stock-based compensation activity	`StockIssuedDuringPeriodValueShareBasedCompensation`	$83.70M	USD	1 Quarter
Stock-based compensation activity	`StockIssuedDuringPeriodValueShareBasedCompensation`	$73.30M	USD	1 Quarter
Other adjustments	`StockholdersEquityOther`	$-200.00K	USD	1 Quarter
Other adjustments	`StockholdersEquityOther`	$400.00K	USD	1 Quarter
Other adjustments	`StockholdersEquityOther`	$-400.00K	USD	1 Quarter
Other adjustments	`StockholdersEquityOther`	$-1.70M	USD	1 Quarter
Other adjustments	`StockholdersEquityOther`	$-300.00K	USD	1 Quarter
Cash dividends	`DividendsCash`	$104.80M	USD	1 Quarter
Cash dividends	`DividendsCash`	$105.00M	USD	1 Quarter
Cash dividends	`DividendsCash`	$105.10M	USD	1 Quarter
Cash dividends	`DividendsCash`	$122.70M	USD	1 Quarter
Cash dividends	`DividendsCash`	$122.90M	USD	1 Quarter
Cash dividends	`DividendsCash`	$122.20M	USD	1 Quarter
Ending balance	`StockholdersEquity`	$4.02B	USD	Point-in-time
Ending balance	`StockholdersEquity`	$3.73B	USD	Point-in-time
Ending balance	`StockholdersEquity`	$4.12B	USD	Point-in-time
Ending balance	`StockholdersEquity`	$3.29B	USD	Point-in-time
Ending balance	`StockholdersEquity`	$3.75B	USD	Point-in-time
Ending balance	`StockholdersEquity`	$3.46B	USD	Point-in-time
Ending balance	`StockholdersEquity`	$3.87B	USD	Point-in-time
Ending balance	`StockholdersEquity`	$4.21B	USD	Point-in-time

Comprehensive Income 52 line items

Line Item	Tag	Value	Unit	Period
Net income	`NetIncomeLoss`	$595.90M	USD	1 Quarter
Net income	`NetIncomeLoss`	$705.80M	USD	1 Quarter
Net income	`NetIncomeLoss`	$245.20M	USD	1 Quarter
Net income	`NetIncomeLoss`	$321.70M	USD	1 Quarter
Net income	`NetIncomeLoss`	$1.29B	USD	3 Qtrs
Net income	`NetIncomeLoss`	$576.50M	USD	1 Quarter
Net income	`NetIncomeLoss`	$471.00M	USD	1 Quarter
Net income	`NetIncomeLoss`	$1.62B	USD	3 Qtrs
Foreign currency translation adjustments	`OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax`	$-120.60M	USD	3 Qtrs
Foreign currency translation adjustments	`OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax`	$-131.90M	USD	1 Quarter
Foreign currency translation adjustments	`OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax`	$-109.10M	USD	3 Qtrs
Foreign currency translation adjustments	`OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax`	$75.20M	USD	1 Quarter
Amounts reclassified from other comprehensive income (loss)	`OtherComprehensiveIncomeLossReclassificationAdjustmentFromAOCIPensionAndOtherPostretirementBenefitPlansNetOfTax`	$1.90M	USD	3 Qtrs
Amounts reclassified from other comprehensive income (loss)	`OtherComprehensiveIncomeLossReclassificationAdjustmentFromAOCIPensionAndOtherPostretirementBenefitPlansNetOfTax`	$-400.00K	USD	1 Quarter
Amounts reclassified from other comprehensive income (loss)	`OtherComprehensiveIncomeLossReclassificationAdjustmentFromAOCIPensionAndOtherPostretirementBenefitPlansNetOfTax`	$-1.10M	USD	3 Qtrs
Amounts reclassified from other comprehensive income (loss)	`OtherComprehensiveIncomeLossReclassificationAdjustmentFromAOCIPensionAndOtherPostretirementBenefitPlansNetOfTax`	$600.00K	USD	1 Quarter
Total pension and other postretirement benefit adjustments	`OtherComprehensiveIncomeDefinedBenefitPlansAdjustmentNetOfTaxPortionAttributableToParent`	$-600.00K	USD	1 Quarter
Foreign currency translation adjustments	`OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax`	$-120.60M	USD	3 Qtrs
Foreign currency translation adjustments	`OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax`	$-131.90M	USD	1 Quarter
Foreign currency translation adjustments	`OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax`	$-109.10M	USD	3 Qtrs
Total pension and other postretirement benefit adjustments	`OtherComprehensiveIncomeDefinedBenefitPlansAdjustmentNetOfTaxPortionAttributableToParent`	$-1.90M	USD	3 Qtrs
Foreign currency translation adjustments	`OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax`	$75.20M	USD	1 Quarter
Total pension and other postretirement benefit adjustments	`OtherComprehensiveIncomeDefinedBenefitPlansAdjustmentNetOfTaxPortionAttributableToParent`	$400.00K	USD	1 Quarter
Total pension and other postretirement benefit adjustments	`OtherComprehensiveIncomeDefinedBenefitPlansAdjustmentNetOfTaxPortionAttributableToParent`	$1.10M	USD	3 Qtrs
Pension and other postretirement benefit adjustments, amounts reclassified from other comprehensive income, tax	`OtherComprehensiveIncomeLossReclassificationAdjustmentFromAOCIPensionAndOtherPostretirementBenefitPlansTax`	$-500.00K	USD	3 Qtrs
Amounts reclassified from other comprehensive income (loss)	`OtherComprehensiveIncomeLossCashFlowHedgeGainLossReclassificationAfterTax`	$900.00K	USD	1 Quarter
Amounts reclassified from other comprehensive income (loss)	`OtherComprehensiveIncomeLossCashFlowHedgeGainLossReclassificationAfterTax`	$4.00M	USD	1 Quarter
Amounts reclassified from other comprehensive income (loss)	`OtherComprehensiveIncomeLossCashFlowHedgeGainLossReclassificationAfterTax`	$5.60M	USD	3 Qtrs
Pension and other postretirement benefit adjustments, amounts reclassified from other comprehensive income, tax	`OtherComprehensiveIncomeLossReclassificationAdjustmentFromAOCIPensionAndOtherPostretirementBenefitPlansTax`	$200.00K	USD	1 Quarter
Pension and other postretirement benefit adjustments, amounts reclassified from other comprehensive income, tax	`OtherComprehensiveIncomeLossReclassificationAdjustmentFromAOCIPensionAndOtherPostretirementBenefitPlansTax`	$-200.00K	USD	1 Quarter
Amounts reclassified from other comprehensive income (loss)	`OtherComprehensiveIncomeLossCashFlowHedgeGainLossReclassificationAfterTax`	$7.20M	USD	3 Qtrs
Pension and other postretirement benefit adjustments, amounts reclassified from other comprehensive income, tax	`OtherComprehensiveIncomeLossReclassificationAdjustmentFromAOCIPensionAndOtherPostretirementBenefitPlansTax`	$500.00K	USD	3 Qtrs
Unrealized net gains on cash flow hedges, amounts reclassified from other comprehensive income, tax	`OtherComprehensiveIncomeLossCashFlowHedgeGainLossReclassificationTax`	$1.80M	USD	3 Qtrs
Unrealized net gains on cash flow hedges, amounts reclassified from other comprehensive income, tax	`OtherComprehensiveIncomeLossCashFlowHedgeGainLossReclassificationTax`	$2.60M	USD	3 Qtrs
Total unrealized net gains on cash flow hedges	`OtherComprehensiveIncomeLossCashFlowHedgeGainLossAfterReclassificationAndTax`	$-4.00M	USD	1 Quarter
Unrealized net gains on cash flow hedges, amounts reclassified from other comprehensive income, tax	`OtherComprehensiveIncomeLossCashFlowHedgeGainLossReclassificationTax`	$1.70M	USD	1 Quarter
Total unrealized net gains on cash flow hedges	`OtherComprehensiveIncomeLossCashFlowHedgeGainLossAfterReclassificationAndTax`	$-7.20M	USD	3 Qtrs
Total unrealized net gains on cash flow hedges	`OtherComprehensiveIncomeLossCashFlowHedgeGainLossAfterReclassificationAndTax`	$-900.00K	USD	1 Quarter
Unrealized net gains on cash flow hedges, amounts reclassified from other comprehensive income, tax	`OtherComprehensiveIncomeLossCashFlowHedgeGainLossReclassificationTax`	$400.00K	USD	1 Quarter
Total unrealized net gains on cash flow hedges	`OtherComprehensiveIncomeLossCashFlowHedgeGainLossAfterReclassificationAndTax`	$-5.60M	USD	3 Qtrs
Other comprehensive income (loss)	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$74.90M	USD	1 Quarter
Other comprehensive income (loss)	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$-136.30M	USD	1 Quarter
Other comprehensive income (loss)	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$6.00M	USD	1 Quarter
Other comprehensive income (loss)	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$1.40M	USD	1 Quarter
Other comprehensive income (loss)	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$33.90M	USD	1 Quarter
Other comprehensive income (loss)	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$-221.60M	USD	1 Quarter
Other comprehensive income (loss)	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$-112.80M	USD	3 Qtrs
Other comprehensive income (loss)	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$-128.90M	USD	3 Qtrs
Comprehensive income	`ComprehensiveIncomeNetOfTax`	$1.16B	USD	3 Qtrs
Comprehensive income	`ComprehensiveIncomeNetOfTax`	$440.20M	USD	1 Quarter
Comprehensive income	`ComprehensiveIncomeNetOfTax`	$1.51B	USD	3 Qtrs
Comprehensive income	`ComprehensiveIncomeNetOfTax`	$780.70M	USD	1 Quarter

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