DuPont Analysis: A Practical Example

The previous Blogs in this series introduced you to the DuPont Analysis; this offering will take up a practical example of how a DuPont Analysis can help you understand the state of a business. The subject of the analysis is a small company that manufactures medical devices of different sorts.  This study uses financials from 2011, at which time the company was about a $1.6 million company. To view or download the DuPont pyramid with pertinent numbers go to this  LINK.

I have discovered that people often feel that financial analysis must be quite complex. Well, yes and no. Large companies with complex business structures can be time consuming to analyze. However, in my experience, small business analysis does not need to be complex at all. As a matter of fact, the problems that a small company may be experiencing are not usually very difficult to pinpoint through financial analysis. The example that follows should give you a feel for the relative simplicity of analysis. Of course, if the numbers themselves are off, so will the analysis, but for the sake of example, the numbers presented in this analysis are accurate.

At the top of the pyramid we have a Return on Equity of 25%. In other words, for every $100 of equity invested in the company, there is a return of $25. Now, how are we to interpret that? There are several aspects to consider. If the company was expecting a 15% return, they are doing quite well. On the other hand, if they were expecting 35%, not so well. The previous year Return on Equity was 26%, which gives you one clue, meaning that the current year is down just a bit. However, the current year’s revenues are up by 16%, so there may be something amiss.

In order to understand better we must go deeper into the pyramid. Return on Capital is 23% with leverage at 1.09, meaning that the small load of debt that the company is carrying is actually improving return on equity (23% X 1.09 = 25%). So the problem is not that the company is over leveraged. As we continue down the left hand side, Net Profit Margin at 23%, Operating Profit margin at 30% and Gross Profit Margin at 72% all seem to indicate that the company has cost under control. On the other hand, perhaps the company could boost returns by increasing leverage. Using debt to increase capital for the purpose of increasing investment might be an option.

When we look at the Total Asset Turnover Ratio (also known as Capital Turnover Ratio), we begin to see the tip of an iceberg peaking above the water. The 1.0 indicates that the company is probably not using capital efficiently. At 1.0, the company is turning each dollar of capital over once a year. So, before the company goes looking for increased debt, they must discover why their use of capital is not more efficient.

We can see that Working Capital Turnover is just over 2, which could be an indication of where the rest of the iceberg is hiding. Working Capital is the amount of investment that is used to keep the company operating. It includes inventory, payables and receivables. Another way that this is expressed is in the Cash Cycle, how many days does it take to circulate a dollar in the process of creating a product, collecting that dollar from clients and paying to vendors.

As we can see, in the pyramid, this company’s cash cycle is 613 days long. Of that cycle, inventory is 554 days. This means that  it takes the company 555 days to circulate a dollar in their production and sales process, including both raw materials and parts purchased from vendors, work in process materials that are unfinished products and inventory both on the company’s shelves waiting to go out  or already on a distributor’s shelf waiting to be sold.

The real problem facing the company is that they are tying up capital in their inventory, making it difficult to deploy that capital for other reasons. For example, if their sales were to create a breakthrough, and they required additional manufacturing capacity, it would be difficult to do without taking on additional loans. But, would they want to take on increased debt when their use of that debt is so inefficient.

The real key is how to shorten their production and sales cycle, so as not to tie up large amounts of capital. The solutions could be improved manufacturing methods such as the use of Just in Time, better forecasting the marketplace for demand and paying closer attention to the inventory on distributor’s shelves. The company would do well to fix this problem before it became an even greater challenge, impeding future growth. In addition to fixing the problem, the company needs to monitor the level of both inventory and working capital closely, to guard against future reoccurrence.

As you can see, understanding the way that financial reports give a vision into the state of a company is not all that difficult. Using the tried and true DuPont Method will afford you that vision into the state of your company, and is well worth the time spent to produce the numbers that “don’t lie”!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s