The 10th version of the freefincal automated stock analyzer includes an easy-to-understand graphical analysis of the factors that drive return on equity (ROE) using the five-step Dupont Analysis.
Return on equity is defined as
ROE = Net income/shareholders equity.
It is the profit for each unit of shareholders equity or the earning power of the company. If there is a gradual increase or decrease in ROE, it is beneficial to dig deeper and find out the reasons behind the trend.
Deconstructing the ROE into multiple factors helps us understand the factors that drive the ROE change. This was first done by DuPont explosives salesman Donaldson Brown in 1912 and hence the name Dupont formula.
In its modern form, the ROE is written as a product of five ratios.
Thus the ROE is the product of
- Financial leverage
- asset turnover
- operating margin
- interest burden
- tax burden.
1. The financial leverage is a measure of a companies debt. Higher the leverage, higher the borrowing and it could result in an increase in ROE! Therefore, if a fall in ROE is driven by a fall in financial leverage it is probably a good development.
2. Asset turnover is a measure of how well assets (including debt) are used to generate profit. An increase in ROE coupled with an increase in asset turnover is desirable. Decreasing asset turnover but steady/increasing revenue could imply the presence of unproductive assets.
3. Operating margin can be thought of as the profit left over after paying for production costs. A healthy operating margin is necessary to pay back debt. An increase in financial leverage should soon result in an increase in operating margin!
4. Interest burden represents the extent interest that has to be paid out to lenders. When financial leverage increases, interest burden will also increase.
5. Tax burden is a measure of the taxes that has to be paid. When interest burden increases, tax burden will usually decrease.
As with all financial ratios and balance sheet entries, these are heavily industry dependent.
Here is an example screenshot (click to enlarge) of the Dupont analysis page. The financial data is automatically downloaded from Morning Star.
The ROE has dropped significantly. The main ROE driver appears to be a fall in operating margin and net income. However, financial leverage has increased and therefore so has the interest burden.
The operating margin seems to have picked up last FY which is important considering the higher interest burden. While I do not know the reasons behind the fall, there are indications of a recent increase in profitability. Excuse me if this is not a very effective example for demonstrating ROE drivers, I am only a student. In any case, I had a wonderful time trying to understand about ROE drivers behind Colgate, Berger, Emami and other companies.
The automated stock analysis sheet
- pulls financials from morningstar and analyzes them
- pulls adjusted stock price history from money control, and
- calculates intrinsic value six different ways!
It also pulls annual (standalone/consolidated) and quarterly financials from Value Research online.
Valuation models available:
1) Price Multiple Model
2) Sustainable Growth Rate
3) Book Value Growth Rate (Buffett’s approach to valuation)
8) Earnings Growth Estimate.