DuPont Analysis Calculator | ROE Decomposition

Income Statement & Balance Sheet (₹ Crore)
Net Revenue / Sales
₹10 Cr₹5,00,000 Cr
Net Profit After Tax
−₹50,000 Cr₹1,50,000 Cr
Total Assets
₹10 Cr₹5,00,000 Cr
Shareholders’ Equity (net worth)
₹1 Cr₹4,00,000 Cr
Return on Equity, Broken Down
Return on Equity (ROE)
₹0
driven by margin, turnover and leverage
Net Profit Margin
0%
Asset Turnover
0.00x
Equity Multiplier
0.00x
Return on Assets
0%
Leverage Contribution
0pp
ROE Quality
The multiplication chain
Decomposition Detail
Component
Value
What it tells you
Adjust any input to see the breakdown

💡 Key Tips

  • Two companies can post an identical 20% ROE for opposite reasons. One earns it on fat margins, the other on borrowed money. DuPont is what separates them.
  • FMCG and pharma typically show high margin with low turnover. Retail and distribution show thin margin with high turnover. Neither is better — but the risks differ.
  • An equity multiplier above 3x means two-thirds of the balance sheet is funded by liabilities. That flatters ROE in good years and destroys it in bad ones.
  • Compare the 3-step and 5-step views. If ROE is holding up only because of the interest burden ratio, the business is leaning on cheap debt rather than operations.
  • Run the decomposition across five years. Watching which of the three levers moved tells you far more than the headline ROE trend.

⚠️ Things To Watch

  • ROE flatters companies with small equity bases. A firm that has bought back heavily or carries accumulated losses can show a spectacular ROE on a weak business.
  • Use average equity and average assets across the year if the balance sheet moved a lot. Year-end figures distort the ratios after a large fundraise or acquisition.
  • Not meaningful for banks and NBFCs — leverage is their business model, so the equity multiplier tells you nothing useful about risk.
  • A negative equity base makes ROE mathematically meaningless. If net worth is negative, stop and read the balance sheet instead.
  • One-off items — asset sales, tax write-backs, exceptional provisions — distort net margin badly. Normalise before comparing years.

📋 Disclaimer

This calculator is provided for educational and informational purposes only. It does not constitute financial, investment, or trading advice. Trading and investing carry substantial risk of loss and are not suitable for every investor. Past performance is not indicative of future results. Always consult a qualified financial advisor and conduct your own due diligence before making any trading or investment decisions.

📐 DuPont Decomposition Explained

1. The 3-step DuPont identity

ROE = Net Profit Margin × Asset Turnover × Equity Multiplier
Net Profit Margin = Net Income ÷ Revenue — how much of each rupee of sales survives to the bottom line
Asset Turnover = Revenue ÷ Total Assets — how hard the asset base is working
Equity Multiplier = Total Assets ÷ Shareholders’ Equity — how much leverage sits underneath
📌 Worked Example: Revenue ₹14,500 Cr, PAT ₹1,850 Cr, assets ₹12,000 Cr, equity ₹6,200 Cr. Margin = 12.76%, turnover = 1.208x, multiplier = 1.935x. ROE = 0.1276 × 1.208 × 1.935 = 29.8%.

2. Why it works — the terms cancel

ROE = (NI ÷ Rev) × (Rev ÷ TA) × (TA ÷ Eq) = NI ÷ Eq
Point = Revenue and Total Assets cancel out, leaving plain ROE. The value is not the answer — it is seeing which of the three levers produced it.

3. The 5-step version — splitting margin into three

ROE = Tax Burden × Interest Burden × Operating Margin × Asset Turnover × Equity Multiplier
Tax Burden = Net Income ÷ Pre-Tax Income — what fraction survives tax. Closer to 1 means a lower effective tax rate.
Interest Burden = Pre-Tax Income ÷ EBIT — what fraction survives interest cost. Below 0.8 signals a heavy debt load.
Operating Margin = EBIT ÷ Revenue — the true operating profitability, before financing and tax choices
📌 Why bother: The 5-step view separates operating skill from financing and tax decisions. A falling operating margin masked by a tax write-back is exactly the kind of thing the 3-step version hides.

4. Return on Assets and the leverage contribution

ROA = Net Profit Margin × Asset Turnover
Leverage contribution = ROE − ROA
Reading it = The gap between ROE and ROA is the portion of shareholder return manufactured purely by borrowing. A wide gap is a risk flag, not an achievement.

DuPont analysis breaks Return on Equity into its underlying drivers — profit margin, asset turnover and financial leverage — so two companies with the same ROE can be told apart. This guide covers both the 3-step and 5-step versions. Educational only, with no buy, sell or hold advice.

Why ROE on its own can mislead

Two companies both report a 20% Return on Equity. One earns it on wide profit margins with very little debt. The other earns it on thin margins and a balance sheet funded largely by borrowing. The headline number is identical; the risk is not remotely comparable.

DuPont analysis is the method that separates them. Rather than treating ROE as one figure, it splits the number into the components that produced it, so you can see which lever is doing the work. That is the entire value of the technique — not the answer, which is just ROE, but the composition behind it.

The 3-step DuPont identity

The standard decomposition splits ROE into three multiplied terms.

ComponentFormulaWhat it measures
Net profit marginNet Income ÷ RevenueHow much of each rupee of sales survives
Asset turnoverRevenue ÷ Total AssetsHow hard the asset base works
Equity multiplierTotal Assets ÷ EquityHow much leverage sits underneath

Multiply the three and revenue and total assets cancel out, leaving net income divided by equity — plain ROE. Worked example: revenue ₹14,500 crore, net profit ₹1,850 crore, total assets ₹12,000 crore, equity ₹6,200 crore. Margin is 12.76%, turnover 1.208x, multiplier 1.935x, giving an ROE of 29.84%.

DuPont analysis chain showing net profit margin multiplied by asset turnover and equity multiplier equals return on equity
The 3-step DuPont identity: margin, turnover and leverage multiply into ROE.EquityTimer.com

The 5-step version and sector patterns

The 5-step form splits profit margin further into three parts: tax burden (net income divided by pre-tax profit), interest burden (pre-tax profit divided by EBIT) and operating margin (EBIT divided by revenue). Both versions arrive at exactly the same ROE.

The extra detail separates operating skill from financing and tax decisions. A falling operating margin masked by a one-off tax write-back is precisely the situation the 3-step view hides.

Sector shapes differ predictably. FMCG and pharmaceutical companies typically run high margins with low asset turnover. Retail and distribution run the reverse — thin margins on rapid turnover. Neither shape is better; they simply carry different risks.

Where DuPont breaks down

ROE flatters companies with a small equity base. A firm that has bought back heavily or carries accumulated losses can post a striking ROE on an otherwise weak business, purely because the denominator is small. If net worth is negative, ROE stops being mathematically meaningful altogether.

Use average equity and average assets across the year when the balance sheet has moved substantially. Year-end figures distort every ratio after a large fundraise or acquisition.

As with the other screening tools, this is not meaningful for banks and NBFCs — leverage is their business model, so the equity multiplier tells you nothing useful about risk. One-off items such as asset sales or exceptional provisions distort net margin badly, so normalise before comparing across years.

Related tools: Altman Z-Score calculator · Piotroski F-Score calculator

Frequently asked questions

What is DuPont analysis in simple terms?

It splits Return on Equity into the parts that create it: how much profit the company makes on each rupee of sales, how efficiently it uses its assets, and how much borrowed money sits underneath. Two companies with identical ROE can have completely different compositions.

What is a good equity multiplier?

There is no universal figure, as it depends heavily on the industry. As a general reference point, a multiplier above 3 means roughly two-thirds of the balance sheet is funded by liabilities rather than shareholders, which amplifies returns in good years and losses in bad ones.

Should I use the 3-step or 5-step version?

The 3-step version is enough to see whether ROE is driven by margin, efficiency or leverage. The 5-step version is worth the extra inputs when you want to separate operating performance from the effects of interest costs and tax, which the 3-step version combines into a single margin figure.

Does DuPont analysis work for banks?

Not usefully. Leverage is intrinsic to how banks and NBFCs operate, so a high equity multiplier reflects the business model rather than any risk signal. Financial companies are generally assessed with sector-specific measures instead.

Educational and informational content only. EquityTimer is not a SEBI-registered investment adviser and does not provide buy, sell or hold recommendations. Data may contain errors or delays; verify independently and consult a registered financial adviser before making any investment decision.