NYSE: SHW - Sherwin-Williams

Yield per half year: +20.25%
Sector: Materials

Current price
237.6 $
Average price
235.78 $ -0.7657%

Average analyst price
375.25 $ +57.93%
Price based on EPS
112.02 $ -52.85%
Discount price Net Income
376.42 $ +58.42%
5/10

Average analyst price

Fair price = 375.25 $
Current price = 237.6 $ (difference = +57.93%)

Idea Price forecast Changes Expiration date Analyst
More details 375 $ +137.4 $ (57.83%) 20.01.2025 Morgan Stanley
More details 350 $ +112.4 $ (47.31%) 20.01.2025 Wells Fargo
More details 390 $ +152.4 $ (64.14%) 20.01.2025 Goldman Sachs
More details 386 $ +148.4 $ (62.46%) 20.01.2025 BMO Capital

Price based on EPS

Price = EPS * (1 + CAGR EPS) / (Key Rate * Excess Key Rate)
Key Rate = Key rate
Fair price = 112.02 $
Current price = 237.6 $ (difference = -52.85%)


Data

Dividend Discount Model

Price = (DPS * (1 + g)) / (Cost Of Equity - g)
Price - Fair price
DPS — Current dividend
g — expected growth rate
Cost Of Equity — discount rate
Cost Of Equity = k(f) + β * Risk Premium + Country Premium (Damodaran table)
k(f) — risk-free rate of return
β (beta) — determines the measure of risk of a stock (asset) in relation to the market and shows the sensitivity of changes in the stock's profitability in relation to changes in market profitability. Beta can be calculated not only for an individual stock, but also for an investment portfolio.
Risk Premium — risk premium - premium for the risk of investing in shares
Country Premium - country risk
Fair price = 79.44 $
Current price = 237.6 $ (difference = -66.57%)


Data

Discounted Cash Flow (Based EBITDA)

Price = (Terminal Value + Company Value) / Count shares
Price - Fair price
Terminal Value — cost in the post-forecast period
Company Value — cost during the forecast period
Count shares - Number of shares
Terminal Value = Discount Ebitda(5) * (1 + Ebitda Yield) / (WACC - Ebitda Yield)
Company Value = ∑ (Future Ebitda / (1 + WACC) ^ 5)
WACC - weighted average cost of capital (taking into account country risks, inflation, taxes, etc.)
Fair price = 1 003.27 $
Current price = 237.6 $ (difference = +322.25%)


Data

Discounted Cash Flow (Based FCF)

Price = (Terminal Value + Company Value) / Count shares
Price - Fair price
Terminal Value — cost in the post-forecast period
Company Value — cost during the forecast period
Count shares - Number of shares
Terminal Value = Discount FCF(5) * (1 + FCF Yield) / (WACC - FCF Yield) ^ 5
Company Value = ∑ (FCF / (1 + WACC) ^ 5)
WACC - weighted average cost of capital (taking into account country risks, inflation, taxes, etc.)
Fair price = 874.11 $
Current price = 237.6 $ (difference = +267.89%)


Data

Pay for your subscription

More functionality and data for company and portfolio analysis is available by subscription