SHW has been removed from your Stock Email Alerts list.
Please enter Portfolio Name for new portfolio.
This valuation method assumes that the stock valuation will revert to its historical mean in terms of Price/Sales Ratio. The reason we use P/S Ratio instead of P/E Ratio or P/B Ratio is because Price/Sales Ratio is independent of profit margin, and can be applied to a broader range of situations.
Median P/S Value is calculated as trailing twelve months (TTM) revenue per share times 10-Year median P/S ratio. Sherwin-Williams Co's revenue per share for the trailing twelve months (TTM) ended in Sep. 2016 was $123.829. Sherwin-Williams Co's 10-Year median P/S ratio is 1.18. Therefore, the Median P/S Value for today is $146.12.
As of today, Sherwin-Williams Co's share price is $284.00. Sherwin-Williams Co's median P/S value is $146.12. Therefore, Sherwin-Williams Co's Price to Median P/S Value Ratio for today is 1.94.
During the past 13 years, the highest Price to Median P/S Value Ratio of Sherwin-Williams Co was 2.09. The lowest was 0.57. And the median was 0.87.
Sherwin-Williams Co's Median P/S Value for today is calculated as
|Median P/S Value||=||Total Annual Sales / Shares Outstanding||*||10-Year Median P/S Ratio|
|=||Revenue per Share (TTM)||*||10-Year Median P/S Ratio|
10-Year Median P/S Ratio is 1.18.
Sherwin-Williams Co's revenue per share for the trailing twelve months (TTM) ended in Sep. 2016 was 27.701 (Dec. 2015 ) + 27.516 (Mar. 2016 ) + 34.008 (Jun. 2016 ) + 34.604 (Sep. 2016 ) = $123.829.
It also assumes that over time the profit margin is constant. If a company increases its profit margin to a sustainable level, this value might under-estimate its value. If it has permanent declined profit margins, this may over-estimate the companys value.
Sherwin-Williams Co's Price to Median P/S Value Ratio for today is calculated as
|Price to Median P/S Value||=||Share Price||/||Median P/S Value|
Sherwin-Williams Co Annual Data
Sherwin-Williams Co Quarterly Data