Loading...
Loading...
Decompose Return on Equity into component ratios to identify performance drivers. Use for financial analysis, performance benchmarking, and identifying improvement opportunities.
npx skill4agent add linuszz/business-strategy-planning-skills dupont-analysisROE = Net Profit Margin × Asset Turnover × Financial Leverage
Where:
- ROE = Net Income / Shareholders' Equity
- Net Profit Margin = Net Income / Revenue
- Asset Turnover = Revenue / Total Assets
- Financial Leverage = Total Assets / Shareholders' EquityROE = Tax Burden × Interest Burden × Operating Margin × Asset Turnover × Leverage
Where:
- Tax Burden = Net Income / EBT (Keep vs. Government)
- Interest Burden = EBT / EBIT (Creditors vs. Equity)
- Operating Margin = EBIT / Revenue (Operations Efficiency)
- Asset Turnover = Revenue / Total Assets (Asset Efficiency)
- Financial Leverage = Total Assets / Equity (Capital Structure)ROE (Return on Equity)
├── ROA (Return on Assets)
│ ├── Net Profit Margin
│ │ ├── Gross Margin
│ │ │ ├── Revenue
│ │ │ └── COGS
│ │ ├── Operating Expenses
│ │ │ ├── SG&A
│ │ │ ├── R&D
│ │ │ └── Depreciation
│ │ ├── Interest Expense
│ │ └── Taxes
│ └── Asset Turnover
│ ├── Revenue
│ └── Total Assets
│ ├── Current Assets
│ │ ├── Cash
│ │ ├── Receivables
│ │ └── Inventory
│ └── Non-Current Assets
│ ├── PP&E
│ └── Intangibles
└── Financial Leverage
├── Total Assets
└── Shareholders' Equity
├── Common Stock
└── Retained Earnings## DuPont Analysis: [Company]
### Summary Metrics
| Metric | Value | Industry Avg | Assessment |
|--------|-------|--------------|------------|
| ROE | X% | Y% | ⬆️/⬇️/➡️ |
| ROA | X% | Y% | ⬆️/⬇️/➡️ |
| Net Profit Margin | X% | Y% | ⬆️/⬇️/➡️ |
| Asset Turnover | X | Y | ⬆️/⬇️/➡️ |
| Financial Leverage | X | Y | ⬆️/⬇️/➡️ |
### 3-Way Decomposition
### 5-Way Decomposition (Extended)
| Component | Value | Interpretation |
|-----------|-------|----------------|
| Tax Burden | X% | % of profit kept after tax |
| Interest Burden | X% | % of EBIT left after interest |
| Operating Margin | X% | Core business profitability |
| Asset Turnover | X | Revenue per dollar of assets |
| Leverage | X | Assets per dollar of equity |
| **ROE** | **X%** | **Result** |
### Driver Analysis
**What's driving ROE?**
| Driver | Impact | Trend | Action Needed |
|--------|--------|-------|---------------|
| [Driver 1] | ⬆️ Positive | Improving | Continue |
| [Driver 2] | ⬆️ Positive | Stable | Maintain |
| [Driver 3] | ⬇️ Negative | Worsening | Address |
| [Driver 4] | ⬇️ Negative | Stable | Improve |
### Improvement Opportunities
**To improve Net Profit Margin:**
1. [Opportunity 1]
2. [Opportunity 2]
**To improve Asset Turnover:**
1. [Opportunity 1]
2. [Opportunity 2]
**To optimize Capital Structure:**
1. [Opportunity 1]
2. [Opportunity 2]
### Peer Comparison
| Company | ROE | NPM | AT | FL | Strategy |
|---------|-----|-----|----|----|----------|
| [Subject] | X% | Y% | Z | W | [Description] |
| Peer A | X% | Y% | Z | W | [Description] |
| Peer B | X% | Y% | Z | W | [Description] |
| Industry Avg | X% | Y% | Z | W | - |