Jan 21, 2012

DuPont Financial Analysis Model


DuPont Financial Analysis Model : A Process For Knowing Where to Spend My Management Time Tomorrow Morning After Breakfast

By
Kevin Bernhardt, UW-Extension, UW-Platteville, and
UW Center for Dairy Profitability

Our computer technology today provides wonderful opportunities to collect, manipulate, and process data including financial analysis data.  Sure, it gives a manager lots of numbers, but what do they mean in terms of where to spend my creative management time tomorrow morning after breakfast? 

There is no lack of ratios to calculate from financial data, each of which is a valuable piece of information to the manager.  The Farm Financial Standard Council’s sweet 16 ratios (recently expanded) have been a standard for years in helping farm managers evaluate their financials.  However over several years of teaching undergraduate students and Extension clientele I often found it difficult for people to wrap their arms around what the ratios were indicating and ultimately where to spend their valuable management time.  The challenge often led to indifference by the undergraduate students and a lack of seeing any value to go further by Extension clientele. 

The DuPont system for financial analysis is a means to fairly quickly and easily assess where the business strengths and weaknesses potentially lie and thus where management time may optimally be spent.  It is not the only nor the most thorough, but it is a fairly straight-forward and systematic means to drill back into the financial numbers to determine the source or lack thereof for financial performance.

A colleague, Gregg Hadley (UW-River Falls), summed up well the DuPont system in a recent article on E-Extension (The DuPont Analysis: Making Benchmarking Easier and More Meaningful, Updated June 10, 2009, http://www.extension.org/pages/The_DuPont_Analysis:_Making_Benchmarking_Easier_and_More_Meaningful):

If we are lucky enough to have the minimum number of financial documents needed to conduct a meaningful financial analysis (both beginning and ending balance sheets, either an actual accrual or accrual adjusted income statement, and a statement of cash flows), we are then inundated with pages and pages of intimidating numbers to sort through.

This gives many managers and advisers a justification not to give their financial records anything more than a passing glance. This is unfortunate. A good financial performance analysis should do more than inform about how a farm performed in the past. More important, it should provide the manager and adviser with insight regarding how to prioritize activities that will enable the farm to improve its financial performance.

The DuPont system has disadvantages as does any financial analysis system.  However, its advantage beyond simplicity of use is that it takes into account the major levers of firm profitability – efficiency, asset use, and debt leverage.

Anatomy of Profits
Before describing the DuPont system, consider the anatomy of profits.  The accounting equation is:

Total Assets = Total Debt + Total Owner Equity

As the accounting equation shows every penny of assets comes from one of two sources – that financed by debt (borrowed capital) and that financed by equity (the owner’s own money).  Assets can also be described by those that are capital assets versus short-term inventory or market assets.  Capital assets are longer-term investments (land, machinery, breeding stock, etc.) that are not sold themselves to make profits, but are put to work to produce marketable inventory that can be sold for profits (feeder cattle, eggs, etc.).  Inventory also includes inputs such as feed, seed, and fertilizer.

Businesses earn profits by mixing their labor and management with inputs and capital assets to produce goods for sale.  The DuPont system recognizes this recipe for profit-making and segregates it into three distinct components or levers:
1.      Earnings (or efficiency),
2.      Turnings (effective use of assets), and
3.      Leverage (using debt to multiply earnings and equity)

In the DuPont system one can drill back into these three levers to determine where profit performance is coming from and potentially determine where management time should be spent for improving profits.  Specifically DuPont measures:
1.      How efficiently inputs are being used to generate profits [Earnings]
2.      How well capital assets are being used to generate gross revenues [Turnings]
3.      How well the business is leveraging its debt capital [Leverage]

Figure 1 shows a graphic of the DuPont system.  It begins on the far right side with Rate of Return on Equity (ROROE).  High ROROE is the prize in the DuPont system.  ROROE is calculated as:
Net Income from Operations – Unpaid Labor & Management
Total Owner Equity
The financial manager can then drill backward to see where ROROE performance either is, or is not, coming from. 


Starting on the upper side ROROE, in-part, comes from how well the business is earning profits from its assets as measured by the Rate of Return on Assets (ROROA).  ROROA is calculated as:
[Net Income from Operations   +   Interest   –   Unpaid Labor and Management
Total Assets
It makes sense that the higher the ROROA the higher the ROROE.  In-turn, the ROROA comes from two components or levers of profitability. 
One is how efficient the manager is in turning inputs into outputs, or in a financial sense, how efficient the manager is in turning the gross revenue of dollars coming into the business into net profits that are kept in the business after all expenses are paid.  This is the “Earnings” lever and is measured by the Operating Profit Margin Ratio (OPMR).  The calculation is:
[Net Income from Operations   +   Interest   –   Unpaid Labor and Management
Gross Revenue
Interest is added back so that the measure you get is one that measures efficiency of operations regardless of the debt structure.   Debt structure effects will come into the system later.  In situations where there is unpaid labor and management it is deducted to recognize the value of the labor and management.  The more efficient you are in turning gross sales into profits that you keep the higher your Rate of Return on Assets and ultimately the higher your Rate of Return on Equity.
The second source of ROROE is how well you are using the assets of the business.  This lever is referred to as “Turnings” meaning how well you are turning assets into production and sales of product.  To use an extreme example, if you had a 300 acre farm (all tillable) that you left sit idle then your performance of turning assets into production and sales of product would go way down.  The “turnings” lever is measured by the Asset Turnover Ratio (ATO).  The calculation is:
Gross Revenue
Total Assets
The better able you are to use the assets you have to produce and sell product the higher the Rate of Return on Assets will be and the higher the Rate of Return on Equity.
The last lever is “Leverage,” which is also known as “Equity Multiplier”.  Before going further with the explanation of leverage, it is worth backing up a step and exploring the accounting equation again
(Total Assets = Total Debt + Total Equity).
Given this equation, which is true for every business, then any profitable return to the use of assets is a profit return to the assets financed by debt and to those financed by equity.  Equity is fairly straight-forward, if you invest $100 of your own money and earn $10 back then your equity has returned 10% (10/100).  For the return to debt it is a bit more complicated because you have to pay someone for the use of the debt – interest.  So, the question becomes whether or not the debt you have is returning a profit larger than the interest you have to pay for using that debt.  If it is then the leftover profit after paying interest is an additional return to your equity.  That is, if I’m paying 8% interest and my profit return on the debt is 10%, then I not only can pay my interest, but I have 2% leftover that I get to keep.  This 2% becomes and increase to my equity.  This is why the debt or leverage component of DuPont is sometimes called an “Equity Multiplier.”
It may seem an odd statement to make for some, but if you want to increase your ROROE then one way to do it is to increase your debt!  The trick is that the debt must be managed in a way that returns a profit greater than the interest rate.  If it is not then the equity multiplier still works, just in the wrong direction!
Ultimately the leverage lever is measured by the Debt to Asset ratio (D:A), which is calculated as:
Total Debt
Total Assets
For ease of the math in the model, the leverage lever can be expressed as:
Total Assets
Total Equity
The greater this ratio then the more the proportion of debt is in the mix of assets.  If the assets financed by debt are earning a return greater than the interest rate, then the higher the ratio the greater the Rate of Return on Equity.

Figure 2 shows the same DuPont model with the ratio measures.

Note, the interest rate adjustment in the ROROA box is the adjustment needed to return the cost of interest before measuring the Rate of Return on Equity.  Recall that interest was taken out when calculating the OPMR.

The DuPont system as illustrated allows you to identify where profit performance is, or is not, coming from in one or more of three areas.  Once identified then the next step is to drill back into the numbers that make up the ratio of concern.

For example, if the OPMR is found to be lower than the manager would like it to be then look at the numerator of the OPMR (net income from operations + interest – unpaid labor & mgt) to determine what might be the problem, particularly expenses.  Compared to your more profitable peers what are your labor, vet, repair, and other input costs? 

If the performance problem appears to be coming from a low ATO then the manager might drill back into the business assets to see how well they are being used.  Are there dead assets in the business (ones not being used to create product for sales), does the business have excess machinery capacity, or are there assets that are under productive (poor weight gain, breeding cycles too long, sickness, death loss, etc.).

If the debt structure is low, that is debt is not leveraging equity as much as peer businesses, then the manager might drill back and question how debt is being used.  Could additional debt be used to improve facilities, machinery, etc. that ultimately pays for itself in higher production and sales or does debt that is not productive need to be paid off (or perhaps the assets sold). 

As with all financial analysis systems the model is only as good as the numbers that go into it, that is, garbage in then garbage out.  Another valuable piece of information to have to evaluate DuPont is benchmarks of profitable peers.  There are general ranges for each of the ratios, but each industry and your size within an industry makes a difference as to what is “good” for the ratios.  Finally whether you rent or own the assets you use in a business also makes a difference in the interpretation of the ratios. 

Appendix A provides a brief example of using the DuPont model.

It is often said that management is part science and part art.  The DuPont system has both elements.  The ratio calculations are science and just a manipulation of numbers.  The art is interpreting the ratios and drilling back into where the ratios indicate there could be challenges and thus information of where to spend your creative management time tomorrow morning after breakfast. 
Appendix A
Brief Example (Adapted from an example from Texas Tech University) http://www.aaec.ttu.edu/faculty/phijohns/AAEC%204316/Lecture/notes/DUPONT.htm

Table 1. DuPont Analysis for Two Farms

Farmer A
Farmer B
1. Operating profit margin ratio (OPMR)
0.30
0.12
2. Asset turnover ratio (ATO)
0.20
0.36
3. ROROA (1*2)
0.060
0.043
4. Interest expense to avg. farm assets
0.05
0.03
5. Equity multiplier
2.00
1.50
6. ROROE (3-4) * 5
0.02
0.02
Farmer A and Farmer B each have a 2 % ROROE.  However, the levers of the DuPont system indicate that the sources of the weakness are different.  Farmer A has a stronger operating profit margin ratio but lower asset turnover compared to Farmer B. Furthermore, Farmer A has a higher leverage ratio (equity multiplier) than Farmer B.
The weak ratios for each farm may be decomposed into components to determine the potential sources of the weakness. To improve asset turnover Farmer A needs to increase production efficiency or price levels or reduce current or noncurrent assets. To improve profit margins, Farmer B needs to increase production efficiency or price levels more than costs or reduce costs more than revenue.
The DuPont analysis is an excellent method to determine the strengths and weaknesses of a farm. A low or declining ROROE is a signal that there may be a weakness. However, using the DuPont analysis can better determine the source of weakness. Asset management, expense control, production efficiency or marketing could be potential sources of weakness within the farm. Expressing the individual components rather than interpreting ROROE itself may identify these weaknesses more readily.





3 comments:

  1. Excellent blog right here! Also your web site lots up fast!
    What web host are you the use of? Can I get your affiliate link in your host?
    I desire my website loaded up as fast as yours lol
    Also see my website :: green coffee bean dr oz

    ReplyDelete
  2. What's Happening i am new to this, I stumbled upon this I have discovered It positively helpful and it has aided me out loads. I am hoping to give a contribution & aid different users like its helped me. Good job.
    Also see my page :: electronic cigarette wholesale

    ReplyDelete