DuPont Analysis: The DuPont Formula Plus How to Calculate and Use It (2024)

What Is the DuPont Analysis?

The DuPont analysis 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.

There are two versions of the tool—one which accounts for decomposition in three steps while the other does so in five steps.

Key Takeaways

  • The DuPont analysis is a framework for analyzing fundamental performance originally popularized by the DuPont Corporation.
  • The formula was developed in 1914 by F. Donaldson Brown, an employee of the DuPont Corporation.
  • DuPont analysis is a useful technique used to decompose the different drivers of return on equity.
  • An investor can use analysis tools 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.

DuPont Analysis: The DuPont Formula Plus How to Calculate and Use It (1)

Understanding the DuPont Analysis

The DuPont analysis is a formula used to track a company's financial performance. It was developed in 1914 by F. Donaldson Brown, who worked for the DuPont Corporation. His formula incorporates earnings, investment, and working capital together into a single figure that he called return on investment (ROI). It became a standard measure for all DuPont departments and was adopted by other companies.

A DuPont analysis is used to evaluate the component parts of a company's ROE. This allows an investor to determine what financial activities contribute the most to the changes in ROE. An investor can use tools 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 ROE:

  • Operating efficiency, which is represented by net profit margin or net income divided by total sales or revenue
  • Asset use efficiency, which is measured by the asset turnover ratio
  • Financial leverage, a metric that is measured by the equity multiplier, which is equal to average assets divided by average equity

Formula and Calculation of DuPont Analysis

The DuPont analysis is an expanded return on equity formula, calculated by multiplying the net profit margin by the asset turnover by the equity multiplier.

DuPontAnalysis=NetProfitMargin×AT×EMwhere:NetProfitMargin=NetIncomeRevenueAT=AssetturnoverAssetTurnover=SalesAverageTotalAssetsEM=EquitymultiplierEquityMultiplier=AverageTotalAssetsAverageShareholders’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}DuPontAnalysis=NetProfitMargin×AT×EMwhere:NetProfitMargin=RevenueNetIncomeAT=AssetturnoverAssetTurnover=AverageTotalAssetsSalesEM=EquitymultiplierEquityMultiplier=AverageShareholders’EquityAverageTotalAssets

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:

ProfitMargin=NetIncomeRevenue=$0.15$1.00=15%\begin{aligned} &\text{Profit Margin} = \frac{ \text{Net Income} }{ \text{Revenue} } = \frac{ \$0.15 }{ \$1.00 } = 15\% \\ \end{aligned}ProfitMargin=RevenueNetIncome=$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:

AssetTurnoverRatio=RevenueAverageAssets=$1,000$100=10\begin{aligned} &\text{Asset Turnover Ratio} = \frac{ \text{Revenue} }{ \text{Average Assets} } = \frac{ \$1,000 }{ \$100 } = 10 \\ \end{aligned}AssetTurnoverRatio=AverageAssetsRevenue=$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 they would show up in other financial measures. If a company's asset turnover rises, its ROE improves.

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:

FinancialLeverage=AverageAssetsAverageEquity=$1,000$250=4\begin{aligned} &\text{Financial Leverage} = \frac{ \text{Average Assets} }{ \text{Average Equity} } = \frac{ \$1,000 }{ \$250 } = 4 \\ \end{aligned}FinancialLeverage=AverageEquityAverageAssets=$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.

A point to note, though, is that some companies use balance sheet averages when one of the components is an income statement metric. In the case noted above, no averaging is necessary as the equation takes balance sheet/balance sheet figures into account.

DuPont Analysis vs. Return on Equity (ROE)

The return on equity metric is net income divided by shareholders’ equity. The DuPont analysis is still the ROE, just an expanded version. The ROE calculation alone reveals how well a company utilizes capital from shareholders.

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.

Drawbacks 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.

Example of DuPont Analysis

Here's a hypothetical example to show how the DuPont analysis works. Let's say an investor has been watching two similar companies, SuperCo and Gear Inc. Both of these companies have improved their return on equity compared to the rest of their peer group, which could be a good thing if the two companies make 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 does to improve its ROE and whether that improvement is sustainable.

DuPont Analysis: The DuPont Formula Plus How to Calculate and Use It (2)

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 that SuperCo also reduced some of its debt since average equity remained the same.

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

Real-World Example

Now let's consider Walmart (WMT). For the fiscal year ending Jan. 31, 2022, the company reported:

  • Net income over the trailing 12 months (TTM) of $13.7 billion
  • Revenue of $572.8 billion
  • Assets of $244.9 billion
  • Shareholders' equity of $83.3 billion

So from these figures, we can use the information above to deduce that the company had the following:

  • Profit margin of 2.4% or $13.7 billion/$572.8 billion
  • Asset turnover of 2.34 or $572.8 billion/$244.9 billion
  • Financial leverage (or equity multiplier) is 2.94 or $244.9 billion/$83.3 billion

According to these figures, Walmart's return on equity (ROE) for the fiscal year was 16.5% (or 2.4% x 2.34 x 2.94).

What Does DuPont Analysis Tell You?

DuPont analysis is a useful technique used to decompose the different drivers of return on equity for a business. This allows an investor to determine what financial activities are contributing the most to the changes in ROE. An investor can usean analysislike 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 three steps and another utilizing five steps. The three-step equation breaks up ROE into three very important components:

ROE=NetIncomeSales×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=SalesNetIncome×AssetsSales×Shareholders’EquityAssets

The five-step version instead is:

ROE=EBTS×SA×AE×(1TR)where:EBT=EarningsbeforetaxS=SalesA=AssetsE=EquityTR=Taxrate\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×(1TR)where:EBT=EarningsbeforetaxS=SalesA=AssetsE=EquityTR=Taxrate

Why Is It Called DuPont Analysis?

A DuPont employee by the name of F. Donaldson Brown developed a formula in 1914 that was used by the company as 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 the DuPont analysis can be a very helpful tool for managers, analysts, and investors, it is not without its weaknesses. Its expansive nature means that it requires several inputs. As with any calculation, the results are only as good as the accuracy of the inputs.

This tool utilizes data from a company'sincome statementandbalance 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 therelative valuesof 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. For instance, some companies always carry a higher level of inventory at certain times of the year. Differentaccounting practicesbetween companies can also make accurate comparisons difficult.

The Bottom Line

DuPont analysis is a useful tool for evaluating the components that make up a company's ROI calculation. Whether you're an analyst, investor, or manager, you can use DuPont analysis to spot the causes for a shift in ROI, track a company's financial performance, and gather data to make informed decisions. Just keep in mind the limitations of this formula as it relates to the quality of the inputs.

DuPont Analysis: The DuPont Formula Plus How to Calculate and Use It (2024)

FAQs

How do you calculate the DuPont analysis? ›

The DuPont analysis is an expanded return on equity formula, calculated by multiplying the net profit margin by the asset turnover by the equity multiplier.

What is the DuPont equation used to solve for? ›

Question: The DuPont equation shows the relationships among asset management, debt management, and profitability ratios. Management can use the DuPont equation to analyze ways of improving the firm's performance.

How do you calculate ROI using the DuPont model to show margin and turnover? ›

According to the DuPont model, your company's ROI is calculated by multiplying its return on sales by its asset turnover. Alternatively, you can also calculate a company or investment's ROI by dividing the profit by the total invested capital and multiplying the result by 100. Both formulas produce the same result.

How do you use the DuPont equation for improving ROE? ›

Financial Leverage = Assets/Equity

The final component of the DuPont formula is Financial Leverage as measured by Assets divided by shareholders' Equity. By increasing financial leverage through increased debt (and tax deductible interest payments), a firm can increase its ROE.

What is the DuPont formula example? ›

3-Step DuPont Analysis Formula

The formulas for these three components are: Net Profit Margin = Net Income / Revenue. Asset Turnover = Revenue / Average Total Assets. Financial Leverage Ratio = Average Total Assets / Average Shareholders' Equity.

What is DuPont analysis with an example? ›

DuPont analysis is a financial ratio used to analyze a company's overall performance. The DuPont equation breaks down return on equity (ROE) into three separate components. These are profit margin, asset turnover, and leverage. This analysis can be helpful in identifying a company's strengths and weaknesses.

Which ratio is the main use in the DuPont analysis? ›

The return on assets (ROA) ratio developed by DuPont for its own use is now used by many firms to evaluate how effectively assets are used. It measures the combined effects of profit margins and asset turnover. The return on equity (ROE) ratio is a measure of the rate of return to stockholders.

What is DuPont analysis PDF? ›

The DuPont equation is an expression which breaks return on equity down into three parts: profit margin, asset turnover, and leverage. LEARNING OBJECTIVES. Explain why splitting the return on equity calculation into its component parts may be helpful to. an analyst. KEY TAKEAWAYS.

What are the three parts of the DuPont equation? ›

The DuPont equation, also known as the DuPont identity, is a useful framework for analyzing a company's ability to increase its return on equity (ROE). This model can be broken down into three component parts: Profit Margin, Total Asset Turnover, and the Equity Multiplier.

How to calculate the sales margin capital turnover and return on investment ROI? ›

Answer & Explanation
  1. Return on Investment (ROI) = Operating income / Average total assets.
  2. Sales margin = Operating income / Sales.
  3. Capital turnover = Sales / Average total assets.
  4. Return on Investment = Sales margin x Capital turnover.
  5. Residual Income = Operating income - (Target rate of return x Average Operating Assets)
Nov 29, 2022

What is the formula used to calculate an owner's ROI? ›

ROI is calculated by subtracting the initial cost of the investment from its final value, then dividing this new number by the cost of the investment, and finally, multiplying it by 100.

What is the 3-step DuPont analysis? ›

The basic DuPont Analysis model is a method of breaking down the original equation for ROE into three components: operating efficiency, asset efficiency, and leverage. Operating efficiency is measured by Net Profit Margin and indicates the amount of net income generated per dollar of sales.

What does the DuPont analysis calculates ROE as the product of? ›

The DuPont identity is an expression that shows a company's return on equity (ROE) can be represented as a product of three other ratios: the profit margin, the total asset turnover, and the equity multiplier.

What is the advantage of using DuPont ROI formula? ›

The DuPont analysis model provides a more accurate assessment of the significance of changes in a company's ROE by focusing on the various means that a company has to increase the ROE figures. The means include the profit margin, asset utilization, and financial leverage (also known as financial gearing).

What is the formula for the DuPont equity multiplier? ›

The equity multiplier is calculated as follows: Equity Multiplier = Assets / Shareholder's Equity. A 20.68% ROE is a good indication of Google's ability to generate profit. Stock analysts can use the DuPont Model to make a side by side comparison of two companies in a similar industry with a similar ROE.

What is the DuPont formula for ROE CFA? ›

Traditional DuPont equation: ROE = net income / common equity. ROE = (net income / net sales) x (net sales / common equity).

What is the formula for total asset turnover? ›

Asset Turnover Ratio = Net Sales / Average Total Assets

Net sales is the total amount of revenue retained by a company. It is the gross sales from a specific period less returns, allowances, or discounts taken by customers.

References

Top Articles
Latest Posts
Article information

Author: Dong Thiel

Last Updated:

Views: 6554

Rating: 4.9 / 5 (79 voted)

Reviews: 94% of readers found this page helpful

Author information

Name: Dong Thiel

Birthday: 2001-07-14

Address: 2865 Kasha Unions, West Corrinne, AK 05708-1071

Phone: +3512198379449

Job: Design Planner

Hobby: Graffiti, Foreign language learning, Gambling, Metalworking, Rowing, Sculling, Sewing

Introduction: My name is Dong Thiel, I am a brainy, happy, tasty, lively, splendid, talented, cooperative person who loves writing and wants to share my knowledge and understanding with you.