Calcady™
Home / Professional / Financial / DuPont Analysis Calculator (ROE Decomposition)

DuPont Analysis Calculator (ROE Decomposition)

Decompose Return on Equity (ROE) using the 3-factor DuPont model. Isolate whether returns are driven by net profit margin, asset turnover efficiency, or financial leverage. Compare two companies with identical ROEs to reveal completely different risk profiles.

DuPont Analysis Calculator (ROE Decomposition)

Decompose Return on Equity (ROE) into its three drivers using the DuPont framework. Two companies can report identical ROEs while having completely different risk profiles — this analysis reveals exactly which lever (margins, efficiency, or debt) is producing the return.

Scenario Presets

After-tax net earnings (can be negative)

Total annual revenue

Average of beginning + ending balance sheet assets

Average equity; must be > 0

Profit Margin= Net Income / Sales × 100
15.00%
Asset Turnover= Sales / Total Assets
0.500×
Equity Multiplier= Total Assets / Equity
2.500×
ROE = 15.00% × 0.500 × 2.500 = 18.75%
Verification: NI/SE = 150,000 / 800,000 = 18.75%
Return on Equity (ROE)
18.75%
Good
Poor < 5%|Adequate 10–15%|Excellent ≥ 20%

Practical Example — Two Companies, Same ROE, Different Risk

SaaS Software Co.: NI = $300k, Sales = $1M, Assets = $500k, Equity = $400k.
Margin = 30% | Turnover = 2.0× | Multiplier = 1.25× → ROE = 75%. High margin, asset-light, almost zero debt.

Leveraged Retailer: NI = $50k, Sales = $5M, Assets = $3M, Equity = $400k.
Margin = 1% | Turnover = 1.67× | Multiplier = 7.5× → ROE = 12.5%. Razor-thin margin propped up entirely by debt leverage (7.5× equity multiplier).

Both could report similar ROEs but the DuPont breakdown immediately reveals that the retailer's ROE is entirely dependent on borrowed money — any interest rate increase or sales dip could trigger insolvency, while the SaaS company's ROE is driven by genuine operational efficiency.

Email LinkText/SMSWhatsApp

What is DuPont Analysis: ROE Decomposition, Leverage Risk & Strategic Insights?

The DuPont analysis framework was developed in the 1920s by E.I. du Pont de Nemours to evaluate business unit performance. By decomposing the single ROE percentage into three distinct ratios, investors immediately identify which aspect of operations drives returns — and whether quality comes from genuine operational excellence or dangerous financial leverage. Two companies can report identical 15% ROEs while representing completely different investment risk profiles.

Mathematical Foundation

3-Step DuPont Equation
ROE=NIS⏟Net Margin×STA⏟Asset Turnover×TASE⏟Equity MultiplierROE = \underbrace{\frac{NI}{S}}_{\text{Net Margin}} \times \underbrace{\frac{S}{TA}}_{\text{Asset Turnover}} \times \underbrace{\frac{TA}{SE}}_{\text{Equity Multiplier}}
Net Profit Margin=NI/S\text{Net Profit Margin} = NI / S= Cents of profit per dollar of revenue after all costs, interest, and taxes. High margins indicate pricing power and operational efficiency. A 30% margin (software, pharma) means 30¢ kept per revenue dollar. A 1% margin (groceries, airlines) means 1¢.
Asset Turnover=S/TA\text{Asset Turnover} = S / TA= Efficiency of asset deployment to generate revenue. A 2.0× ratio means $1 of assets produces $2 of annual revenue. Capital-efficient businesses (software, consulting) have high turnover (2–5×). Capital-intensive businesses (steel, utilities) have low turnover (0.3–0.8×).
Equity Multiplier=TA/SE\text{Equity Multiplier} = TA / SE= Financial leverage — dollars of assets per dollar of equity. A 3× multiplier means $3 of assets per $1 of equity, implying $2 of debt. Higher leverage amplifies both gains and losses. At 7× leverage, a 1.4% asset decline wipes out all equity.

Laws & Principles

  • The Same ROE, Two Completely Different Risk Profiles: Case A — High-Margin Software: 30% margin × 2.0× turnover × 1.25× leverage = 75% ROE. Almost no debt, exceptional margins, rapid asset velocity. Case B — Leveraged Retailer: 1% margin × 1.67× turnover × 7.5× leverage = 12.5% ROE. For every $1 of equity, $6.50 of debt. A 5% revenue decline wipes out the entire equity base. This is why DuPont — not raw ROE — is the correct investment analysis lens.
  • ROE vs. ROA — Separating Operations from Capital Structure: ROA = Margin × Turnover = underlying performance independent of financing. ROE = ROA × Equity Multiplier. If ROA = 6% and cost of debt = 5%, leverage is accretive. If ROA falls to 4% with cost of debt at 5%, leverage is destructive — the company pays more for debt than it earns on debt-funded assets.
  • 5-Step DuPont — Tax and Interest Separately: ROE = (NI/EBT) × (EBT/EBIT) × (EBIT/Sales) × (Sales/TA) × (TA/Equity). The first two factors isolate tax burden and interest burden from operating margin — essential for M&A modeling to separately quantify post-acquisition deleveraging effects.
  • Trend Analysis Red Flag: Declining margin + rising leverage over 5 years signals a deteriorating business masking problems with debt. The ROE stays stable while fundamentals deteriorate — a structural warning that surfaces years before credit ratings or analyst downgrades catch it.

Step-by-Step Example Walkthrough

" Analyst evaluates a manufacturer: Net Income $150K, Sales $1M, Total Assets $2M, Shareholders' Equity $800K. "

  1. Net Profit Margin = $150,000 / $1,000,000 = 15.00%.
  2. Asset Turnover = $1,000,000 / $2,000,000 = 0.500×.
  3. Equity Multiplier = $2,000,000 / $800,000 = 2.500×.
  4. ROE = 15.00% × 0.500 × 2.500 = 18.75%.
  5. Verify: $150,000 / $800,000 = 18.75% ✓.
  6. ROA = 7.50% — at 2.5× leverage, accretive if cost of debt ≈ 5%.
Final Result: ROE = 18.75%. Monitoring trigger: if EBIT margin falls below 5%, ROA drops to ~2.5% — below the cost of debt, making leverage destructive and equity value at risk.

Quick Answer: What does the DuPont model reveal that raw ROE doesn't?

A raw 15% ROE tells you that a company returns 15¢ per equity dollar — nothing about why or how safely. DuPont splits that into: profitability (are margins high?), efficiency (are assets productive?), and leverage (is the balance sheet risky?). Two peers with identical 15% ROEs can look equal until DuPont reveals one earns it with 20% margins and minimal debt, while the other earns it with 1% margins and 7× leverage — one recession quarter from insolvency.

The 3-Factor DuPont Decomposition

ROE = Net Profit Margin × Asset Turnover × Equity Multiplier

Net Margin

Net Income ÷ Sales

Pricing power & cost control

Asset Turnover

Sales ÷ Total Assets

Asset deployment efficiency

Equity Multiplier

Total Assets ÷ Equity

Financial leverage risk

DuPont Peer Comparison Scenarios

✓ Quality ROE: Margin-Driven Software

  1. Inputs: Net Income $6M, Revenue $20M, Total Assets $15M, Equity $12M.
  2. Margin: 30% | Turnover: 1.33× | Leverage: 1.25× (virtually unlevered).
  3. ROE: 30% × 1.33 × 1.25 = 50%.
  4. Diagnosis: ROE sourced almost entirely from exceptional margins. Even with 30% revenue decline, the business remains solidly profitable with minimal default risk.

✗ Leverage-Manufactured ROE: Retail Danger

  1. Inputs: Net Income $500K, Revenue $50M, Total Assets $40M, Equity $2M.
  2. Margin: 1% | Turnover: 1.25× | Leverage: 20× (debt-to-equity ≈ 19×).
  3. ROE: 1% × 1.25 × 20 = 25%.
  4. Diagnosis: 95% leverage-manufactured ROE. A 1% revenue decline wipes the entire net income — zero coverage for $38M in debt. Classic credit distress territory.

DuPont Benchmarks by Industry

Industry Typical Margin Asset Turnover
SaaS / Software15% – 35%0.5 – 1.5×
Pharmaceuticals15% – 25%0.4 – 0.7×
Manufacturing5% – 12%0.8 – 1.4×
Retail1% – 4%1.5 – 3.0×
Banking / Finance10% – 20%0.05 – 0.1×

DuPont Analysis Directives

Do This

  • ✓Run DuPont across 5 years — trends reveal what snapshots hide. A company whose ROE stays at 18% while margins decline 12%→6% and leverage rises 2×→4× is structurally deteriorating behind a stable headline number. Trend analysis surfaces hidden quality degradation years before it appears in credit ratings or analyst downgrades.
  • ✓Use DuPont to identify which lever has room to move safely. If leverage is already 4×, adding more debt is dangerous. But if asset turnover is 0.5× vs. 1.0× industry peers, solving that doubles ROE without touching the balance sheet or pricing — the highest-ROI improvement path with no added risk.

Avoid This

  • ✗Never compare DuPont components across fundamentally different industries. A bank's 12× equity multiplier is regulated, expected, and structural — not reckless. Applying retail leverage heuristics to banking produces entirely wrong conclusions. DuPont benchmarks are only meaningful within the same industry vertical.
  • ✗Don't use single-year DuPont for valuation or credit decisions. One-time items (asset impairments, litigation settlements, tax benefits) can dramatically distort all three components. Always normalize for one-time items or use a trailing 3-year average to smooth distortions before drawing conclusions.

Frequently Asked Questions

Why can two companies have the same ROE but completely different risk levels?

Because ROE is a product of three factors — any combination multiplying to the same result produces identical ROE. A company with 20% margin and no debt shows the same ROE as one with 1% margin and 20× leverage. The second is one bad quarter from default. DuPont is the tool that separates these profiles that a single ROE number cannot distinguish.

What is the difference between ROE and ROA, and when should each be used?

ROA = Net Income / Total Assets = Margin × Turnover. It measures operational performance independent of how the assets are financed. ROE includes the equity multiplier, capturing the leverage effect. Use ROA to compare operating efficiency across companies with different capital structures. Use ROE for equity investor returns. In DuPont: ROE = ROA × Equity Multiplier explicitly shows how much of any observed ROE is leverage-amplified vs. operationally earned.

Can ROE be negative, and what does that signal?

Yes, in two scenarios: (1) Negative net income — the company lost money. Expected for early-stage growth companies or cyclical downturns. (2) Negative equity — total liabilities exceed total assets. Negative equity with positive net income also produces negative ROE — mathematically valid but analytically meaningless. Always identify whether negative ROE stems from operational losses or a distorted balance sheet before drawing conclusions.

How does the 5-step DuPont model improve on the 3-step version?

The 5-step DuPont separates net margin into: tax burden ratio (NI/EBT), interest burden ratio (EBT/EBIT), and operating margin (EBIT/Sales). This isolates tax policy effects from debt refinancing effects from core operating leverage — all of which collapse into a single net margin in the 3-step model. For M&A modeling, it quantifies exactly how much ROE improvement a post-acquisition debt paydown produces independently of operational improvement assumptions.

Related Financial Analysis Tools