investorscraft@gmail.com

Intrinsic value of The Sherwin-Williams Company (SHW)

Previous Close$251.61
Intrinsic Value
Upside potential
Previous Close
$251.61

VALUATION INPUT DATA (original, your and others' valuations)

ParameterOrig.Your
Date of valuation (DoV)  
Intrinsic value (IV) at DoV, $/sh  
IV at current val. algorithm, $/sh99.95 

The original valuation is based on fiscal year data as of 2021-12-31 and quarterly data as of 2022-09-30.

Registered users can save their valuation input data

  1. Annual
  2. Quarterly YoY
  3. Quarterly QoQ

Annual revenue growth rates, % (past and forecasted)

NOTE: The bar chart shows historic and forecasted yearly revenue growth rates. Its purpose is to help you in determining what initial revenue rate you want to base your stock valuation on. Please make sure that you are confident in the value you select - for most stocks it is by far the most important parameter in valuation.

Company description

The Sherwin-Williams Company develops, manufactures, distributes, and sells paints, coatings, and related products to professional, industrial, commercial, and retail customers. It operates through three segments: The Americas Group, Consumer Brands Group, and Performance Coatings Group. The Americas Group segment offers architectural paints and coatings, and protective and marine products, as well as OEM product finishes and related products for architectural and industrial paint contractors, and do-it-yourself homeowners. The Consumer Brands Group segment supplies a portfolio of branded and private-label architectural paints, stains, varnishes, industrial products, wood finishes products, wood preservatives, applicators, corrosion inhibitors, aerosols, caulks, and adhesives to retailers and distributors. The Performance Coatings Group segment develops and sells industrial coatings for wood finishing and general industrial applications, automotive refinish products, protective and marine coatings, coil coatings, packaging coatings, and performance-based resins and colorants. It serves retailers, dealers, jobbers, licensees, and other third-party distributors through its branches and direct sales staff, as well as through outside sales representatives. The company has operations primarily in the North and South America, the Caribbean, Europe, Asia, and Australia. As of February 17, 2022, it operated approximately 5,000 company-operated stores and facilities. The Sherwin-Williams Company was founded in 1866 and is headquartered in Cleveland, Ohio.

show cash flow forecast

FINANCIAL STATEMENTS FORECAST and PRESENT VALUE CALCULATION

Fiscal year2021(a)2022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046

INCOME STATEMENT

Revenue growth rate, %8.6NaN
Revenue, $19945NaN
Variable operating expenses, $mNaN
Fixed operating expenses, $mNaN
Total operating expenses, $m17386NaN
Operating income, $m2559NaN
EBITDA, $m3532NaN
Interest expense (income), $mNaN
Earnings before tax, $m2248NaN
Tax expense, $m384NaN
Net income, $m1864NaN

BALANCE SHEET

Cash and short-term investments, $m166NaN
Total assets, $m20667NaN
Adjusted assets (=assets-cash), $m20501NaN
Average production assets, $m14970NaN
Working capital, $m-666NaN
Total debt, $m11496NaN
Total liabilities, $m18230NaN
Total equity, $m2437NaN
Debt-to-equity ratio4.717NaN
Adjusted equity ratio0.181NaN

CASH FLOW

Net income, $m1864NaN
Depreciation, amort., depletion, $m973NaN
Funds from operations, $mNaN
Change in working capital, $mNaN
Cash from operations, $m2646NaN
Maintenance CAPEX, $mNaN
New CAPEX, $mNaN
Total CAPEX, $m-372NaN
Free cash flow, $m3018NaN
Issuance/(repurchase) of shares, $mNaN
Retained Cash Flow, $mNaN
Pot'l extraordinary dividend, $m-666
Cash available for distribution, $mNaN
Discount rate, %NaN
PV of cash for distribution, $mNaN
Current shareholders' claim on cash, %NaN
HomeMenuAccount