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.


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


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.


None of the content published on 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.

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

Top 100 Gainers Today

Top 100 losers Today

Real gdpReal personal consumption expReal private investmentReal govt expenditureReal net exportsReal exportsReal importsFederal receiptsFederal outlaysFederal surplus or deficitFederal debtReal private investment nonresidentialReal private investment residentialReal potential gdpReal personal incomeReal personal consumption exp monthlyRpce durable goodsRpce nondurable goodsRpce servicesPersonal savings rateMonetary baseCurrency in circulationBank reservesMoney supply m1Money supply m2Sp500DjiaWilshire indexVixFinancial stress indexCorporate bond index aaCorporate bond index bbbFederal funds rateTreasury rate 3mTreasury rate 1yTreasury rate 5yTreasury rate 10yTips 5yTips 10yBond yield aaaBond yield baaMortgage rate 15yMortgage rate 30yUs dollar weighted averageUsdollar to euroUsdollar to poundYuan to usdollarCanadiandollar to usdollarYen to usdollarCpiCpi wo food energyCpi foodCpi energyChain price indexChain price index wo food energyGdp price deflatorPpi final demandPpi finished goodsPpi materialPpi crude goodsPpi final demand wo food energyPpi finished goods wo food energyHouse price indexHouse price index 20cityCrude oil priceGasoline priceNatural gas priceIndustrial productionCapacity utilisationInventoriesSales retail foodVehicle sales light weightManufacture orders durablesManufacture orders capital goodsLoansConsumer credit outstandingCorporate profitsHousing startsBuilding permitsResidential constructionEmployees nonfarmEmployees privateEmployees goods producingEmployees service providingEmployees governmentUnemployment rateInitial cliamsAverage weeks unemployedJob openingsHiresSeparationsQuitsLayoffs dischargesHours of productionHourly earningsReal outputPopulationLabor forceLabor force participation rate
Search for a stock

Top MarketXLS Rank stocks

Cowen Inc. logo

Cowen Inc.

Optionable: Yes
Market Cap: 859 M
Industry: Capital Markets
52 week range    
Booz Allen Hamilton Holding Corporation logo

Booz Allen Hamilton Holding Corporation

Optionable: Yes
Market Cap: 11,928 M
Industry: Business Services
52 week range    
Rush Enterprises Inc. Class B Common Stock logo

Rush Enterprises Inc. Class B Common Stock

Optionable: No
Market Cap: 2,846 M
Industry: Auto & Truck Dealerships
52 week range    
Amdocs Limited logo

Amdocs Limited

Optionable: Yes
Market Cap: 10,201 M
Industry: Software - Infrastructure
52 week range    
NBT Bancorp Inc. logo

NBT Bancorp Inc.

Optionable: Yes
Market Cap: 1,640 M
Industry: Banks - Regional - US
52 week range    
CRA InternationalInc. logo

CRA InternationalInc.

Optionable: Yes
Market Cap: 661 M
Industry: Business Services
52 week range    
CatchMark Timber Trust Inc. Class A logo

CatchMark Timber Trust Inc. Class A

Optionable: Yes
Market Cap: 504 M
Industry: REIT - Diversified
52 week range    
America's Car-Mart Inc. logo

America's Car-Mart Inc.

Optionable: Yes
Market Cap: 683 M
Industry: Auto & Truck Dealerships
52 week range    
ManTech International Corporation logo

ManTech International Corporation

Optionable: Yes
Market Cap: 3,917 M
Industry: Software - Application
52 week range    
CACI International Inc. Class A logo

CACI International Inc. Class A

Optionable: Yes
Market Cap: 6,536 M
Industry: Information Technology Services
52 week range    

More Features

Stand with Ukraine

As the situation in Ukraine escalates, many of us in MarketXLS are left with emotions too overwhelming to name. If you’d like to show your support, but aren’t sure how to, we want to help make it easier for you to act.

For any amount donated, we’ll extend your MarketXLS subscription for double of the donated amount. Please send proof of your payment to to avail the extention

From all of us at MarketXLS, thank you!