Sherwin-Williams Co (WBO:SHWW) Days Inventory : 78.02 (As of Dec. 2023)

View and export this data going back to 2019. Start your Free Trial

What is Sherwin-Williams Co Days Inventory?

Days Inventory is also known as Days Sales of Inventory (DSI). Sherwin-Williams Co's Average Total Inventories for the three months ended in Dec. 2023 was €2,120 Mil. Sherwin-Williams Co's Cost of Goods Sold for the three months ended in Dec. 2023 was €2,479 Mil. Hence, Sherwin-Williams Co's Days Inventory for the three months ended in Dec. 2023 was 78.02.

The historical rank and industry rank for Sherwin-Williams Co's Days Inventory or its related term are showing as below:

WBO:SHWW' s Days Inventory Range Over the Past 10 Years
Min: 59.72 Med: 64.5 Max: 73.58
Current: 73.32

During the past 13 years, Sherwin-Williams Co's highest Days Inventory was 73.58. The lowest was 59.72. And the median was 64.50.

WBO:SHWW's Days Inventory is ranked better than
58.03% of 1494 companies
in the Chemicals industry
Industry Median: 83.765 vs WBO:SHWW: 73.32

Sherwin-Williams Co's Days Inventory declined from Dec. 2022 (81.49) to Dec. 2023 (78.02).

Inventory Turnover measures how fast the company turns over its inventory within a year. Sherwin-Williams Co's Inventory Turnover for the three months ended in Dec. 2023 was 1.17.

Inventory-to-Revenue determines the ability of a company to manage their inventory levels. It measures the percentage of Inventories the company currently has on hand to support the current amount of Revenue. Sherwin-Williams Co's Inventory-to-Revenue for the three months ended in Dec. 2023 was 0.44.

Sherwin-Williams Co Days Inventory Historical Data

The historical data trend for Sherwin-Williams Co's Days Inventory can be seen below:

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.

* Premium members only.

Sherwin-Williams Co Days Inventory Chart

Sherwin-Williams Co Annual Data

Trend

Dec14

Dec15

Dec16

Dec17

Dec18

Dec19

Dec20

Dec21

Dec22

Dec23

Days Inventory

Get a 7-Day Free Trial

67.76

73.03

57.67

63.09

74.72

Sherwin-Williams Co Quarterly Data
	Mar19	Jun19	Sep19	Dec19	Mar20	Jun20	Sep20	Dec20	Mar21	Jun21	Sep21	Dec21	Mar22	Jun22	Sep22	Dec22	Mar23	Jun23	Sep23	Dec23
Days Inventory	Get a 7-Day Free Trial															81.49	80.97	70.15	66.24	78.02

Competitive Comparison of Sherwin-Williams Co's Days Inventory

For the Specialty Chemicals subindustry, Sherwin-Williams Co's Days Inventory, along with its competitors' market caps and Days Inventory data, can be viewed below:

* Competitive companies are chosen from companies within the same industry, with headquarter located in same country, with closest market capitalization; x-axis shows the market cap, and y-axis shows the term value; the bigger the dot, the larger the market cap. Note that "N/A" values will not show up in the chart.

Sherwin-Williams Co's Days Inventory Distribution in the Chemicals Industry

For the Chemicals industry and Basic Materials sector, Sherwin-Williams Co's Days Inventory distribution charts can be found below:

* The bar in red indicates where Sherwin-Williams Co's Days Inventory falls into.

Sherwin-Williams Co Days Inventory Calculation

Days Inventory indicates the number of days of goods in sales that a company has in the inventory.

Sherwin-Williams Co's Days Inventory for the fiscal year that ended in Dec. 2023 is calculated as

	Days Inventory (A: Dec. 2023 )
=	Average Total Inventories					/	Cost of Goods Sold	*	Days in Period
=	( (Total Inventories (A: Dec. 2022 )	+	Total Inventories (A: Dec. 2023 ))	/	count )	/	Cost of Goods Sold (A: Dec. 2023 )	*	Days in Period
=	( (2479.416	+	2136.427)	/	2 )	/	11273.414	*	365
=	2307.9215					/	11273.414	*	365
=	74.72

Sherwin-Williams Co's Days Inventory for the quarter that ended in Dec. 2023 is calculated as:

	Days Inventory (Q: Dec. 2023 )
=	Average Total Inventories					/	Cost of Goods Sold	*	Days in Period
=	( (Total Inventories (Q: Sep. 2023 )	+	Total Inventories (Q: Dec. 2023 ))	/	count )	/	Cost of Goods Sold (Q: Dec. 2023 )	*	Days in Period
=	( (2102.909	+	2136.427)	/	2 )	/	2479.109	*	365 / 4
=	2119.668					/	2479.109	*	365 / 4
=	78.02

Sherwin-Williams Co (WBO:SHWW) Days Inventory Explanation

Days Inventory indicates the liquidity of the inventory. Generally, a lower Days Inventory is preferred as it indicates a shorter duration to clear off the inventory. An increase of the ratio may indicate the company's sales slowed. Similar ratios related to Days Inventory are:

1. Inventory Turnover measures how fast the company turns over its inventory within a year.

Sherwin-Williams Co's Inventory Turnover for the three months ended in Dec. 2023 is calculated as

Inventory Turnover	=	Cost of Goods Sold	/	Average Total Inventories
	=	2479.109	/	2119.668
	=	1.17

2. Inventory-to-Revenue determines the ability of a company to manage their inventory levels. It measures the percentage of Inventories the company currently has on hand to support the current amount of Revenue.

Sherwin-Williams Co's Inventory to Revenue for the three months ended in Dec. 2023 is calculated as

Inventory-to-Revenue	=	Average Total Inventories	/	Revenue
	=	2119.668	/	4816.267
	=	0.44

Be Aware

A lot of business are seasonable. It makes more sense to compare Days Inventory from the same period in the previous year instead of from the previous quarter.

Sherwin-Williams Co Days Inventory Related Terms

Thank you for viewing the detailed overview of Sherwin-Williams Co's Days Inventory provided by GuruFocus.com. Please click on the following links to see related term pages.

Sherwin-Williams Co (WBO:SHWW) Business Description

Industry

GURUFOCUS.COM » STOCK LIST » Basic Materials » Chemicals » Sherwin-Williams Co (WBO:SHWW) » Definitions » Days Inventory

Comparable Companies

Traded in Other Exchanges

SHW:USA SHW:Mexico 1SHW:Italy SJ3:Germany S1HW34:Brazil

Address

101 West Prospect Avenue, Cleveland, OH, USA, 44115-1075

Website

https://www.sherwin-williams.com

Sherwin-Williams is the largest provider of architectural paint in the United States. The company has over 4,900 stores and sells premium paint at higher price points than most competitors. Sherwin-Williams also sells paint-related products in big-box stores and provides coatings for original equipment manufacturers.

Sherwin-Williams Co (WBO:SHWW) Headlines

No Headlines