DuPont Analysis Calculator

The DuPont analysis calculator breaks return on equity into three operating drivers: net profit margin, total asset turnover, and financial leverage. ROE alone tells you how much profit a company earned relative to shareholders’ equity. DuPont analysis explains how that return was produced.

That distinction matters. A retailer, software company, bank, and manufacturer can report similar ROE while relying on very different economics. One company may earn a high margin on each sale. Another may accept thin margins but turn assets quickly. A third may amplify returns with debt-funded assets. This calculator separates those effects so you can compare the quality, repeatability, and risk behind the headline percentage.

Formula

The calculator uses the three-part DuPont identity:

$\text{ROE} = \text{net profit margin} \times \text{total asset turnover} \times \text{financial leverage}$

Each component is calculated from the inputs:

$\text{net profit margin} = \frac{\text{net income}}{\text{sales}}$

$\text{total asset turnover} = \frac{\text{sales}}{\text{total assets}}$

$\text{financial leverage} = \frac{\text{total assets}}{\text{total equity}}$

Multiplying the three fractions cancels sales and assets, leaving net income divided by total equity. The calculator formats ROE and net profit margin as percentages, total asset turnover as a decimal, and financial leverage as a multiple.

Worked example that matches this calculator

Suppose the inputs are the defaults: sales of $1,000,000, net income of $120,000, total assets of $750,000, and total equity of $300,000. Net profit margin is:

$\text{net profit margin} = \frac{120{,}000}{1{,}000{,}000} = 0.12$

Total asset turnover is:

$\text{total asset turnover} = \frac{1{,}000{,}000}{750{,}000} = 1.3333$

Financial leverage is:

$\text{financial leverage} = \frac{750{,}000}{300{,}000} = 2.50$

ROE is the product:

$\text{ROE} = 0.12 \times 1.3333 \times 2.50 = 0.40$

The calculator displays 40% return on equity, 12% net profit margin, 1.33 total asset turnover, and 2.50x financial leverage. The note restates the decomposition as margin times turnover times leverage. If net income fell to $60,000 with the same sales, assets, and equity, margin would fall to 6% and ROE would drop to 20%. If equity fell to $200,000 while assets stayed $750,000, financial leverage would rise to 3.75x, increasing ROE but also increasing risk.

What the result measures

DuPont analysis measures the source of shareholder return. Net profit margin shows how much of each sales dollar remains after expenses, interest, and taxes. Total asset turnover shows how efficiently assets generate revenue. Financial leverage shows how many asset dollars are supported by each dollar of equity.

Because the components are distinct, the calculator helps you diagnose business models. High margins with low turnover may describe a brand, software, or specialty product company. Low margins with high turnover may describe a retailer or distributor. High leverage may describe banks, utilities, or capital-intensive firms. Use the total asset turnover calculator, financial leverage ratio calculator, and interest coverage ratio calculator to inspect the pieces separately.

Benchmarks and interpretation

There is no universal best DuPont profile. A 20% ROE produced by a durable 20% margin, 1.0 asset turnover, and 1.0 leverage is very different from a 20% ROE produced by a 4% margin, 1.0 turnover, and 5.0 leverage. The second company may be more exposed to interest rates, refinancing, and downturns even though the final ROE is the same.

Compare companies within the same industry and over several periods. If ROE improves because margin expands while turnover and leverage stay stable, operations may be strengthening. If ROE improves only because equity shrank or debt rose, the result may be less durable. If turnover falls while margin rises, the company may be trading volume for profitability. The decomposition makes those trade-offs visible.

Limitations

The calculator uses the numbers you enter for total assets and total equity. For rigorous analysis, average balances are often better than ending balances because sales and net income cover a period. Negative or very small equity can create extreme leverage and ROE values that are mathematically correct but economically hard to compare.

Accounting choices also matter. One-time gains, impairments, restructuring charges, share buybacks, goodwill, leases, and asset write-downs can all change the components. DuPont analysis identifies where to investigate; it does not prove whether the driver is sustainable.

The formula also says little about cash timing. A company can report healthy net income and ROE while receivables grow, inventory builds, or capital spending consumes cash. Treat DuPont analysis as an income-statement and balance-sheet diagnostic, then confirm the story with cash-flow analysis.

Practical tips

Use consistent periods and definitions across companies. Separate recurring net income from unusual items when possible. Compare the leverage component with debt cost and coverage rather than assuming more leverage is better. For asset-heavy companies, also review fixed asset productivity with the fixed asset turnover calculator. For operating assets specifically, compare with the operating asset turnover calculator.

Sources

• Corporate Finance Institute, DuPont Analysis — three-part ROE decomposition and component definitions.
• Wall Street Prep, DuPont Analysis — explanation of margin, turnover, and leverage drivers.
• Corporate Finance Institute, Financial Leverage — background on leverage as a financing and return driver.