SOLVETUTORMATH SOLVER

Instrument MI-02-186 · Finance

DuPont Analysis Calculator

Enter net margin, asset turnover, and the equity multiplier. The instrument multiplies the three into return on equity and shows which one is doing the work.

Instrument MI-02-186
Sheet 1 OF 1
Rev A
Verified
Type 02 — Investing SER. 2026-02186

Return on equity, %

30.0000

ROE = net margin × asset turnover × equity multiplier

The working Every figure verified twice
  1. roe = 10·1.5·2 = 30.0000
Worksheet log
  1. No entries yet — change an input to log a scenario.

How this instrument works

Return on equity collapses a company's whole performance into one percentage, which is exactly what makes it dangerous to read alone: two firms can post the same ROE for opposite reasons. DuPont analysis, worked out inside the DuPont company's treasury department by Donaldson Brown around 1920 and later carried by him into General Motors, reopens that single number into three separate levers — how much profit survives each dollar of sales, how hard the assets work to generate sales, and how much of the asset base is financed by debt rather than shareholders' money.

The three pieces multiply back to the original ROE because revenue and total assets cancel out algebraically: net income over revenue, times revenue over assets, times assets over equity, leaves net income over equity. Nothing new is computed — the identity just refuses to let profitability, efficiency, and leverage hide inside a single figure. A grocery chain and a regional bank can both report a 12% ROE while sitting at opposite ends of every one of these three ratios.

The decomposition is only as sound as the inputs behind it. Net margin, turnover, and the multiplier all come from a specific accounting period's book figures, so a one-off asset sale, a share buyback, or a write-down can swing the equity multiplier or the margin without reflecting how the business actually runs day to day. Analysts typically check a few consecutive periods rather than trust one snapshot.

ROE=margin×turnover×multiplier\text{ROE} = \text{margin} \times \text{turnover} \times \text{multiplier}ROE=NIRev×RevAssets×AssetsEquity\text{ROE} = \frac{NI}{Rev} \times \frac{Rev}{Assets} \times \frac{Assets}{Equity}
ROE — return on equity · net margin — net income ÷ revenue · asset turnover — revenue ÷ total assets · equity multiplier — total assets ÷ shareholders' equity, the leverage term. Revenue and assets cancel algebraically, leaving net income ÷ equity, the same ROE reached directly.
  • Enter Net profit margin, % — net income divided by revenue for the period you are studying.
  • Enter Asset turnover — revenue divided by total assets, how many dollars of sales each dollar of assets produces.
  • Enter Equity multiplier — total assets divided by shareholders' equity, the leverage term.
  • Read Return on equity, % — the product of all three — then change one input at a time to see which lever actually moves it.
  • Rerun the sheet with a peer company's three ratios; a matching ROE built from a different mix is the whole point of the exercise.

Worked example — 10% margin, 1.5x turnover, 2x leverage

A company posts a 10% net profit margin, turns its assets over 1.5 times a year, and carries an equity multiplier of 2, meaning its assets are twice its shareholders' equity. Multiply the three: 10% × 1.5 × 2 = 30% return on equity. Each factor is unremarkable on its own — a 10% margin and modest 2x leverage are both ordinary — yet stacked together they produce a return most single-digit-margin businesses could not reach without one of the other two levers doing extra work.

Compare that against a different route to the same headline number: a thin 3% margin, 2x turnover, and a heavier 5x equity multiplier also multiplies out to 30% ROE. Both companies would report an identical return on equity, but the first earns it mostly from profitability and modest leverage while the second leans hard on debt financing to get there. A lender or a shareholder reading only the ROE line would miss that the second business carries far more balance-sheet risk for the same reported result.

Questions

Why decompose ROE instead of just reporting the one number?

Because the single figure hides how it was earned. A rising ROE driven by fatter margins reflects operating improvement; the same rise driven by a climbing equity multiplier reflects added debt. The two carry very different risk, and only the three-way split tells them apart.

Can two companies really have the same ROE for different reasons?

Yes, and it is the most common misreading of the ratio. A software firm might reach 30% ROE mainly through a high net margin with almost no leverage, while a retailer with thin 3% margins reaches the same 30% through fast asset turnover and heavier borrowing. Comparing only the headline ROE across the two tells you nothing about which is riskier.

What counts as a high equity multiplier?

It depends entirely on the industry. Retailers and industrial firms often run multipliers of 1.5 to 3; banks routinely sit at 8 to 12 because deposits and borrowed funds finance most of their assets. A multiplier that looks alarming for a manufacturer can be ordinary for a lender, so compare within the same sector rather than against a fixed rule.

Is a rising ROE always good news?

Not automatically. If the increase traces back to net margin or asset turnover, the business is likely doing more with what it has. If it traces back to the equity multiplier, the company has simply taken on more debt relative to equity, which raises the fixed obligations it must cover even in a weak year. This sheet shows which of the three moved.

What is the difference between this and the extended, five-step DuPont model?

This three-step version splits ROE into margin, turnover, and leverage. The extended model further splits net margin into a tax-burden ratio and an interest-burden ratio sitting on top of operating margin, isolating how much of pre-tax profit taxes and interest expense remove before it reaches the net-income line.

Does the calculation use book values or market values?

Book values throughout — net income and revenue from the income statement, assets and equity from the balance sheet at accounting cost, not what the market thinks the company is worth. That makes the ratio comparable across ordinary reporting periods, but it will not match valuation multiples built on market capitalization.

References

Read this first: This instrument shows arithmetic, not advice. Real offers add fees, taxes and terms that vary by lender and place — verify the figures against your actual paperwork before deciding anything.