Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Fundamental analysisValuation Models

Dupont Analysis In Excel With Marketxls Template

Written by admin
Mon Apr 17 2017
Dupont Analysis In Excel With Marketxls Template - MarketXLS
See how MarketXLS helps you take advantage in the markets.
Dupont Analysis In Excel With Marketxls Template - MarketXLS

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
I agree to the MarketXLS Terms and Conditions
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.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and starter sheets.
Get started today

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

Get started today

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord