January 23rd, 2012
The DuPont Analysis is an approach that breaks down ROE (Return on Equity) into a function of 3 or 5 ratios that helps to see the impact of each ratio on ROE.
Suppose you are going through the financial ratios of our company and stop at ROE and wondering what are the factors that are contributing or impacting the ROE. You called your accountant and asked him to find the means through which factors impacting ROE can be tracked. Considering your concern, the accountant is explaining you the two variants of DuPont Analysis.
- The three part approach
- The extended five part approach
Original Formula for ROE
Now multiply (Revenue/Revenue) with the above mentioned formula and re-arrange the terms
Now multiply (Total Assets/Total Assets) and re-arrange the terms
If we further breaks down the Net Profit Margin, it becomes the extended five part DuPont equation.
Therefore the extended DuPont equation is
Procedure for three-part Approach
Step 1: Calculate the Net Profit Margin
Step 2: Calculate the Asset Turnover Ratio
Step 3: Calculate the Financial Leverage
Step 4: Finally multiply all the three ratios to calculate the ROE
Procedure for five-part Approach
Step 1: Calculate the Tax Burden
Step 2: Calculate the Interest Burden
Step 3: Calculate the EBIT Margin
Step 4: Calculate the Asset Turnover Ratio
Step 5: Calculate the Financial Leverage
Step 6: Finally multiply the entire above calculated ratio together to get the ROE
Dupont Analysis Templates to download
I have created a Dupont Analysis template for you, where the subheadings are given and you have to link the model to get the cash numbers! You can download the same from here. You can go through the case and fill in the yellow boxes. I also recommend that you try to create this structure on your own (so that you get a hang of what information is to be recorded).
Also you can download this filled template and check, if the information you recorded, matches mine or not!
About the Author
Pankaj Baheti is a CFA Level III Candidate currently working with Pristine. Prior to Pristine, he was working with Achi Group. He has done his Post Graduate Diploma in Management and loves trekking in the hills of Arunachal.
FREE 10 days
- Business Analytics
- Career in Finance
- CFA Concept Checkers
- Chartered Financial Analyst (CFA)
- Diagnose FRM
- Financial Modeling
- Financial Modeling Templates
- Financial Risk Manager (FRM)
- Free Quizzes
- FRM Interviews
- Professional Risk Manager (PRM)
- Project Management
- Tips and Material
- Value at Risk (VAR)