Return on Equity (ROE) Calculation and What It Means

What Is Return on Equity (ROE)?

Return on equity (ROE) is a measure of financial performance calculated by dividing net income by shareholders' equity. Because shareholders' equity is equal to a company’s assets minus its debt, ROE is considered the return on net assets.

ROE is considered a gauge of a corporation's profitability and how efficient it is in generating profits. The higher the ROE, the more efficient a company's management is at generating income and growth from its equity financing. 

Calculating Return on Equity (ROE)

ROE is expressed as a percentage and can be calculated for any company if net income and equity are both positive numbers. Net income is calculated before dividends paid to common shareholders and after dividends to preferred shareholders and interest to lenders.

$\begin{aligned} &\text{Return on Equity} = \dfrac{\text{Net Income}}{\text{Average Shareholders' Equity}}\\ \end{aligned}$​Return on Equity=Average Shareholders’ EquityNet Income​​

Net income is the amount of income, net expenses, and taxes that a company generates for a given period. Average shareholders' equity is calculated by adding equity at the beginning of the period. The beginning and end of the period should coincide with the period during which the net income is earned.

Net income over the last full fiscal year, or trailing 12 months, is found on the income statement—a sum of financial activity over that period. Shareholders' equity comes from the balance sheet—a running balance of a company’s entire history of changes in assets and liabilities.

It is considered best practice to calculate ROE based on average equity over a period because of the mismatch between the income statement and the balance sheet.

What Return on Equity Tells You

Whether an ROE is deemed good or bad will depend on what is normal among a stock’s peers. For example, utilities have many assets and debt on the balance sheet compared to a relatively small amount of net income. A normal ROE in the utility sector could be 10% or less. A technology or retail firm with smaller balance sheet accounts relative to net income may have normal ROE levels of 18% or more.

A good rule of thumb is to target an ROE that is equal to or just above the average for the company's sector—those in the same business. For example, assume a company, TechCo, has maintained a steady ROE of 18% over the past few years compared to the average of its peers, which was 15%. An investor could conclude that TechCo’s management is above average at using the company’s assets to create profits.

Relatively high or low ROE ratios will vary significantly from one industry group or sector to another. Still, a common shortcut for investors is to consider a return on equity near the long-term average of the S&P 500 (14%) as an acceptable ratio and anything less than 10% as poor.

Return on Equity and Stock Performance

Sustainable growth rates and dividend growth rates can be estimated using ROE, assuming that the ratio is roughly in line or just above its peer group average. Although there may be some challenges, ROE can be a good starting place for developing future estimates of a stock’s growth rate and the growth rate of its dividends. These two calculations are functions of each other and can be used to make an easier comparison between similar companies.

To estimate a company’s future growth rate, multiply the ROE by the company’s retention ratio. The retention ratio is the percentage of net income that is retained or reinvested by the company to fund future growth.

ROE and a Sustainable Growth Rate

Assume that there are two companies with identical ROEs and net income but different retention ratios. This means they will each have a different sustainable growth rate (SGR). The SGR is the rate a company can grow without having to borrow money to finance that growth. The formula for calculating SGR is ROE times the retention ratio (or ROE times one minus the payout ratio).

For example, Company A has an ROE of 15% and has a retention ratio of 70%. Business B also has an ROE of 15% but has a 90% retention ratio. For Company A, the sustainable growth rate is 10.5% (15% * 70%). Business B's SGR is 13.5% (15% * 90%).

A stock that is growing at a slower rate than its sustainable rate could be undervalued, or the market may be accounting for key risks. In either case, a growth rate that is far above or below the sustainable rate warrants additional investigation.

Using Return on Equity to Identify Problems

It's reasonable to wonder why an average or slightly above-average ROE is preferable rather than an ROE that is double, triple, or even higher than the average of its peer group. Aren’t stocks with a very high ROE a better value?

Sometimes an extremely high ROE is a good thing if net income is extremely large compared to equity because a company’s performance is so strong. However, an extremely high ROE is often due to a small equity account compared to net income, which indicates risk.

Inconsistent Profits

The first potential issue with a high ROE could be inconsistent profits. Imagine that a company, LossCo, has been unprofitable for several years. Each year’s losses are recorded on the balance sheet in the equity portion as a “retained loss.” These losses are a negative value and reduce shareholders' equity.

Now, assume that LossCo has had a windfall in the most recent year and has returned to profitability. The denominator in the ROE calculation is now very small after many years of losses, which makes its ROE misleadingly high.

Excess Debt

A second issue that could cause a high ROE is excess debt. If a company has been borrowing aggressively, it can increase ROE because equity is equal to assets minus debt. The more debt a company has, the lower equity can fall. A common scenario is when a company borrows large amounts of debt to buy back its own stock. This can inflate earnings per share (EPS), but it does not affect actual performance or growth rates.

Negative Net Income

Finally, negative net income and negative shareholders' equity can create an artificially high ROE. However, if a company has a net loss or negative shareholders’ equity, ROE should not be calculated.

If shareholders’ equity is negative, the most common issue is excessive debt or inconsistent profitability. However, there are exceptions to that rule for companies that are profitable and have been using cash flow to buy back their own shares. For many companies, this is an alternative to paying dividends, and it can eventually reduce equity (buybacks are subtracted from equity) enough to turn the calculation negative.

In all cases, negative or extremely high ROE levels should be considered a warning sign worth investigating. In rare cases, a negative ROE ratio could be due to a cash flow-supported share buyback program and excellent management, but this is the less likely outcome. In any case, a company with a negative ROE cannot be evaluated against other stocks with positive ROE ratios.

Limitations of Return on Equity

A high ROE might not always be positive. An outsize ROE can be indicative of a number of issues—such as inconsistent profits or excessive debt. Also, a negative ROE due to the company having a net loss or negative shareholders’ equity cannot be used to analyze the company, nor can it be used to compare against companies with a positive ROE.

Return on Equity vs. Return on Invested Capital

Though ROE looks at how much profit a company can generate relative to shareholders’ equity, return on invested capital (ROIC) takes that calculation a couple of steps further.

The purpose of ROIC is to figure out the amount of money after dividends a company makes based on all its sources of capital, which includes shareholders' equity and debt. ROE looks at how well a company uses shareholders' equity while ROIC is meant to determine how well a company uses all its available capital to make money.

Example of Return on Equity

For example, imagine a company with an annual income of $1,800,000 and average shareholders' equity of $12,000,000. This company’s ROE would be 15%, or $1.8 million divided by $12 million.

As a real-world example, consider Apple Inc. (AAPL)'s financials for the fiscal year ending Sept. 29, 2018, the company generated $59.5 billion in net income. At the end of the fiscal year, its shareholders’ equity was $107.1 billion versus $134 billion at the beginning.

Apple’s return on equity, therefore, is 49.4%, or $59.5 billion / [($107.1 billion + $134 billion) / 2].

Compared to its peers, Apple had a very strong ROE:

• Amazon.com, Inc. (AMZN) had an ROE of 28.3% in 2018.
• Microsoft Corp. (MSFT) had an ROE of 19.4% in 2018.
• Google (GOOGL) had an ROE of 18.6% for 2018.
  

How to Calculate ROE Using Excel

The formula for calculating a company's ROE is its net income divided by shareholders' equity. Here's how to use Microsoft Excel to set up the calculation for ROE:

• In Excel, get started by right-clicking on column A. Next, move the cursor down and left-click on column width. Then, change the column width value to 30 default units and click OK. Repeat this procedure for columns B and C.
• Next, enter the name of a company into cell B1 and the name of another company into cell C1.
• Then, enter "Net Income" into cell A2, "Shareholders' Equity" into cell A3, and "Return on Equity" into cell A4.
• Enter the formula for "Return on Equity" =B2/B3 into cell B4 and enter the formula =C2/C3 into cell C4.
• When that is complete, enter the corresponding values for "Net Income" and "Shareholders' Equity" into cells B2, B3, C2, and C3.

ROE and DuPont Analysis

Though ROE can easily be computed by dividing net income by shareholders' equity, a technique called DuPont decomposition can break down the ROE calculation into additional steps. Created by the American chemicals corporation DuPont in the 1920s, this analysis reveals which factors are contributing the most (or the least) to a firm's ROE.

There are two versions of DuPont analysis. The first involves three steps:

$\begin{aligned} &\text{ROE} = \text{NPM} \times \text{Asset Turnover} \times \text{Equity Multiplier} \\ &\textbf{where:} \\ &\text{NPM} = \text{Net profit margin, the measure of operating} \\ &\text{efficiency} \\ &\text{Asset Turnover} = \text{Measure of asset use efficiency} \\ &\text{Equity Multiplier} = \text{Measure of financial leverage} \\ \end{aligned}$​ROE=NPM×Asset Turnover×Equity Multiplierwhere:NPM=Net profit margin, the measure of operatingefficiencyAsset Turnover=Measure of asset use efficiencyEquity Multiplier=Measure of financial leverage​

​Alternatively, the five-step version is as follows:

$\begin{aligned} &\text{ROE} = \frac{ \text{EBT} }{ \text{S} } \times \frac{ \text{S} }{ \text{A} } \times \frac{ \text{A} }{ \text{E} } \times ( 1 - \text{TR} ) \\ &\textbf{where:} \\ &\text{EBT} = \text{Earnings before tax} \\ &\text{S} = \text{Sales} \\ &\text{A} = \text{Assets} \\ &\text{E} = \text{Equity} \\ &\text{TR} = \text{Tax rate} \\ \end{aligned}$​ROE=SEBT​×AS​×EA​×(1−TR)where:EBT=Earnings before taxS=SalesA=AssetsE=EquityTR=Tax rate​

Both the three- and five-step equations provide a deeper understanding of a company's ROE by examining what is changing in a company rather than looking at one simple ratio. As always with financial statement ratios, they should be examined against the company's history and its competitors' histories.

For example, when looking at two peer companies, one may have a lower ROE. With the five-step equation, you can see if this is lower because creditors perceive the company as riskier and charge it higher interest, the company is poorly managed and has leverage that is too low, or the company has higher costs that decrease its operating profit margin. Identifying sources like these leads to a better knowledge of the company and how it should be valued.