Sherwin-Williams Co (MEX:SHW) Cyclically Adjusted PB Ratio: 21.57 (As of Sep. 02, 2026) — 14% Below Median

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.

MEX:SHW Sherwin-Williams Co MEX:SHW
76 GF Score
Price MXN5,760.00
GF Value MXN6,383.57
Valuation Fairly Valued
! 2 Warning Signs
View Full Analysis

What is Sherwin-Williams Co Cyclically Adjusted PB Ratio?

Sherwin-Williams Co MEX:SHW 76 Cyclically Adjusted PB Ratio is 21.57 as of Sep. 02, 2026, which is 14% below its 10-year median of 25.01. GuruFocus rates MEX:SHW with a GF Score™ of 76/100 and a GF Value™ of MXN6,383.57 (Fairly Valued). The stock has 2 warning signs investors should review. Among 1,091 Chemicals companies, Sherwin-Williams Co ranks worse than 98.81% on this metric.

As of today (2026-09-02), Sherwin-Williams Co's current share price is MXN5760.00. Sherwin-Williams Co's Cyclically Adjusted Book per Share for the quarter that ended in Jun. 2026 was MXN267.00. Sherwin-Williams Co's Cyclically Adjusted PB Ratio for today is 21.57.

The historical rank and industry rank for Sherwin-Williams Co's Cyclically Adjusted PB Ratio or its related term are showing as below:

MEX:SHW' s Cyclically Adjusted PB Ratio Range Over the Past 10 Years
Min: 17.31   Med: 25.01   Max: 37.74
Current: 21.5

During the past years, Sherwin-Williams Co's highest Cyclically Adjusted PB Ratio was 37.74. The lowest was 17.31. And the median was 25.01.

MEX:SHW's Cyclically Adjusted PB Ratio is ranked worse than
98.81% of 1091 companies
in the Chemicals industry
Industry Median: 1.69 vs MEX:SHW: 21.50

The Shiller PE Ratio was first used by professor Robert Shiller. He uses E10 for his Shiller PE Ratio calculation. E10 is the average of the inflation adjusted earnings per share of a company over the past 10 years. The similar calculation is applied by GuruFocus to calculate the Cyclically Adjusted PB Ratio. The Cyclically Adjusted Book per Share is the average of the inflation adjusted book value per share of a company over the past 10 years.

Sherwin-Williams Co's adjusted book value per share data for the three months ended in Jun. 2026 was MXN277.069. Add all the adjusted book value per share for the past 10 years together and divide the count will get our Cyclically Adjusted Book per Share, which is MXN267.00 for the trailing ten years ended in Jun. 2026.

Shiller PE for Stocks: The True Measure of Stock Valuation


Sherwin-Williams Co  (MEX:SHW) 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 22.43

MEX:SHW 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.


MEX:SHW
76GF Score
Sherwin-Williams Co MEX:SHW
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 PB Ratio for today is calculated as

Cyclically Adjusted PB Ratio=Share Price/ Cyclically Adjusted Book per Share
=5760.00/267.00
=21.57

* 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'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)
=277.069/333.9520*333.9520
=277.069

Current CPI (Jun. 2026) = 333.9520.

Sherwin-Williams Co Quarterly Data

Book Value per Share CPI Adj_Book
201609 110.841 241.428 153.319
201612 138.790 241.432 191.976
201703 139.193 243.801 190.663
201706 154.246 244.955 210.287
201709 177.312 246.819 239.907
201712 254.368 246.524 344.578
201803 238.883 249.554 319.672
201806 262.824 251.989 348.311
201809 264.702 252.439 350.175
201812 262.224 251.233 348.562
201903 242.349 254.202 318.380
201906 260.091 256.143 339.099
201909 286.787 256.759 373.008
201912 281.315 256.974 365.584
202003 283.123 258.115 366.308
202006 327.021 257.797 423.625
202009 341.109 260.280 437.660
202012 267.332 260.474 342.745
202103 236.630 264.877 298.339
202106 214.738 271.696 263.943
202109 210.979 274.310 256.851
202112 191.453 278.802 229.324
202203 171.018 287.504 198.647
202206 172.675 296.311 194.610
202209 201.644 296.808 226.879
202212 233.620 296.797 262.866
202303 221.341 301.836 244.892
202306 242.082 305.109 264.967
202309 257.235 307.789 279.101
202312 247.789 306.746 269.766
202403 229.338 312.332 245.213
202406 272.472 314.175 289.624
202409 324.931 315.301 344.152
202412 336.226 315.605 355.772
202503 337.167 319.799 352.089
202506 332.348 322.561 344.085
202509 327.473 324.800 336.700
202512 334.256 324.054 344.466
202603 323.978 330.213 327.646
202606 277.069 333.952 277.069

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.

What does a Cyclically Adjusted PB Ratio of 21.57 mean?
Sherwin-Williams Co (MEX:SHW) has a Cyclically Adjusted PB Ratio of 21.57 as of Sep. 02, 2026. Cyclically Adjusted PB Ratio is the ratio of share price to a company's inflation-adjusted book value per share over a 10-year period. View historical data on Sherwin-Williams Co and its competitors. This is 14% below median its historical median of 25.01. Over the past decade, Sherwin-Williams Co's Cyclically Adjusted PB Ratio has ranged from 17.31 to 37.74. According to the industry distribution chart, Sherwin-Williams Co ranks #1078 out of 1091 companies in the Chemicals industry, placing it in the top 98.8%.
Is Sherwin-Williams Co's Cyclically Adjusted PB Ratio too high?
Sherwin-Williams Co's current Cyclically Adjusted PB Ratio of 21.57 is 14% below median its 10-year median of 25.01. Over the past 10 years, this metric has ranged from a low of 17.31 to a high of 37.74. The Chemicals industry median Cyclically Adjusted PB Ratio is 1.69. Sherwin-Williams Co's value of 21.57 is 1176.3% above this industry median. Based on the distribution chart, Sherwin-Williams Co ranks #1078 out of 1091 companies in the Chemicals industry, which is in the bottom quartile relative to peers. Overall, Sherwin-Williams Co has a GF Score™ of 76/100 and is considered Fairly Valued, reflecting its overall financial health beyond just this single metric.
How does Sherwin-Williams Co's Cyclically Adjusted PB Ratio compare to ECL and APD?
According to the Chemicals industry distribution chart, Sherwin-Williams Co ranks #1078 out of 1091 companies for Cyclically Adjusted PB Ratio. This places Sherwin-Williams Co in the lower half of its industry. The industry median Cyclically Adjusted PB Ratio is 1.69. Sherwin-Williams Co's value of 21.57 is 1176.3% above this benchmark. Historically, Sherwin-Williams Co's own Cyclically Adjusted PB Ratio has ranged from 17.31 to 37.74 over the past decade. While the company's 10-year median is 25.01 vs. the industry median of 1.69, Sherwin-Williams Co has consistently been above the industry average. See the competitive comparison table and distribution chart on this page for a detailed peer-by-peer breakdown.
What is a good Cyclically Adjusted PB Ratio for a Chemicals company?
The median Cyclically Adjusted PB Ratio among Chemicals companies is 1.69, based on 1,091 companies in the industry. Companies in the top quartile (top 25%) have a Cyclically Adjusted PB Ratio significantly above this median, while those in the bottom quartile fall well below. However, Cyclically Adjusted PB Ratio should not be evaluated in isolation — investors should consider it alongside profitability, growth, and financial strength metrics. Sherwin-Williams Co's current Cyclically Adjusted PB Ratio of 21.57 is 1176.3% above the industry median. Use the industry distribution chart on this page to see where any company falls relative to its peers.
What does a high Cyclically Adjusted PB Ratio mean?
A high Cyclically Adjusted PB Ratio can signal that a stock is expensive relative to its fundamentals. Cyclically Adjusted PB Ratio is the ratio of share price to a company's inflation-adjusted book value per share over a 10-year period. View historical data on Sherwin-Williams Co and its competitors. For the Chemicals industry, the median Cyclically Adjusted PB Ratio is 1.69 — values significantly above this may indicate overvaluation, while values below may suggest a bargain or underlying issues. Sherwin-Williams Co's current Cyclically Adjusted PB Ratio is 21.57, which is 14% below median its own 10-year median of 25.01. However, context matters — high-growth companies often justify higher valuations. Always evaluate alongside other metrics like GF Score™ and GF Value™.
Is Sherwin-Williams Co stock overvalued right now?
Based on GuruFocus' analysis, Sherwin-Williams Co (MEX:SHW) is currently considered Fairly Valued. The stock's GF Value™ is MXN6,383.57, compared to a current price of MXN5,760.00 — trading 9.8% below its estimated fair value. The current Cyclically Adjusted PB Ratio is 21.57, which is 14% below median its 10-year median of 25.01 and 1176.3% above the Chemicals industry median of 1.69. Sherwin-Williams Co's overall GF Score™ is 76/100 with 2 warning signs to review. Investors should evaluate multiple metrics — including profitability, growth, and financial strength — before making a decision.
How is Cyclically Adjusted PB Ratio calculated?
Cyclically Adjusted PB Ratio is calculated from a company's financial statements. For Sherwin-Williams Co (MEX:SHW), the current Cyclically Adjusted PB Ratio is 21.57 as of Sep. 02, 2026. GuruFocus calculates this using data sourced from SEC filings and annual reports. See the calculation section and 30-year financial data on this page for the full breakdown.

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

Based on GuruFocus' analysis, Sherwin-Williams Co stock appears to be undervalued. The current stock price of MXN5,760.00 is trading 9.8% below its estimated GF Value™ of MXN6,383.57. GuruFocus considers Sherwin-Williams Co to be Fairly Valued.

Key valuation signals for MEX:SHW:

  • Cyclically Adjusted PB Ratio: 21.57 (14% below median its 10-year median of 25.01)
  • GF Value™: MXN6,383.57 vs. price of MXN5,760.00 (9.8% below fair value)
  • GF Score™: 76/100 with 2 warning signs
  • Industry Position: 1176.3% above the Chemicals median (#1078 of 1091)

No single metric tells the full story. See the MEX:SHW 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.
76GF Score

Get the complete analysis for MEX:SHW

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

MXN5,760.00
Price
MXN6,383.57
GF Value