How should the SHW historical PE ratio be determined?
Realizing that PE stands for Price to Earnings ratio, we need two values to compute it: stock price and earnings per share. The stock price at any given date is a known historical value, but what about the earnings number to use?
✔️Accepted answer:
There are a number of different approaches when it comes to calculating a historical PE ratio for a company like Sherwin-Williams. We like to take our measurements on each of the past quarterly earnings reports. That only leaves the question of whether the earnings number at that quarterly report should be used on an annualized basis, or some other method. We approach this question using three different methods, on this SHW Historical PE Ratio page.
What is the average historical PE for SHW based on annualized quarterly earnings?
As we look back through earnings history, what is the resulting PE calculation if at each measurement period we use that quarter's earnings result annualized?
✔️Accepted answer:
The SHW historical PE ratio using the annualized quarterly earnings method works out to 28.4.
What is the average historical PE for SHW based on trailing twelve month earnings?
As we look back through earnings history, what is the resulting PE calculation if at each measurement period we use the trailing twelve months combined earnings result in the calculation?
✔️Accepted answer:
The SHW historical PE ratio using the TTM earnings method works out to 27.3.
What is the average historical PE for SHW based on median TTM earnings?
As we look back through earnings history, what is the resulting PE calculation if at each measurement period we use the median earnings over the trailing twelve months and annualize that median result in the calculation?
✔️Accepted answer:
The SHW historical PE ratio using the annualized median TTM earnings method works out to 11.08.
On this page we presented the
SHW Historical PE Ratio information for Sherwin-Williams' stock.
The average SHW historical PE based on using the annualized quarterly earnings result at each measurement period (for the "E" in the PE calculation; and the closing price on earnings date as the "P") is 28.4. Meanwhile, using the trailing twelve month (TTM) quarterly earnings result as our method of calculation the "E" value at each measurement period, the average SHW historical PE based on this TTM earnings result method is 27.3.
Let's now compare this SHW historical PE result, against the recent PE: when this page was posted on 10/23/2024, the most recent closing price for SHW had been 362.72, and the most recent quarterly earnings result, annualized, was 13.48. Meanwhile, the most recent TTM earnings summed to 11.05. From these numbers, we calculate the recent SHW PE on 10/23/2024 based on annualized quarterly EPS was 26.9. Based on SHW's history, that recent PE is low relative to the historical average, with the recent PE 5.3% lower than the historical average PE across our data set for Sherwin-Williams. Looking at the recent SHW PE on 10/23/2024 based on TTM EPS, we calculate the ratio at 32.8. Based on SHW's history, that recent PE is elevated relative to the historical average, with the recent PE 20.1% higher than the historical average PE across our Sherwin-Williams data set with TTM EPS used in the calculation at each period.
Another interesting SHW historical PE Ratio calculation we look at is to take the
median earnings per share of the last four quarters for SHW, and then annualize the resulting value... with that annualized number then being used in the PE calculation. To walk through this math for SHW, we start with the past four EPS numbers and we first sort them from lowest to highest: 1.81, 2.17, 3.37, and 3.70. We then toss out the highest and lowest result, and then take the average of those two middle numbers — 2.17 and 3.37 — which gives us the median of 2.77. Basically the way to think about this 2.77 number is this: for the trailing four earnings reports, 2.77 marks the "middle ground" number where SHW has reported a value
higher than 2.77 half the time, and has reported a value
lower than 2.77 half the time. Annualizing that median value then gets us to 11.08/share, which we use as the denominator in our next PE calculation. With 362.72 as the numerator (as of 10/23/2024), the calculation is then 362.72 / 11.08 =
32.7 as the SHW PE ratio as of 10/23/2024, based on that annualized median value we calculated.
For self directed investors doing their due diligence on SHW or any other given stock, valuation analysis for SHW
can greatly benefit from studying the past earnings and resulting PE calculations. This exercise can help inform an analysis
as to whether the past earnings trajectory and current versus historical PE ratios justify the current stock value.
That's why we bring you
HistoricalPERatio.com to make it easy for investors to investigate
Sherwin-Williams PE history or the past PE information for any stock in our coverage universe.
And in your continued research we hope you will be sure to check out the further links included for earnings
surprises history (beat/miss data) as well as next earnings dates for SHW. Thanks for visiting, and the next
time you need to research
SHW Historical PE Ratio or the ratio for another stock, we hope you'll think of our site, as your
go-to historical PE ratio research resource of choice.