Tools of analysis
- Ratios relate one number to another, removing the effect of size.
- Common-size statements express each line as a percentage of revenue or total assets.
- Trend (horizontal) analysis shows the change in each line over time.
- Cross-sectional analysis compares the company with peers.
- Charts of the above help spot turning points.
Ratios raise questions; they rarely answer them. Differences in accounting policy, business mix, seasonality and one-off items all distort comparisons.
Activity ratios
| Ratio | Formula |
|---|---|
| Receivables turnover | Revenue ÷ average receivables |
| Days of sales outstanding (DSO) | 365 ÷ receivables turnover |
| Inventory turnover | COGS ÷ average inventory |
| Days of inventory on hand (DOH) | 365 ÷ inventory turnover |
| Payables turnover | Purchases ÷ average payables |
| Days of payables outstanding | 365 ÷ payables turnover |
| Total asset turnover | Revenue ÷ average total assets |
| Fixed asset turnover | Revenue ÷ average net fixed assets |
Cash conversion cycle = DSO + DOH − days of payables. It measures how long cash is tied up in operations. 45 + 60 − 30 = 75 days. Shorter is generally better.
Liquidity and solvency
Liquidity: current, quick and cash ratios, plus the defensive interval (cash + marketable securities + receivables ÷ daily cash expenditures).
Solvency: debt-to-assets, debt-to-capital, debt-to-equity, financial leverage, interest coverage and fixed charge coverage.
Profitability
- Margins: gross, operating, pretax, net.
- Returns: ROA = net income ÷ average total assets; operating ROA = operating income ÷ average total assets; return on total capital = EBIT ÷ (debt + equity); ROE = net income ÷ average equity.
DuPont analysis
ROE can be broken down to show what drives it.
Three steps:
ROE = (net income / revenue) × (revenue / assets) × (assets / equity)
= net profit margin × asset turnover × financial leverage
Five steps:
ROE = (NI / EBT) × (EBT / EBIT) × (EBIT / revenue) × (revenue / assets) × (assets / equity)
= tax burden × interest burden × EBIT margin × asset turnover × leverage
Move the sliders to see what lifts ROE:
At the starting values: 0.75 × 0.90 × 12% × 1.1 × 2.0 = 17.8%. Leverage raises ROE only while the return on assets exceeds the after-tax cost of debt, and in practice more debt also lowers the interest burden ratio.
Valuation and other ratios
- P/E, P/cash flow, P/sales, P/book.
- Dividend payout ratio = dividends ÷ net income; retention rate = 1 − payout.
- Sustainable growth rate = retention rate × ROE.
Industry-specific and credit ratios
Banks use capital adequacy and net interest margin; retailers use same-store sales and sales per square foot; airlines use revenue per available seat mile. Credit analysts focus on coverage (EBITDA ÷ interest), leverage (debt ÷ EBITDA) and cash flow (FFO ÷ debt).
Segment analysis
Segment disclosures show revenue, profit and assets by business line or region. Computing margins and asset turnover by segment shows where value is created and where risks sit.
Exam focus
Compute any ratio from a set of statements, interpret a change in the cash conversion cycle, and use DuPont to explain why ROE moved.