DuPont Analysis , Formula, & Equation

What Is the DuPont Analysis?

The DuPont analysis (also known as the DuPont identity or DuPont model) is a framework for analyzing fundamental performance popularized by the DuPont Corporation. DuPont analysis is a useful technique used to decompose the different drivers of return on equity (ROE). The decomposition of ROE allows investors to focus on the key metrics of financial performance individually to identify strengths and weaknesses.

Formula and Calculation of DuPont Analysis

DuPont Analysis = Net Profit Margin × AT × EM where: Net Profit Margin = Net Income Revenue AT = Asset turnover Asset Turnover = Sales Average Total Assets EM = Equity multiplier Equity Multiplier = Average Total Assets Average Shareholders’ Equity \begin{aligned} &\text{DuPont Analysis} = \text{Net Profit Margin} \times \text{AT} \times \text{EM} \\ &\textbf{where:}\\ &\text{Net Profit Margin} = \frac{ \text{Net Income} }{ \text{Revenue} } \\ &\text{AT} = \text{Asset turnover} \\ &\text{Asset Turnover} = \frac{ \text{Sales} }{ \text{Average Total Assets} } \\ &\text{EM} = \text{Equity multiplier} \\ &\text{Equity Multiplier} = \frac{ \text{Average Total Assets} }{ \text{Average Shareholders' Equity} } \\ \end{aligned} DuPont Analysis=Net Profit Margin×AT×EMwhere:Net Profit Margin=RevenueNet IncomeAT=Asset turnoverAsset Turnover=Average Total AssetsSalesEM=Equity multiplierEquity Multiplier=Average Shareholders’ EquityAverage Total Assets

What DuPont Analysis Tells You

A DuPont analysis is used to evaluate the component parts of a company's return on equity (ROE). This allows an investor to determine what financial activities are contributing the most to the changes in ROE. An investor can use analysis like this to compare the operational efficiency of two similar firms. Managers can use DuPont analysis to identify strengths or weaknesses that should be addressed.

There are three major financial metrics that drive return on equity (ROE): operating efficiency, asset use efficiency, and financial leverage. Operating efficiency is represented by net profit margin or net income divided by total sales or revenue. Asset use efficiency is measured by the asset turnover ratio. Leverage is measured by the equity multiplier, which is equal to average assets divided by average equity.

DuPont Analysis Components

DuPont analysis breaks ROE into its constituent components to determine which of these factors are most responsible for changes in ROE.

Net Profit Margin

The net profit margin is the ratio of bottom line profits compared to total revenue or total sales. This is one of the most basic measures of profitability.

One way to think about the net margin is to imagine a store that sells a single product for $1.00. After the costs associated with buying inventory, maintaining a location, paying employees, taxes, interest, and other expenses, the store owner keeps $0.15 in profit from each unit sold. That means the owner's profit margin is 15%, which can be calculated as follows:

Profit Margin = Net Income Revenue = $ 0 . 1 5 $ 1 . 0 0 = 1 5 % \begin{aligned} &\text{Profit Margin} = \frac{ \text{Net Income} }{ \text{Revenue} } = \frac{ \$0.15 }{ \$1.00 } = 15\% \\ \end{aligned} Profit Margin=RevenueNet Income=$1.00$0.15=15%

The profit margin can be improved if costs for the owner were reduced or if prices were raised, which can have a large impact on ROE. This is one of the reasons that a company's stock will experience high levels of volatility when management makes a change to its guidance for future margins, costs, and prices.

Asset Turnover Ratio

The asset turnover ratio measures how efficiently a company uses its assets to generate revenue. Imagine a company had $100 of assets, and it made $1,000 of total revenue last year. The assets generated 10 times their value in total revenue, which is the same as the asset turnover ratio and can be calculated as follows:

Asset Turnover Ratio = Revenue Average Assets = $ 1 , 0 0 0 $ 1 0 0 = 1 0 \begin{aligned} &\text{Asset Turnover Ratio} = \frac{ \text{Revenue} }{ \text{Average Assets} } = \frac{ \$1,000 }{ \$100 } = 10 \\ \end{aligned} Asset Turnover Ratio=Average AssetsRevenue=$100$1,000=10

A normal asset turnover ratio will vary from one industry group to another. For example, a discount retailer or grocery store will generate a lot of revenue from its assets with a small margin, which will make the asset turnover ratio very large. On the other hand, a utility company owns very expensive fixed assets relative to its revenue, which will result in an asset turnover ratio that is much lower than that of a retail firm.

The ratio can be helpful when comparing two companies that are very similar. Because average assets include components like inventory, changes in this ratio can signal that sales are slowing down or speeding up earlier than it would show up in other financial measures. If a company's asset turnover rises, its ROE will improve.

Financial Leverage

Financial leverage, or the equity multiplier, is an indirect analysis of a company's use of debt to finance its assets. Assume a company has $1,000 of assets and $250 of owner's equity. The balance sheet equation will tell you that the company also has $750 in debt (assets - liabilities = equity). If the company borrows more to purchase assets, the ratio will continue to rise. The accounts used to calculate financial leverage are both on the balance sheet, so analysts will divide average assets by average equity rather than the balance at the end of the period, as follows:

Financial Leverage = Average Assets Average Equity = $ 1 , 0 0 0 $ 2 5 0 = 4 \begin{aligned} &\text{Financial Leverage} = \frac{ \text{Average Assets} }{ \text{Average Equity} } = \frac{ \$1,000 }{ \$250 } = 4 \\ \end{aligned} Financial Leverage=Average EquityAverage Assets=$250$1,000=4

Most companies should use debt with equity to fund operations and growth. Not using any leverage could put the company at a disadvantage compared with its peers. However, using too much debt in order to increase the financial leverage ratio — and therefore increase ROE — can create disproportionate risks.

Example of DuPont Analysis Use

An investor has been watching two similar companies, SuperCo and Gear Inc., that have recently been improving their return on equity compared to the rest of their peer group. This could be a good thing if the two companies are making better use of assets or improving profit margins.

In order to decide which company is a better opportunity, the investor decides to use DuPont analysis to determine what each company is doing to improve its ROE and whether that improvement is sustainable.

Image by Sabrina Jiang © Investopedia 2020

As you can see in the table, SuperCo improved its profit margins by increasing net income and reducing its total assets. SuperCo's changes improved its profit margin and asset turnover. The investor can deduce from the information that SuperCo also reduced some of its debt since average equity remained the same.

Looking closely at Gear Inc., the investor can see that the entire change in ROE was due to an increase in financial leverage. This means Gear Inc. borrowed more money, which reduced average equity. The investor is concerned because the additional borrowings didn't change the company's net income, revenue, or profit margin, which means the leverage may not be adding any real value to the firm.

Or, as a real-life example, consider Wal-Mart Stores (NYSE: WMT). Wal-Mart has a net income over the trailing twelve months of $5.2 billion, revenue of $512 billion, assets of $227 billion, and shareholders' equity of $72 billion.

The company's profit margin is 1%, or $5.2 billion / $512 billion. Its asset turnover is 2.3, or $512 billion / $227 billion. The financial leverage (or equity multiplier) is 3.2, or $227 billion / $72 billion. Thus, its return or equity (ROE) is 7.4%, or 1% x 2.3 x 3.2.

DuPont Analysis vs. ROE

With a Dupont analysis, investors and analysts can dig into what drives changes in ROE, or why an ROE is considered high or low. That is, a Dupont analysis can help deduce whether its profitability, use of assets, or debt that’s driving ROE.

Limitations of Using DuPont Analysis

The biggest drawback of the DuPont analysis is that, while expansive, it still relies on accounting equations and data that can be manipulated. Plus, even with its comprehensiveness, the Dupont analysis lacks context as to why the individual ratios are high or low, or even whether they should be considered high or low at all.

What Does DuPont Analysis Tell You?

DuPont analysis is a useful technique used to decompose the different drivers of return on equity (ROE) for a business. This allows an investor to determine what financial activities are contributing the most to the changes in ROE. An investor can use analysis like this to compare the operational efficiency of two similar firms.

What Is the Difference Between 3-Step and 5-Step DuPont Analysis?

There are two versions of DuPont analysis, one utilizing decomposition of ROE via 3 steps and another utilizing 5 steps. The three-step equation breaks up ROE into three very important components:

ROE=Net IncomeSales×SalesAssets×AssetsShareholders’ Equity\begin{aligned} &\text{ROE} = \frac{ \text{Net Income} }{ \text{Sales} } \times \frac{ \text{Sales} }{ \text{Assets} } \times \frac{ \text{Assets} }{ \text{Shareholders' Equity} } \\ \end{aligned}ROE=SalesNet Income×AssetsSales×Shareholders’ EquityAssets

The five-step version instead is:

ROE=EBTS×SA×AE×(1−TR)where:EBT=Earnings before taxS=SalesA=AssetsE=EquityTR=Tax rate\begin{aligned} &\text{ROE} = \frac{ \text{EBT} }{ \text{S} } \times \frac{ \text{S} }{ \text{A} } \times \frac{ \text{A} }{ \text{E} } \times ( 1 - \text{TR} ) \\ &\textbf{where:} \\ &\text{EBT} = \text{Earnings before tax} \\ &\text{S} = \text{Sales} \\ &\text{A} = \text{Assets} \\ &\text{E} = \text{Equity} \\ &\text{TR} = \text{Tax rate} \\ \end{aligned}ROE=SEBT×AS×EA×(1−TR)where:EBT=Earnings before taxS=SalesA=AssetsE=EquityTR=Tax rate

Why Is It Called DuPont Analysis?

In the 1920s, the American chemicals and manufacturing giant, DuPont Corporation, created an internal management tool to better understand where its operating efficiency was coming from and where it was falling short. By breaking down ROE into a more complex equation, DuPont analysis shows the causes of shifts in this number.

What Are Some Limitations of Using DuPont analysis?

While DuPont analysis can be a very helpful tool for managers, analysts, and investors, it is not without its weaknesses. The expansive nature of the DuPont equations means that it requires several inputs. As with any calculation, the results are only as good as the accuracy of the inputs. DuPont analysis utilizes data from a company's income statement and balance sheet, some of which may not be entirely accurate. Even if the data used for calculations are reliable, there are still additional potential problems, such as the difficulty of determining the relative values of ratios as good or bad compared to industry norms. Seasonal factors, depending on the industry, can also be an important consideration, since these factors can distort ratios. Some companies always carry a higher level of inventory at certain times of the year, for example. Different accounting practices between companies can also make accurate comparisons difficult.