Wall Street Prep

DuPont Analysis

Learn the Steps to Perform DuPont Analysis with Excel Template

Learn Online Now

DuPont Analysis

Key Learning Objectives
  • What is the purpose of performing DuPont analysis?
  • What are some of the components of the DuPont analysis?
  • How are the 3-step and 5-step DuPont variations different?
  • Which specific factors increase (or decrease) a company’s ROE?

3-Step DuPont Analysis

In a 3-step DuPont analysis, the equation states that if a company’s net profit margin, asset turnover, and financial leverage are multiplied, you will arrive at the company’s return on equity (ROE).

As the simpler version between the two approaches, the ROE is broken into three components:

  1. Net Profit Margin = Net Income ÷ Revenue
  2. Asset Turnover = Revenue ÷ Average Total Assets
  3. Financial Leverage Ratio = Average Total Assets ÷ Average Shareholders’ Equity

The starting point to arrive at these three components is the ROE formula.

  • Return on Equity (ROE) = Net Income ÷ Average Shareholders’ Equity

If we multiply the ROE formula above by two ratios – (Revenue / Revenue) and (Average Total Assets / Average Total Assets) – we are essentially multiplying ROE by one since the numerator and denominator are the same in both ratios.

But with some re-arranging of the terms, we arrive at three standard metrics: the net profit margin, asset turnover ratio, and leverage ratio.

The DuPont formula shown below is the most commonly used equation:

DuPont Analysis Formula

Upon splitting up the ROE calculation into these three components, the changes in ROE can be better understood and what is driving the net increase (or decrease).

The DuPont analysis implies that a company can increase its ROE if it:

  • Generates Higher Net Profit Margin
  • Efficiently Utilizes Assets to Generate More Revenue
  • Increases its Financial Leverage
DuPont Analysis Flow Chart

DuPont Analysis

Net Profit Margin

The net profit margin represents a company’s “bottom line” profitability once all expenses have been deducted, including the interest expense payments on debt obligations and taxes to the government.

If the net profit margin increases, each dollar of revenue will bring in more earnings to the company, resulting in a higher return on equity (ROE).

Therefore, a company’s net income represents the remaining profits left over, which are attributable to one specific group of capital providers – the equity shareholders.

Asset Turnover Ratio

For the second component, the total asset turnover ratio is an efficiency ratio tracking the ability of a company to generate more revenue per dollar of asset owned.

If a company improves upon its turnover ratio, the ROE increases because the implication is that it can utilize its assets better – i.e. generate more revenue with fewer assets.

The first two components – the net profit margin and total asset turnover – represent measures of operating efficiency and asset efficiency.

Financial Leverage

The third and final component is financial leverage, which is the amount of debt in the company’s capital structure.

The use of more debt financing leads to higher interest expenses, which are tax-deductible and create a “tax shield” that reduces the amount of taxable income.

Often called the “equity multiplier,” increasing the amount of debt to benefit from the lower taxes, the lower cost of capital, and obtaining access to a cheaper funding source could easily backfire from irresponsible decision-making.

Hence, the company must be led by a management team with their interests aligned with that of its shareholders.

The company must strike the right balance between benefiting from debt financing but not placing excess leverage on the company, where the company’s cash flows are insufficient to handle all the debt obligations and are now at risk of default.

5-Step DuPont Analysis

The five components to the 5-step DuPont formula are the following:

  1. Tax Burden = Net Income ÷ Pre-Tax Income
  2. Asset Turnover = Revenue ÷ Average Total Assets
  3. Financial Leverage Ratio = Average Total Assets ÷ Average Shareholders’ Equity
  4. Interest Burden = Pre-Tax Income ÷ Operating Income
  5. Operating Margin = Operating Income ÷ Revenue

DuPont Analysis Formula Five Part

There are two additional components in the 5-step equation as compared to the 3-step equation. To expand further upon the additional parts of this formula:

  • Tax Burden: Proportion of profits retained post-taxes
  • Interest Burden: Depicts the extent to how much interest expense impacts profits
  • Operating Margin: Operating profit (EBIT) retained per dollar of sales after deducting COGS and OpEx

All three of these new parts are extensions of the net profit margin calculation.

  • Net Profit Margin = EBIT Margin × Tax Burden × Interest Burden

DuPont Excel Template

Now that we’ve discussed the 3-step and 5-step DuPont formulas, we can now move on to applying those concepts into practice.

For access to the model template, fill out the form below:

dl
Submitting ...

DuPont Model Assumptions

In the first part of our DuPont modeling exercise, we’ll start with the model assumptions.

Here, we’ll be assessing three different operating scenarios:

  1. “Downside” Case
  2. “Base” Case
  3. “Upside” Case

For our projections, we’ll be using the “Downside” case as our starting point. We’ll be using a step function and use different step values for the other two cases.

Income Statement Assumptions

Downside Case

  • Revenue: $200m
  • Cost of Goods Sold (COGS): –$140m
  • Operating Expenses (OpEx): –$40m
  • Interest Expense: $0m

Then, from those figures, we’ll be using the following step-functions – i.e. the value of the hard-coded number in blue font is added to the cell on the left.

I/S Step Function

Base and Upside Case

  • Revenue: +$50m
  • COGS: –$10m
  • OpEx: –$10m
  • Interest Expense: –$10m
  • Tax Rate: 25% – Constant in Each Case

Next, we’ll move on to the balance sheet assumptions, for which we only require two data points, the “Average Total Assets” and “Average Shareholders’ Equity” accounts.

Balance Sheet Assumptions

B/S Downside Case

  • Average Total Assets: $500m
  • Average Shareholders’ Equity: $500m

B/S Base and Upside Case – Step Function

  • Average Total Assets: –$50m
  • Average Shareholders’ Equity: –$100m

Since there is no debt in the capital structure in the “Downside” case, the total assets must equal the average shareholders’ equity for the balance sheet to remain in balance.

The completed financials based on the provided assumptions are shown below.

Model Assumptions

DuPont ROE Example Calculations

We now have all the required inputs to calculate ROE using both the 3-step and 5-step DuPont approaches.

To calculate the ROE under the 3-step approach, we can use the following formula:

  • Return on Equity (ROE) = Net Profit Margin x Total Asset Turnover x Financial Leverage Ratio

DuPont 3-Step Formula

In the final part of our modeling exercise, we’ll calculate the ROE under the 5-step approach.

The formula for calculating each input is listed on the side, while the ROE formula can be seen in the highlighted cells.

  • Return on Equity (ROE) = Tax Burden × Asset Turnover × Financial Leverage Ratio × Interest Burden × Operating Margin

DuPont 5-Step Formula

From our completed model output, the return on equity (ROE) comes out to:

  • ROE – Downside Case: 3.0%
  • ROE – Base Case: 7.5%
  • ROE – Upside Case: 15.0%

The fact that the ROE is equal in both the 3-step and 5-step approaches confirms that the formulas in our model were entered correctly, as well as how the two are fundamentally identical.

Simply put, the 5-step approach takes the basic approach a tad bit further by getting more into the specifics regarding net income.

In our hypothetical scenario, the two major contributors towards the variance in ROE values were the following:

  1. Margin Expansion in Profitability (i.e. Net Profit Margin, Operating Margin)
  2. Increased Efficiency in Utilization of Assets to Generate Revenue (i.e. Total Asset Turnover)

DuPont Analysis Done

Comments
guest
0 Comments
Inline Feedbacks
View all comments
Learn Financial Modeling Online

Everything you need to master financial and valuation modeling: 3-Statement Modeling, DCF, Comps, M&A and LBO.

Learn More
X

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.