Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Logout MarketXLS
Fundamental analysisValuation Models

Dupont Analysis In Excel With Marketxls Template

Written by admin
Mon Apr 17 2017
dupont analysis in Excel
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →
dupont analysis in Excel
 

Dupont analysis in Excel with MarketXLS

Dupont analysis is a way to look at two ratios, ROA and ROE. Mainly, we decompose these ratios and look at different parts of these, so maybe we can get a better understanding of what is going on in the firm. Scientists at Dupont Corporation first used Dupont analysis in the 1920’s. This article explains the concept and provides the guidance on how to do Dupont analysis in Excel with MarketXLS

Essentially, DuPont analysis an accounting equation, so before we go into the detail let us look at what ROA and ROE are.

So, let’s say we have revenues of USD 100 and Expenses of USD 90 in our income statement. Our Net Income in the Income statement is USD 10. On the Balance Sheet, let’s say we have Assets of USD 100 and liabilities of USD 50.

ROA is the return on the Assets. So, in our example its 10/100 (10%). In essence, it is an indicator of how a firm can utilize the Assets it has. ROE, on the other hand, is the return on the equity. Think about equity as if you pay back all your liabilities how much Assets you will be left. So, in our example, Equity will be Assets – Liabilities = 100-50 = USD 50. So, ROE is essentially a return on this equity so 10/50 (20%).

Two main elements drive Net Income; you could either sell more or you less but with a higher margin.

So, let’s say there are two companies with the same net income; one company could be generating this revenue by selling more and other company could be making same net income by selling less with higher margins. So, the fundamental idea is that just by looking at ROA we can not make out if this return is more due to better margins or its due to more sales.

We can demonstrate this by multiplying and divide the ROA equation by Revenue. The first element is the Profit Margin and the second one is asset turnover ratio.

Dupont analysis example

If a company has zero liabilities, that means equity finances all the assets of the enterprise. If that is the case, then the ROE will be equal to ROA. However, in a typical situation, ROE will be higher than the ROA because equity is a part of the assets.

For ROE, if you multiply the previous equation by a factor called Equity Multiplier (which is a way to show how much of the total assets is from equity) you get the ROE. Now, if all the assets come from the equity multiplier will be 1, so ROE and ROA will be the same.

Dupont analysis example

So, Dupont analysis just another way of looking at the ROE and ROA and decompose its parts to find out which part in the ratio is making the ratio look better or worse.

Different industries may have different benchmark margins and asset turnover ratios. So, when comparing companies, we will see what if they are reflective of the industry or not.

dupont analysis in Excel

We have created the template to do Dupont analysis in Excel, you can use it with MarketXLS

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

Dick's Sporting Goods Inc logo

Dick's Sporting Goods Inc

109.82
 
USD
 
5.18
 
(4.95%)
86
Rank
Optionable: Yes
Market Cap: 8,757 M
Industry: Specialty Retail
52 week range    
63.45   
   142.78
Dillard's Inc. logo

Dillard's Inc.

285.06
 
USD
 
12.30
 
(4.51%)
80
Rank
Optionable: Yes
Market Cap: 4,506 M
Industry: Department Stores
52 week range    
184.12   
   416.71
EOG Resources Inc. logo

EOG Resources Inc.

119.93
 
USD
 
8.20
 
(7.34%)
76
Rank
Optionable: Yes
Market Cap: 61,798 M
Industry: Oil & Gas E&P
52 week range    
80.67   
   147.99
STORE Capital Corporation logo

STORE Capital Corporation

31.36
 
USD
 
0.03
 
(0.10%)
75
Rank
Optionable: Yes
Market Cap: 8,941 M
Industry: REIT - Diversified
52 week range    
24.48   
   36.13
National Research Corporation logo

National Research Corporation

40.64
 
USD
 
0.84
 
(2.11%)
75
Rank
Optionable: No
Market Cap: 983 M
Industry: Diagnostics & Research
52 week range    
30.93   
   52.36
Chesapeake Energy Corporation logo

Chesapeake Energy Corporation

98.93
 
USD
 
4.72
 
(5.01%)
75
Rank
Optionable: Yes
Market Cap: 11,105 M
Industry: Oil & Gas E&P
52 week range    
56.75   
   105.93
NACCO Industries Inc. logo

NACCO Industries Inc.

48.70
 
USD
 
1.67
 
(3.55%)
74
Rank
Optionable: No
Market Cap: 346 M
Industry: Coal
52 week range    
28.32   
   63.19
Marathon Oil Corporation logo

Marathon Oil Corporation

24.97
 
USD
 
2.39
 
(10.58%)
74
Rank
Optionable: Yes
Market Cap: 14,494 M
Industry: Oil & Gas E&P
52 week range    
14.29   
   33.24
Destination XL Group Inc. logo

Destination XL Group Inc.

5.75
 
USD
 
0.33
 
(6.09%)
74
Rank
Optionable: No
Market Cap: 340 M
Industry: Apparel Stores
52 week range    
3.27   
   9.00
CF Industries Holdings Inc. logo

CF Industries Holdings Inc.

100.30
 
USD
 
4.05
 
(4.21%)
74
Rank
Optionable: Yes
Market Cap: 19,103 M
Industry: Agricultural Inputs
52 week range    
55.29   
   119.60

More Features