10-Q Filing

SHERWIN WILLIAMS CO CIK: 89800 Q1 2017

Filing Information

Form Type	10-Q
Accession Number	`0000089800-17-000009`
Period End Date	20170331
Filing Date	20170421
Fiscal Year	2017
Fiscal Period	Q1
XBRL Instance	shw-20170331.xml

Filing Contents

This filing contains the following financial statements:

Balance Sheet 118 Income Statement 36 Cash Flow Statement 68

Balance Sheet 118 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`	93.13M	shares	Point-in-time
Common stock, shares outstanding (in shares)	`CommonStockSharesOutstanding`	93.01M	shares	Point-in-time
Common stock, shares outstanding (in shares)	`CommonStockSharesOutstanding`	92.50M	shares	Point-in-time
Cash and cash equivalents	`CashAndCashEquivalentsAtCarryingValue`	$70.55M	USD	Point-in-time
Cash and cash equivalents	`CashAndCashEquivalentsAtCarryingValue`	$205.74M	USD	Point-in-time
Cash and cash equivalents	`CashAndCashEquivalentsAtCarryingValue`	$889.79M	USD	Point-in-time
Cash and cash equivalents	`CashAndCashEquivalentsAtCarryingValue`	$1.02B	USD	Point-in-time
Accounts receivable, less allowance	`AccountsReceivableNetCurrent`	$1.36B	USD	Point-in-time
Accounts receivable, less allowance	`AccountsReceivableNetCurrent`	$1.29B	USD	Point-in-time
Accounts receivable, less allowance	`AccountsReceivableNetCurrent`	$1.23B	USD	Point-in-time
Finished goods	`InventoryFinishedGoodsNetOfReserves`	$972.04M	USD	Point-in-time
Finished goods	`InventoryFinishedGoodsNetOfReserves`	$898.63M	USD	Point-in-time
Finished goods	`InventoryFinishedGoodsNetOfReserves`	$1.07B	USD	Point-in-time
Work in process and raw materials	`InventoryWorkInProcessAndRawMaterialsNetOfReserves`	$178.01M	USD	Point-in-time
Work in process and raw materials	`InventoryWorkInProcessAndRawMaterialsNetOfReserves`	$169.70M	USD	Point-in-time
Work in process and raw materials	`InventoryWorkInProcessAndRawMaterialsNetOfReserves`	$175.32M	USD	Point-in-time
Total net inventory	`InventoryNet`	$1.25B	USD	Point-in-time
Total net inventory	`InventoryNet`	$1.07B	USD	Point-in-time
Total net inventory	`InventoryNet`	$1.15B	USD	Point-in-time
Deferred income taxes	`DeferredIncomeTaxAssetsNet`	$97.56M	USD	Point-in-time
Deferred income taxes	`DeferredIncomeTaxAssetsNet`	-	USD	Point-in-time
Deferred income taxes	`DeferredIncomeTaxAssetsNet`	$57.16M	USD	Point-in-time
Other current assets	`OtherAssetsCurrent`	$282.40M	USD	Point-in-time
Other current assets	`OtherAssetsCurrent`	$381.03M	USD	Point-in-time
Other current assets	`OtherAssetsCurrent`	$254.32M	USD	Point-in-time
Total current assets	`AssetsCurrent`	$3.88B	USD	Point-in-time
Total current assets	`AssetsCurrent`	$3.63B	USD	Point-in-time
Total current assets	`AssetsCurrent`	$2.89B	USD	Point-in-time
Goodwill	`Goodwill`	$1.13B	USD	Point-in-time
Goodwill	`Goodwill`	$1.15B	USD	Point-in-time
Goodwill	`Goodwill`	$1.13B	USD	Point-in-time
Intangible assets	`IntangibleAssetsNetExcludingGoodwill`	$250.57M	USD	Point-in-time
Intangible assets	`IntangibleAssetsNetExcludingGoodwill`	$252.93M	USD	Point-in-time
Intangible assets	`IntangibleAssetsNetExcludingGoodwill`	$255.01M	USD	Point-in-time
Deferred pension assets	`DefinedBenefitPlanAssetsForPlanBenefitsNoncurrent`	$246.03M	USD	Point-in-time
Deferred pension assets	`DefinedBenefitPlanAssetsForPlanBenefitsNoncurrent`	$224.21M	USD	Point-in-time
Deferred pension assets	`DefinedBenefitPlanAssetsForPlanBenefitsNoncurrent`	$225.53M	USD	Point-in-time
Other assets	`OtherAssetsNoncurrent`	$442.21M	USD	Point-in-time
Other assets	`OtherAssetsNoncurrent`	$449.00M	USD	Point-in-time
Other assets	`OtherAssetsNoncurrent`	$421.90M	USD	Point-in-time
Land	`Land`	$120.57M	USD	Point-in-time
Land	`Land`	$116.08M	USD	Point-in-time
Land	`Land`	$115.56M	USD	Point-in-time
Buildings	`BuildingsAndImprovementsGross`	$704.59M	USD	Point-in-time
Buildings	`BuildingsAndImprovementsGross`	$721.47M	USD	Point-in-time
Buildings	`BuildingsAndImprovementsGross`	$714.82M	USD	Point-in-time
Machinery and equipment	`MachineryAndEquipmentGross`	$2.15B	USD	Point-in-time
Machinery and equipment	`MachineryAndEquipmentGross`	$2.07B	USD	Point-in-time
Machinery and equipment	`MachineryAndEquipmentGross`	$2.21B	USD	Point-in-time
Construction in progress	`ConstructionInProgressGross`	$70.89M	USD	Point-in-time
Construction in progress	`ConstructionInProgressGross`	$117.13M	USD	Point-in-time
Construction in progress	`ConstructionInProgressGross`	$89.84M	USD	Point-in-time
Total gross property, plant and equipment	`PropertyPlantAndEquipmentGross`	$2.99B	USD	Point-in-time
Total gross property, plant and equipment	`PropertyPlantAndEquipmentGross`	$3.10B	USD	Point-in-time
Total gross property, plant and equipment	`PropertyPlantAndEquipmentGross`	$3.11B	USD	Point-in-time
Less allowances for depreciation	`AccumulatedDepreciationDepletionAndAmortizationPropertyPlantAndEquipment`	$2.05B	USD	Point-in-time
Less allowances for depreciation	`AccumulatedDepreciationDepletionAndAmortizationPropertyPlantAndEquipment`	$2.01B	USD	Point-in-time
Less allowances for depreciation	`AccumulatedDepreciationDepletionAndAmortizationPropertyPlantAndEquipment`	$1.93B	USD	Point-in-time
Total net property, plant and equipment	`PropertyPlantAndEquipmentNet`	$1.06B	USD	Point-in-time
Total net property, plant and equipment	`PropertyPlantAndEquipmentNet`	$1.10B	USD	Point-in-time
Total net property, plant and equipment	`PropertyPlantAndEquipmentNet`	$1.06B	USD	Point-in-time
Total Assets	`Assets`	$6.99B	USD	Point-in-time
Total Assets	`Assets`	$6.04B	USD	Point-in-time
Total Assets	`Assets`	$6.75B	USD	Point-in-time
Short-term borrowings	`ShortTermBorrowings`	$40.74M	USD	Point-in-time
Short-term borrowings	`ShortTermBorrowings`	$41.91M	USD	Point-in-time
Short-term borrowings	`ShortTermBorrowings`	$128.68M	USD	Point-in-time
Accounts payable	`AccountsPayableCurrent`	$1.03B	USD	Point-in-time
Accounts payable	`AccountsPayableCurrent`	$1.22B	USD	Point-in-time
Accounts payable	`AccountsPayableCurrent`	$1.15B	USD	Point-in-time
Compensation and taxes withheld	`EmployeeRelatedLiabilitiesCurrent`	$296.18M	USD	Point-in-time
Compensation and taxes withheld	`EmployeeRelatedLiabilitiesCurrent`	$284.86M	USD	Point-in-time
Compensation and taxes withheld	`EmployeeRelatedLiabilitiesCurrent`	$398.05M	USD	Point-in-time
Accrued taxes	`TaxesPayableCurrent`	$115.40M	USD	Point-in-time
Accrued taxes	`TaxesPayableCurrent`	$158.59M	USD	Point-in-time
Accrued taxes	`TaxesPayableCurrent`	$76.77M	USD	Point-in-time
Current portion of long-term debt	`LongTermDebtCurrent`	$700.48M	USD	Point-in-time
Current portion of long-term debt	`LongTermDebtCurrent`	$2.18M	USD	Point-in-time
Current portion of long-term debt	`LongTermDebtCurrent`	$700.79M	USD	Point-in-time
Other accruals	`OtherLiabilitiesCurrent`	$519.77M	USD	Point-in-time
Other accruals	`OtherLiabilitiesCurrent`	$578.55M	USD	Point-in-time
Other accruals	`OtherLiabilitiesCurrent`	$578.52M	USD	Point-in-time
Total current liabilities	`LiabilitiesCurrent`	$2.94B	USD	Point-in-time
Total current liabilities	`LiabilitiesCurrent`	$2.83B	USD	Point-in-time
Total current liabilities	`LiabilitiesCurrent`	$2.26B	USD	Point-in-time
Long-term debt	`LongTermDebtNoncurrent`	$1.21B	USD	Point-in-time
Long-term debt	`LongTermDebtNoncurrent`	$1.21B	USD	Point-in-time
Long-term debt	`LongTermDebtNoncurrent`	$1.91B	USD	Point-in-time
Postretirement benefits other than pensions	`OtherPostretirementDefinedBenefitPlanLiabilitiesNoncurrent`	$250.17M	USD	Point-in-time
Postretirement benefits other than pensions	`OtherPostretirementDefinedBenefitPlanLiabilitiesNoncurrent`	$250.40M	USD	Point-in-time
Postretirement benefits other than pensions	`OtherPostretirementDefinedBenefitPlanLiabilitiesNoncurrent`	$252.03M	USD	Point-in-time
Other long-term liabilities	`OtherLiabilitiesNoncurrent`	$615.98M	USD	Point-in-time
Other long-term liabilities	`OtherLiabilitiesNoncurrent`	$583.18M	USD	Point-in-time
Other long-term liabilities	`OtherLiabilitiesNoncurrent`	$521.01M	USD	Point-in-time
Common stock	`CommonStockValue`	$116.56M	USD	Point-in-time
Common stock	`CommonStockValue`	$116.04M	USD	Point-in-time
Common stock	`CommonStockValue`	$116.78M	USD	Point-in-time
Other capital	`AdditionalPaidInCapital`	$2.37B	USD	Point-in-time
Other capital	`AdditionalPaidInCapital`	$2.55B	USD	Point-in-time
Other capital	`AdditionalPaidInCapital`	$2.49B	USD	Point-in-time
Retained earnings	`RetainedEarningsAccumulatedDeficit`	$4.21B	USD	Point-in-time
Retained earnings	`RetainedEarningsAccumulatedDeficit`	$3.32B	USD	Point-in-time
Retained earnings	`RetainedEarningsAccumulatedDeficit`	$4.05B	USD	Point-in-time
Treasury stock, at cost	`TreasuryStockValue`	$4.24B	USD	Point-in-time
Treasury stock, at cost	`TreasuryStockValue`	$4.24B	USD	Point-in-time
Treasury stock, at cost	`TreasuryStockValue`	$4.26B	USD	Point-in-time
Cumulative other comprehensive loss	`AccumulatedOtherComprehensiveIncomeLossNetOfTax`	$-540.35M	USD	Point-in-time
Cumulative other comprehensive loss	`AccumulatedOtherComprehensiveIncomeLossNetOfTax`	$-568.09M	USD	Point-in-time
Cumulative other comprehensive loss	`AccumulatedOtherComprehensiveIncomeLossNetOfTax`	$-549.41M	USD	Point-in-time
Total shareholders' equity	`StockholdersEquity`	$1.00B	USD	Point-in-time
Total shareholders' equity	`StockholdersEquity`	$2.07B	USD	Point-in-time
Total shareholders' equity	`StockholdersEquity`	$1.88B	USD	Point-in-time
Total Liabilities and Shareholders Equity	`LiabilitiesAndStockholdersEquity`	$6.04B	USD	Point-in-time
Total Liabilities and Shareholders Equity	`LiabilitiesAndStockholdersEquity`	$6.75B	USD	Point-in-time
Total Liabilities and Shareholders Equity	`LiabilitiesAndStockholdersEquity`	$6.99B	USD	Point-in-time

Income Statement 36 line items

Line Item	Tag	Value	Unit	Period
Net sales	`SalesRevenueNet`	$2.57B	USD	1 Quarter
Net sales	`SalesRevenueNet`	$2.76B	USD	1 Quarter
Cost of goods sold	`CostOfRevenue`	$1.31B	USD	1 Quarter
Cost of goods sold	`CostOfRevenue`	$1.42B	USD	1 Quarter
Gross profit	`GrossProfit`	$1.34B	USD	1 Quarter
Gross profit	`GrossProfit`	$1.26B	USD	1 Quarter
Percent to net sales	`GrossProfitPercentage`	0.49	pure	1 Quarter
Percent to net sales	`GrossProfitPercentage`	0.49	pure	1 Quarter
Selling, general and administrative expenses	`SellingGeneralAndAdministrativeExpense`	$1.00B	USD	1 Quarter
Selling, general and administrative expenses	`SellingGeneralAndAdministrativeExpense`	$1.02B	USD	1 Quarter
Percent to net sales	`SellingGeneralAdministrativeExpenseAsPercentNetSales`	0.37	pure	1 Quarter
Percent to net sales	`SellingGeneralAdministrativeExpenseAsPercentNetSales`	0.39	pure	1 Quarter
Other general expense - net	`OtherGeneralIncomeExpenseNet`	$-17.55M	USD	1 Quarter
Other general expense - net	`OtherGeneralIncomeExpenseNet`	$-276.00K	USD	1 Quarter
Interest expense	`InterestExpense`	$25.73M	USD	1 Quarter
Interest expense	`InterestExpense`	$25.70M	USD	1 Quarter
Interest and net investment income	`InvestmentIncomeNet`	$1.28M	USD	1 Quarter
Interest and net investment income	`InvestmentIncomeNet`	$487.00K	USD	1 Quarter
Other (income) expense - net	`NonoperatingIncomeExpense`	$-226.00K	USD	1 Quarter
Other (income) expense - net	`NonoperatingIncomeExpense`	$4.37M	USD	1 Quarter
Income before income taxes	`IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments`	$306.61M	USD	1 Quarter
Income before income taxes	`IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments`	$216.37M	USD	1 Quarter
Income taxes	`IncomeTaxExpenseBenefit`	$67.45M	USD	1 Quarter
Income taxes	`IncomeTaxExpenseBenefit`	$51.49M	USD	1 Quarter
Net income	`NetIncomeLoss`	$164.88M	USD	1 Quarter
Net income	`NetIncomeLoss`	$239.15M	USD	1 Quarter
Basic (in dollars per share)	`EarningsPerShareBasic`	$2.58	USD	1 Quarter
Basic (in dollars per share)	`EarningsPerShareBasic`	$1.80	USD	1 Quarter
Diluted (in dollars per share)	`EarningsPerShareDiluted`	$2.53	USD	1 Quarter
Diluted (in dollars per share)	`EarningsPerShareDiluted`	$1.75	USD	1 Quarter
Average shares outstanding - basic (in shares)	`WeightedAverageNumberOfSharesOutstandingBasic`	92.55M	shares	1 Quarter
Average shares outstanding - basic (in shares)	`WeightedAverageNumberOfSharesOutstandingBasic`	91.48M	shares	1 Quarter
Average shares and equivalents outstanding - diluted (in shares)	`WeightedAverageNumberOfDilutedSharesOutstanding`	94.54M	shares	1 Quarter
Average shares and equivalents outstanding - diluted (in shares)	`WeightedAverageNumberOfDilutedSharesOutstanding`	94.11M	shares	1 Quarter
Comprehensive income	`ComprehensiveIncomeNetOfTax`	$230.09M	USD	1 Quarter
Comprehensive income	`ComprehensiveIncomeNetOfTax`	$183.89M	USD	1 Quarter

Cash Flow Statement 68 line items

Line Item	Tag	Value	Unit	Period
Net income	`NetIncomeLoss`	$164.88M	USD	1 Quarter
Net income	`NetIncomeLoss`	$239.15M	USD	1 Quarter
Depreciation	`Depreciation`	$42.90M	USD	1 Quarter
Depreciation	`Depreciation`	$44.59M	USD	1 Quarter
Amortization of intangible assets	`AmortizationOfIntangibleAssets`	$5.78M	USD	1 Quarter
Amortization of intangible assets	`AmortizationOfIntangibleAssets`	$6.18M	USD	1 Quarter
Stock-based compensation expense	`ShareBasedCompensation`	$15.77M	USD	1 Quarter
Stock-based compensation expense	`ShareBasedCompensation`	$17.32M	USD	1 Quarter
Amortization of credit facility and debt issuance costs	`AmortizationOfFinancingCosts`	$6.66M	USD	1 Quarter
Amortization of credit facility and debt issuance costs	`AmortizationOfFinancingCosts`	$984.00K	USD	1 Quarter
Provisions for qualified exit costs	`RestructuringChargesAndRestructuringReserveAccrualAdjustment`	$2.86M	USD	1 Quarter
Provisions for qualified exit costs	`RestructuringChargesAndRestructuringReserveAccrualAdjustment`	$1.13M	USD	1 Quarter
Provisions for environmental-related matters	`EnvironmentalRemediationExpense`	$18.03M	USD	1 Quarter
Provisions for environmental-related matters	`EnvironmentalRemediationExpense`	$519.00K	USD	1 Quarter
Defined benefit pension plans net cost	`PensionExpense`	$5.16M	USD	1 Quarter
Defined benefit pension plans net cost	`PensionExpense`	$6.99M	USD	1 Quarter
Net increase in postretirement liability	`NetIncreaseDecreaseInPostretirementLiability`	$961.00K	USD	1 Quarter
Net increase in postretirement liability	`NetIncreaseDecreaseInPostretirementLiability`	$1.91M	USD	1 Quarter
Other	`OtherNoncashIncomeExpense`	$37.38M	USD	1 Quarter
Other	`OtherNoncashIncomeExpense`	$147.00K	USD	1 Quarter
Change in working capital accounts - net	`IncreaseDecreaseInOperatingCapital`	$58.40M	USD	1 Quarter
Change in working capital accounts - net	`IncreaseDecreaseInOperatingCapital`	$298.34M	USD	1 Quarter
Costs incurred for environmental-related matters	`PaymentsForEnvironmentalLiabilities`	$3.37M	USD	1 Quarter
Costs incurred for environmental-related matters	`PaymentsForEnvironmentalLiabilities`	$5.04M	USD	1 Quarter
Costs incurred for qualified exit costs	`PaymentsForRestructuring`	$2.87M	USD	1 Quarter
Costs incurred for qualified exit costs	`PaymentsForRestructuring`	$996.00K	USD	1 Quarter
Other	`OtherOperatingActivitiesCashFlowStatement`	$-18.75M	USD	1 Quarter
Other	`OtherOperatingActivitiesCashFlowStatement`	$13.29M	USD	1 Quarter
Net operating cash	`NetCashProvidedByUsedInOperatingActivities`	$231.82M	USD	1 Quarter
Net operating cash	`NetCashProvidedByUsedInOperatingActivities`	$-62.06M	USD	1 Quarter
Capital expenditures	`PaymentsToAcquireProductiveAssets`	$41.48M	USD	1 Quarter
Capital expenditures	`PaymentsToAcquireProductiveAssets`	$52.00M	USD	1 Quarter
Proceeds from sale of assets	`ProceedsFromSaleOfProductiveAssets`	$34.76M	USD	1 Quarter
Proceeds from sale of assets	`ProceedsFromSaleOfProductiveAssets`	$988.00K	USD	1 Quarter
Increase in other investments	`PaymentsForProceedsFromOtherInvestingActivities`	$23.19M	USD	1 Quarter
Increase in other investments	`PaymentsForProceedsFromOtherInvestingActivities`	$10.53M	USD	1 Quarter
Net investing cash	`NetCashProvidedByUsedInInvestingActivities`	$-29.91M	USD	1 Quarter
Net investing cash	`NetCashProvidedByUsedInInvestingActivities`	$-61.54M	USD	1 Quarter
Net increase in short-term borrowings	`ProceedsFromRepaymentsOfShortTermDebt`	$85.77M	USD	1 Quarter
Net increase in short-term borrowings	`ProceedsFromRepaymentsOfShortTermDebt`	$326.00K	USD	1 Quarter
Payments of long-term debt	`RepaymentsOfLongTermDebt`	-	USD	1 Quarter
Payments of long-term debt	`RepaymentsOfLongTermDebt`	$71.00K	USD	1 Quarter
Payments for credit facility and debt issuance costs	`PaymentsOfDebtIssuanceCosts`	$41.85M	USD	1 Quarter
Payments for credit facility and debt issuance costs	`PaymentsOfDebtIssuanceCosts`	$7.00K	USD	1 Quarter
Payments of cash dividends	`PaymentsOfDividends`	$77.73M	USD	1 Quarter
Payments of cash dividends	`PaymentsOfDividends`	$79.45M	USD	1 Quarter
Proceeds from stock options exercised	`ProceedsFromStockOptionsExercised`	$19.72M	USD	1 Quarter
Proceeds from stock options exercised	`ProceedsFromStockOptionsExercised`	$41.76M	USD	1 Quarter
Other	`ProceedsFromPaymentsForOtherFinancingActivities`	$-9.58M	USD	1 Quarter
Other	`ProceedsFromPaymentsForOtherFinancingActivities`	$-22.70M	USD	1 Quarter
Net financing cash	`NetCashProvidedByUsedInFinancingActivities`	$-60.14M	USD	1 Quarter
Net financing cash	`NetCashProvidedByUsedInFinancingActivities`	$-23.68M	USD	1 Quarter
Effect of exchange rate changes on cash	`EffectOfExchangeRateOnCashAndCashEquivalents`	$12.08M	USD	1 Quarter
Effect of exchange rate changes on cash	`EffectOfExchangeRateOnCashAndCashEquivalents`	$-13.75M	USD	1 Quarter
Net increase (decrease) in cash and cash equivalents	`CashAndCashEquivalentsPeriodIncreaseDecrease`	$-135.20M	USD	1 Quarter
Net increase (decrease) in cash and cash equivalents	`CashAndCashEquivalentsPeriodIncreaseDecrease`	$128.01M	USD	1 Quarter
Cash and cash equivalents at beginning of year	`CashAndCashEquivalentsAtCarryingValue`	$70.55M	USD	Point-in-time
Cash and cash equivalents at beginning of year	`CashAndCashEquivalentsAtCarryingValue`	$205.74M	USD	Point-in-time
Cash and cash equivalents at beginning of year	`CashAndCashEquivalentsAtCarryingValue`	$889.79M	USD	Point-in-time
Cash and cash equivalents at beginning of year	`CashAndCashEquivalentsAtCarryingValue`	$1.02B	USD	Point-in-time
Cash and cash equivalents at end of period	`CashAndCashEquivalentsAtCarryingValue`	$70.55M	USD	Point-in-time
Cash and cash equivalents at end of period	`CashAndCashEquivalentsAtCarryingValue`	$205.74M	USD	Point-in-time
Cash and cash equivalents at end of period	`CashAndCashEquivalentsAtCarryingValue`	$889.79M	USD	Point-in-time
Cash and cash equivalents at end of period	`CashAndCashEquivalentsAtCarryingValue`	$1.02B	USD	Point-in-time
Income taxes paid	`IncomeTaxesPaid`	$8.68M	USD	1 Quarter
Income taxes paid	`IncomeTaxesPaid`	$23.16M	USD	1 Quarter
Interest paid	`InterestPaid`	$30.84M	USD	1 Quarter
Interest paid	`InterestPaid`	$30.55M	USD	1 Quarter

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