Sherwin-Williams Co (Sherwin-Williams Co) Days Inventory

: 77.19 (As of Dec. 2023)

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

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,287 Mil. Sherwin-Williams Co's Cost of Goods Sold for the three months ended in Dec. 2023 was $2,704 Mil. Hence, Sherwin-Williams Co's Days Inventory for the three months ended in Dec. 2023 was 77.19.

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

SHW' 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.

SHW's Days Inventory is ranked better than
57.98% of 1492 companies
in the Chemicals industry
Industry Median: 83.41 vs SHW: 73.32

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

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.18.

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 Annual Data

Trend

Dec14

Dec15

Dec16

Dec17

Dec18

Dec19

Dec20

Dec21

Dec22

Dec23

Days Inventory

Get a 7-Day Free Trial

68.54

69.64

59.72

64.81

73.58

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															78.78	80.55	69.72	66.76	77.19

Competitive Comparison

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 Days Inventory Distribution

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
=	( (2626.5	+	2329.8)	/	2 )	/	12293.8	*	365
=	2478.15					/	12293.8	*	365
=	73.58

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
=	( (2244.3	+	2329.8)	/	2 )	/	2703.5	*	365 / 4
=	2287.05					/	2703.5	*	365 / 4
=	77.19

Sherwin-Williams Co (NYSE:SHW) 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
	=	2703.5	/	2287.05
	=	1.18

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
	=	2287.05	/	5252.2
	=	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 (Sherwin-Williams Co) Business Description

Industry

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

Comparable Companies

Traded in Other Exchanges

SHW:Mexico 1SHW:Italy SJ3:Germany 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.

Executives

Mary L Garceau	officer: SVP, Gen. Counsel & Secretary	101 W. PROSPECT AVENUE, CLEVELAND OH 44115
Heidi G Petz	officer: President, Consumer Brands Grp	101 W. PROSPECT AVENUE, CLEVELAND OH 44115
John G Morikis	officer: President, Paint Stores Group	C/O THE SHERWIN WILLIAMS CO, 101 W. PROSPECT AVENUE, CLEVELAND OH 44115
Thomas L Williams	director	6035 PARKLAND BOULEVARD, CLEVELAND OH 44124
Gregory P. Sofish	officer: SVP - Human Resources	101 WEST PROSPECT AVENUE, 1180 MIDLAND BUILDING, CLEVELAND OH 44115
Justin T Binns	officer: President, Perf Coatings Grp	101 W. PROSPECT AVENUE, CLEVELAND OH 44115
Karl J Jorgenrud	officer: President, Perf Coatings Group	101 WEST PROSPECT AVENUE, 1180 MIDLAND, CLEVELAND OH 44115
Todd D Rea	officer: President, Consumer Brands Grp	101 W. PROSPECT AVENUE, 1180 MIDLAND, CLEVELAND OH 44115
Bryan J Young	officer: SVP - Corp Strategy & Devel.	101 W. PROSPECT AVENUE, CLEVELAND OH 44115
Joseph F Sladek	officer: Pres. & GM, Glob. Supply Chain	101 W. PROSPECT AVENUE, CLEVELAND OH 44115
Marta R Stewart	director	C/O NORFOLK SOUTHERN CORP, THREE COMMERCIAL PL, NORFOLK VA 23510-9219
Peter J. Ippolito	officer: President, The Americas Group	101 W. PROSPECT AVENUE, CLEVELAND OH 44115
Jane M. Cronin	officer: SVP - Corporate Controller	101 W. PROSPECT AVENUE, CLEVELAND OH 44115
Thomas P Gilligan	officer: SVP-Human Resources	101 W. PROSPECT AVENUE, CLEVELAND OH 44115
Brian E Padden	officer: President, Consumer Brands Grp	101 W. PROSPECT, CLEVELAND OH 44115