DuPont Analysis Calculator (5-Step ROE Decomposition)

Return on Equity is the single most-cited profitability metric in investing, but a headline ROE number by itself is dangerously easy to misread. Two companies can post an identical 20% ROE for completely different reasons: one earns it through genuinely strong operating margins on modest leverage, and the other earns it by piling on debt to shrink the equity base in the denominator. Those two companies carry very different risk profiles even though the ROE headline looks the same.

DuPont Analysis, developed internally at the DuPont corporation in the 1920s to evaluate its own business units, solves this by algebraically decomposing ROE into its multiplicative components. The classic 3-step version splits ROE into net profit margin, asset turnover, and equity multiplier. The 5-step "extended" version used here goes one level deeper, splitting net profit margin itself into tax burden, interest burden, and operating margin, isolating exactly how much of profitability comes from tax efficiency, financing cost, versus core operating performance.

This distinction matters most when comparing companies with different capital structures or tax situations. A company with a favorable tax position and low debt load will show that clearly in its Tax Burden and Interest Burden ratios, components the simpler 3-step model collapses into a single net profit margin figure.

The 5-step DuPont identity multiplies five ratios together:

$$ROE = \text{Tax Burden} \times \text{Interest Burden} \times \text{Operating Margin} \times \text{Asset Turnover} \times \text{Equity Multiplier}$$

Where:

• Tax Burden = Net Income / Pre-Tax Income (EBT): the share of pre-tax income the company keeps after taxes. Lower means a heavier effective tax load.
• Interest Burden = EBT / EBIT: the share of operating earnings that survives after interest expense. Lower means the company is carrying more debt-service cost.
• Operating Margin = EBIT / Revenue: core operating profitability before financing and tax effects.
• Asset Turnover = Revenue / Average Total Assets: how efficiently the asset base generates sales.
• Equity Multiplier = Average Total Assets / Average Shareholders' Equity: financial leverage: how many dollars of assets each dollar of equity supports.

Multiplying all five terms together telescopes back down to the simple identity ROE = Net Income / Average Shareholders' Equity, since every intermediate numerator cancels the previous denominator. This calculator computes and displays that direct check alongside the 5-step breakdown so you can confirm the decomposition reconciles exactly.

A company reports:

• Net Income: $800,000
• Pre-Tax Income (EBT): $1,000,000
• EBIT: $1,200,000
• Revenue: $10,000,000
• Total Assets: $8,000,000
• Shareholders' Equity: $4,000,000

Step 1: Tax Burden: $800,000 / $1,000,000 = 0.800

Step 2: Interest Burden: $1,000,000 / $1,200,000 = 0.833

Step 3: Operating Margin: $1,200,000 / $10,000,000 = 0.12, or 12.00%

Step 4: Asset Turnover: $10,000,000 / $8,000,000 = 1.250

Step 5: Equity Multiplier: $8,000,000 / $4,000,000 = 2.000

Multiply all five:

$$ROE = 0.800 \times 0.833 \times 0.12 \times 1.250 \times 2.000 = 0.20 = 20.00\%$$

Direct check: Net Income / Equity = $800,000 / $4,000,000 = 20.00%: matches exactly. This company's 20% ROE comes from a healthy 12% operating margin combined with moderate 2.0x leverage, not from an aggressively thin equity base or an unusual tax position.

• Off-balance-sheet leverage. Operating leases, guarantees, and other financing arrangements that don't appear as debt on the balance sheet are invisible to the Equity Multiplier term, even though they carry similar economic risk to on-balance-sheet debt.
• Share buybacks mechanically inflating ROE. A company that shrinks its equity base through buybacks, rather than through operational improvement, will show a rising Equity Multiplier and rising ROE even if underlying operating performance is flat. The decomposition reveals this, but only if you look past the headline ROE number.
• One-time items. A large one-time gain or impairment flows straight through Net Income and EBT, distorting the Tax Burden and Interest Burden terms for a single period without reflecting a change in the underlying business.
• Using ending balances instead of averages. For a company growing rapidly or shrinking, using period-ending totals instead of average balances for assets and equity can meaningfully skew the Asset Turnover and Equity Multiplier terms for that period.
• Industry-appropriate benchmarks. Asset Turnover in particular varies enormously by industry; a grocery chain typically turns assets several times a year while a utility might turn assets less than once. DuPont components should be benchmarked against direct competitors, not a universal standard.

• Comparing ROE across industries without decomposing it. A capital-intensive company (utilities, telecom) will naturally show a lower Asset Turnover and rely more on leverage to hit a comparable ROE than an asset-light company (software, consulting). Decomposition prevents an apples-to-oranges conclusion.
• Treating a high ROE from high leverage the same as a high ROE from high margins. The former carries materially more financial risk in a downturn; a company levered to produce ROE has less cushion if earnings decline.
• Conflating the 3-step and 5-step models. The 3-step version (Net Profit Margin × Asset Turnover × Equity Multiplier) and the 5-step version should produce identical ROE, since Tax Burden × Interest Burden × Operating Margin algebraically equals Net Profit Margin. If they don't match, check for a data or calculation error.
• Forgetting Interest Burden falls with rising rates. In a rising-rate environment, a company with variable-rate debt will see its Interest Burden ratio decline period over period purely from higher financing costs, independent of any change in operating performance.
• Overlooking negative components. A company with negative EBIT or negative EBT produces a negative Tax Burden or Interest Burden ratio; the arithmetic still works, but the resulting figures require careful interpretation rather than being dismissed as errors.

• Investopedia, "DuPont Analysis: Overview, Formula, and How to Compute"
• Corporate Finance Institute (CFI), "DuPont Analysis"
• CFA Institute Program Curriculum, Financial Statement Analysis: Financial Analysis Techniques