DuPont Analysis: Profit Margin, Turnover and ROE

Choose the return measure before calculating

The classic three-part DuPont identity decomposes return on equity, or ROE, into net profit margin, asset turnover and the equity multiplier. It is not simply another name for every return-on-investment calculation. ROE relates net income to shareholders' equity, while a project ROI commonly compares a gain with its investment cost. Because the denominators serve different purposes, the percentages need not match. State which income period and which balance-sheet averages you are using before assembling the ratios. This makes the identity reproducible from the underlying financial statements.

Write the three ratios with matching bases

Net profit margin equals net income divided by revenue. Asset turnover equals revenue divided by average total assets. The equity multiplier equals average total assets divided by average shareholders' equity. Multiplying these gives net income divided by average equity, because revenue and average assets cancel. Cancellation works only when the repeated quantities use the same definition and period. Using gross profit in one factor, quarter revenue in another and year-end assets elsewhere breaks the interpretation even if the spreadsheet still produces a numeric percentage.

Work a complete numerical example

Assume a business reports annual revenue of 1,000,000 and net income of 80,000. Its average assets are 500,000 and average equity is 250,000. Profit margin is 80,000/1,000,000=0.08, or 8%. Asset turnover is 1,000,000/500,000=2.0 times. The equity multiplier is 500,000/250,000=2.0 times. Their product is 0.08×2×2=0.32, or 32% ROE. Verify it directly: 80,000/250,000=0.32. The two calculations should agree before interpreting why the business earned that return.

Understand what each factor contributes

The margin describes how much net income remains per unit of revenue. Turnover describes revenue generated per unit of assets. The multiplier describes assets relative to equity; a larger value commonly reflects greater use of liabilities. In the example, increasing margin to 10% while holding the other two factors fixed would produce 40% ROE. Increasing leverage can also raise the measured ROE without improving operations. Those are different economic changes, so a higher final percentage alone is not enough to conclude that business performance became safer or stronger.

Average the balance-sheet quantities deliberately

An income statement covers a period, while a balance sheet describes a point in time. A common approximation for average assets is (opening assets + closing assets)/2, with the same approach for equity. If a large acquisition or capital issue occurred during the year, more frequent averages may represent the period better. For example, opening equity of 200,000 and closing equity of 300,000 gives a simple average of 250,000. Do not silently switch to closing equity of 300,000: it would lower the direct ROE in the example to about 26.67%.

Recognize unusual or unstable denominators

Negative equity, equity near zero, extraordinary income and major accounting changes can make conventional ROE comparisons difficult. Dividing by a tiny positive equity value produces a very large ratio without necessarily indicating an attractive investment. A negative denominator can reverse the sign and confuse a simple ranking. Review the statements and explain these conditions rather than replacing the denominator with an absolute value. Compare businesses with attention to industry structure and accounting policies; an asset-heavy manufacturer and a services business may have quite different normal turnover patterns.

Keep project ROI separate in the linked tool

The linked ROI Calculator evaluates investment cost and return; it does not request all three DuPont components. Use it for a project such as a 10,000 investment returning 12,000, whose simple gain-on-cost ROI is (12,000-10,000)/10,000=20%. Use the three ratios above or a spreadsheet for DuPont ROE. A project ROI does not automatically annualize the return or account for intermediate cash-flow timing. Label each metric explicitly when placing them in the same report, and retain the direct net-income-to-equity check for the DuPont calculation.

Related guides

Roe and ROI formula

Roe and ROI formula: calculation method, required inputs, worked check, limitations and a link to ROI Calculator.

Margin vs ROI

Margin vs ROI: calculation method, required inputs, worked check, limitations and a link to ROI Calculator.

Net Profit Margin Example

Net Profit Margin Example: calculation method, required inputs, worked check, limitations and a link to Profit Margin Calculator.