DuPont Analysis Calculator (3 + 5 Factor ROE)

Share:

DuPont analysis calculator. 3-factor + 5-factor ROE decomposition: net margin × asset turnover × equity multiplier. Reveals where return on equity comes from — operating efficiency, asset use, or financial leverage.

RT-FIN-231 · Finance & Money

DuPont Analysis Calculator

Income statement ($M)
total sales
for 5-factor only
EBIT − interest expense
Bottom line + balance sheet ($M)
after-tax bottom line
avg of beginning + ending
avg of beginning + ending
Advertisement
After results · AD-W1Responsive · Post-tool — peak engagement

How to use the DuPont analysis calculator

Enter revenue, EBIT, EBT

Revenue: top-line sales. EBIT: operating income before interest + tax. EBT: pre-tax income (EBIT − interest expense). All from the income statement. The 3-factor DuPont only needs revenue + net income; the 5-factor variant adds EBIT and EBT to decompose net margin into tax × interest × operating components.

Enter net income + assets + equity

Net Income: bottom-line earnings after tax. Total Assets: from the balance sheet — preferably average of beginning and ending values. Shareholders' Equity: also from balance sheet, also averaged. Average values prevent distortion from material capital structure changes during the period.

Read 3-factor decomposition

Net Margin × Asset Turnover × Equity Multiplier = ROE. Three sources of ROE: (1) Net margin — how much profit per dollar of sales. (2) Asset turnover — how efficiently assets generate sales. (3) Equity multiplier — how much leverage. A company with 50% ROE can get there via 25% margins × 1.0 turnover × 2.0 leverage OR 5% margins × 5.0 turnover × 2.0 leverage. Same ROE, very different businesses.

Read 5-factor extended decomposition

The 5-factor splits net margin further. Tax Burden (NI/EBT) ≈ (1 − effective tax rate). Interest Burden (EBT/EBIT) shows how much pre-tax income survives interest expense. Operating Margin (EBIT/Revenue) is the core profitability. This reveals whether ROE is driven by operating quality vs financial engineering.

Interpret the driver profile

The "Profile" + "Quality" boxes tag your firm. High-margin + high-turnover + low-leverage = exceptional sustainable ROE (Apple historically). High-leverage-driven ROE = warning sign for sustainability (regional banks before 2008). Match these patterns to industry benchmarks via Damodaran's industry-average DuPont tables.

Advertisement
After how-to · AD-W2Responsive

DuPont analysis — the 1920s framework still taught at every business school

DuPont analysis is one of the oldest pieces of financial analysis still in active use. Developed by a young financial analyst named Donaldson Brown at the DuPont Corporation in 1914 (later adopted by General Motors when DuPont controlled GM), it answers a deceptively simple question: why does this company earn a certain return on equity? Two companies can have identical 15% ROE for completely different reasons. Company A: 30% net margins, 0.5× asset turnover, 1.0× equity multiplier — a high-margin asset-light brand like LVMH or Coca-Cola. Company B: 2% net margins, 5× asset turnover, 1.5× leverage — a low-margin high-volume retailer like Walmart. Same ROE, opposite business models. DuPont decomposition makes the comparison legible.

The 3-factor framework

ROE = (NI/Revenue) × (Revenue/Assets) × (Assets/Equity). Three multiplicative pillars. Net margin — pricing power and operating discipline. High margins indicate strong competitive moat (Apple, LVMH, ASML, Visa). Asset turnover — how productively the firm uses its capital. High turnover indicates lean operations and efficient asset management (Walmart, Costco, lean industrials). Equity multiplier (Assets/Equity, same as 1 + D/E) — financial leverage. Higher multiplier amplifies returns but also amplifies risks. The genius of DuPont: it shows you exactly which pillar produces the firm\'s ROE, and therefore where its strength lies and where it\'s fragile.

Two companies with 15% ROE can be radically different. DuPont shows you whether it\'s a high-margin brand business, a high-turnover retailer, or a leverage-amplified bank. Same number, three completely different bets.

The 5-factor extension

The 5-factor variant splits net margin into tax burden × interest burden × operating margin. This separates operating performance (operating margin) from financing decisions (interest burden, via leverage) and tax planning (tax burden). For credit analysis especially, the 5-factor view is more useful — you can see exactly how much of net margin compression comes from rising interest expense vs operating headwinds. CFA Level 1 introduces the 3-factor model; Level 2 expects mastery of the 5-factor decomposition for ratio analysis questions.

Industry benchmarks via DuPont

Damodaran publishes industry-average DuPont decompositions annually for 90+ industries. Typical patterns: Tech (software): high margin (25-35%), moderate turnover (0.5-0.8), low-moderate leverage (1.3-1.8). Banks: low margin (15-25%), low turnover (~0.06 due to massive assets), very high leverage (10-15×) — banks earn ROE primarily via leverage. Retail: low margin (2-5%), high turnover (2-4×), moderate leverage (2-3×). Utilities: moderate margin (8-12%), low turnover (0.3-0.5), high leverage (3-4×) — utilities resemble banks more than tech in their DuPont structure. For ASEAN: regional firms have similar industry-level patterns but with material variation due to capital intensity, regulatory environment, and currency effects.

10 Things to Know About DuPont

01

Donaldson Brown invented DuPont analysis in 1914 at the DuPont Corporation. Adopted by General Motors when DuPont controlled GM. Used continuously since.

02

3-factor: ROE = Margin × Turnover × Leverage. The textbook formula every business student learns.

03

5-factor: splits net margin into Tax × Interest × Operating. Reveals operating vs financing drivers.

04

Tech firms: high margin, moderate turnover, low leverage. Apple, Microsoft, ASML, Visa typical.

05

Banks: low margin, very low turnover, very high leverage (10-15× multiplier). Earn ROE via balance-sheet leverage.

06

Retail: low margin, high turnover, moderate leverage. Walmart, Costco typical. Operating efficiency model.

07

ROE = ROA × Equity Multiplier. If equity multiplier > 3, ROE is partly leverage-amplified. Check sustainability.

08

Use average assets and equity (avg of beginning + ending), not point-in-time. Avoids distortion from material capital structure changes.

09

Equity multiplier = 1 + D/E. A firm with D/E of 2.0 has equity multiplier 3.0. Same leverage, different expression.

10

Damodaran publishes industry-average DuPont decompositions annually. Useful benchmarks at pages.stern.nyu.edu/~adamodar/.

Frequently asked questions

  • Because the same 15% ROE can mean wildly different things. A 15% ROE driven by 25% margins and modest leverage is a sustainable franchise business (LVMH, Hermès). A 15% ROE driven by 3% margins, 5× turnover, and 1× leverage is a high-volume operations business (Walmart, Costco). A 15% ROE driven by 8% margins, 1× turnover, and 1.9× leverage is a moderately-leveraged mature industrial. Each has different competitive risks, different cash flow profiles, different valuation multiples. DuPont decomposition lets you compare like-for-like and identify which kind of business you\'re really looking at.

  • Always average (mean of beginning + ending balance). The income statement reports a flow over a 12-month period; the balance sheet is a snapshot at a point in time. Using year-end balances overstates assets/equity used during the year (they\'ve typically grown), which artificially deflates ratios. Average balances match the flow concept. This is the CFA Institute\'s recommended method and the standard in equity research.

  • One driven by operating excellence (high margins + high turnover) rather than financial leverage. A 20% ROE from 12% margins × 1.5 turnover × 1.1 leverage is high-quality — the business genuinely creates value. A 20% ROE from 4% margins × 1.5 turnover × 3.3 leverage is leverage-amplified — the underlying business is mediocre, and the ROE will collapse if interest rates rise or debt covenants tighten. Buffett famously avoids leverage-driven ROE; he wants ROE from competitive moats, not balance sheet engineering.

  • Banks are inherently leveraged businesses. They take deposits (liabilities) and make loans (assets). For every $1 of equity, banks typically hold $10-15 in assets — equity multiplier of 10-15×. This leverage allows banks to generate 10-15% ROE on what would otherwise be a very low-margin spread business (net interest margin of 2-4%). Regulatory capital rules (Basel III) set minimum equity-to-asset ratios; banks operate close to those minimums to maximise ROE. DuPont for banks is dominated by the multiplier; comparing bank-to-bank DuPont can\'t reveal much because all banks have similar multipliers and the variation is in NIM efficiency.

  • ROE = NI / Equity. The return on shareholder capital — what shareholders earn. ROA = NI / Assets. The return on all capital (debt + equity). ROE = ROA × Equity Multiplier. A firm with high equity multiplier amplifies ROA into higher ROE. ROA is the cleaner measure of operating quality because it isn\'t distorted by capital structure decisions. Bank analysts often emphasise ROA over ROE precisely because bank ROE is dominated by leverage. For most non-financial comparisons, both ROE and ROA matter.

  • For year-over-year analysis of margin compression. If net margin drops from 12% to 8%, the 3-factor model can\'t tell you why. The 5-factor reveals: maybe operating margin held but interest burden grew (rising rates), maybe tax burden changed (tax law), maybe operating margin compressed (real business issue). Different causes have different valuation implications. Also useful for cross-jurisdictional comparison — companies in different tax regimes have different tax burdens but similar operating performance; the 5-factor disentangles them.

  • ROIC = NOPAT / Invested Capital = NOPAT / (Debt + Equity − Cash). Different conceptually from ROE because ROIC uses NOPAT (the unlevered operating return) and includes debt + equity in the denominator. ROIC measures capital efficiency regardless of how the firm is financed; ROE measures shareholder return given the existing financing. Both useful: ROIC for evaluating capital allocation skill, ROE for evaluating equity-investor outcomes. McKinsey\'s "Valuation" textbook prefers ROIC; CFA traditionally emphasises ROE/DuPont. Use both for comprehensive analysis.

  • No. Revenue, EBIT, EBT, net income, assets, equity — every input stays in your browser. The 3-factor + 5-factor decomposition runs as client-side JavaScript. Open DevTools → Network when you click Run and you\'ll see zero outbound requests. Safe for confidential equity research.

  • Standard reference: Brealey-Myers-Allen, Principles of Corporate Finance, Ch.28. CFA Institute Level 1 Financial Reporting and Analysis curriculum has full DuPont coverage. Penman SH, Financial Statement Analysis and Security Valuation for the deep rigorous treatment. Damodaran\'s data archive (pages.stern.nyu.edu/~adamodar/) has industry-average DuPont decompositions updated annually. Original 1914 framework is documented in Brown\'s autobiography Some Reminiscences of an Industrialist.

  • Yes — the framework is universal. For ASEAN banks (DBS, OCBC, Maybank, BCA): expect high equity multipliers (typically 8-12×), with ROE in 10-15% range. ASEAN consumer staples (Nestlé Malaysia, Indofood): moderate margin, moderate turnover, low leverage — similar to global consumer staples. Singapore REITs: high turnover (rental income), moderate leverage (regulator-capped), modest margins after CapEx — a structurally lower-ROE format relative to operating companies but more predictable. Use the same Damodaran-style benchmarks adjusted for regional industry mix.

Related News

You may be interested in these recent stories from our newsroom.

View all news →
Advertisement
Pre-footer · AD-W3 728 × 90

75 more free tools

Calculators, converters, security tools — no signup.