biz-dupont

DuPont Analysis

Overview

DuPont decomposes ROE into three multiplicative components: Net Profit Margin × Asset Turnover × Equity Multiplier. This reveals whether ROE is driven by profitability, efficiency, or leverage — critical for diagnosis and comparison.

When to Use

Trigger conditions:

• User asks "why is our ROE high/low?"
• User comparing financial performance across companies
• User needs to identify which operational lever improves returns
• User analyzing profitability beyond top-line metrics

When NOT to use:

• For company valuation → use DCF
• For comprehensive ratio analysis → use Financial Ratios skill
• For strategic positioning → use SWOT

Framework

IRON LAW: Three-Factor Decomposition

ROE = Net Profit Margin × Asset Turnover × Equity Multiplier
    = (Net Income/Revenue) × (Revenue/Total Assets) × (Total Assets/Equity)

All three factors MUST be calculated and analyzed. Reporting ROE without
decomposition is like reporting a fever without checking symptoms.

IRON LAW: High Leverage ≠ Good Performance

A high Equity Multiplier (Assets/Equity) inflates ROE through debt.
A company with 5% margin, 1.0x turnover, and 6x leverage has ROE of 30% —
but is one bad quarter away from insolvency. Always flag when leverage
is the dominant driver.

Step 1: Calculate the Three Components

Component	Formula	What It Measures
Net Profit Margin	Net Income / Revenue	Profitability — how much of each dollar of revenue becomes profit
Asset Turnover	Revenue / Total Assets	Efficiency — how well assets generate revenue
Equity Multiplier	Total Assets / Shareholders' Equity	Leverage — how much debt amplifies equity returns

Step 2: Diagnose the Driver

Compare each component to industry benchmarks and trends:

• Margin-driven ROE: Premium brands, tech companies (high margin, lower turnover)
• Turnover-driven ROE: Retail, fast food (low margin, high turnover)
• Leverage-driven ROE: Banks, real estate (moderate margin, high leverage) — flag the risk

Step 3: Trend Analysis

Calculate DuPont components for 3-5 years. Identify:

• Which component is improving/declining?
• Is improving ROE driven by operations (margin, turnover) or financial engineering (leverage)?

Step 4: Peer Comparison

Compare DuPont components across competitors to identify relative strengths/weaknesses.

Output Format

⚠️ Decimal vs percent: The bundled script returns ROE and all margin/burden components as decimals (0.2014 means 20.14%, NOT 20.14). The narrative table below renders them as percentages for humans, but JSON outputs and any downstream pipeline must use decimals consistently.

# DuPont Analysis: {Company}

## ROE Decomposition

| Component | Value | Industry Avg | Trend (3yr) |
|-----------|-------|-------------|-------------|
| Net Profit Margin | X% | X% | ↑/↓/→ |
| Asset Turnover | X.Xx | X.Xx | ↑/↓/→ |
| Equity Multiplier | X.Xx | X.Xx | ↑/↓/→ |
| **ROE** | **X%** | **X%** | ↑/↓/→ |

## Diagnosis
- Primary ROE driver: {margin / turnover / leverage}
- Risk flag: {leverage concern if applicable}

## Peer Comparison
| Company | Margin | Turnover | Leverage | ROE |
|---------|--------|----------|----------|-----|
| {Company} | X% | X.Xx | X.Xx | X% |
| {Peer A} | ... | ... | ... | ... |

## Recommendations
1. {Which lever to improve and how}

Examples

Correct Application

Scenario: DuPont for two Taiwanese retailers

	Company A	Company B
Net Profit Margin	2%	8%
Asset Turnover	3.5x	1.2x
Equity Multiplier	2.0x	2.0x
ROE	14%	19.2%

Diagnosis: Company A is turnover-driven (high-volume, low-margin retail). Company B is margin-driven (premium positioning). Both have similar leverage — ROE difference comes from operations ✓

Incorrect Application

• ROE is 25% and reported as "excellent" without decomposition. Turns out: Margin 3%, Turnover 1.0x, Leverage 8.3x → Almost entirely leverage-driven, extremely risky. Violates Iron Law: must decompose.

Gotchas

• Extended 5-factor DuPont: For deeper analysis, decompose margin into Tax Burden × Interest Burden × Operating Margin. Useful when comparing across tax jurisdictions.
• Negative equity breaks the model: Companies with accumulated losses can have negative equity, making the multiplier meaningless. Note and use alternative metrics.
• One-time items distort margin: Use normalized/adjusted net income to avoid single-year spikes from asset sales, write-downs, or legal settlements.
• Turnover varies wildly by industry: Asset-light businesses (SaaS) have naturally high turnover. Capital-heavy businesses (manufacturing) have low turnover. Compare within industry only.

Scripts

Script	Description	Usage
scripts/dupont.py	Decompose ROE into 3-factor or 5-factor DuPont components	python scripts/dupont.py --help

Run python scripts/dupont.py --verify to execute built-in sanity tests.

References

• For 5-factor DuPont extension, see references/extended-dupont.md