Sherwin-Williams Co (MEX:SHW) Cyclically Adjusted Book per Share: MXN267.00 (As of Jun. 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.

MEX:SHW Sherwin-Williams Co MEX:SHW
74 GF Score
Price MXN5,923.00
GF Value MXN6,226.06
Valuation Fairly Valued
! 3 Warning Signs
View Full Analysis

What is Sherwin-Williams Co Cyclically Adjusted Book per Share?

Sherwin-Williams Co MEX:SHW 74 Cyclically Adjusted Book per Share is MXN267.00 as of Jun. 2026. GuruFocus rates MEX:SHW with a GF Score™ of 74/100 and a GF Value™ of MXN6,226.06 (Fairly Valued). The stock has 3 warning signs investors should review.

E10 is a concept invented by Prof. Robert Shiller, who uses E10 for his Shiller PE Ratio calculation. E10 is the average of the inflation adjusted earnings of a company over the past 10 years. The similar calculation is applied by GuruFocus to calculate the Cyclically Adjusted Book per Share and 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 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.

During the past 12 months, Sherwin-Williams Co's average Cyclically Adjusted Book Growth Rate was 12.90% per year. During the past 3 years, the average Cyclically Adjusted Book Growth Rate was 11.40% per year. During the past 5 years, the average Cyclically Adjusted Book Growth Rate was 11.10% per year. During the past 10 years, the average Cyclically Adjusted Book Growth Rate was 12.70% per year. Please click Growth Rate Calculation Example (GuruFocus) to see how GuruFocus calculates Wal-Mart Stores Inc (WMT)'s revenue growth rate. You can apply the same method to get the Cyclically Adjusted Book Growth Rate using Cyclically Adjusted Book per Share data.

During the past 13 years, the highest 3-Year average Cyclically Adjusted Book Growth Rate of Sherwin-Williams Co was 16.20% per year. The lowest was 0.10% per year. And the median was 5.50% per year.

As of today (2026-08-21), Sherwin-Williams Co's current stock price is MXN5923.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 of today is 22.18.

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


Sherwin-Williams Co  (MEX:SHW) Cyclically Adjusted Book per Share Explanation

If a company grows much fast than inflation, Cyclically Adjusted Book per Share may underestimate the company's equity. Cyclically Adjusted PB Ratio can seem to be too high even the actual PB Ratio is low.

For the Cyclically Adjusted PB Ratio, the book value of the past 10 years are inflation-adjusted and averaged. The result is used for P/B calculation. Since it looks at the average over the last 10 years, the Cyclically Adjusted PB Ratio is also called CAPB Ratio.

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 Cyclically Adjusted PB Ratio of today is calculated as

Cyclically Adjusted PB Ratio=Share Price/Cyclically Adjusted Book per Share
=5923.00/267.00
=22.18

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

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


Be Aware

Cyclically Adjusted PB Ratio works better for cyclical companies. It gives you a better idea on the company's real book value.


Sherwin-Williams Co Cyclically Adjusted Book per Share Related Terms


Sherwin-Williams Co Cyclically Adjusted Book per Share Historical Data

* Premium members only.

The historical data trend for Sherwin-Williams Co's Cyclically Adjusted Book per Share 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 Book per Share Chart

Sherwin-Williams Co Annual Data
Trend Dec16 Dec17 Dec18 Dec19 Dec20 Dec21 Dec22 Dec23 Dec24 Dec25
Cyclically Adjusted Book per Share
Get a 7-Day Free Trial Premium Member Only Premium Member Only 192.61 203.85 190.03 260.81 258.05

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 Book per Share 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 254.60 256.98 258.05 261.22 267.00

MEX:SHW vs ECL, APD, PPG: Cyclically Adjusted Book per Share 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
74GF Score
Sherwin-Williams Co MEX:SHW
Cyclically Adjusted Book per Share is just one metric. See GF Score™, valuation, warning signs, and more.
View Full Analysis

Sherwin-Williams Co Cyclically Adjusted Book per Share Calculation

E10 is a concept invented by Prof. Robert Shiller, who uses E10 for his Shiller PE Ratio calculation. E10 is the average of the inflation adjusted earnings of a company over the past 10 years. The similar calculation is applied by GuruFocus to calculate the Cyclically Adjusted Book per Share and 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.

What is Cyclically Adjusted Book per Share? How do we calculate Cyclically Adjusted Book per Share?

Cyclically Adjusted Book per Share is the average of the inflation adjusted Book Value per Share of a company over the past 10 years. Let's use an example to explain.

If we want to calculate the Cyclically Adjusted Book per Share of Wal-Mart (WMT) for Dec. 31, 2010, we need to have the inflation data and the book value per share from 2001 through 2010.

We adjusted the 2001 book value per share data with the total inflation from 2001 through 2010 to the equivalent book value in 2010. If the total inflation from 2001 to 2010 is 40%, and Wal-Mart's book value is $1 a share in 2001, then the 2001's equivalent book value in 2010 is $1.4 a share. If Wal-Mart's book value is $1 again in 2002, and the total inflation from 2002 through 2010 is 35%, then the equivalent 2002 book value in 2010 is $1.35. So on and so forth, you get the equivalent book value per share of past 10 years. Then you add them together and divided the sum by the count to get 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.

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.

What does a Cyclically Adjusted Book per Share of MXN267.00 mean?
Sherwin-Williams Co (MEX:SHW) has a Cyclically Adjusted Book per Share of MXN267.00 as of Jun. 2026. Cyclically adjusted book value per share represents the company's inflation-adjusted book value per share over a 10-year period. View historical data on Sherwin-Williams Co and its competitors.
Is Sherwin-Williams Co's Cyclically Adjusted Book per Share too high?
Sherwin-Williams Co's current Cyclically Adjusted Book per Share is MXN267.00. Overall, Sherwin-Williams Co has a GF Score™ of 74/100 and is considered Fairly Valued, reflecting its overall financial health beyond just this single metric.
How does Sherwin-Williams Co's Cyclically Adjusted Book per Share compare to ECL and APD?
Sherwin-Williams Co's Cyclically Adjusted Book per Share of MXN267.00 can be compared against companies in the Chemicals industry. See the competitive comparison table and distribution chart on this page for a detailed peer-by-peer breakdown.
What is a good Cyclically Adjusted Book per Share for a Chemicals company?
A good Cyclically Adjusted Book per Share depends on the Chemicals industry context. However, Cyclically Adjusted Book per Share should not be evaluated in isolation — investors should consider it alongside profitability, growth, and financial strength metrics. Use the industry distribution chart on this page to see where any company falls relative to its peers.
What does a high Cyclically Adjusted Book per Share mean?
A high Cyclically Adjusted Book per Share can signal that a stock is expensive relative to its fundamentals. Cyclically adjusted book value per share represents the company's inflation-adjusted book value per share over a 10-year period. View historical data on Sherwin-Williams Co and its competitors. Sherwin-Williams Co's current Cyclically Adjusted Book per Share is MXN267.00. 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,226.06, compared to a current price of MXN5,923.00 — trading 4.9% below its estimated fair value. The current Cyclically Adjusted Book per Share is MXN267.00. Sherwin-Williams Co's overall GF Score™ is 74/100 with 3 warning signs to review. Investors should evaluate multiple metrics — including profitability, growth, and financial strength — before making a decision.
How is Cyclically Adjusted Book per Share calculated?
Cyclically Adjusted Book per Share is calculated from a company's financial statements. For Sherwin-Williams Co (MEX:SHW), the current Cyclically Adjusted Book per Share is MXN267.00 as of Jun. 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,923.00 is trading 4.9% below its estimated GF Value™ of MXN6,226.06. GuruFocus considers Sherwin-Williams Co to be Fairly Valued.

Key valuation signals for MEX:SHW:

  • Cyclically Adjusted Book per Share: MXN267.00
  • GF Value™: MXN6,226.06 vs. price of MXN5,923.00 (4.9% below fair value)
  • GF Score™: 74/100 with 3 warning signs

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.
74GF Score

Get the complete analysis for MEX:SHW

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

MXN5,923.00
Price
MXN6,226.06
GF Value