Scenario presets
Income Statement & Balance Sheet Inputs
Profitability & DuPont Metrics
Calculating ROE...
- Return on Equity (ROE)
- -
- Return on Assets (ROA)
- -
- Net Profit Margin
- -
- Asset Turnover ratio
- -
- Equity Multiplier (Financial Leverage)
- -
- Sustainable Growth Rate (SGR)
- -
- Retention ratio (1 - Payout)
- -
- Financial leverage risk tier
- -
DuPont 3-Step & 5-Step Decomposition Table
Isolating tax efficiency, interest burden, core operating margins, asset utilization, and financial leverage.
| DuPont Driver | Formula Component | Calculated Value | Evaluation & Economic Significance |
|---|
Sensitivity Analysis 1: Net Profit Margin vs. Asset Turnover on ROA (%)
Operating engine efficiency: Return on Assets before the application of financial leverage.
| Net Margin \ Turnover | 0.75x | 1.00x | 1.25x (Base) | 1.50x | 1.75x |
|---|
Sensitivity Analysis 2: Return on Assets (ROA) vs. Equity Multiplier on ROE (%)
Financial leverage magnification: how debt gearing amplifies return on shareholders' equity.
| ROA % \ Equity Multiplier | 1.25x | 1.50x | 2.00x (Base) | 2.50x | 3.00x |
|---|
Formulas and worked example
- Return on Equity (ROE) = Net Income / Shareholders' Equity
- Return on Assets (ROA) = Net Income / Total Assets = Net Margin × Asset Turnover
- 3-Step DuPont = Net Margin × Asset Turnover × Equity Multiplier
- 5-Step DuPont = $(\text{Net Income}/\text{EBT}) \times (\text{EBT}/\text{EBIT}) \times (\text{EBIT}/\text{Rev}) \times (\text{Rev}/\text{Assets}) \times (\text{Assets}/\text{Equity})$
- Tax Burden = Net Income / EBT; Interest Burden = EBT / EBIT; EBIT Margin = EBIT / Revenue
- Sustainable Growth Rate (SGR) = $\text{ROE} \times (1 - \text{Payout Ratio})$
A business produces $10,000,000 in revenue, $1,800,000 in EBIT, $1,500,000 in EBT, and $1,200,000 in Net Income against $8,000,000 in assets and $4,000,000 in equity. Net profit margin is 12.0%, asset turnover is 1.25x, and the equity multiplier is 2.00x (50% debt-to-assets). ROA is 15.0% ($12.0\% \times 1.25$). Financial leverage magnifies ROA by 2.0x, resulting in an ROE of 30.0% ($15.0\% \times 2.0$). Retaining 70% of earnings yields a sustainable annual growth rate of 21.0% without requiring external equity dilution.
Self-check quiz
1. In the 3-step DuPont model, Return on Equity is the product of:
2. If Company X increases its debt borrowing while operating profits remain constant, its Equity Multiplier will:
3. A company has an 8.0% Net Margin, 1.5x Asset Turnover, and an Equity Multiplier of 1.5x. Its ROE is:
4. The Sustainable Growth Rate (SGR) measures the rate a firm can grow without:
Frequently asked questions
What is Return on Equity (ROE) and what does it measure?
Return on Equity (ROE) is the ratio of annual Net Income to Shareholders' Equity. It measures management's efficiency at generating profits per dollar of net assets funded by equity shareholders, serving as a primary benchmark for shareholder value creation.
How does the 3-step DuPont framework decompose Return on Equity?
The 3-step DuPont formula breaks ROE into three operational components: Net Profit Margin (Net Income / Revenue, measuring pricing power and cost efficiency), Asset Turnover (Revenue / Total Assets, measuring capital productivity), and the Equity Multiplier (Total Assets / Shareholders' Equity, measuring financial leverage).
Why can a high ROE sometimes be a warning sign rather than good news?
A high ROE is not always driven by operating excellence. If a company takes on excessive debt, its equity base shrinks relative to total assets, boosting the Equity Multiplier and artificially inflating ROE. If operating cash flows falter, high debt leverage dramatically increases bankruptcy risk.
What is the Sustainable Growth Rate (SGR) and how does ROE determine it?
The Sustainable Growth Rate (SGR = ROE * (1 - Dividend Payout Ratio)) is the maximum annual percentage sales growth a business can achieve without issuing new dilutive equity or taking on disproportionate debt. A higher ROE combined with earnings retention accelerates internal reinvestment capacity.