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: Finallymultiply 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!
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.
Global Association of Risk Professionals,
Inc. (GARP®) does not endorse, promote, review or warrant the
accuracy of the products or services offered by Edu for FRM®
related information, nor does it endorse any pass rates claimed by
the provider. Further, GARP is not responsible for any fees or
costs paid by the user to Edu nor is GARP responsible for any fees
or costs of any person or entity providing any services to Edu
Study Program. FRM®, GARP® and Global Association of Risk
Professionals®, are trademarks owned by the Global Association of
Risk Professionals, Inc
CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas®, and Chartered Financial Analyst® are trademarks owned by CFA Institute.
Utmost care has been taken to ensure that
there is no copyright violation or infringement in any of our
content. Still, in case you feel that there is any copyright
violation of any kind please send a mail to firstname.lastname@example.org and we
will rectify it.