Financial statement analysis and common stock valuation

Common Stock Valuation Ratios

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.

• Current Valuation Ratios
• 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)

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.

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

Enterprise Value (EV)

Enterprise value is total company value (the market value of common equity, debt, and preferred equity) minus the value of cash and short-term investments.

• Current EV
• Historical EV

Analysis of Short-term (Operating) Activity Ratios

Evaluates revenues and output generated by the Sherwin-Williams Co. assets. Operating performance ratios describe the relationship between the Sherwin-Williams Co. level of operations and the assets needed to sustain operating activities.

• Short-term Activity Ratios (Summary)
• Inventory Turnover
• Receivables Turnover
• Payables Turnover
• Working Capital Turnover
• Average Inventory Processing Period
• Average Receivable Collection Period
• Operating Cycle
• Average Payables Payment Period
• Cash Conversion Cycle

Analysis of Long-term (Investment) Activity Ratios

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
• Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)
• Total Asset Turnover
• Equity Turnover

Analysis of Profitability Ratios
Quarterly Data

Measures the income of Sherwin-Williams Co. relative to its revenues and invested capital.

• Profitability Ratios (Summary)
• Gross Profit Margin
• Operating Profit Margin
• Net Profit Margin
• Return on Equity (ROE)
• Return on Assets (ROA)

Common-Size Income Statement
Quarterly Data

Income statement components (revenues and expenses) shown as percentage of total sales.

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

Analysis of Solvency Ratios
Quarterly Data

Examines Sherwin-Williams Co. capital structure in terms of the mix of its financing sources and the ability of the firm to satisfy its longer-term debt and investment obligations.

• Solvency Ratios (Summary)
• Debt to Equity
• Debt to Equity (including Operating Lease Liability)
• Debt to Capital
• Debt to Capital (including Operating Lease Liability)
• Debt to Assets
• Debt to Assets (including Operating Lease Liability)
• Financial Leverage
• Interest Coverage