DuPont analysis calculator (three-step and five-step ROE)
Enter a company's income statement and balance sheet figures. It splits return on equity into the parts that drive it, so you can see whether profit, efficiency or leverage is behind it.
How it works
ROE = Net margin × Asset turnover × Leverage
ROE = Tax burden × Interest burden × EBIT margin × Asset turnover × Leverage
Net margin is net income ÷ revenue, asset turnover is revenue ÷ average assets, and leverage is average assets ÷ average equity. The five-step version splits net margin into three pieces.
A worked example
Revenue 1,000, EBIT 130, pre-tax income 100, net income 80, average assets 800 and average equity 400. Net margin is 8%, asset turnover 1.25 and leverage 2.0, so ROE = 8% × 1.25 × 2.0 = 20.0%. The five-step version splits the margin into a tax burden of 0.80, an interest burden of 0.769 and an EBIT margin of 13%, and multiplies to the same ROE.
Common mistakes on the exam
- Use average balances for assets and equity unless the question says otherwise.
- A high ROE from high leverage is a different thing from one earned through margin: leverage raises risk as well as return.
- The five-step identity multiplies out to the three-step ROE, which is a useful check.
Where this is taught
- Contrast market value with book value and link return on equity to the cost of equity
- Break return on equity into its parts with DuPont analysis
- Work out a firm's sustainable growth rate and explain it, showing how DuPont analysis can be used to estimate that rate
- Back out the growth rate implied in residual income from the market P/B ratio and an estimated required return on equity
Read the guide
Practise what you read
Questions people ask
What does the DuPont decomposition tell you?
Why a return on equity is what it is: how much comes from profitability (margin), efficiency (turnover) and financial leverage. Two firms with the same ROE can be very different businesses.
What is the tax burden in five-step DuPont?
Net income divided by pre-tax income: the share of profit kept after tax. It is 1 minus the effective tax rate.
Why use average assets and equity?
Income is earned over the year while a balance sheet is a snapshot, so the average of the opening and closing balances matches the period better.
Practise this until the arithmetic is automatic: questions on every topic, with the reason each wrong option is wrong.
Take the free diagnostic →