1. MARKETS
  2. SECTOR : GENERAL & INDUSTRIAL MANUFACTURING
  3. INDUSTRY : INDUSTRIAL SPECIALTIES
  4. SHERWIN-WILLIAMS CO.
Sherwin-Williams Co. XNYS: SHW
Mid-range Performer
Download real time
343.90 2.68 (0.79%)
1.6M
XNYS Volume

XNYS 02 Oct, 2025 5:30 PM (EDT)

Watchlist

Portfolio

Alert

Analyze undervaluation/ overvaluation of Sherwin-Williams Co. with current and 1 Year Forward PE

INSIGHT
Sherwin-Williams Co. is fairly valued at current PE, but undervalued on future earnings estimates
Right Now : Current PE vs 5 year Average PE
Fairly Valued
Fair price

Based on 5Yr Average PE

341.1
Upside

Current PE versus 5Yr Average PE

-0.82 %
1 Year Forward : 5 Yr Average PE & Projected 1Yr Forward EPS*
Undervalued
Fair price

Based on 1Yr Forward EPS

378.0
Upside

5 Yr Average PE & 1Yr Forward EPS

9.90 %
Info: The Sherwin-Williams Co.'s current PE is 33.69 ,while its 5 year PE average is 33.4. Its forward PE based on analyst estimates is 30.4
Note: The forward PE ratio (or forward price-to-earnings ratio) is calculated by dividing the current share price of a company by the estimated(1Yr) future (“forward”) earnings per share (EPS) of that company.

Analyze undervaluation/ overvaluation of Sherwin-Williams Co. with historical PE and PBV ratios

from 03 Oct, 2023 to 02 Oct, 2025

Restated PE

Neutral zone

58.0% into PE buy sell zone

% time spent below current PE
0 20 40 60 80 100
Strong upside potential
Gains already realized

Out of 502 days, Sherwin-Williams Co. traded 291 (58.0%) days below the current PE of on Restated basis.

Originally Reported PE

Sell Zone

60.4% into PE buy sell zone

% time spent below current PE
0 20 40 60 80 100
Strong upside potential
Gains already realized

Out of 502 days, Sherwin-Williams Co. traded 303 (60.4%) days below the current PE of on Originally Reported basis.

Note: This is a reverse percentile score. Values close to 100% are bad while values close to 0% are good. Days when PE is negative are not considered in the analysis
60.4%

Sell Zone

% Days traded below current PE

33.7
 

Current PE

33.1
 

Average PE

33.0
 

Median PE

378.0
 

Forward 1Y Price

30.4
 

Forward PE

11.3
 

Forward EPS

PE range Days traded in range % Days traded in range Days traded within & below range % Days traded within & below range
24-28
 34 6.8% 34 6.8%
28-31
Forward PE is 30.41
54 10.8% 88 17.5%
31-32
 76 15.1% 164 32.7%
32-33
 85 16.9% 249 49.6%
33-34
Current PE is 33.7
68 13.5% 317 63.1%
34-35
 40 8.0% 357 71.1%
35-36
 73 14.5% 430 85.7%
36-37
 26 5.2% 456 90.8%
37-39
 46 9.2% 502 100.0%
Total 502 502
58.0%

Neutral zone

% Days traded below current PE

33.7
 

Current PE

33.3
 

Average PE

33.2
 

Median PE

378.0
 

Forward 1Y Price

30.4
 

Forward PE

11.3
 

Forward EPS

PE range Days traded in range % Days traded in range Days traded within & below range % Days traded within & below range
24-28
 33 6.6% 33 6.6%
28-31
Forward PE is 30.41
43 8.6% 76 15.1%
31-32
 74 14.7% 150 29.9%
32-33
 85 16.9% 235 46.8%
33-34
Current PE is 33.7
78 15.5% 313 62.4%
34-35
 30 6.0% 343 68.3%
35-36
 76 15.1% 419 83.5%
36-37
 33 6.6% 452 90.0%
37-40
 50 10.0% 502 100.0%
Total 502 502

FAQ

  • What is the PE ratio?

    In its simplest definition, the price-to-earnings ratio (PE ratio) represents the price an investor pays per dollar of a company's earnings.
    For example, if a company has a PE ratio of 25, investors are willing to pay USD 25 for each dollar of the company's current earnings. This indicates that investors value the stock at 25 times its current earnings, with an expectation of future earnings growth.
    The PE ratio fluctuates based on investor sentiment towards a company. Positive sentiment drives the stock price higher, resulting in a higher PE ratio (investors pay more for each dollar of earnings). Conversely, negative sentiment lowers the PE ratio (investors pay less for each dollar of earnings).

  • What is the PE buy/sell zone?

    The PE buy/sell zone is calculated based on how many days a stock has traded at its current PE level.
    To do this, we compare the current PE to the stock’s historical PE performance, to find out how often (for how many days in the past) the stock has traded at its current PE value.
    If the stock has usually traded above its current PE level (it’s at a higher PE for the majority of trading days), then the stock is cheaper than usual and in the PE buy zone.
    If the stock has usually traded below its current PE level (it’s at a lower PE for the majority of trading days), then the stock is more expensive than usual and in the PE sell zone.

  • How is the PE buy sell zone useful?

    The PE buy sell zone tells you if a stock’s current PE level is unusually high or low, and if a stock doesn’t typically trade at that level. It helps investors identify stocks that are undervalued or overvalued in terms of their typical PE trading behavior.
    Investors should keep in mind that the buy zone/sell zone is not a foolproof buy or sell signal. For example, the PE of a stock may have fallen substantially due to adverse events or negative news. Or the PE may have risen sharply after the company has won new orders, made an acquisition, announced a buyback, or some other positive event. PE Buy/Sell Zone signals should be looked at in conjunction with other information.

  • Why are the number of days different for Restated and Originally Reported data?

    This can be because of any of the 2 following reasons:
    1. Days when PE is negative are not considered in the analysis. So if only 1 of the Restated or Originally Reported PE is negative and the other is not, then the days will be different
    2. Companies have reported Originally Reported data for limited period.
Buy Sell Stock Screeners