Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Logout MarketXLS
BasicsFundamental analysisGuru functionsStock investmentsStocks

Dupont Analysis Using Marketxls (Excel Spreadsheet)

Written by Meesha Ghedia
Tue Apr 20 2021
MarketXLS template - DuPont
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →
MarketXLS template - DuPont
 

The DuPont method is an essential analysis used to assess a company’s performance in detail. Donaldson Brown, a DuPont Corporation salesman, found the DuPont equation in 1920. The DuPont analysis is an expansion of the Return on Equity (ROE) which is broken down into a more detailed and complex equation. Many investors use the ROE to find the right companies to invest in. Further, we will explore what is ROE and how using the DuPont equation will give investors a more precise analysis of the company.

Return on Equity

ROE measures the profits a company makes compared to the shareholder’s investment.

Return on Equity

An increase in shareholder equity is a positive sign for the company meaning a higher ROE. However, a high ROE can also be caused when a company takes on more debt, which means a decrease in shareholder equity. This could cause the stocks to become riskier. The ROE number can be misleading therefore the ratio needs to be decomposed to analyze the data better. Utilizing ROE does not always give an accurate estimation of company performance.

How to Calculate DuPont Analysis?

The Three-Step DuPont equation has additional components to calculating the ROE compared to the original ROE equation. It measures three factors of a company: Profitability, Efficiency, and Financial Leverage.

ROE = Net Profit Margin x Asset Turnover x Equity Multiplier

These three factors are a result of three separate formulas:

Net Profit Margin = Net Income/ revenue

Asset Turnover = Sales / Assets

Equity Multiplier = Assets / Shareholders Equity

Return on Equity Equation - DuPont Analysis

Return On Equity (ROE) vs. Return On Assets (ROA)

As said above, ROE is a measure of how much a business profits based on the amount of equity invested in the business. Return on Assets (ROA) is a measure of how much profits a business makes with respect to the total assets.

ROA

A difference between ROE and ROA is the denominator. The numerator “Net Income” is the same for both. The denominator of ROE is Shareholder’s Equity which is equal to Assets – Liabilities. While ROA’s denominator is Total Assets = Shareholder’s Equity + Liabilities.
Looking at these two equations we see that ROA and ROE are actually equal to each other especially when the company’s liabilities are zero which leads to equity equals assets. To see the difference between ROE and ROA, we need to use ROE’s DuPont Analysis equation.

DuPont Equation

The image above shows that the first half of the ROE equation is ROA because if you cancel the sales then it becomes Net Income/Assets. Financial leverage, also known as equity multiplier, is the main differentiator between ROE and ROA. If a company takes on debt/financial leverage then it would affect the ROE because taking on debt increases the company’s assets. When debt increases, shareholder’s equity decreases which raises ROE. Both ROE and ROA are profitability ratios that are important to consider when looking at a company’s performance.

Using the MarketXLS Template

Instead of doing all the calculations, MarketXLS has a template that makes it easier for investors to use the DuPont Analysis.

MarketXLS template - DuPont Analysis

The table above is a part of the DuPont template. It calculates the ROE of all three factors, thereby reducing your workload. You can use it to compare ROE between multiple companies or between multiple years.
Here is a link to the template MarketXLS – DuPont Analysis Template

Conclusion

Finally, we can see that the DuPont Analysis is important to investors because it can show them the whole picture. A DuPont Analysis will show us what is changing in the company and where exactly are they doing better or lagging. If a company is doing worse than its competitors, you can check whether it has a high cost, thereby decreasing net profit margin or lowering financial leverage. DuPont Analysis is essential in providing a deeper understanding of a company’s financial standing.

Disclaimer

None of the content published on marketxls.com constitutes a recommendation that any particular security, portfolio of securities, transaction, or investment strategy is suitable for any specific person.
The author is not offering any professional advice of any kind. The reader should consult a professional financial advisor to determine their suitability for any strategies discussed herein.
The article is written to help users collect the required information from various sources deemed to be an authority in their content. The trademarks, if any, are the property of their owners, and no representations are made. All trademarks referenced are the property of their respective owners. Other trademarks and trade names may be used in this document to refer to either the entity claiming the marks and names or their products. MarketXLS disclaims any proprietary interest in trademarks and trade names other than its own or affiliation with the trademark owner.

References:
Image of DuPont Model equation 

Information on DuPont Analysis

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
Download Option Templates
Stock screens
Public saved screens

Top 100 Gainers Today

Top 100 losers Today

Call: 1-877-778-8358
Ankur Mohan MarketXLS
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONSGet started today
Search for a stock

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

Top MarketXLS Rank stocks

STORE Capital Corporation logo

STORE Capital Corporation

31.58
 
USD
 
-0.14
 
(-0.44%)
77
Rank
Optionable: Yes
Market Cap: 8,978 M
Industry: REIT - Diversified
52 week range    
24.48   
   36.13
Dillard's Inc. logo

Dillard's Inc.

280.00
 
USD
 
-6.76
 
(-2.36%)
77
Rank
Optionable: Yes
Market Cap: 5,077 M
Industry: Department Stores
52 week range    
167.03   
   416.71
Williams-Sonoma Inc. (DE) logo

Williams-Sonoma Inc. (DE)

125.49
 
USD
 
-3.52
 
(-2.73%)
76
Rank
Optionable: Yes
Market Cap: 8,796 M
Industry: Specialty Retail
52 week range    
101.58   
   223.32
ICF International Inc. logo

ICF International Inc.

108.01
 
USD
 
-0.46
 
(-0.42%)
74
Rank
Optionable: Yes
Market Cap: 2,040 M
Industry: Business Services
52 week range    
84.68   
   111.10
First Interstate BancSystem Inc. logo

First Interstate BancSystem Inc.

41.49
 
USD
 
-1.14
 
(-2.67%)
74
Rank
Optionable: Yes
Market Cap: 4,622 M
Industry: Banks - Regional - US
52 week range    
32.40   
   45.33
Global Cord Blood Corporation logo

Global Cord Blood Corporation

2.99
 
USD
 
0.77
 
(34.58%)
74
Rank
Optionable: Yes
Market Cap: 317 M
Industry: Biotechnology
52 week range    
2.03   
   5.50
Penske Automotive Group Inc. logo

Penske Automotive Group Inc.

100.37
 
USD
 
-3.16
 
(-3.05%)
73
Rank
Optionable: Yes
Market Cap: 7,684 M
Industry: Auto & Truck Dealerships
52 week range    
88.58   
   126.93
General Mills Inc. logo

General Mills Inc.

79.17
 
USD
 
-1.61
 
(-1.99%)
72
Rank
Optionable: Yes
Market Cap: 44,923 M
Industry: Packaged Foods
52 week range    
58.85   
   81.24
Allegiance Bancshares Inc. logo

Allegiance Bancshares Inc.

43.90
 
USD
 
0.18
 
(0.41%)
72
Rank
Optionable: Yes
Market Cap: 883 M
Industry: Banks - Regional - US
52 week range    
35.99   
   46.96
National Research Corporation logo

National Research Corporation

39.24
 
USD
 
0.49
 
(1.26%)
71
Rank
Optionable: No
Market Cap: 948 M
Industry: Diagnostics & Research
52 week range    
30.93   
   52.36

More Features