10-Q Filing

SHERWIN WILLIAMS CO CIK: 89800 Q2 2022

Filing Information

Form Type	10-Q
Accession Number	`0000089800-22-000029`
Period End Date	20220630
Filing Date	20220727
Fiscal Year	2022
Fiscal Period	Q2
XBRL Instance	shw-20220630_htm.xml

Filing Contents

This filing contains the following financial statements:

Balance Sheet 102 Income Statement 74 Cash Flow Statement 92 Stockholders Equity 48 Comprehensive Income 40

Balance Sheet 102 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`	263.30M	shares	Point-in-time
Common stock, shares outstanding (in shares)	`CommonStockSharesOutstanding`	259.20M	shares	Point-in-time
Common stock, shares outstanding (in shares)	`CommonStockSharesOutstanding`	261.10M	shares	Point-in-time
Cash and cash equivalents	`CashAndCashEquivalentsAtCarryingValue`	$165.70M	USD	Point-in-time
Cash and cash equivalents	`CashAndCashEquivalentsAtCarryingValue`	$312.60M	USD	Point-in-time
Cash and cash equivalents	`CashAndCashEquivalentsAtCarryingValue`	$219.60M	USD	Point-in-time
Accounts receivable, net	`AccountsReceivableNetCurrent`	$2.98B	USD	Point-in-time
Accounts receivable, net	`AccountsReceivableNetCurrent`	$2.35B	USD	Point-in-time
Accounts receivable, net	`AccountsReceivableNetCurrent`	$2.59B	USD	Point-in-time
Inventories	`InventoryNet`	$1.93B	USD	Point-in-time
Inventories	`InventoryNet`	$2.41B	USD	Point-in-time
Inventories	`InventoryNet`	$1.80B	USD	Point-in-time
Other current assets	`OtherAssetsCurrent`	$571.40M	USD	Point-in-time
Other current assets	`OtherAssetsCurrent`	$552.80M	USD	Point-in-time
Other current assets	`OtherAssetsCurrent`	$608.40M	USD	Point-in-time
Total current assets	`AssetsCurrent`	$5.19B	USD	Point-in-time
Total current assets	`AssetsCurrent`	$6.26B	USD	Point-in-time
Total current assets	`AssetsCurrent`	$5.05B	USD	Point-in-time
Property, plant and equipment, net	`PropertyPlantAndEquipmentNet`	$1.81B	USD	Point-in-time
Property, plant and equipment, net	`PropertyPlantAndEquipmentNet`	$1.87B	USD	Point-in-time
Property, plant and equipment, net	`PropertyPlantAndEquipmentNet`	$1.96B	USD	Point-in-time
Goodwill	`Goodwill`	$7.13B	USD	Point-in-time
Goodwill	`Goodwill`	$7.11B	USD	Point-in-time
Goodwill	`Goodwill`	$7.02B	USD	Point-in-time
Intangible assets	`IntangibleAssetsNetExcludingGoodwill`	$3.96B	USD	Point-in-time
Intangible assets	`IntangibleAssetsNetExcludingGoodwill`	$4.00B	USD	Point-in-time
Intangible assets	`IntangibleAssetsNetExcludingGoodwill`	$4.17B	USD	Point-in-time
Operating lease right-of-use assets	`OperatingLeaseRightOfUseAsset`	$1.84B	USD	Point-in-time
Operating lease right-of-use assets	`OperatingLeaseRightOfUseAsset`	$1.76B	USD	Point-in-time
Operating lease right-of-use assets	`OperatingLeaseRightOfUseAsset`	$1.82B	USD	Point-in-time
Other assets	`OtherAssetsNoncurrent`	$580.10M	USD	Point-in-time
Other assets	`OtherAssetsNoncurrent`	$927.80M	USD	Point-in-time
Other assets	`OtherAssetsNoncurrent`	$789.00M	USD	Point-in-time
Total assets	`Assets`	$22.05B	USD	Point-in-time
Total assets	`Assets`	$20.67B	USD	Point-in-time
Total assets	`Assets`	$20.52B	USD	Point-in-time
Short-term borrowings	`ShortTermBorrowings`	$763.50M	USD	Point-in-time
Short-term borrowings	`ShortTermBorrowings`	$762.10M	USD	Point-in-time
Short-term borrowings	`ShortTermBorrowings`	$2.01B	USD	Point-in-time
Accounts payable	`AccountsPayableCurrent`	$2.40B	USD	Point-in-time
Accounts payable	`AccountsPayableCurrent`	$2.50B	USD	Point-in-time
Accounts payable	`AccountsPayableCurrent`	$2.99B	USD	Point-in-time
Compensation and taxes withheld	`EmployeeRelatedLiabilitiesCurrent`	$587.60M	USD	Point-in-time
Compensation and taxes withheld	`EmployeeRelatedLiabilitiesCurrent`	$593.10M	USD	Point-in-time
Compensation and taxes withheld	`EmployeeRelatedLiabilitiesCurrent`	$716.60M	USD	Point-in-time
Accrued taxes	`TaxesPayableCurrent`	$185.60M	USD	Point-in-time
Accrued taxes	`TaxesPayableCurrent`	$160.30M	USD	Point-in-time
Accrued taxes	`TaxesPayableCurrent`	$228.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`	$687.10M	USD	Point-in-time
Current portion of long-term debt	`LongTermDebtCurrent`	$260.60M	USD	Point-in-time
Current portion of operating lease liabilities	`OperatingLeaseLiabilityCurrent`	$418.10M	USD	Point-in-time
Current portion of operating lease liabilities	`OperatingLeaseLiabilityCurrent`	$409.70M	USD	Point-in-time
Current portion of operating lease liabilities	`OperatingLeaseLiabilityCurrent`	$393.00M	USD	Point-in-time
Other accruals	`OtherLiabilitiesCurrent`	$1.01B	USD	Point-in-time
Other accruals	`OtherLiabilitiesCurrent`	$1.00B	USD	Point-in-time
Other accruals	`OtherLiabilitiesCurrent`	$1.02B	USD	Point-in-time
Total current liabilities	`LiabilitiesCurrent`	$7.20B	USD	Point-in-time
Total current liabilities	`LiabilitiesCurrent`	$6.19B	USD	Point-in-time
Total current liabilities	`LiabilitiesCurrent`	$5.72B	USD	Point-in-time
Long-term debt	`LongTermDebtNoncurrent`	$7.60B	USD	Point-in-time
Long-term debt	`LongTermDebtNoncurrent`	$8.59B	USD	Point-in-time
Long-term debt	`LongTermDebtNoncurrent`	$8.59B	USD	Point-in-time
Postretirement benefits other than pensions	`OtherPostretirementDefinedBenefitPlanLiabilitiesNoncurrent`	$257.50M	USD	Point-in-time
Postretirement benefits other than pensions	`OtherPostretirementDefinedBenefitPlanLiabilitiesNoncurrent`	$259.40M	USD	Point-in-time
Postretirement benefits other than pensions	`OtherPostretirementDefinedBenefitPlanLiabilitiesNoncurrent`	$273.10M	USD	Point-in-time
Deferred income taxes	`DeferredIncomeTaxLiabilitiesNet`	$768.20M	USD	Point-in-time
Deferred income taxes	`DeferredIncomeTaxLiabilitiesNet`	$803.40M	USD	Point-in-time
Deferred income taxes	`DeferredIncomeTaxLiabilitiesNet`	$754.00M	USD	Point-in-time
Long-term operating lease liabilities	`OperatingLeaseLiabilityNoncurrent`	$1.47B	USD	Point-in-time
Long-term operating lease liabilities	`OperatingLeaseLiabilityNoncurrent`	$1.43B	USD	Point-in-time
Long-term operating lease liabilities	`OperatingLeaseLiabilityNoncurrent`	$1.48B	USD	Point-in-time
Other long-term liabilities	`OtherLiabilitiesNoncurrent`	$1.42B	USD	Point-in-time
Other long-term liabilities	`OtherLiabilitiesNoncurrent`	$1.38B	USD	Point-in-time
Other long-term liabilities	`OtherLiabilitiesNoncurrent`	$1.54B	USD	Point-in-time
Common stock	`CommonStockValue`	$91.00M	USD	Point-in-time
Common stock	`CommonStockValue`	$90.80M	USD	Point-in-time
Common stock	`CommonStockValue`	$90.60M	USD	Point-in-time
Other capital	`AdditionalPaidInCapital`	$3.79B	USD	Point-in-time
Other capital	`AdditionalPaidInCapital`	$3.61B	USD	Point-in-time
Other capital	`AdditionalPaidInCapital`	$3.88B	USD	Point-in-time
Retained earnings	`RetainedEarningsAccumulatedDeficit`	$2.12B	USD	Point-in-time
Retained earnings	`RetainedEarningsAccumulatedDeficit`	$1.60B	USD	Point-in-time
Retained earnings	`RetainedEarningsAccumulatedDeficit`	$2.76B	USD	Point-in-time
Treasury stock, at cost	`TreasuryStockValue`	$3.60B	USD	Point-in-time
Treasury stock, at cost	`TreasuryStockValue`	$2.87B	USD	Point-in-time
Treasury stock, at cost	`TreasuryStockValue`	$1.76B	USD	Point-in-time
Accumulated other comprehensive loss	`AccumulatedOtherComprehensiveIncomeLossNetOfTax`	$-698.40M	USD	Point-in-time
Accumulated other comprehensive loss	`AccumulatedOtherComprehensiveIncomeLossNetOfTax`	$-701.20M	USD	Point-in-time
Accumulated other comprehensive loss	`AccumulatedOtherComprehensiveIncomeLossNetOfTax`	$-914.60M	USD	Point-in-time
Total shareholders' equity	`StockholdersEquity`	$3.08B	USD	Point-in-time
Total shareholders' equity	`StockholdersEquity`	$3.61B	USD	Point-in-time
Total shareholders' equity	`StockholdersEquity`	$2.22B	USD	Point-in-time
Total shareholders' equity	`StockholdersEquity`	$2.84B	USD	Point-in-time
Total shareholders' equity	`StockholdersEquity`	$2.44B	USD	Point-in-time
Total shareholders' equity	`StockholdersEquity`	$2.23B	USD	Point-in-time
Total liabilities and shareholders equity	`LiabilitiesAndStockholdersEquity`	$20.52B	USD	Point-in-time
Total liabilities and shareholders equity	`LiabilitiesAndStockholdersEquity`	$20.67B	USD	Point-in-time
Total liabilities and shareholders equity	`LiabilitiesAndStockholdersEquity`	$22.05B	USD	Point-in-time

Income Statement 74 line items

Line Item	Tag	Value	Unit	Period
Net sales	`RevenueFromContractWithCustomerExcludingAssessedTax`	$10.04B	USD	2 Qtrs
Net sales	`RevenueFromContractWithCustomerExcludingAssessedTax`	$5.87B	USD	1 Quarter
Net sales	`RevenueFromContractWithCustomerExcludingAssessedTax`	$5.38B	USD	1 Quarter
Net sales	`RevenueFromContractWithCustomerExcludingAssessedTax`	$10.87B	USD	2 Qtrs
Cost of goods sold	`CostOfGoodsAndServicesSold`	$6.37B	USD	2 Qtrs
Cost of goods sold	`CostOfGoodsAndServicesSold`	$5.51B	USD	2 Qtrs
Cost of goods sold	`CostOfGoodsAndServicesSold`	$2.97B	USD	1 Quarter
Cost of goods sold	`CostOfGoodsAndServicesSold`	$3.42B	USD	1 Quarter
Gross profit	`GrossProfit`	$4.50B	USD	2 Qtrs
Gross profit	`GrossProfit`	$4.52B	USD	2 Qtrs
Gross profit	`GrossProfit`	$2.41B	USD	1 Quarter
Gross profit	`GrossProfit`	$2.45B	USD	1 Quarter
Percent to net sales	`GrossProfitPercentage`	0.42	pure	1 Quarter
Percent to net sales	`GrossProfitPercentage`	0.45	pure	1 Quarter
Percent to net sales	`GrossProfitPercentage`	0.45	pure	2 Qtrs
Percent to net sales	`GrossProfitPercentage`	0.41	pure	2 Qtrs
Selling, general and administrative expenses	`SellingGeneralAndAdministrativeExpense`	$1.52B	USD	1 Quarter
Selling, general and administrative expenses	`SellingGeneralAndAdministrativeExpense`	$1.44B	USD	1 Quarter
Selling, general and administrative expenses	`SellingGeneralAndAdministrativeExpense`	$2.76B	USD	2 Qtrs
Selling, general and administrative expenses	`SellingGeneralAndAdministrativeExpense`	$2.93B	USD	2 Qtrs
Percent to net sales	`SellingGeneralAdministrativeExpenseAsPercentNetSales`	0.27	pure	1 Quarter
Percent to net sales	`SellingGeneralAdministrativeExpenseAsPercentNetSales`	0.26	pure	1 Quarter
Percent to net sales	`SellingGeneralAdministrativeExpenseAsPercentNetSales`	0.27	pure	2 Qtrs
Percent to net sales	`SellingGeneralAdministrativeExpenseAsPercentNetSales`	0.28	pure	2 Qtrs
Other general expense (income) - net	`OtherOperatingIncomeExpenseNet`	$-6.90M	USD	2 Qtrs
Other general expense (income) - net	`OtherOperatingIncomeExpenseNet`	$-112.30M	USD	2 Qtrs
Other general expense (income) - net	`OtherOperatingIncomeExpenseNet`	$5.20M	USD	1 Quarter
Other general expense (income) - net	`OtherOperatingIncomeExpenseNet`	$-4.40M	USD	1 Quarter
Amortization	`AmortizationOfIntangibleAssets`	$78.50M	USD	1 Quarter
Amortization	`AmortizationOfIntangibleAssets`	$157.00M	USD	2 Qtrs
Amortization	`AmortizationOfIntangibleAssets`	$156.50M	USD	2 Qtrs
Amortization	`AmortizationOfIntangibleAssets`	$77.80M	USD	1 Quarter
Interest expense	`InterestExpense`	$166.70M	USD	2 Qtrs
Interest expense	`InterestExpense`	$83.50M	USD	1 Quarter
Interest expense	`InterestExpense`	$181.30M	USD	2 Qtrs
Interest expense	`InterestExpense`	$92.90M	USD	1 Quarter
Interest income	`InvestmentIncomeNet`	$1.20M	USD	2 Qtrs
Interest income	`InvestmentIncomeNet`	$1.30M	USD	1 Quarter
Interest income	`InvestmentIncomeNet`	$600.00K	USD	1 Quarter
Interest income	`InvestmentIncomeNet`	$2.20M	USD	2 Qtrs
Other expense (income) - net	`OtherNonoperatingIncomeExpense`	$-31.80M	USD	2 Qtrs
Other expense (income) - net	`OtherNonoperatingIncomeExpense`	$-15.50M	USD	1 Quarter
Other expense (income) - net	`OtherNonoperatingIncomeExpense`	$1.10M	USD	1 Quarter
Other expense (income) - net	`OtherNonoperatingIncomeExpense`	$3.30M	USD	2 Qtrs
Income before income taxes	`IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest`	$1.20B	USD	2 Qtrs
Income before income taxes	`IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest`	$739.90M	USD	1 Quarter
Income before income taxes	`IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest`	$819.20M	USD	1 Quarter
Income before income taxes	`IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest`	$1.33B	USD	2 Qtrs
Income taxes	`IncomeTaxExpenseBenefit`	$162.00M	USD	1 Quarter
Income taxes	`IncomeTaxExpenseBenefit`	$252.30M	USD	2 Qtrs
Income taxes	`IncomeTaxExpenseBenefit`	$270.00M	USD	2 Qtrs
Income taxes	`IncomeTaxExpenseBenefit`	$170.60M	USD	1 Quarter
Net income	`NetIncomeLoss`	$948.70M	USD	2 Qtrs
Net income	`NetIncomeLoss`	$1.06B	USD	2 Qtrs
Net income	`NetIncomeLoss`	$370.80M	USD	1 Quarter
Net income	`NetIncomeLoss`	$577.90M	USD	1 Quarter
Net income	`NetIncomeLoss`	$648.60M	USD	1 Quarter
Net income	`NetIncomeLoss`	$409.60M	USD	1 Quarter
Basic (in dollars per share)	`EarningsPerShareBasic`	$2.24	USD	1 Quarter
Basic (in dollars per share)	`EarningsPerShareBasic`	$2.47	USD	1 Quarter
Basic (in dollars per share)	`EarningsPerShareBasic`	$4.00	USD	2 Qtrs
Basic (in dollars per share)	`EarningsPerShareBasic`	$3.67	USD	2 Qtrs
Diluted (in dollars per share)	`EarningsPerShareDiluted`	$3.93	USD	2 Qtrs
Diluted (in dollars per share)	`EarningsPerShareDiluted`	$2.42	USD	1 Quarter
Diluted (in dollars per share)	`EarningsPerShareDiluted`	$3.61	USD	2 Qtrs
Diluted (in dollars per share)	`EarningsPerShareDiluted`	$2.21	USD	1 Quarter
Basic (in shares)	`WeightedAverageNumberOfSharesOutstandingBasic`	258.10M	shares	1 Quarter
Basic (in shares)	`WeightedAverageNumberOfSharesOutstandingBasic`	258.50M	shares	2 Qtrs
Basic (in shares)	`WeightedAverageNumberOfSharesOutstandingBasic`	264.30M	shares	2 Qtrs
Basic (in shares)	`WeightedAverageNumberOfSharesOutstandingBasic`	262.80M	shares	1 Quarter
Diluted (in shares)	`WeightedAverageNumberOfDilutedSharesOutstanding`	267.80M	shares	1 Quarter
Diluted (in shares)	`WeightedAverageNumberOfDilutedSharesOutstanding`	261.80M	shares	1 Quarter
Diluted (in shares)	`WeightedAverageNumberOfDilutedSharesOutstanding`	269.00M	shares	2 Qtrs
Diluted (in shares)	`WeightedAverageNumberOfDilutedSharesOutstanding`	262.50M	shares	2 Qtrs

Cash Flow Statement 92 line items

Line Item	Tag	Value	Unit	Period
Net income	`NetIncomeLoss`	$948.70M	USD	2 Qtrs
Net income	`NetIncomeLoss`	$1.06B	USD	2 Qtrs
Net income	`NetIncomeLoss`	$370.80M	USD	1 Quarter
Net income	`NetIncomeLoss`	$577.90M	USD	1 Quarter
Net income	`NetIncomeLoss`	$648.60M	USD	1 Quarter
Net income	`NetIncomeLoss`	$409.60M	USD	1 Quarter
Depreciation	`Depreciation`	$136.40M	USD	2 Qtrs
Depreciation	`Depreciation`	$130.30M	USD	2 Qtrs
Non-cash lease expense	`OperatingLeasesNoncashExpense`	$208.40M	USD	2 Qtrs
Non-cash lease expense	`OperatingLeasesNoncashExpense`	$194.50M	USD	2 Qtrs
Amortization of intangible assets	`AmortizationOfIntangibleAssets`	$78.50M	USD	1 Quarter
Amortization of intangible assets	`AmortizationOfIntangibleAssets`	$157.00M	USD	2 Qtrs
Amortization of intangible assets	`AmortizationOfIntangibleAssets`	$156.50M	USD	2 Qtrs
Amortization of intangible assets	`AmortizationOfIntangibleAssets`	$77.80M	USD	1 Quarter
Loss on divestiture of business	`GainLossOnSaleOfBusiness`	-	USD	2 Qtrs
Loss on divestiture of business	`GainLossOnSaleOfBusiness`	-	USD	1 Quarter
Loss on divestiture of business	`GainLossOnSaleOfBusiness`	-	USD	1 Quarter
Loss on divestiture of business	`GainLossOnSaleOfBusiness`	$-111.90M	USD	2 Qtrs
Amortization of credit facility and debt issuance costs	`AmortizationOfFinancingCosts`	$3.30M	USD	2 Qtrs
Amortization of credit facility and debt issuance costs	`AmortizationOfFinancingCosts`	$3.20M	USD	2 Qtrs
Stock-based compensation expense	`ShareBasedCompensation`	$53.70M	USD	2 Qtrs
Stock-based compensation expense	`ShareBasedCompensation`	$39.00M	USD	2 Qtrs
Provisions for environmental-related matters	`EnvironmentalRemediationExpense`	$4.70M	USD	2 Qtrs
Provisions for environmental-related matters	`EnvironmentalRemediationExpense`	$2.50M	USD	1 Quarter
Provisions for environmental-related matters	`EnvironmentalRemediationExpense`	$4.10M	USD	1 Quarter
Provisions for environmental-related matters	`EnvironmentalRemediationExpense`	$5.00M	USD	2 Qtrs
Defined benefit pension plans net cost	`PensionExpense`	$3.90M	USD	2 Qtrs
Defined benefit pension plans net cost	`PensionExpense`	$2.80M	USD	2 Qtrs
Deferred income taxes	`DeferredIncomeTaxExpenseBenefit`	$-24.20M	USD	2 Qtrs
Deferred income taxes	`DeferredIncomeTaxExpenseBenefit`	$-19.20M	USD	2 Qtrs
Other	`OtherNoncashIncomeExpense`	$-26.40M	USD	2 Qtrs
Other	`OtherNoncashIncomeExpense`	$-32.80M	USD	2 Qtrs
Change in working capital accounts - net	`IncreaseDecreaseInOperatingCapital`	$338.10M	USD	2 Qtrs
Change in working capital accounts - net	`IncreaseDecreaseInOperatingCapital`	$668.10M	USD	2 Qtrs
Change in operating lease liabilities	`IncreaseDecreaseInOperatingLeaseLiabilities`	$-196.70M	USD	2 Qtrs
Change in operating lease liabilities	`IncreaseDecreaseInOperatingLeaseLiabilities`	$-209.40M	USD	2 Qtrs
Costs incurred for environmental-related matters	`PaymentsForEnvironmentalLiabilities`	$12.00M	USD	2 Qtrs
Costs incurred for environmental-related matters	`PaymentsForEnvironmentalLiabilities`	$21.30M	USD	2 Qtrs
Other	`OtherOperatingActivitiesCashFlowStatement`	$41.10M	USD	2 Qtrs
Other	`OtherOperatingActivitiesCashFlowStatement`	$12.20M	USD	2 Qtrs
Net operating cash	`NetCashProvidedByUsedInOperatingActivities`	$1.20B	USD	2 Qtrs
Net operating cash	`NetCashProvidedByUsedInOperatingActivities`	$639.70M	USD	2 Qtrs
Capital expenditures	`PaymentsToAcquireProductiveAssets`	$151.40M	USD	2 Qtrs
Capital expenditures	`PaymentsToAcquireProductiveAssets`	$235.80M	USD	2 Qtrs
Acquisitions of businesses, net of cash acquired	`PaymentsToAcquireBusinessesNetOfCashAcquired`	$25.30M	USD	2 Qtrs
Acquisitions of businesses, net of cash acquired	`PaymentsToAcquireBusinessesNetOfCashAcquired`	$211.80M	USD	2 Qtrs
Proceeds from divestiture of business	`ProceedsFromDivestitureOfBusinesses`	-	USD	2 Qtrs
Proceeds from divestiture of business	`ProceedsFromDivestitureOfBusinesses`	$116.20M	USD	2 Qtrs
Proceeds from sale of assets	`ProceedsFromSaleOfProductiveAssets`	$13.10M	USD	2 Qtrs
Proceeds from sale of assets	`ProceedsFromSaleOfProductiveAssets`	$14.90M	USD	2 Qtrs
Other	`PaymentsForProceedsFromOtherInvestingActivities`	$41.20M	USD	2 Qtrs
Other	`PaymentsForProceedsFromOtherInvestingActivities`	$25.10M	USD	2 Qtrs
Net investing cash	`NetCashProvidedByUsedInInvestingActivities`	$-473.90M	USD	2 Qtrs
Net investing cash	`NetCashProvidedByUsedInInvestingActivities`	$-72.50M	USD	2 Qtrs
Net increase in short-term borrowings	`ProceedsFromShortTermDebt`	$1.25B	USD	2 Qtrs
Net increase in short-term borrowings	`ProceedsFromShortTermDebt`	$761.90M	USD	2 Qtrs
Payments of long-term debt	`RepaymentsOfLongTermDebt`	-	USD	2 Qtrs
Payments of long-term debt	`RepaymentsOfLongTermDebt`	$260.20M	USD	2 Qtrs
Payments for credit facility and debt issuance costs	`PaymentsOfDebtIssuanceCosts`	$1.70M	USD	2 Qtrs
Payments for credit facility and debt issuance costs	`PaymentsOfDebtIssuanceCosts`	-	USD	2 Qtrs
Payments of cash dividends	`PaymentsOfDividends`	$297.70M	USD	2 Qtrs
Payments of cash dividends	`PaymentsOfDividends`	$307.10M	USD	2 Qtrs
Proceeds from stock options exercised	`ProceedsFromStockOptionsExercised`	$26.30M	USD	2 Qtrs
Proceeds from stock options exercised	`ProceedsFromStockOptionsExercised`	$68.20M	USD	2 Qtrs
Treasury stock purchased	`PaymentsForRepurchaseOfEquity`	$703.50M	USD	2 Qtrs
Treasury stock purchased	`PaymentsForRepurchaseOfEquity`	$1.65B	USD	2 Qtrs
Treasury stock purchased	`PaymentsForRepurchaseOfEquity`	$870.10M	USD	1 Quarter
Treasury stock purchased	`PaymentsForRepurchaseOfEquity`	$296.40M	USD	1 Quarter
Proceeds from treasury stock issued	`ProceedsFromSaleOfTreasuryStock`	$22.00M	USD	2 Qtrs
Proceeds from treasury stock issued	`ProceedsFromSaleOfTreasuryStock`	$11.70M	USD	2 Qtrs
Proceeds from treasury stock issued	`ProceedsFromSaleOfTreasuryStock`	$22.00M	USD	Point-in-time
Proceeds from treasury stock issued	`ProceedsFromSaleOfTreasuryStock`	$11.70M	USD	Point-in-time
Other	`ProceedsFromPaymentsForOtherFinancingActivities`	$-34.00M	USD	2 Qtrs
Other	`ProceedsFromPaymentsForOtherFinancingActivities`	$-22.20M	USD	2 Qtrs
Net financing cash	`NetCashProvidedByUsedInFinancingActivities`	$-1.13B	USD	2 Qtrs
Net financing cash	`NetCashProvidedByUsedInFinancingActivities`	$-8.00M	USD	2 Qtrs
Effect of exchange rate changes on cash	`EffectOfExchangeRateOnCashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	$-10.50M	USD	2 Qtrs
Effect of exchange rate changes on cash	`EffectOfExchangeRateOnCashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	$-10.90M	USD	2 Qtrs
Net increase (decrease) in cash and cash equivalents	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalentsPeriodIncreaseDecreaseIncludingExchangeRateEffect`	$146.90M	USD	2 Qtrs
Net increase (decrease) in cash and cash equivalents	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalentsPeriodIncreaseDecreaseIncludingExchangeRateEffect`	$-7.00M	USD	2 Qtrs
Cash and cash equivalents at beginning of year	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	$312.60M	USD	Point-in-time
Cash and cash equivalents at beginning of year	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	$226.60M	USD	Point-in-time
Cash and cash equivalents at beginning of year	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	$165.70M	USD	Point-in-time
Cash and cash equivalents at beginning of year	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	$219.60M	USD	Point-in-time
Cash and cash equivalents at end of period	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	$312.60M	USD	Point-in-time
Cash and cash equivalents at end of period	`CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents`	$226.60M	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`	$219.60M	USD	Point-in-time
Income taxes paid	`IncomeTaxesPaid`	$219.50M	USD	2 Qtrs
Income taxes paid	`IncomeTaxesPaid`	$177.20M	USD	2 Qtrs
Interest paid	`InterestPaidNet`	$166.60M	USD	2 Qtrs
Interest paid	`InterestPaidNet`	$177.90M	USD	2 Qtrs

Stockholders Equity 48 line items

Line Item	Tag	Value	Unit	Period
Cash dividends (in dollars per share)	`CommonStockDividendsPerShareCashPaid`	$1.10	USD	2 Qtrs
Cash dividends (in dollars per share)	`CommonStockDividendsPerShareCashPaid`	$1.20	USD	2 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.55	USD	1 Quarter
Cash dividends (in dollars per share)	`CommonStockDividendsPerShareCashPaid`	$0.55	USD	1 Quarter
Beginning balance	`StockholdersEquity`	$3.08B	USD	Point-in-time
Beginning balance	`StockholdersEquity`	$3.61B	USD	Point-in-time
Beginning balance	`StockholdersEquity`	$2.22B	USD	Point-in-time
Beginning balance	`StockholdersEquity`	$2.84B	USD	Point-in-time
Beginning balance	`StockholdersEquity`	$2.44B	USD	Point-in-time
Beginning balance	`StockholdersEquity`	$2.23B	USD	Point-in-time
Net income	`NetIncomeLoss`	$948.70M	USD	2 Qtrs
Net income	`NetIncomeLoss`	$1.06B	USD	2 Qtrs
Net income	`NetIncomeLoss`	$370.80M	USD	1 Quarter
Net income	`NetIncomeLoss`	$577.90M	USD	1 Quarter
Net income	`NetIncomeLoss`	$648.60M	USD	1 Quarter
Net income	`NetIncomeLoss`	$409.60M	USD	1 Quarter
Other comprehensive loss	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$-172.60M	USD	1 Quarter
Other comprehensive loss	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$-45.50M	USD	1 Quarter
Other comprehensive loss	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$62.60M	USD	1 Quarter
Other comprehensive loss	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$17.10M	USD	2 Qtrs
Other comprehensive loss	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$-216.20M	USD	2 Qtrs
Other comprehensive loss	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$-43.60M	USD	1 Quarter
Treasury stock purchased	`TreasuryStockValueAcquiredParValueMethod`	$775.40M	USD	1 Quarter
Treasury stock purchased	`TreasuryStockValueAcquiredParValueMethod`	$296.40M	USD	1 Quarter
Treasury stock purchased	`TreasuryStockValueAcquiredParValueMethod`	$870.10M	USD	1 Quarter
Treasury stock purchased	`TreasuryStockValueAcquiredParValueMethod`	$407.10M	USD	1 Quarter
Treasury stock issued	`StockIssuedDuringPeriodValueTreasuryStockReissued`	$11.70M	USD	1 Quarter
Treasury stock issued	`StockIssuedDuringPeriodValueTreasuryStockReissued`	$22.00M	USD	1 Quarter
Stock-based compensation activity	`StockholdersEquityValueStockBasedCompensationActivity`	$5.60M	USD	1 Quarter
Stock-based compensation activity	`StockholdersEquityValueStockBasedCompensationActivity`	$41.50M	USD	1 Quarter
Stock-based compensation activity	`StockholdersEquityValueStockBasedCompensationActivity`	$30.30M	USD	1 Quarter
Stock-based compensation activity	`StockholdersEquityValueStockBasedCompensationActivity`	$54.20M	USD	1 Quarter
Other adjustments	`StockholdersEquityOther`	$-600.00K	USD	1 Quarter
Other adjustments	`StockholdersEquityOther`	$-300.00K	USD	1 Quarter
Other adjustments	`StockholdersEquityOther`	$-700.00K	USD	1 Quarter
Other adjustments	`StockholdersEquityOther`	$3.90M	USD	1 Quarter
Cash dividends	`DividendsCash`	$156.20M	USD	1 Quarter
Cash dividends	`DividendsCash`	$150.90M	USD	1 Quarter
Cash dividends	`DividendsCash`	$151.80M	USD	1 Quarter
Cash dividends	`DividendsCash`	$145.90M	USD	1 Quarter
Ending balance	`StockholdersEquity`	$3.08B	USD	Point-in-time
Ending balance	`StockholdersEquity`	$3.61B	USD	Point-in-time
Ending balance	`StockholdersEquity`	$2.22B	USD	Point-in-time
Ending balance	`StockholdersEquity`	$2.84B	USD	Point-in-time
Ending balance	`StockholdersEquity`	$2.44B	USD	Point-in-time
Ending balance	`StockholdersEquity`	$2.23B	USD	Point-in-time

Comprehensive Income 40 line items

Line Item	Tag	Value	Unit	Period
Net income	`NetIncomeLoss`	$948.70M	USD	2 Qtrs
Net income	`NetIncomeLoss`	$1.06B	USD	2 Qtrs
Net income	`NetIncomeLoss`	$370.80M	USD	1 Quarter
Net income	`NetIncomeLoss`	$577.90M	USD	1 Quarter
Net income	`NetIncomeLoss`	$648.60M	USD	1 Quarter
Net income	`NetIncomeLoss`	$409.60M	USD	1 Quarter
Foreign currency translation adjustments	`OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax`	$16.30M	USD	2 Qtrs
Foreign currency translation adjustments	`OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax`	$62.60M	USD	1 Quarter
Foreign currency translation adjustments	`OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax`	$-216.70M	USD	2 Qtrs
Foreign currency translation adjustments	`OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax`	$-173.10M	USD	1 Quarter
Amounts reclassified from AOCI	`OtherComprehensiveIncomeLossReclassificationAdjustmentFromAOCIPensionAndOtherPostretirementBenefitPlansNetOfTax`	$2.50M	USD	2 Qtrs
Amounts reclassified from AOCI	`OtherComprehensiveIncomeLossReclassificationAdjustmentFromAOCIPensionAndOtherPostretirementBenefitPlansNetOfTax`	$1.50M	USD	1 Quarter
Amounts reclassified from AOCI	`OtherComprehensiveIncomeLossReclassificationAdjustmentFromAOCIPensionAndOtherPostretirementBenefitPlansNetOfTax`	$1.40M	USD	1 Quarter
Amounts reclassified from AOCI	`OtherComprehensiveIncomeLossReclassificationAdjustmentFromAOCIPensionAndOtherPostretirementBenefitPlansNetOfTax`	$3.20M	USD	2 Qtrs
Foreign currency translation adjustments	`OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax`	$16.30M	USD	2 Qtrs
Foreign currency translation adjustments	`OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax`	$62.60M	USD	1 Quarter
Foreign currency translation adjustments	`OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax`	$-216.70M	USD	2 Qtrs
Foreign currency translation adjustments	`OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax`	$-173.10M	USD	1 Quarter
Pension and other postretirement benefit adjustments, amounts reclassified from other comprehensive income, tax	`OtherComprehensiveIncomeLossReclassificationAdjustmentFromAOCIPensionAndOtherPostretirementBenefitPlansTax`	$300.00K	USD	1 Quarter
Amounts reclassified from AOCI	`OtherComprehensiveIncomeLossCashFlowHedgeGainLossReclassificationAfterTax`	$1.40M	USD	1 Quarter
Pension and other postretirement benefit adjustments, amounts reclassified from other comprehensive income, tax	`OtherComprehensiveIncomeLossReclassificationAdjustmentFromAOCIPensionAndOtherPostretirementBenefitPlansTax`	$800.00K	USD	2 Qtrs
Amounts reclassified from AOCI	`OtherComprehensiveIncomeLossCashFlowHedgeGainLossReclassificationAfterTax`	$1.00M	USD	1 Quarter
Amounts reclassified from AOCI	`OtherComprehensiveIncomeLossCashFlowHedgeGainLossReclassificationAfterTax`	$2.00M	USD	2 Qtrs
Pension and other postretirement benefit adjustments, amounts reclassified from other comprehensive income, tax	`OtherComprehensiveIncomeLossReclassificationAdjustmentFromAOCIPensionAndOtherPostretirementBenefitPlansTax`	$1.10M	USD	2 Qtrs
Amounts reclassified from AOCI	`OtherComprehensiveIncomeLossCashFlowHedgeGainLossReclassificationAfterTax`	$2.40M	USD	2 Qtrs
Pension and other postretirement benefit adjustments, amounts reclassified from other comprehensive income, tax	`OtherComprehensiveIncomeLossReclassificationAdjustmentFromAOCIPensionAndOtherPostretirementBenefitPlansTax`	$600.00K	USD	1 Quarter
Other comprehensive (loss) income	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$-172.60M	USD	1 Quarter
Unrealized net gains on cash flow hedges, amounts reclassified from other comprehensive income, tax	`OtherComprehensiveIncomeLossCashFlowHedgeGainLossReclassificationTax`	$100.00K	USD	1 Quarter
Other comprehensive (loss) income	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$-45.50M	USD	1 Quarter
Other comprehensive (loss) income	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$62.60M	USD	1 Quarter
Other comprehensive (loss) income	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$17.10M	USD	2 Qtrs
Other comprehensive (loss) income	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$-216.20M	USD	2 Qtrs
Unrealized net gains on cash flow hedges, amounts reclassified from other comprehensive income, tax	`OtherComprehensiveIncomeLossCashFlowHedgeGainLossReclassificationTax`	$400.00K	USD	1 Quarter
Unrealized net gains on cash flow hedges, amounts reclassified from other comprehensive income, tax	`OtherComprehensiveIncomeLossCashFlowHedgeGainLossReclassificationTax`	$700.00K	USD	2 Qtrs
Unrealized net gains on cash flow hedges, amounts reclassified from other comprehensive income, tax	`OtherComprehensiveIncomeLossCashFlowHedgeGainLossReclassificationTax`	$400.00K	USD	2 Qtrs
Other comprehensive (loss) income	`OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent`	$-43.60M	USD	1 Quarter
Comprehensive income	`ComprehensiveIncomeNetOfTax`	$405.30M	USD	1 Quarter
Comprehensive income	`ComprehensiveIncomeNetOfTax`	$732.50M	USD	2 Qtrs
Comprehensive income	`ComprehensiveIncomeNetOfTax`	$711.20M	USD	1 Quarter
Comprehensive income	`ComprehensiveIncomeNetOfTax`	$1.08B	USD	2 Qtrs

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