Sherwin-Williams Co (MIL:1SHW) Cyclically Adjusted PB Ratio: (As of Jul. 30, 2026)

Author: Vera Yuan Vera Yuan
Vera Yuan
Vera Yuan
Director of Data and Quant Analytics at GuruFocus
Focused on building reliable datasets, financial models, and research tools for value-minded investors. Committed to turning complex data into practical guidance for value-investing and long-term wealth.
Reviewed by: Charlie Tian Charlie Tian
Charlie Tian
Charlie Tian
Founder & CEO of GuruFocus
Dr. Charlie Tian is the founder and CEO of GuruFocus.com, a leading global investment research platform established in 2004. With a Ph.D. in physics, Dr. Tian transitioned from science to finance, applying a data-driven, disciplined approach to value investing.

MIL:1SHW Sherwin-Williams Co MIL:1SHW
63 GF Score
Price €301.80
GF Value €303.69
Valuation Fairly Valued
! 1 Warning Sign
View Full Analysis

What is Sherwin-Williams Co Cyclically Adjusted PB Ratio?

Shiller PE for Stocks: The True Measure of Stock Valuation


Sherwin-Williams Co  (MIL:1SHW) Cyclically Adjusted PB Ratio Explanation

Compared with the regular PB Ratio, which works poorly for cyclical businesses, the Cyclically Adjusted PB Ratio smoothed out the fluctuations of book value during business cycles. Therefore it is more accurate in reflecting the valuation of the company.

If a company has consistent business performance, the Cyclically Adjusted PB Ratio should give similar results to regular PB Ratio.


Sherwin-Williams Co Cyclically Adjusted PB Ratio Related Terms


Sherwin-Williams Co Cyclically Adjusted PB Ratio Historical Data

* Premium members only.

The historical data trend for Sherwin-Williams Co's Cyclically Adjusted PB Ratio 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.

Sherwin-Williams Co Cyclically Adjusted PB Ratio Chart

Sherwin-Williams Co Annual Data
Trend Dec16 Dec17 Dec18 Dec19 Dec20 Dec21 Dec22 Dec23 Dec24 Dec25
Cyclically Adjusted PB Ratio
Get a 7-Day Free Trial Premium Member Only Premium Member Only 37.35 22.86 27.43 26.96 22.59

Sherwin-Williams Co Quarterly Data
Sep21 Dec21 Mar22 Jun22 Sep22 Dec22 Mar23 Jun23 Sep23 Dec23 Mar24 Jun24 Sep24 Dec24 Mar25 Jun25 Sep25 Dec25 Mar26 Jun26
Cyclically Adjusted PB Ratio Get a 7-Day Free Trial Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only 25.25 24.70 22.59 21.46 0.00

MIL:1SHW vs ECL, APD, PPG: Cyclically Adjusted PB Ratio Comparison

For the Specialty Chemicals subindustry, Sherwin-Williams Co's Cyclically Adjusted PB Ratio, along with its competitors' market caps and Cyclically Adjusted PB Ratio 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 Cyclically Adjusted PB Ratio vs Chemicals Industry

For the Chemicals industry and Basic Materials sector, Sherwin-Williams Co's Cyclically Adjusted PB Ratio distribution charts can be found below:

* The bar in red indicates where Sherwin-Williams Co's Cyclically Adjusted PB Ratio falls into.


MIL:1SHW
63GF Score
Sherwin-Williams Co MIL:1SHW
Cyclically Adjusted PB Ratio is just one metric. See GF Score™, valuation, warning signs, and more.
View Full Analysis

Sherwin-Williams Co Cyclically Adjusted PB Ratio Calculation

Like the Shiller PE Ratio, the Cyclically Adjusted PB Ratio takes the Book Value per Share from the past 10 years, adjusts it for inflation, and then calculates the average. This average is then used for the P/B calculation. Because it considers this 10-year average, it's often referred to as the CAPB Ratio.

The Shiller PE Ratio was first used by professor Robert Shiller to measure the valuation of the overall market. The similar calculation is applied by GuruFocus to calculate the Cyclically Adjusted PB Ratio.

Sherwin-Williams Co's Cyclically Adjusted Book per Share for the quarter that ended in Jun. 2026 is calculated as:

For example, Sherwin-Williams Co's adjusted Book Value per Share data for the three months ended in Jun. 2026 was:

Adj_Book=Book Value per Share/CPI of Jun. 2026 (Change)*Current CPI (Jun. 2026)
=13.601/333.9520*333.9520
=13.601

Current CPI (Jun. 2026) = 333.9520.

Sherwin-Williams Co Quarterly Data

Book Value per Share CPI Adj_Book
201609 5.108 241.428 7.066
201612 6.382 241.432 8.828
201703 6.912 243.801 9.468
201706 7.595 244.955 10.354
201709 8.197 246.819 11.091
201712 10.944 246.524 14.825
201803 10.664 249.554 14.271
201806 11.450 251.989 15.174
201809 12.128 252.439 16.044
201812 11.739 251.233 15.604
201903 11.057 254.202 14.526
201906 11.983 256.143 15.623
201909 13.190 256.759 17.155
201912 13.424 256.974 17.445
202003 10.927 258.115 14.137
202006 12.581 257.797 16.298
202009 13.110 260.280 16.821
202012 11.047 260.474 14.163
202103 9.724 264.877 12.260
202106 8.954 271.696 11.006
202109 8.722 274.310 10.618
202112 8.260 278.802 9.894
202203 7.799 287.504 9.059
202206 8.120 296.311 9.152
202209 10.125 296.808 11.392
202212 11.312 296.797 12.728
202303 11.469 301.836 12.689
202306 13.033 305.109 14.265
202309 13.837 307.789 15.013
202312 13.386 306.746 14.573
202403 12.713 312.332 13.593
202406 13.817 314.175 14.687
202409 14.868 315.301 15.747
202412 15.396 315.605 16.291
202503 15.245 319.799 15.920
202506 15.303 322.561 15.843
202509 15.210 324.800 15.639
202512 15.854 324.054 16.338
202603 15.541 330.213 15.717
202606 13.601 333.952 13.601

Add all the adjusted book value per share together and divide the count will get our Cyclically Adjusted Book per Share.

Please note that we use the CPI data of the country/region where the company is headquartered. If the CPI data for that country/region is not available, then we will use the CPI data of the United States as default.

Is Sherwin-Williams Co (MIL:1SHW) Overvalued in 2026?

Based on GuruFocus' analysis, Sherwin-Williams Co stock appears to be undervalued. The current stock price of €301.80 is trading 0.6% below its estimated GF Value™ of €303.69. GuruFocus considers Sherwin-Williams Co to be Fairly Valued.

Key valuation signals for MIL:1SHW:

  • Cyclically Adjusted PB Ratio:
  • GF Value™: €303.69 vs. price of €301.80 (0.6% below fair value)
  • GF Score™: 63/100 with 1 warning sign

No single metric tells the full story. See the MIL:1SHW stock analysis page for a complete view including 30-year financials, guru trades, and insider activity.


Sherwin-Williams Co Business Description

Address 1 Sherwin Way, Cleveland, OH, USA, 44113-2206
Sherwin-Williams is the largest global manufacturer of paints and coatings. The company focuses on the development, manufacturing, and distribution of paint, coatings, and related products to customers ranging from professional painters and contractors to industrial manufacturers to do-it-yourself consumers. Sherwin organizes its operations into three primary segments: the paint stores group is the largest segment and includes the company's network of over 4,800 company-owned stores; the consumer brands group sells branded architectural paints through big-box retailers such as Lowe's, and the performance coatings group provides specialized coatings for industrial applications, such as automotive refinishing, packaging, and industrial wood.
63GF Score

Get the complete analysis for MIL:1SHW

Cyclically Adjusted PB Ratio is just one metric. See GF Value™, 30-year financials, guru trades, warning signs, and more.

€301.80
Price
€303.69
GF Value