The fair value of requested stock should be $99.54
* Note: Prices are in Million (M) USD.
These criteria used Company’s Cash, EBITDA and Debt balance to determines its fair value:
Cash : $210 M
Debt : $12,100 M
EBITDA : $4,400 M
Net Debt (Debt - Cash): $11,890 M
Since Net Debt is covered by EBITDA within 3 years, 1 points assigned.
This criteria used industry in which company operates:
Sector: Basic Materials
Industry: Specialty Chemicals
Based on industry, 3 points assigned.
This criteria used Company’s Price To Earning (P/E) Ratio to determines its fair value:
Forward PE Ratio: 26.01
Since Forward PE Ratio is between 25 - 35, 1 point assigned.
This criteria used Company's ability to convert Sales into free cash flow to determine fair value:
Average Free Cash Flow: $1,285 M
Average Revenue: $13,285 M
Free Cash Flow to Revenue : 10 %
Since Free Cash Flow (FCF) to Revenue percentage is less than 15, 1 point assigned.
This criteria used company's growth potential to calculate its fair value:
Latest Revenue (2024-12-31): $23,099 M
Revenue 4 Years Ago (2020-12-31): $18,362 M
Revenue Growth: 5%
Since Revenue Growth is between 5 - 10, 2 points assigned.
This criteria used Company's ability to buy back its own share:
Latest Share Count (2024-12-31): $254 M
Share Count 5 Years Ago (2020-12-31): $276 M
Company is buying back its own shares, 3 points assigned.
This criteria used Company's dividend payout ratio to determine its fair value:
Earnings Per Share (EPS): $12.75
Dividend Per Share (DPS): $3
Payout Ratio: 22%
Dividend Yield: 1%
Since company Payout Ratio is less than 50, 2 points assigned.
Since Dividend Yield is less than 1, 0 point assigned.
This criteria used Company's Return On Equity (ROE%) to determine its fair value:
Average ROE: 50%
Since Average ROE is greater than 20, 5 points assigned.
This criteria used Company's current price to its 52 week low price to determines its fair value:
Current Price: $332
52-Week Low: $280
Threshold Price (15% Above 52-Week Low): $322
Since Current price is not within 15% threshold, 0 point assigned.
This criteria used Company's Market Cap to determines its fair value:
Market Capitalization: $84,701 M
Since Market Cap is between 10B - 100B, 2 points assigned.
% Exposure to Total Portfolio
Based on the calculated score, we recommend do not exceed 3% exposure of Total Portfolio.
Value-Trade has assigned 20 points to above Sherwin-Williams Co (SHW) stock.
Twenty Years Avg PE 40, Fair Value PE 15, Industry Based PE is 15 and Growth based PE is 15. Based on these all values average assigned is 21.25.
Value-Trades has assined P/E value 21.25. Since current year earning per share is $12.75.
The fair value of Sherwin-Williams Co (SHW) stock should be (21.25 x $12.75) = $270.94
Join Discussion Group