DuPont Analysis Calculator: 3-Step and 5-Step ROE Decomposition

Return on equity tells you how large the return was; the DuPont identity tells you where it came from. Enter revenue, EBIT, pre-tax income, net income and the average asset and equity balances, and this calculator splits ROE two ways — the 3-step identity into net profit margin, total asset turnover and the equity multiplier, and the 5-step identity into tax burden, interest burden, EBIT margin, turnover and leverage. Both versions multiply back to exactly the same ROE, because this is an algebraic identity rather than a model. All it does is move the explanation into five terms a manager can actually pull.

Calculator

This calculator runs in your browser. Enable JavaScript for live results — the inputs, formula and worked example below remain fully readable without it.

Inputs this calculator takes, with typical values
InputWhat to enterExample
Revenue (net sales)The top line for the period, net of returns and allowances. Use the same period as the income figures below.2000000 $
EBIT (operating profit)Profit before interest and tax. Take operating income from the income statement, or add interest and tax back to net income.300000 $
Pre-tax income (EBT)The 'income before income taxes' line, which is EBIT less net interest expense and other non-operating items.250000 $
Net incomeProfit after interest and tax attributable to the parent. Enter a negative number for a loss.187500 $
Average total assetsOpening plus closing total assets divided by two; take both from the balance sheet's comparative columns.1600000 $
Average shareholders' equityOpening plus closing total equity divided by two, on the same basis as assets — include or exclude noncontrolling interests consistently.800000 $

It returns

  • Return on equity — Net income divided by average shareholders' equity — the product of every factor below.
  • Net profit margin
  • Total asset turnover
  • Equity multiplier (leverage)
  • Return on assets (margin × turnover)
  • Tax burden (net income ÷ pre-tax income)
  • Interest burden (pre-tax income ÷ EBIT)
  • EBIT margin

The formula

ROE=Net incomeRevenueRevenueAvg assetsAvg assetsAvg equity
ROE=NIEBTEBTEBITEBITRevenueRevenueAssetsAssetsEquity
ROA=Net incomeRevenueRevenueAvg assets

In plain text: ROE = (Net income / Revenue) × (Revenue / Avg assets) × (Avg assets / Avg equity)

  • ROEReturn on average shareholders' equity (%)
  • Net income / RevenueNet profit margin — cents of profit per dollar of sales (decimal)
  • Revenue / Avg assetsTotal asset turnover — sales generated per dollar of assets (×)
  • Avg assets / Avg equityEquity multiplier — the leverage term (×)
  • EBITEarnings before interest and tax (operating profit) ($)
  • EBTEarnings before tax (pre-tax income) ($)

Revenue and average assets each appear once in a numerator and once in a denominator, so they cancel and the product collapses to net income divided by average equity. That is why the decomposition is exact rather than approximate.

Updated Category Profitability & Return Ratios Verified against published test cases Reading time 12 min

Why you decompose ROE instead of just quoting it

A single ROE figure hides which of three completely different levers produced it. A company can earn 18% on equity by charging a lot per sale, by turning a small asset base over quickly, or by funding ordinary assets with a lot of other people's money. Those three businesses need different management, carry different risk, and deserve different valuations, yet they report the same headline ratio.

The DuPont identity forces the question open. Multiply net profit margin by total asset turnover by the equity multiplier and the middle terms cancel: revenue appears once above the line and once below it, and so do average assets. What survives is net income over average equity, which is ROE. Because nothing is estimated, the decomposition cannot disagree with the ratio it explains — it can only tell you which factor moved.

The technique is older than most of the ratios around it. Donaldson Brown, working in DuPont's treasury in the early 1910s, split return on investment into margin and turnover so that a plant manager could see which half was his problem. When Brown moved to General Motors the arithmetic went with him, and it has framed return on equity ever since.

The 3-step identity, factor by factor

Net profit margin (net income ÷ revenue) is the income statement in one number: how many cents of every sales dollar survive cost of goods, operating expense, interest and tax. It rises with pricing power, product mix and cost discipline, and it is the factor most exposed to competition. See the net profit margin calculator for the full build-up.

Total asset turnover (revenue ÷ average total assets) is the balance sheet in one number: how much business the asset base supports. As a rule of thumb, high-volume discount grocers run well above 2× while pipelines, hotels and other heavy fixed-asset businesses run below 0.5×. Turnover rises when receivables collect faster, inventory sits for less time, or a plant runs closer to capacity, which is why it is the factor working-capital projects actually move. The total asset turnover calculator works it out from the same two figures.

Multiply those two and you get return on assets — the return the business earns on everything it controls, regardless of who paid for it. ROA is the honest operating scorecard, and it is where any comparison across capital structures has to start.

The equity multiplier (average assets ÷ average equity) is the financing term. A multiplier of 1.00 means shareholders funded every asset; 2.00 means creditors funded half; 12.00 means the company is a bank. It equals 1 plus total liabilities divided by equity, so it moves with every dollar of debt, every lease liability, every payable — not just with borrowings. The debt-to-equity ratio calculator expresses the same fact on a different scale.

The 5-step identity splits margin into three

The extended version keeps turnover and leverage and cuts net margin into the three things that reduce operating profit on its way to the bottom line.

EBIT margin (EBIT ÷ revenue) is operating profitability with financing and tax stripped out — the only margin factor comparable across companies with different debt loads and tax domiciles. Compare it with the operating profit margin calculator.

Interest burden (pre-tax income ÷ EBIT) is the share of operating profit that survives net financing cost whenever EBIT is positive. At 1.00 the company pays no net interest; at 0.83 financing takes a sixth of operating profit; at 0.50 it takes half, and what survives still has to bear tax before a shareholder sees any of it. It is the reciprocal cousin of the interest coverage ratio, and it exceeds 1.00 when interest income outweighs interest expense.

Tax burden (net income ÷ pre-tax income) is one minus the effective tax rate. A US corporation paying the 21% federal statutory rate under IRC §11 and nothing else shows 1 − 0.21 = 0.79; state income taxes push the effective rate higher and the burden factor correspondingly lower, so as a rule of thumb a domestic filer sits somewhat below 0.79.

Here is the point most readers miss: debt appears twice, with opposite signs. Borrowing raises the equity multiplier, which lifts ROE, and lowers the interest burden, which cuts it. Whether leverage helps depends on which effect is larger — that is, on whether the return the assets earn exceeds the after-tax cost of the debt. Only the 5-step identity shows both sides of that trade at once.

Worked example: taking a 23.44% ROE apart

A distributor reports $2,000,000 of revenue, $300,000 of EBIT, $250,000 of pre-tax income and $187,500 of net income. Average total assets are $1,600,000 and average equity is $800,000.

  1. Net profit margin. $187,500 ÷ $2,000,000 = 0.09375 = 9.375%.
  2. Total asset turnover. $2,000,000 ÷ $1,600,000 = 1.25×.
  3. Equity multiplier. $1,600,000 ÷ $800,000 = 2.00×.
  4. 3-step ROE. 9.375% × 1.25 × 2.00 = 23.4375%. Check it directly: $187,500 ÷ $800,000 = 23.4375%. The identity holds exactly.
  5. Return on assets. 9.375% × 1.25 = 11.719%, so leverage supplies the other 11.719 points of ROE.
  6. EBIT margin. $300,000 ÷ $2,000,000 = 15.00%.
  7. Interest burden. $250,000 ÷ $300,000 = 0.8333. Financing consumes one sixth of operating profit.
  8. Tax burden. $187,500 ÷ $250,000 = 0.7500, an effective tax rate of 25.00%.
  9. 5-step ROE. 0.7500 × 0.8333 × 15.00% × 1.25 × 2.00 = 23.4375% again.

Read the ladder from the top and the story is clear. The business converts 15 cents of every sales dollar into operating profit, keeps 12.5 cents after interest, keeps 9.375 cents after tax, earns 11.7% on its assets, and doubles that to 23.4% because half the assets are funded by creditors. If ROE fell next year, exactly one of those five numbers has to have moved, and the ladder tells you which.

Five routes to the same 18% return on equity

Illustrative business models, not survey data. Every row multiplies to exactly 18.0%, which is the whole point: an ROE comparison across these five tells you nothing until you decompose it.
Business modelNet marginAsset turnoverROAEquity multiplierROE
Discount retailer2.5%2.88×7.2%2.50×18.0%
Branded consumer goods10.0%0.90×9.0%2.00×18.0%
Enterprise software18.0%0.50×9.0%2.00×18.0%
Regulated utility12.0%0.30×3.6%5.00×18.0%
Commercial bank25.0%0.06×1.5%12.00×18.0%

The retailer earns its return by moving goods; the software firm by pricing; the utility and the bank by financing. Only the first three are comparable to each other, and only on ROA.

How to read each factor once you have it

Compare against the same company's own history first, then against direct competitors. Cross-industry DuPont comparisons are almost always noise, because margin and turnover trade off systematically: business models that charge a premium carry heavy assets or slow inventory, and the ones that turn assets fast survive on thin margins. What is genuinely informative is a factor moving while the others hold.

Diagnose a change by elimination. If ROE rose and the equity multiplier rose with it while ROA was flat, the improvement was borrowed and it came with risk, not skill. If ROA rose because turnover rose while margin held, the balance sheet got tighter — usually receivables, inventory or an idle asset. If margin rose while EBIT margin was flat, the gain came from tax or financing, neither of which is repeatable at will.

Watch the interest burden and the equity multiplier together. Leverage adds to ROE only while the after-tax return on assets exceeds the after-tax cost of debt. When rates reset upward on floating or maturing debt, the interest burden falls immediately while the multiplier does not, so a highly levered ROE can collapse with nothing changing in the operating business.

Treat a tax burden far from 1 minus the statutory rate as a question. A reading of 0.90 against a 21% federal rate usually means credits, loss carryforwards or a favourable foreign mix; 0.55 often means a valuation allowance or a one-off charge. Neither is a durable advantage, so strip it out before you extrapolate.

What each DuPont factor isolates

The five 5-step factors, the question each one answers, and what moves it.
FactorFormulaWhat it isolatesWhat moves it
Tax burdenNet income ÷ pre-tax income1 − effective tax rateJurisdiction mix, credits, loss carryforwards, one-off charges
Interest burdenPre-tax income ÷ EBITShare of operating profit left after net financing costDebt level, interest rates, interest and other non-operating income
EBIT marginEBIT ÷ revenueOperating profitability, free of tax and financingPricing, mix, gross margin, operating cost leverage
Asset turnoverRevenue ÷ average total assetsSales produced per dollar of assetsReceivable days, inventory days, capacity use, asset-light choices
Equity multiplierAverage assets ÷ average equityHow much of the asset base creditors fundedBorrowing, leases, payables, buybacks, retained earnings

The first two are financing and tax policy, the middle one is operations, the last two are the balance sheet. Only EBIT margin and asset turnover are genuinely about running the business.

Mistakes that break a DuPont analysis

  • Mixing average and closing balances. Use averages for both assets and equity or closing figures for both. Mix them and the multiplier stops equalling assets over equity, and the identity no longer reconciles.
  • Including noncontrolling interests on one side only. If net income is parent-only, equity must be parent-only too. Consolidated equity against parent-only earnings understates ROE and misprices the multiplier.
  • Reading the factors of a loss-making year literally. With negative EBIT and negative pre-tax income, the tax and interest burdens come out positive because two negatives divide. The product is still exact, but those two factors mean nothing.
  • Crediting operations for a leverage-driven ROE. If ROA is flat and ROE is climbing, the balance sheet did the work. Say so.
  • Comparing across industries. Margin and turnover trade off by business model, so only ROA and the individual factors are comparable, and even then only within a sector.
  • Forgetting what a buyback does to the denominators. Repurchasing stock cuts assets and equity by the same dollar amount, which raises the equity multiplier and asset turnover with no operating change at all — and raises ROE too, as long as the company is profitable. In a loss year the same shrunken equity base makes ROE look worse, not better.

Where DuPont stops and ROIC begins

The classic identity has one structural weakness: it mixes operating and financing items on both sides of the ratio. Total assets include cash the business does not need to operate, and net income is already net of interest. So the equity multiplier picks up trade payables, which are operating, alongside term debt, which is financing, and treats them identically.

Two refinements fix this. The first is return on invested capital, which puts after-tax operating profit over the capital actually invested in operations and can be compared directly with a weighted average cost of capital. The second is the reformulated or operating DuPont analysis used in academic financial statement analysis, which restates ROE as return on net operating assets plus financial leverage times the spread between that return and the net borrowing cost.

Use the 3-step identity for a fast read of a moving ROE, the 5-step when financing or tax is the suspect, and ROIC when the question is whether the business creates value rather than how it distributes it. The sustainable growth rate calculator is the natural next step once you trust the ROE: multiply it by the retention ratio for the pace at which the whole structure can grow on its own funding.

Key terms

DuPont identity
An algebraic decomposition of ROE into a product of ratios whose intermediate terms cancel. Exact by construction, not an approximation.
Equity multiplier
Average total assets divided by average shareholders' equity, equal to 1 plus total liabilities over equity. The leverage factor in every version of the identity.
Interest burden
Pre-tax income divided by EBIT. When EBIT is positive it is the fraction of operating profit that survives net financing cost, and it rises above 1.00 when non-operating income exceeds interest expense. When EBIT is negative the ratio is a multiple of the operating loss, not a share retained.
Tax burden
Net income divided by pre-tax income, which is one minus the effective tax rate.
Return on assets
Net income over average total assets, and the product of net margin and asset turnover. The leverage-free part of ROE.
Reformulated DuPont
An operating decomposition that splits the balance sheet into operating and financial items and writes ROE as return on net operating assets plus leverage times spread.

Frequently asked questions

What is the difference between 3-step and 5-step DuPont analysis?

The 5-step version splits net profit margin into three factors — tax burden, interest burden and EBIT margin — and leaves asset turnover and the equity multiplier untouched. Both give an identical ROE. Use the 3-step when you want a quick read on whether a change came from operations, the asset base or financing; use the 5-step when you need to separate operating margin from the tax and interest effects that sit inside net margin.

Should I use average or year-end assets and equity?

Use averages of the opening and closing balances whenever you have both, because income accrues across the period while a balance sheet is a single date. The rule that matters is consistency: whatever basis you pick for assets, use it for equity too, or the equity multiplier stops reconciling and the identity fails to multiply back to ROE.

Can the equity multiplier be less than 1?

Not on a real balance sheet. Assets equal liabilities plus equity, so as long as liabilities are positive, assets exceed equity and the multiplier is above 1.00. A reading below 1.00 means your two figures are on different bases — usually parent-only equity against consolidated assets, or averages on one side and closing balances on the other.

Why is my interest burden greater than 1?

If EBIT is positive, it means pre-tax income exceeds operating profit, which happens whenever non-operating income outweighs interest expense: interest earned on a large cash pile, equity-method earnings, foreign exchange gains or a gain on an asset sale. If EBIT is negative, the reading is the opposite — a factor of 3.0 on a $20,000 operating loss means the pre-tax loss is three times as deep, at $60,000, because interest expense added to it. Either way the identity still multiplies back to ROE exactly; only the interpretation changes with the sign of EBIT.

What does DuPont analysis show that ROE alone does not?

Which lever moved. Two firms at 18% ROE can sit at 2.5% margin with 2.9× turnover or at 25% margin with 0.06× turnover and twelve times leverage. Only the decomposition distinguishes a retailer from a bank, tells you whether last year's improvement was operating or borrowed, and points at the specific ratio a manager can act on. It converts one number you can only compare into five numbers you can investigate.

How do I use DuPont analysis to explain a fall in ROE?

Run every factor for both years and find the one that moved. Hold the others at last year's level and substitute the current year's value one factor at a time; the change in the product at each substitution is that factor's contribution. Watch for offsetting moves — a margin decline hidden by rising leverage is common, and the headline ROE can sit flat while the business deteriorates.

What is a normal equity multiplier?

As a rule of thumb, most non-financial companies sit between about 1.5 and 3.0, meaning creditors funded a third to two thirds of the assets. Capital-intensive regulated businesses commonly run 3 to 5. Banks and insurers operate near 10 to 15, which is how a return on assets near 1% becomes a low-double-digit ROE. Above 5 for an industrial company, check lease liabilities and pension obligations before concluding anything.

Does DuPont analysis work for a company with negative equity?

No. With negative book equity the equity multiplier turns negative and ROE becomes meaningless — a loss divided by negative equity even reports as a positive return. This calculator returns undefined rather than a misleading number. Read the operating factors on their own, then use return on invested capital or return on assets, both of which stay interpretable when accumulated losses have pushed equity below zero.

References

  • International Financial Statement Analysis (CFA Institute Investment Series), 4th ed. — Wiley
  • Analysis for Financial Management — McGraw-Hill (Robert C. Higgins)
  • Financial Statement Analysis and Security Valuation — McGraw-Hill (Stephen H. Penman)
  • Relevance Lost: The Rise and Fall of Management Accounting (Donaldson Brown's return-on-investment formula at DuPont) — Harvard Business School Press (H. Thomas Johnson and Robert S. Kaplan)
  • Regulation S-X, 17 CFR Part 210 (Rule 5-02 and 5-03, balance sheet and income statement captions)U.S. Securities and Exchange Commission
  • Internal Revenue Code § 11, Tax imposed on corporations (21% statutory rate) — 26 U.S.C. §11