Financial statement analysis and common stock valuation

Enterprise Value to EBITDA (EV/EBITDA)

To calculate EBITDA analysts start with net earnings. To that earnings number, interest, taxes, depreciation, and amortization are added. EBITDA as a pre-interest number is a flow to all providers of capital.

• Earnings before Interest, Tax, Depreciation and Amortization (EBITDA)
• EV to EBITDA Ratio, Current
• EV to EBITDA Ratio, Historical

Statement of Comprehensive Income

Comprehensive income is the change in equity (net assets) of Sherwin-Williams Co. during a period from transactions and other events and circumstances from non-owners sources. It includes all changes in equity during a period except those resulting from investments by owners and distributions to owners.

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Measures how efficiently Sherwin-Williams Co. generates revenues from its investments in fixed or total assets.

• Long-term Activity Ratios (Summary)
• Net Fixed Asset Turnover
• Total Asset Turnover
• Equity Turnover

Analysis of Reportable Segments

Sherwin-Williams Co. operates in 3 segments: Paint Stores Group; Consumer Brands Group; and Performance Coatings Group.

• Segment Profit Margin
• Segment Return on Assets (Segment ROA)
• Segment Asset Turnover
• Segment Capital Expenditures to Depreciation
• Net sales and intersegment transfers
• Income before income taxes
• Identifiable assets
• Capital expenditures
• Depreciation

Common-Size Balance Sheet: Liabilities and Stockholders’ Equity

Liabilities and stockholders’ equity components shown as percentage of total liabilities and stockholders’ equity.

Common Stock Valuation Ratios
Quarterly Data

Relative valuation technique determine the value of Sherwin-Williams Co. by comparing it to similar entities (like industry or sector) on the basis of several relative ratios that compare its stock price to relevant variables that affect the stock value, such as earnings, book value, and sales.

• Historical Valuation Ratios (Summary)
• Price to Earnings (P/E)
• Price to Operating Profit (P/OP)
• Price to Sales (P/S)
• Price to Book Value (P/BV)

Balance Sheet: Liabilities and Stockholders’ Equity

The liabilities and stockholders’ equity reports major classes and amounts of external claims on assets and owners’ capital contributions, and other internally generated sources of capital.

Capital Asset Pricing Model (CAPM)

CAPM is a theory concentrated with deriving the expected rates of return on risky assets based on the assets’ systematic risk levels. Systematic risk is the variability of returns that is due to macroeconomic factors that affect all risky assets. It cannot be eliminated by diversification.

• Rates of Return
• Variance and Covariance
• Systematic Risk (β) Estimation
• Expected Rate of Return

Present Value of Free Cash Flow to Equity (FCFE)

The FCFE valuation approach estimates the value of equity as the present value of future FCFE discounted at the required rate of return on equity.

• Intrinsic Stock Value (Valuation Summary)
• Required Rate of Return (r)
• FCFE Growth Rate (g)

Common-Size Balance Sheet: Assets
Quarterly Data

Assets components shown as percentage of total assets.