Switch to:
GuruFocus has detected 4 Warning Signs with Sherwin-Williams Co \$SHW.
More than 500,000 people have already joined GuruFocus to track the stocks they follow and exchange investment ideas.
Sherwin-Williams Co (NYSE:SHW)
Cost of Goods Sold
\$6,039 Mil (TTM As of Mar. 2017)

Sherwin-Williams Co's cost of goods sold for the three months ended in Mar. 2017 was \$1,418 Mil. Its cost of goods sold for the trailing twelve months (TTM) ended in Mar. 2017 was \$6,039 Mil.

Cost of Goods Sold is directly linked to profitability of the company through Gross Margin. Sherwin-Williams Co's Gross Margin for the three months ended in Mar. 2017 was 48.64%.

Cost of Goods Sold is also directly linked to Inventory Turnover. Sherwin-Williams Co's Inventory Turnover for the three months ended in Mar. 2017 was 1.22.

Definition

Cost of goods sold (COGS) refers to the Inventory costs of those goods a business has sold during a particular period.

Sherwin-Williams Co Cost of Goods Sold for the trailing twelve months (TTM) ended in Mar. 2017 was 1583.732 (Jun. 2016 ) + 1643.173 (Sep. 2016 ) + 1394.153 (Dec. 2016 ) + 1418.247 (Mar. 2017 ) = \$6,039 Mil.

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.

Explanation

Cost of Goods Sold is directly linked to profitability of the company through Gross Margin.

Sherwin-Williams Co's Gross Margin for the three months ended in Mar. 2017 is calculated as:

 Gross Margin = (Revenue - Cost of Goods Sold) / Revenue = (2761.387 - 1418.247) / 2761.387 = 48.64 %

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.

A company that has a moat can usually maintain or even expand their Gross Margin. A company can increase its Gross Margin in two ways. It can increase the prices of the goods it sells and keeps its Cost of Goods Sold unchanged. Or it can keep the sales price unchanged and squeeze its suppliers to reduce the Cost of Goods Sold. Warren Buffett believes businesses with the power to raise prices have moats.

Cost of Goods Sold is also directly linked to another concept called Inventory Turnover:

Sherwin-Williams Co's Inventory Turnover for the three months ended in Mar. 2017 is calculated as:

 Inventory Turnover = Cost of Goods Sold / Average Inventory = 1418.247 / 1158.007 = 1.22

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.

Inventory Turnover measures how fast the company turns over its inventory within a year. A higher inventory turnover means the company has light inventory. Therefore the company spends less money on storage, write downs, and obsolete inventory. If the inventory is too light, it may affect sales because the company may not have enough to meet demand.

Usually retailers pile up their inventories at holiday seasons to meet the stronger demand. Therefore, the inventory of a particular quarter of a year should not be used to calculate inventory turnover. An average inventory is a better indication.

Related Terms

Historical Data

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.

Sherwin-Williams Co Annual Data

 Dec07 Dec08 Dec09 Dec10 Dec11 Dec12 Dec13 Dec14 Dec15 Dec16 COGS 4,406 4,481 3,831 4,295 5,021 5,328 5,569 5,965 5,780 5,933

Sherwin-Williams Co Quarterly Data

 Dec14 Mar15 Jun15 Sep15 Dec15 Mar16 Jun16 Sep16 Dec16 Mar17 COGS 1,351 1,318 1,602 1,578 1,282 1,312 1,584 1,643 1,394 1,418
Get WordPress Plugins for easy affiliate links on Stock Tickers and Guru Names | Earn affiliate commissions by embedding GuruFocus Charts
GuruFocus Affiliate Program: Earn up to \$400 per referral. ( Learn More)