DuPont analysis calculator three-step and five-step.

Is this entity in good shape, or are there warning signs?

Split return on equity into what drove it: tax, interest, operating margin, asset turnover and leverage, with each factor shown and the product checked against ROE.

  • Runs in your browser
  • Nothing stored or sent
  • Free, no sign-up
Financial statement inputs
Return on equity
23.33%
Net income ÷ equity
Return on assets
10.77%
Net margin × asset turnover
Equity multiplier
2.17x
Assets ÷ equity
How this was worked out
Work shownrecomputed as you type
Tax burden = NI ÷ EBT = $420,000 ÷ $560,000 = 0.7500
Interest burden = EBT ÷ EBIT = $560,000 ÷ $640,000 = 0.8750
EBIT margin = EBIT ÷ sales = 12.308%
Asset turnover = sales ÷ assets = 1.333x; equity multiplier = assets ÷ equity = 2.167x
ROE = 0.7500 × 0.8750 × 0.1231 × 1.3333 × 2.1667 = 23.333%

The factors multiply back to ROE exactly, so the breakdown shows which lever moved: profitability, efficiency or financial leverage. Compare the factors to the prior year and to the expectation you set for the analytical procedure.

Formula

The DuPont identity splits return on equity into factors that multiply back to it exactly. The three-step form uses net margin, asset turnover and the equity multiplier. The five-step form replaces net margin with the tax burden (net income ÷ pretax income), the interest burden (pretax income ÷ EBIT) and the EBIT margin. The tool recomputes ROE as net income ÷ equity and as the product of the factors so a data entry slip shows up.

When to use it

Use it to form or test an expectation in analytical procedures, to explain a change in return to a client finance team, and to see whether profit improved through operations, financing or tax. It pairs with the financial ratio calculator for turnover days and with the analytical procedures tool for thresholds.

Limits

Ratios depend on the accounting policies and period end used, so compare like with like. One-off items in net income, EBIT definitions that differ between companies, and seasonality distort the factors. The decomposition explains arithmetic, not cause. Illustrative figures only. Check the result against your firm's methodology before relying on it.

Common questions

What is the DuPont formula?

Three-step: ROE = net income ÷ sales × sales ÷ total assets × total assets ÷ equity, which is net profit margin × asset turnover × equity multiplier. Five-step: ROE = (net income ÷ pretax income) × (pretax income ÷ EBIT) × (EBIT ÷ sales) × (sales ÷ assets) × (assets ÷ equity), which separates the tax burden, interest burden and EBIT margin.

Should I use average or year-end balances?

Income statement items cover a period, so many analysts divide by the average of opening and closing assets and equity. Year-end balances are common in quick comparisons. Pick one and use it for the current and the comparison period. The tool lets you switch.

What does a rising equity multiplier tell me?

ROE can rise because the entity borrowed more, not because it earned more on its assets. If the equity multiplier rises while margin and turnover are flat, the improvement came from leverage and brings more financial risk. The five-step version also shows whether higher interest costs are offsetting it through the interest burden.

How does this help in an audit?

A DuPont breakdown gives a structured expectation for an analytical procedure under AU-C 520: AU-C 520 describes analytical procedures as evaluating financial information through analysis of plausible relationships among financial and nonfinancial data. Compare each factor to the prior year and to what you know about the business, and investigate the factor that moved without a business explanation.

What if equity is negative or sales are zero?

The tool shows a dash for any ratio with a zero denominator and warns when assets, sales or equity are zero or negative. With negative equity the equity multiplier and ROE reverse sign and the decomposition no longer reads like a normal one.

Runs in your browser. The figures you type are not sent to CORAA or stored. Check the result against your firm's methodology before relying on it.

Related audit calculators

For US CPA firms

Join the CORAA waitlist

CORAA AI drafts audit working papers from your client’s QuickBooks books and does the first pass: lead schedules, tie-out, memos, draft notes and letters. CORAA Network reviewers clear every finding. Your firm reviews and signs.

  • First audit free, so you can judge the quality on a real file
  • Flat fee by entity size; messy books included
  • We work only with CPA firms, never their clients
See how it works →

* required