Saved

Press the star next to a tool's name to save it.

All my tools

DuPont Analysis Calculator

Use this DuPont analysis calculator to split return on equity into net margin, asset turnover and equity multiplier, with the five-step version too.

Restored your last values ·

More options

Use figures for the same year. Average assets and equity are the average of the opening and closing balances. Add pre-tax income and EBIT for the five-step version.

Everything is worked out in your browser. Nothing you type is sent anywhere.

–

–

Fill in the boxes and press Calculate.

See full result

A DuPont analysis calculator breaks a company's return on equity into the parts that drive it: how much profit it keeps from each sale, how hard its assets work, and how much it relies on borrowed money. Enter net income, sales, average total assets and average equity for the three-step analysis. Add pre-tax income and EBIT to split profitability further in the five-step version.

The DuPont formula

ROE = net profit margin × asset turnover × equity multiplier
= (net income ÷ sales) × (sales ÷ average total assets) × (average total assets ÷ average equity)

The DuPont method gives this three-step version. Multiplying the three ratios cancels sales and assets, leaving net income divided by equity, which is the return on equity. The value of the analysis is in the parts: two companies with the same ROE can reach it in very different ways.

The five-step version

ROE = (net income ÷ pre-tax income) × (pre-tax income ÷ EBIT) × (EBIT ÷ sales) × (sales ÷ average assets) × (average assets ÷ average equity)

The five-step version names the extra parts the tax burden, the interest burden and the operating margin. Together they replace the net profit margin, showing how much of the operating profit is lost to interest and how much to tax.

How to use the DuPont analysis calculator

  1. Enter net income and sales for the year.
  2. Enter average total assets and average equity, the average of the opening and closing figures.
  3. Optionally enter pre-tax income and EBIT for the five-step breakdown.
  4. Press Calculate.

Worked example

A company earns net income of $50,000 on sales of $500,000, with average assets of $400,000 and average equity of $250,000. Its net profit margin is 10 percent, its asset turnover 1.25 and its equity multiplier 1.6. ROE is 10% × 1.25 × 1.6 = 20 percent. If its pre-tax income was $65,000 and EBIT $75,000, the tax burden is 0.77, the interest burden 0.87 and the operating margin 15 percent, and multiplying all five parts gives the same 20 percent.

What each part tells you

Net profit margin shows pricing power and cost control. Asset turnover shows how much sales each dollar of assets produces, which is high for retailers and low for businesses with heavy equipment. The equity multiplier shows financial leverage: a higher figure means more of the assets are financed by debt. A high ROE that comes mainly from a high equity multiplier is riskier than one that comes from strong margins, because it depends on borrowing. The five-step version adds whether interest costs or a high tax rate are eating into profit.

Comparing companies

CompanyMarginTurnoverMultiplierROE
A10%1.251.620%
B4%2.52.020%
C20%0.52.020%

All three earn the same ROE, but A relies on balanced margins and turnover, B on selling a lot at thin margins, and C on high margins from a large asset base. The breakdown points to where each could improve. For the leverage part on its own, try the debt to asset calculator, and for margins, the gross margin calculator.

Using DuPont analysis over time

Running the analysis for the same company over several years shows what is changing behind its return on equity. If ROE rises because the net margin improves, the business is becoming more profitable. If it rises because the equity multiplier goes up, the company is borrowing more, which lifts returns but adds risk. If asset turnover falls, the company may be investing in assets that are not yet producing sales. Seeing which part moved turns a single headline figure into a story about how the business is run.

Finding the figures

Net income and sales come from the income statement. Total assets and shareholders' equity come from the balance sheet; take the figures at the start and end of the year and average them. Pre-tax income and operating profit, or EBIT, are also on the income statement. If the company reports interest separately, EBIT is pre-tax income plus interest expense. Use figures from the same annual report so they are consistent.

Return on assets

The calculator also shows return on assets, the net margin times asset turnover. It measures how well the company uses all its assets, before the effect of leverage. The gap between return on assets and return on equity comes entirely from the equity multiplier: the more debt, the wider the gap.

Industry patterns

The parts of the DuPont formula vary a great deal between industries, so compare a company mainly with others in the same line of business. Businesses that sell high volumes at low prices tend to show thin margins and high asset turnover, while businesses with expensive equipment or property tend to show lower turnover. A company that stands out from its peers on one ratio is worth a closer look, whether the difference is a strength to build on or a weakness to fix. Recording each part every year makes those comparisons quick.

Common mistakes

  • Using year-end balances only. Averages match the year's income better.
  • Mixing periods. Use income and balances for the same year.
  • Reading a high ROE as always good. Check whether it comes from leverage.

What next

Use this often? Add DuPont Analy to your Home screen.

Frequently asked questions

How does a DuPont analysis calculator work?

It multiplies net profit margin, asset turnover and the equity multiplier, which together equal return on equity.

What is the ROE with a 10% margin, 1.25 turnover and 1.6 equity multiplier?

10% × 1.25 × 1.6 = 20 percent.

What is the five-step DuPont analysis?

It splits the net margin into tax burden, interest burden and operating margin, as the five-step version describes.

What does the equity multiplier show?

Financial leverage: average assets divided by average equity.

Why use average assets and equity?

Income is earned over the whole year, so averages of opening and closing balances match it better.

What went wrong?

We only receive the reason you pick, never what you typed into the tool.

Thanks for your feedback.

More Finance Tools