The DuPont analysis is a financial performance framework which aim is to break down the different financial metrics that affect the return on equity (ROE) to understand what is driving it. Thus, the DuPont Analysis allows having a better understanding of the primary drivers of the return on equity.
Why is the Dupont Analysis helpful?
The financial world can be pretty confusing at times.
Financial news is spread anywhere; Gurus at each corner of the road are ready to tell you how to invest your money;
Although they trust their advice so much that they donโt even invest in what they say you should invest.
Financial magazines offer you subscriptions for a few bucks a year, and you end up buying them all.
The consequence is an excess of information, that although it was supposed to make you feel like an expert actually killed any ability to decide how to invest.
Less is more
The problem of many amateur investors is that they rely too much on external information and overwhelm themselves with useless business knowledge.
They start reading newspapers, watching business channels, and learning the technical jargon that makes them feel part of the game.
This is the โexpert fallacyโ in action.
Although in some fields knowing more about a subject may make you better at predicting what will happen, this is not the case for the financial world.
In fact, the first principle is โless is more.โ
Therefore, rather than concerning yourself with knowing everything is going on in the financial world or wasting your day collecting other peopleโs opinions, it is time to form your own!
The best analysis is the one you do on your own
Here is the second principle: โthe best analysis is the one you do on your own.โ
In fact, if it made sense 10-15 years ago to buy financial information, it doesnโt make sense today (save for a few rare exceptions).
You can find reports and useful data anywhere on the web. This allows you to go straight to the source.
Therefore, the objective here is to form your own unbiased opinion.
Simplicity is the maximum sophistication
Third principle: โsimplicity is the maximum sophistication.โ
Financial charts, formulas, and technical jargon serve to impress people from outside the business world.
Finance is not rocket science, and people from the industry know that.
For such reason, at times these tools are used more as a way to delude rather than for their actual usefulness.
Keep in mind that most of the financial analysis (except very few formulas) is simple arithmetic and common sense, which I am sure everyone possesses.
Having said that, where do we start to perform our analysis?
Zero experience required
The term โfinancial analysisโ may confuse you as well. If you are new to it and if you are not.
You may have approached the discipline in the past and heard many new technical terms, such as LBO, IRR, DCF, CAPM, WACC and you rightly gave all up.
But are those tools necessary to understand the fundamentals of a company?
The answer is a plain “NOT AT ALL!” Although finance professionals use these tools, most of the time they are used more for justifying their pay, rather than for their practicality.
I am not saying those tools are not useful at all, but to the person approaching the financial discipline, it may be too overwhelming.
Therefore, in this article, I want to burst the myth that you have to be a finance professional to perform a practical analysis.
But where do we start?
In this article, I will show you how to analyze a company using the DuPont equation, a straightforward but effective tool.
Keep in mind that the DuPont Analysis doesnโt tell us anything about the future, but a lot about the current state of affairs.
On the other hand, other complex financial tools seem to tell us what will happen in the future, but they are based on assumptions, which, if turned out to be wrong, can be very misleading.
Therefore, we are better off using the DuPont analysis, which is a relatively more straightforward tool, but more useful, rather than a complex tool that gives the impression of understanding, but can lead us to more significant mistakes.
The DuPont analysis uses financial ratios, which are relationships between metrics that we can find on the financial statements.
Letโs start by collecting the financial data we need for the DuPont Analysis.
What to look for?
First, we have to find the financial data for our analysis.
Where do we get it? Bloomberg? Forbes? Financial times? None of them! We just get it from the companyโs website.
Before we move forward, what reports do we want to look at?
Assuming our company is listed and located in the U.S., according to the SEC (Security and Exchange Commission), the reports to submit are of three kinds:
โข 10K.
โข 10Q.
โข 8K.
The 10K and 10Q are very similar forms in which all the financial information (and also the business, strategic and corporate governance information) is reported.
The main difference is that the 10K is an annual report, while the 10Q is a quarterly report. The 8K is a report the company submits each time there are relevant changes to communicate to the investors.
Our purpose here, to analyze the target company is to find the 10K of the firm. Assuming we want to analyze Apple Inc.’s financials for 2015, where do we get them? Go to www.apple.com, and at the bottom of the page, on the right side, under โAbout Apple,โ click on investors:
Once you do so, it will open up a page where all the financials are shown. Our objective here is to download the 10K for 2015. Therefore click on the โfinancial informationโ icon as shown below:
It will open up another screen where all the financial reports are saved. Here we want to download the 10K for 2015.
Follow the instructions below and download your report:
Click on the icon and download the file. It will open up a report. Go to the table of content of the report and look for โfinancial statements and complementary data:โ
Our objective here is to find the consolidated income statement (Apple calls it statements of operations) and balance sheet.
You will find these documents, respectively at pages 39 and 41 of the 10k and they will look like the following:
What is the purpose of the DuPont analysis?
One of the most used ratios in finance is the ROE (return on equity).
This ratio is the relationship between the net income, which is the bottom line of the income statement and the shareholders’ equity (capital endowed by shareholders).
This ratio explains what is the level of return generated for each dollar invested.
For example, a 20% ROE means that for each dollar invested into the business, 20 cents are earnings.
Keep in mind that returns are not dividends.
In other words, the profits generated by the firm will not be automatically distributed to shareholders. Indeed, the part of profits distributed to shareholders is called dividends.
Often a company that produces high returns also distributes higher dividends than non-profitable companies (true in most cases).
In short, a company that can produce a high ROE usually is also well-perceived by investors.
There is a drawback to this ratio tough. The ROE usually increases for three reasons: the net income increases, the shareholdersโ equity decreases or both conditions are met.
While the first case is most of the time a good sign, the other condition (the shareholders’ equity decreased) isnโt always a good sign:
An increase in net income is usually due to improved profitability or better efficiency in business operations.
Instead, a decrease in shareholdersโ equity is usually associated with higher leverage, which can be bad for the company in the long run.
Therefore the objective here is to see how the ROE evolved over time.
Did it increase from 2014? If so, why?
What data do we need?
To perform the DuPont analysis, we need to perform three ratios:
Net Margin, given by Net Profits over Sales.
This ratio explains how profitable a company is.
In short, when firms can have excess money left after paying for their expenses, interests, and taxes, this is called net profits.
A high net margin is a good sign, and usually, this happens for two main reasons.
On one hand, when the firm can charge a higher price for its products and services or sell a high quantity of them, the profitability improves.
On the other hand, when a firm can reduce its overall expenses, its profitability improves.
For instance, the company may get a better price for the raw materials due to its good relationship with suppliers.
Therefore, through the net margin, we will check the firm’s profitability level.
Asset Turnover is given by sales over total assets.
This ratio explains the ability of the firm to use its assets to generate revenues.
In other words, when a company buys an asset, it does that to improve its revenues in the future.
Therefore, from a firm, which is efficiently managed, we expect that with the increase in the value of its assets, also the revenues will grow.
For instance, Apple opened new retail stores (increased assets) because it wanted to expand its revenue growth.
Furthermore, we can expect that opening new retail stores will positively impact the firm’s revenues. If this condition is met, the company’s assets will be well managed.
This ratio will be expressed as a number and will tell us how much revenue is generated for each dollar invested in assets.
For instance, an asset turnover of 0.50 means that for each dollar invested in assets are produced 50 cents in revenues are.
Financial Leverage is given by total assets over equity.
This ratio will be expressed in percentages and will explain the amount of equity for the assets owned by the organization.
The higher the number, the more debt has been pumped into the company and the riskier the company may become over time.
Usually, leverage itself is not a bad thing. In many circumstances, using debt is way cheaper than using your capital.
For instance, if you try to buy a house, which costs $100K, you can put 100% capital or use 50% capital and borrow 50% from the bank.
Assuming you will sell the house in one year at $120K, your ROI (return on investment) will considerably increase by using leverage.
For instance, if you sell the house for $120K after putting in $100K of capital, your ROI before interest and taxes will be 20%, given by the sale’s profit (120K โ 100K) over the initial capital invested (100K).
In the second scenario, you still sell the house for $120K, but in this case, your ROI before interest and taxes will be 40%.
In short, you used leverage (debt) to double your ROI, which didn’t bring any downside.
If financial leverage is not necessarily a bad thing, it starts to be dangerous when interest payments rise steeply and swipe your profits away.
To sum up, given the three ratios above, we need the following data from the financial statements of Apple Inc.: Sales, Net Income, Total Assets, and Equity. We are ready to move forward.
Extrapolate the data from the financial statements
We will get the sales and net income from the statement of operations. Furthermore, we will get the total assets and equity from the balance sheet. We need the data for 2015 and 2014 to understand the trend.
Letโs get sales and net income from the income statement, like in the example below:
Then letโs get total assets and total equity from the balance sheet, like in the example below:
We have the financial data; we can move forward.
Perform the DuPont analysis
We are going to perform this DuPont analysis in three easy steps.
In step number one we are going to compute the ROE for 2014 and 2015.
In step two, we will run the three ratios for our DuPont Analysis.
In the third step we are going to draw some conclusions.
Step one: ROE for 2014 โ 2015
To compute our ROE we are going to take the net income and then divide it by the total equity.
Usually, it is even more appropriate to take the average equity for the current year and the previous year.
This is because equity can change considerably between one year and the other.
In this specific case, though, to keep it simple, we are going to use the equity for the current year.
ROE 2015 = 53,394/119355 = 44.7%
ROE 2014 = 39,510/111547 = 35.4%
The thing that you notice immediately is that the ROE increased by almost 10% from 2014 to 2015, which means 26% in one year! Pretty astonishing!
We want to know why this happened. We are going to find out in the second step.
Step two: Net Margin, Asset Turnover, and Financial Leverage for 2014 and 2015
We are going to complete this step and divide it into three sub-steps:
Sub-step one: we are going to compute our net margin
Net margin for 2015 = 53,394/233,715 = 22.8%
Net margin for 2014 = 39,510/182,795 = 21.6%
The net margin for 2015 is 22.8%, which means that Apple Inc. still has 22.8% of the money left after paying all its suppliers, business expenses, interests (although Apple didnโt pay any in 2015), and taxes.
In addition, the profitability slightly improved from 2014 to 2015 (5.7% increase).
Sub-step two: also, in this case, it is common to use the average total assets, but for simplicity, we are going to take the total assets for the current year. We are going to compute the asset turnover
Asset turnover for 2015 = 233,715/290,479 = $0.80
Asset turnover for 2014 = 182,795/231839 = $0.79
Remember that this ratio is expressed as a number, which we will interpret as a $ amount.
In this case, Apple Inc. in 2015 produced 80 cents of revenues for each dollar of asset invested. The asset turnover grew by 2% in 2015 compared to 2014.
Sub-step three: we are going to compute the financial leverage:
Financial leverage for 2015 = 290,479/119,355 = 243.4%
Financial leverage for 2014 = 231,839/111,547 = 207.8%
The financial leverage in 2015 was 243.4%, which means that most of the companyโs assets have been financed through debt.
Indeed, total liabilities (all the debt outstanding of the firm) represent 59% of the total assets. The financial leverage of the company increased by 17% in 2015.
We are ready to move forward and draw some conclusions here.
Step three: conclusions from DuPont analysis
By performing the DuPont Analysis, it came out that although the ROE increased by 26% in 2015, this happened mainly due to financial leverage.
In short, Apple Inc. increased its level of debt considerably in the last year while its shareholders’ equity didn’t keep pace.
In fact, profitability and asset efficiency, respectively increased by 6% and 2% in 2015. Instead, financial leverage increased by 17%!
This is not necessarily a bad thing.
In fact, it seems that Apple will be able to manage its interest payments in the future, given its high profitability.
- On the other hand, due to this increased debt burden, we may expect to see fewer profits in the future. We may go even further and check in the 10K why Apple Inc. is using debt to increase its ROE, but we will stop here for simplicity’s sake.
Conclusions
- In this article, I wanted to show you that it is possible also for the non-finance professional to make his analyses by using tools that are simple and effective.
- So far, we took some metrics from the primary financial statements to understand what was going on with Apple Inc. ROE, and we ended up analyzing the profitability, asset use, and financial leverage of the company. This is, of course, part of the picture, but it is a good starting point.
- If so far you thought that learning financial analysis was impossible for you, you may want to reconsider that.
- Why Ratio Analysis?
- Financial Ratio Analysis and interpretation
- Key financial ratios
- Types of financial ratios
- How, why and when to use financial ratios
Connected Financial Concepts
Read next:
- Accounting Equation
- Financial Statements In A Nutshell
- Cash Flow Statement In A Nutshell
- How To Read A Balance Sheet Like An Expert
- Income Statement In A Nutshell
- What is a Moat?
- Gross Margin In A Nutshell
- Profit Margin In A Nutshell
Main Free Guides: