DuPont Analysis Calculator (3-Step Model)
The 3-Step DuPont Analysis decomposes Return on Equity (ROE) into three distinct core drivers: Operating Profitability (Net Profit Margin), Asset Efficiency (Asset Turnover), and Financial Leverage (Equity Multiplier). It reveals exactly how a company generates its equity returns.
Sensitivity Analysis
Evaluate how variations in key operational drivers impact Deconstructed ROE (%).
| Sensitivity Case | Assumption Shift | Driver Value | Deconstructed ROE (%) | Impact vs Base |
|---|
Formula & Methodology
ROE (%) = Net Profit Margin (%) * Asset Turnover * Equity MultiplierNet Profit MarginNet Income / Revenue (Cents of net profit per dollar of sales).
Asset TurnoverRevenue / Total Assets (Sales generated per dollar of asset base).
Equity MultiplierTotal Assets / Shareholders Equity (Assets controlled per dollar of equity).
Practical Worked Example
Acme Corp produces $2,000,000 in net income on $20,000,000 in revenue, with $10,000,000 in assets and $4,000,000 in shareholder equity.
Interpretation & Industry Benchmarks
The DuPont model answers WHY Return on Equity is high or low. A high ROE caused by high profit margin is far superior to a high ROE caused by excessive debt leverage.
Strong pricing power and low production cost (e.g. Apple, Software).
Rapid inventory and asset velocity (e.g. Costco, Walmart).
ROE inflated by debt (e.g. Banks, distressed turnarounds).
Industry Nuance: Retailers win on Asset Turnover; Luxury goods win on Profit Margin; Banks win on Financial Leverage.
Analytical Limitations
- Does not separate tax burden and interest expense; use the 5-Step DuPont model for deeper tax/interest analysis.
Frequently Asked Questions
Why is the DuPont model so famous?
It was invented by F. Donaldson Brown at DuPont Corporation in 1914 to clearly diagnose whether an executive was creating real operational efficiency or merely borrowing money to make ROE look good.