Dalal Street Blogs provides information for educational purposes only and does not constitute investment advice. Please consult a SEBI-registered investment adviser before making any investment decisions.
CAUTION: Dalal Street Blogs publishes market news and educational content only. We do not promote, recommend or endorse any stock, and nothing here is a solicitation to buy or sell securities. Please consult a SEBI-registered adviser before investing.

Indian Stock Market News, Analysis and Trading Guides

Earnings & Quarterly Results

DuPont Analysis: Splitting Return on Equity Into Margin, Turnover and Leverage, With a Rupee Worked Example

DuPont analysis: a hand working out return on equity ratios on a desk calculator

Photo: jarmoluk via Pixabay (428294)

By Dalal Street Blogs Editorial9 min read

Two companies report the same 20% return on equity. One gets there by selling at fat margins. The other earns thin margins and props the number up with borrowed money. On a results day screener they look identical. DuPont analysis is the simple bit of arithmetic that pulls them apart, by splitting ROE into the three things that actually produce it: how much profit each rupee of sales keeps, how hard the assets work, and how much debt sits behind the equity.

We’ll go through the formula, both the three-step and five-step versions, then run a full worked example in rupees using two made-up companies. Every number in the example is hypothetical and chosen to keep the maths clean. The definitions follow Investopedia’s DuPont analysis explainer and the Wikipedia entry on DuPont analysis.

In this article
  1. What DuPont analysis actually measures
  2. The three-step DuPont formula
  3. The five-step version, for when margin needs more detail
  4. Worked example: two companies, one ROE
  5. Worked example, year two: when ROE rises for the wrong reason
  6. Running the five-step split on Company A
  7. Reading DuPont numbers sensibly
  8. Where DuPont falls short
  9. How to run it on a listed Indian company
  10. The short version

What DuPont analysis actually measures

Start with plain ROE. It is net income divided by shareholders’ equity, and it tells you how much profit the company earned on the capital its owners have in the business. Useful, but it’s one number. It can’t tell you whether a rise came from better operations or from extra borrowing.

DuPont analysis takes that one number and writes it as a product of three ratios. Investopedia describes them as operating efficiency (net profit margin), asset use efficiency (asset turnover) and financial leverage (the equity multiplier). Multiply the three and you land back on ROE. Nothing new is being measured. The same profit and the same equity are simply being looked at through three windows.

The framework is old. It takes its name from the chemical company DuPont, where it was developed about a century ago. The sources don’t agree on the exact date: Investopedia says it was devised in 1919 by a DuPont executive, while Wikipedia says the company began using the formula in the 1920s and that a DuPont salesman put it in an internal efficiency report in 1914. What matters for us is that it has survived because it is easy to run on any set of published accounts.

The three-step DuPont formula

Here is the version most people use:

ROE = Net profit margin × Asset turnover × Equity multiplier

  • Net profit margin = Net income ÷ Revenue. How many paise of profit each rupee of sales leaves behind.
  • Asset turnover = Revenue ÷ Average total assets. How many rupees of sales each rupee of assets produces in a year.
  • Equity multiplier = Average total assets ÷ Average shareholders’ equity. How many rupees of assets sit on each rupee of owners’ money. The gap between the two is funded by liabilities, debt included.

Write the three fractions side by side and you can see why it works. Revenue appears on top in the turnover term and at the bottom in the margin term, so it cancels. Average total assets cancel the same way. What’s left is net income over equity, which is ROE. Wikipedia sets out the identity exactly like this.

One practical detail. Investopedia’s version uses average assets and average equity, usually the opening and closing balance for the year added together and halved. Profit is earned across the whole year, so dividing it by a single year-end balance can distort the ratio when the balance sheet has grown or shrunk a lot. If you compare companies, use the same convention for all of them.

The five-step version, for when margin needs more detail

Net profit margin bundles together operations, interest and tax. The five-step formula on Wikipedia breaks it into three pieces:

  • Tax burden = Net income ÷ Pre-tax income. The share of pre-tax profit that survives tax.
  • Interest burden = Pre-tax income ÷ EBIT. The share of operating profit left after interest. EBIT means earnings before interest and tax.
  • EBIT margin = EBIT ÷ Revenue. The operating margin before financing and tax.

Multiply tax burden, interest burden and EBIT margin and you get back the net profit margin. Then multiply by asset turnover and the equity multiplier as before. The five-step view is handy when a company’s margin moved and you want to know whether the business improved, or whether it just paid less interest or a lower tax rate that year.

Same ROE, different engine. DuPont doesn’t tell you which company is better. It tells you which lever each one is pulling, and that’s the question you actually need answered.

Worked example: two companies, one ROE

Let’s build two hypothetical companies. Call them Company A and Company B. Both have revenue of ₹1,000 crore for the year. All figures below are invented for illustration.

Company A earns net profit of ₹100 crore on average total assets of ₹800 crore, funded by average shareholders’ equity of ₹500 crore.

  • Net profit margin = 100 ÷ 1,000 = 10%
  • Asset turnover = 1,000 ÷ 800 = 1.25 times
  • Equity multiplier = 800 ÷ 500 = 1.6 times
  • ROE = 10% × 1.25 × 1.6 = 20%

Check it the direct way: 100 ÷ 500 = 20%. It matches.

Company B earns net profit of ₹80 crore on average total assets of ₹1,000 crore, with average equity of just ₹400 crore.

  • Net profit margin = 80 ÷ 1,000 = 8%
  • Asset turnover = 1,000 ÷ 1,000 = 1.0 times
  • Equity multiplier = 1,000 ÷ 400 = 2.5 times
  • ROE = 8% × 1.0 × 2.5 = 20%

Directly: 80 ÷ 400 = 20%. Same answer as Company A.

Now look at what’s underneath. Company A has a better margin and works its assets harder. Company B is behind on both, and makes up the entire gap with leverage. Its equity multiplier of 2.5 means ₹600 crore of its ₹1,000 crore asset base is funded by liabilities rather than owners. Company A’s multiplier of 1.6 means liabilities fund ₹300 crore of its ₹800 crore.

Neither shape is automatically wrong. But they behave very differently when things go badly. If sales drop, Company B still has the same liabilities to service, and its thinner margin leaves less cushion. Investopedia makes the same point: some debt is normal and can help, but piling on debt to lift the leverage ratio, and with it ROE, brings outsized risk.

Worked example, year two: when ROE rises for the wrong reason

Suppose Company B reports a better year. Again, these are hypothetical figures. Revenue grows to ₹1,050 crore and net profit to ₹84 crore. Average total assets rise to ₹1,100 crore, but average equity falls to ₹350 crore, say because the company paid out a large dividend and borrowed to fund new assets.

  • Net profit margin = 84 ÷ 1,050 = 8.0%, unchanged
  • Asset turnover = 1,050 ÷ 1,100 = about 0.95 times, down from 1.0
  • Equity multiplier = 1,100 ÷ 350 = about 3.14 times, up from 2.5
  • ROE = 84 ÷ 350 = 24%, up from 20%

A headline that says “ROE up four percentage points” sounds great. DuPont tells a less cheerful story. The margin didn’t move. The assets actually worked a little less hard. The whole improvement came from a thinner equity base and more liabilities. If you were deciding whether the business got better, the honest answer here is no. It got more leveraged.

This is the main reason we like running DuPont on two or three years of numbers, not just one. A single year shows the mix. A run of years shows which lever management keeps pulling.

If ROE rises while margin is flat and turnover slips, the improvement is coming from the balance sheet, not the business.

Running the five-step split on Company A

Let’s open up Company A’s 10% net margin. Assume, hypothetically, that its EBIT was ₹160 crore, interest cost was ₹25 crore, so pre-tax income was ₹135 crore, and tax was ₹35 crore, leaving the ₹100 crore net profit.

  • EBIT margin = 160 ÷ 1,000 = 16%
  • Interest burden = 135 ÷ 160 = about 0.84
  • Tax burden = 100 ÷ 135 = about 0.74
  • Net profit margin = 16% × 0.84375 × 0.7407 = 10%

Multiply that by the 1.25 turnover and 1.6 multiplier and we are back at 20% ROE. Now you can ask sharper questions. Interest eats about 16% of operating profit. Tax takes about 26% of pre-tax profit. If next year’s net margin jumps, you can check which of the three moved. A higher EBIT margin is an operating story. A lower interest burden could mean debt was repaid. A lower tax bill could be a one-off.

Reading DuPont numbers sensibly

The ratios only mean something against the right comparison. Wikipedia notes that some businesses, such as high-end fashion, lean on margin, while retailers and grocers can run on thin margins but sell a large multiple of their assets every year. Investopedia gives a similar contrast: a discount retailer tends to have high asset turnover, while a utility, with expensive fixed assets, has a much lower one. So comparing a supermarket chain’s turnover with a power company’s tells you nothing. Compare within an industry, and compare a company with its own past.

A few habits help:

  • Use the same profit line every time. Consolidated or standalone, before or after exceptional items. Mixing them makes the ratios jump for no real reason.
  • Watch for shrinking equity. The multiplier is assets divided by equity, so anything that shrinks equity while assets stay put, such as a large payout or a loss, pushes it up. ROE can then rise even when profit is flat, exactly as it did for Company B.
  • Look at the five-step split when margins move. It separates operating gains from changes in interest and tax.
  • Treat one-off items carefully. A large write-down or gain in a single year will swing margin. Our explainer on goodwill impairment in results covers one common example.

Where DuPont falls short

The framework is only as good as the accounts that feed it. Investopedia flags this as the biggest drawback: it relies on reported financial statement data, and that data is shaped by accounting estimates, assumptions and reporting choices. It also lacks context. It can tell you that a margin is low; it can’t tell you why, or whether low is fine for that business.

It’s also a poor fit for some sectors. Wikipedia notes that it is less useful for industries such as investment banking, where the underlying elements are not very meaningful. Banks and NBFCs run on high leverage by design, so an equity multiplier that would alarm you in a cement company is normal there. So read a lender’s DuPont numbers against other lenders, never against manufacturers.

How to run it on a listed Indian company

You need two documents: the profit and loss statement and the balance sheet, ideally for three years so you can take averages and see a trend. Listed companies file their annual reports and quarterly results with the exchanges, and you can pull them from the company’s page on BSE. Then:

  1. Note revenue and net profit for the year.
  2. Average the opening and closing total assets.
  3. Average the opening and closing shareholders’ equity.
  4. Work out margin, turnover and the multiplier, and multiply them.
  5. Check the product against net profit divided by average equity. If the two don’t match, one input is off.

Quarterly numbers can work too, but turnover based on a single quarter’s revenue will look roughly a quarter of the annual figure, so annualise consistently or stick to full years. If you’re new to reading results, our guide on how to analyse quarterly results of a company walks through the statements first.

The short version

ROE on its own is a score. DuPont analysis shows how the score was made. When margin and turnover drive it, the return is coming from the business. When the equity multiplier does most of the work, the return is coming from leverage, and leverage cuts both ways. Run it over a few years, compare within an industry, and treat a sudden ROE jump with flat margins as a question, not an answer.

Disclaimer: This article is for educational purposes only and is not investment advice. The companies and figures in the worked examples are hypothetical. Please do your own research or consult a SEBI-registered adviser before making any investment decision.

Leave a Reply

Join the conversation

Commenting is open to registered readers. Sign up with just your email — no password needed, and it takes under a minute.

Sign up to comment Log in