DuPont Analysis: Formula, Example, and ROE Breakdown

DuPont analysis breaks return on equity (ROE) into three drivers—profit margin, asset turnover, and financial leverage—so finance teams can see why ROE changed, not just that it did. This guide covers the 3-step and 5-step formulas, a worked calculation example, interpretation frameworks, common limitations, and how to build a DuPont dashboard in FineBI that turns ratio analysis into management-ready insight.

What Is DuPont Analysis?

DuPont analysis is a financial framework that decomposes ROE into component ratios, revealing whether profitability comes from operating efficiency, asset utilization, or capital structure. It was developed in 1919 by Donaldson Brown at DuPont Corporation and remains a standard tool in corporate finance, credit analysis, and executive performance review.

Unlike simple ROE, which gives a single number, DuPont analysis answers diagnostic questions:

• Did ROE improve because margins expanded or because the company took on more debt?
• Is a declining ROE caused by falling sales productivity or rising leverage risk?
• How does our ROE driver mix compare to industry peers?

The most common version is the 3-step DuPont model. A more granular 5-step version separates tax and interest effects for deeper analysis. Both are covered below with formulas and examples.

DuPont Analysis Formula

3-Step DuPont Formula

The 3-step model breaks ROE into three multiplicative components:

ROE = Net Profit Margin × Asset Turnover × Equity Multiplier

Expanded with underlying accounting figures:

ROE = (Net Income / Sales) × (Sales / Average Total Assets) × (Average Total Assets / Average Shareholders' Equity)

5-Step DuPont Formula

The 5-step model further decomposes net profit margin into tax burden, interest burden, and EBIT margin:

ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Equity Multiplier

Where:

• Tax Burden = Net Income ÷ Earnings Before Tax (EBT)
• Interest Burden = EBT ÷ EBIT
• EBIT Margin = EBIT ÷ Sales
• Asset Turnover = Sales ÷ Average Total Assets
• Equity Multiplier = Average Total Assets ÷ Average Shareholders' Equity

The 5-step version is useful when comparing companies with different tax jurisdictions or capital structures, as it isolates operating performance from financing and tax effects.

3-Step DuPont Analysis Example

Consider a company with the following annual figures:

Step-by-step calculation:

Verification: Direct ROE = Net Income ÷ Equity = $3M ÷$10M = 30%. The DuPont decomposition matches.

What this tells us: This company's 30% ROE is driven primarily by leverage (2.0× multiplier) and solid asset efficiency (1.5× turnover), while its profit margin (10%) is moderate. If ROE declines next quarter, management should check whether margin compression or asset bloat is the cause—not assume profitability itself deteriorated.

5-Step DuPont Analysis Formula

Using the same company, assume additional data:

The 5-step breakdown reveals that interest expense reduces pre-tax earnings by ~11%, and taxes consume 25% of pre-tax income. If management wants to improve ROE without increasing leverage, improving EBIT margin (operational efficiency) or reducing interest burden (refinancing) are the levers to pull.

How to Interpret DuPont Analysis Results

A DuPont decomposition is only useful if it drives action. Use this interpretation framework:

Cross-period comparison is essential. A single snapshot shows structure; trend analysis shows direction. Build dashboards that display at least 4–8 quarters of each component alongside ROE.

Peer benchmarking adds context. Industry norms vary significantly: retail typically shows high turnover with low margins, while software shows high margins with lower turnover. Compare within the same sector for meaningful conclusions.

DuPont Analysis vs Simple ROE

Simple ROE is adequate for quick screening. DuPont analysis is necessary when you need to explain why performance changed and what to do about it.

When to Use DuPont Analysis

DuPont analysis is most valuable in these situations:

• Quarterly/annual performance reviews. Explain ROE movement to boards and executives with driver-level clarity.
• Credit analysis and lending decisions. Lenders assess whether ROE is supported by sustainable operations or excessive leverage.
• M&A due diligence. Decompose target company ROE to identify hidden risks or improvement opportunities.
• Internal benchmarking. Compare business units or subsidiaries with different capital structures on an apples-to-apples basis.
• Investor relations. Communicate profitability strategy with specificity rather than generic statements.
• Turnaround diagnosis. Identify whether declining returns stem from operational deterioration or financial restructuring needs.

Limitations of DuPont Analysis

DuPont analysis is powerful but not sufficient alone. Be aware of these constraints:

Use DuPont analysis as a diagnostic starting point, not a standalone verdict.

How to Build a DuPont Analysis Dashboard in FineBI

A static spreadsheet captures a single period. A FineBI dashboard makes DuPont analysis interactive, trend-aware, and shareable across finance and management teams.

What an Effective DuPont Dashboard Shows

• ROE waterfall chart. Visual decomposition showing how margin, turnover, and leverage contributed to total ROE change between periods.
• Component trend lines. 8-quarter history of net profit margin, asset turnover, and equity multiplier plotted alongside ROE.
• Driver contribution bars. Stacked bar chart showing each component's proportional impact on ROE movement.
• Peer benchmark overlay. Industry median lines for each component to contextualize performance.
• Drill-down by segment. Business unit, region, or product line breakdown to pinpoint where driver changes originate.
• Alert thresholds. Conditional formatting flags when any component breaches predefined warning levels.

Key Design Principles

1. Lead with the question. The dashboard title should be "Why Did ROE Change?" not "DuPont Analysis." Frame every widget around a specific diagnostic need.
2. Show change, not just level. Absolute values matter less than deltas. Highlight period-over-period and year-over-year movements.
3. Enable self-service exploration. Allow users to filter by entity, period, and segment without requesting new reports. FineBI's drag-and-drop interface supports this natively.
4. Connect to live data. Use FineDataLink to automate ETL from ERP and financial systems, ensuring dashboards reflect actuals without manual uploads.
5. Separate summary from detail. Executive view shows ROE and three drivers. Analyst view adds 5-step breakdown, segment drill-down, and peer comparison.

For fixed-format financial reports (P&L, balance sheet, regulatory filings), complement dashboards with FineReport.

From DuPont Dashboards to AI Financial Analysis

A DuPont dashboard shows whether ROE changed because of margin, asset efficiency, or leverage. Finance and management teams often need the next layer: why a specific driver moved, which business unit is responsible, and what explanation to present to leadership.

Dora operates as an AI analysis layer on top of governed DuPont dashboards and financial reports built in FineBI and FineReport. It does not generate investment advice or replace analyst judgment. Instead, it accelerates the path from visibility to explanation:

• Natural-language follow-up. Ask "Why did asset turnover decline in Q2?" and receive a narrative summary grounded in actual dashboard data and underlying transactions.
• ROE change summaries. Automatically generate period-over-period or business-unit comparisons explaining which drivers contributed to or detracted from ROE.
• Anomaly detection. Flag unusual movements in any DuPont component that deviate from historical patterns or peer benchmarks, with contextual explanations.
• Management-ready briefings. Produce concise, structured narratives suitable for CFO reviews, board decks, or investor communications—based on trusted, governed data sources.
• Consistent metric definitions. All Dora responses reference the same calculated fields and data lineage as your FineBI dashboards, eliminating version conflicts.

DuPont analysis identifies the driver. Dora helps teams articulate the story behind it.