What is 3-Step DuPont Analysis Calculator (ROE Decomposition) and How Do You Calculate It?
ROE (%) = Net Profit Margin (%) * Asset Turnover * Equity MultiplierThis standardized equation forms the quantitative foundation used by chartered financial analysts (CFA), investment bankers, and corporate treasurers under GAAP and IFRS reporting frameworks.
Where to Find Each Component on Financial Statements
| Formula Variable | Financial Statement | Reporting Line Item | Analyst Extraction Guidance |
|---|---|---|---|
| Net Income | Income Statement | Net Income / Net Earnings (Bottom Line) | Located at the bottom of the income statement. Ensure discontinued operations and non-controlling interest deductions are factored in. |
| Total Net Revenue | Income Statement | Revenue / Net Sales (Top Line) | First line item on the income statement, net of sales returns, customer allowances, and discounts. |
| Total Assets | Balance Sheet | Total Assets (Current + Non-Current) | Sum of all current assets, property plant & equipment, intangibles, and goodwill. For high accuracy, use average of beginning and ending balances. |
| Shareholders' Equity | Balance Sheet | Total Stockholders' / Shareholders' Equity | Common stock, additional paid-in capital, retained earnings, minus treasury stock. Excludes preferred equity and non-controlling interest. |
Step-by-Step Real-World Worked Example
Acme Corporation produces $150,000 in bottom-line net income on $1,500,000 total revenue, holding $1,000,000 in average total assets financed by $500,000 in shareholders' equity.
Strategic Takeaway: Acme generates a strong 30.00% ROE balanced evenly between healthy operating profitability (10%), efficient asset rotation (1.5x), and conservative 2.0x financial leverage.
Industry Benchmark Comparison Table
The 3-Step DuPont model demystifies Return on Equity. Two companies can both report a 25% ROE, yet Company A might achieve it through an elite 25% margin with zero debt, while Company B relies on an anemic 2% margin inflated by a dangerous 10x debt multiplier.
| Industry Sector | Target / Healthy | Moderate / Industry Avg | High Risk / Alert | Sector Dynamics & Nuance |
|---|---|---|---|---|
| Enterprise Software & SaaS | 20% – 35% ROE | 12% – 20% ROE | < 8% ROE | High profit margin (18–28%), moderate turnover (0.8–1.2x), low leverage (1.1–1.5x). Premier return quality. |
| Discount Retail & Supermarkets | 15% – 25% ROE | 10% – 15% ROE | < 6% ROE | Razor-thin margins (2–4%) offset by blazing asset turnover (2.5–3.8x) and moderate leverage (2.0–2.8x). |
| Industrial Manufacturing | 14% – 20% ROE | 8% – 14% ROE | < 5% ROE | Balanced profiles: 6–10% margin, 1.0–1.4x asset turnover, and 1.8–2.4x financial leverage. |
| Commercial Banking & Lending | 11% – 16% ROE | 8% – 11% ROE | < 6% ROE | High leverage (9.0–12.0x equity multiplier) offsets tiny asset yields (ROA 0.9–1.3%). Regulatory capital dictates returns. |
| Healthcare & Medical Devices | 16% – 26% ROE | 10% – 16% ROE | < 7% ROE | Patent-protected margins (14–22%) compensate for heavy capitalized R&D asset bases. |
| Electric & Gas Utilities | 9% – 12% ROE | 7% – 9% ROE | < 5% ROE | Rate-regulated returns on equity with low asset turnover (0.3–0.5x) and high infrastructure leverage (2.5–3.5x). |
| Automotive & Capital Goods | 12% – 18% ROE | 6% – 12% ROE | < 3% ROE | Highly cyclical; margin compression in downturns severely degrades ROE despite high plant leverage. |
Executive Sector Note: Software firms achieve ROE via Net Margin; Big box retailers achieve ROE via Asset Turnover; Commercial banks achieve ROE via Financial Leverage.
Analytical Comparison & Critical Limitations
3-Step vs. 5-Step DuPont Analysis: Choosing the Right Depth
The 3-Step DuPont model is the classic tool for rapid strategic diagnosis. The extended 5-Step DuPont model further breaks down Net Profit Margin into Operating Margin, Interest Burden, and Tax Burden to isolate fiscal and financing drags.
| Metric | Mathematical Focus | Key Analytical Difference | When to Use |
|---|---|---|---|
| 3-Step DuPont ROE | Net Margin × Asset Turnover × Equity Multiplier | Evaluates profitability, asset turnover, and leverage in three consolidated metrics. | Standard equity screening, quarterly corporate earnings calls, and peer benchmarking. |
| 5-Step DuPont ROE | Tax Burden × Interest Burden × Operating Margin × Asset Turnover × Leverage | Separates pre-tax operating efficiency from interest expense and corporate tax shields. | Analyzing leveraged buyouts (LBOs), heavily indebted corporations, or cross-border tax variations. |
| Standard ROE | Net Income ÷ Shareholders' Equity | Single composite percentage without any causal breakdown. | Surface-level ranking only; provides zero diagnostic explanation of what drove the return. |
Analyst Takeaway: Always check the Equity Multiplier first. If a company’s ROE surged over the past 3 years while its Net Margin and Asset Turnover declined, the return expansion was entirely engineered by borrowing money.
- Does not separate tax rates from core operating profitability; a sudden drop in tax provision can temporarily inflate 3-step ROE.
- Asset Turnover can be distorted by asset age: companies with older, fully depreciated plant assets will appear artificially efficient.
- Financial leverage (Equity Multiplier) does not distinguish between low-cost bank debt and expensive subordinated bonds or trade payables.
- Negative equity (resulting from sustained historical losses or massive share repurchases) renders the equity multiplier and ROE mathematically meaningless.
Frequently Asked Questions
What is the 3-step DuPont analysis formula?
The formula is: Return on Equity (ROE) = Net Profit Margin × Asset Turnover × Equity Multiplier. Mathematically: (Net Income / Revenue) × (Revenue / Total Assets) × (Total Assets / Shareholders' Equity).
How does financial leverage affect ROE in 3-step DuPont analysis?
Financial leverage (the Equity Multiplier: Total Assets / Equity) acts as a mathematical multiplier on Return on Assets (ROA). If a company earns a 10% ROA and has a 3.0x Equity Multiplier, its ROE triples to 30%. However, excessive leverage raises financial distress risk.
Can a company have a high ROE but low profitability?
Yes. A company with a razor-thin 2% net profit margin can produce a high 24% ROE if it turns over its assets rapidly (3.0x) and carries heavy leverage (4.0x multiplier: 2% × 3.0 × 4.0 = 24%). This is common in grocery stores and discount trading desks.
What is the difference between 3-step and 5-step DuPont analysis?
The 3-step model combines operating performance, interest, and taxes into a single "Net Profit Margin". The 5-step model breaks Net Margin into three sub-drivers: Tax Burden (Net Income / EBT), Interest Burden (EBT / EBIT), and Operating Margin (EBIT / Revenue).
What does an Equity Multiplier of 1.0x mean?
An Equity Multiplier of 1.0x means Total Assets equal Shareholders' Equity, indicating that the company has zero liabilities and zero debt on its balance sheet. In this case, ROE exactly equals ROA.
Why do asset-light businesses achieve high ROE without debt?
Asset-light companies (like enterprise software and digital marketplaces) require minimal capital expenditure and physical inventory. They achieve high ROE through high net profit margins (25%–35%) and high asset turnover rather than borrowing money.