5.6 Reporting Quality, Ratios, DuPont, and Modeling
Key Takeaways
- Reporting quality concerns the usefulness and faithful representation of statements, while earnings quality concerns the sustainability and cash support of earnings.
- Ratio analysis is strongest when ratios are grouped by purpose, compared with peers and history, and tied to accounting policy choices.
- DuPont analysis decomposes ROE into profitability, efficiency, and leverage drivers, with expanded versions adding tax and interest effects.
- Introductory modeling links revenue, margins, working capital, capital investment, depreciation, debt, taxes, and cash flow into consistent forecasts.
Reporting Quality, Ratios, DuPont, And Modeling
Reporting quality and earnings quality are related but distinct. Reporting quality asks whether financial reports faithfully represent economic reality and are useful for decisions. Earnings quality asks whether earnings are sustainable, repeatable, and cash-supported. A company can have transparent reporting with weak earnings quality if the business is cyclical or declining.
Low reporting quality can come from biased estimates, poor disclosure, aggressive recognition, weak controls, or intentional misstatement. Low earnings quality can come from one-time gains, unusually low expenses, unsustainable tax benefits, excessive accruals, or revenue growth that is not collected. Analysts look for patterns rather than one isolated clue.
Reporting quality red-flag map:
| Signal | Possible interpretation | Follow-up |
|---|---|---|
| Receivables grow faster than sales | Aggressive revenue or weak collections | Review days sales outstanding and allowance |
| Inventory grows faster than COGS | Slowing demand or obsolete stock | Review turnover, markdowns, and write-downs |
| CFO trails net income for years | Accrual earnings quality concern | Reconcile working capital and noncash items |
| Frequent non-GAAP adjustments | Core earnings may be overstated | Reconcile to GAAP or IFRS and assess recurrence |
| Long useful lives versus peers | Depreciation expense may be low | Compare asset age, capex, and depreciation policy |
Ratio analysis organizes evidence. Liquidity ratios test near-term obligations. Activity ratios test asset use and working capital. Solvency ratios test long-term financial risk. Profitability ratios test margins and returns. Market ratios connect accounting numbers to share price. Each ratio needs a benchmark: the company's history, peer group, industry economics, covenants, or forecast assumptions.
Core ratio table:
| Group | Ratio | Formula |
|---|---|---|
| Liquidity | Current ratio | Current assets / current liabilities |
| Activity | Receivables turnover | Revenue / average receivables |
| Activity | Inventory turnover | COGS / average inventory |
| Solvency | Debt-to-assets | Total debt / total assets |
| Profitability | ROA | Net income / average total assets |
| Profitability | ROE | Net income / average total equity |
| Market | P/E | Price per share / EPS |
Use average balance sheet amounts when an income statement flow is compared with a balance sheet stock. Revenue, COGS, and net income cover a period. Assets, receivables, inventory, and equity are point-in-time balances. Average balances reduce distortion from growth, seasonality, or one large year-end transaction.
DuPont analysis decomposes ROE. The three-part model separates profit margin, asset turnover, and financial leverage. A company can raise ROE by improving margins, using assets more efficiently, or increasing leverage. The same ROE can therefore have very different risk implications.
ROE = net income / average equity
ROE = (net income / sales) x (sales / average assets) x (average assets / average equity)
ROE = net profit margin x total asset turnover x financial leverage
The expanded DuPont version can separate tax burden, interest burden, operating margin, asset turnover, and leverage. This helps identify whether ROE changed because of taxes, financing, operations, efficiency, or capital structure. A tax benefit or leverage increase may lift ROE without improving operating competitiveness.
Modeling is the practical extension of FSA. A simple three-statement model starts with revenue drivers, then forecasts operating costs, working capital, capital expenditures, depreciation, debt, interest, taxes, and equity distributions. The income statement gives earnings, the balance sheet gives investment and financing needs, and the cash flow statement explains funding.
Modeling workflow:
| Forecast step | Common driver | Statement link |
|---|---|---|
| Revenue | Volume, price, units, market growth | Income statement and receivables |
| COGS and SG&A | Margins or cost behavior | Income statement and payables |
| Working capital | Days sales, days inventory, days payables | Balance sheet and CFO |
| Capex | Percent of revenue or capacity plan | PP&E and CFI |
| Depreciation | Asset lives and prior capex | Income statement and PP&E |
| Debt and interest | Funding gap and rates | Balance sheet, income statement, CFF |
A good model is internally consistent. If revenue grows, receivables usually grow unless collection speed changes. If production grows, inventory and payables may change. If capex exceeds depreciation, net PP&E may rise. If free cash flow is negative, the company needs cash balances, debt issuance, equity issuance, or lower distributions to fund the gap.
The exam does not require investment-banking modeling depth, but it does expect financial logic. Avoid hard-coded plug numbers that break the accounting identity. Use common-size statements, ratio trends, and operating drivers. Then test sensitivity to margins, working capital, capex, and debt cost. The best model tells a coherent business story and exposes which assumptions matter most.
A company reports net profit margin of 8%, total asset turnover of 1.5, and financial leverage of 2.0. ROE under the three-part DuPont model is closest to:
Revenue grows rapidly while receivables grow much faster than revenue and operating cash flow lags net income. The most appropriate analyst response is to:
In a basic three-statement model, revenue growth most directly affects: