ROE Calculator

ROE, ROA and ROCE Calculator

How hard a business makes its money work: return on equity, on total assets and on capital employed, with the DuPont breakdown of ROE into margin, asset turnover and leverage.

Return on equity

Profit + balance sheet → ROE, ROA, ROCE
For a full year. Use a loss as a negative number.
Profit before interest and tax. Used only for ROCE.
(Equity at the start of the year + equity at the end) ÷ 2. Share capital plus reserves.
(Total assets at the start + at the end) ÷ 2.
Total assets − current liabilities is the same as equity plus long-term borrowings and other non-current liabilities.
Used with the first option. Take it on the same basis as total assets (average or year-end).
Used only with the second option.
For the DuPont breakdown. 0 to skip it.
15.00%Example

Net profit $9,00,000, EBIT $16,00,000, average equity $60,00,000, average total assets $1,00,00,000, current liabilities $20,00,000, revenue $1,20,00,000

Advertisement

ROE, ROA, ROCE and DuPont

ROE = net profit ÷ average equity; ROA = net profit ÷ average total assets; ROCE = EBIT ÷ capital employed
DuPont: ROE = (net profit ÷ revenue) × (revenue ÷ assets) × (assets ÷ equity)
average
(opening balance + closing balance) ÷ 2, as in the OpenStax finance text
capital employed
total assets − current liabilities, or equity + non-current liabilities
equity multiplier
assets ÷ equity; the higher it is, the more of the assets are financed by borrowing

Worked example

Net profit $9,00,000, EBIT $16,00,000, average equity $60,00,000, average total assets $1,00,00,000, current liabilities $20,00,000, revenue $1,20,00,000
ROE = 9,00,000 ÷ 60,00,000 = 15.00%
ROA = 9,00,000 ÷ 1,00,00,000 = 9.00%
Capital employed = 1,00,00,000 − 20,00,000 = $80,00,000; ROCE = 16,00,000 ÷ 80,00,000 = 20.00%
DuPont: 7.50% × 1.20 × 1.67 = 15.00%

Same profit, same assets, different funding

ExampleHalf the equity, more debt
Average equity$60,00,000$30,00,000
Equity multiplier1.673.33
ROA9.00%9.00%
ROE15.00%30.00%
Net profit held at 9,00,000 for illustration. In reality more debt means more interest, which lowers net profit.

Three returns, and what the DuPont breakdown adds

Each ratio divides a profit by the money that produced it, and the choice of pair matters. Return on equity is net profit over the shareholders’ money: what the owners earn. Return on assets is net profit over everything the business owns, however it was financed. Return on capital employed is operating profit — before interest and tax — over the long-term money in the business, equity plus long-term borrowing, which makes it the fairest way to compare businesses funded differently. In the example ROE is 15%, ROA 9% and ROCE 20%.

The DuPont method, used in the OpenStax finance text, splits ROE into three multiplied parts: the net profit margin (how much of each sale is profit), asset turnover (how much revenue each rupee of assets generates) and the equity multiplier (how much of the assets the owners paid for). Here 7.5% × 1.2 × 1.67 gives the same 15%. Two businesses with the same ROE can get there very differently — a jeweller on thin margins and fast turnover, a software firm on fat margins — and the third term shows how much of the return comes from debt. Borrowing raises ROE when the business earns more on its assets than the debt costs, and deepens losses when it does not, which is why a high ROE with a high equity multiplier deserves a second look.

Use averages of the opening and closing balance sheets, as the textbooks do, so a big change during the year does not distort the result; year-end figures are a common shortcut. Definitions of capital employed vary: some texts use total assets minus current liabilities, others equity plus all interest-bearing debt, and some take averages. Keep one definition when comparing years or companies. ROE means nothing when equity is negative, and none of these ratios has a universal “good” level; compare within an industry. For a quoted share, the P/E ratio calculator looks at the same profit from the price side, and the ROI calculator works out the return on your own investment. This is arithmetic on the figures you enter, not financial advice.

Advertisement

Frequently asked questions

How do you calculate ROE?

Net profit divided by average shareholders’ equity. 9,00,000 ÷ 60,00,000 = 15% in the example.

What is the difference between ROE, ROA and ROCE?

ROE measures the return to shareholders, ROA the return on everything the business owns, and ROCE the operating profit on equity plus long-term borrowing, before interest and tax.

What is the DuPont formula?

ROE = net profit margin × asset turnover × equity multiplier, which is (profit ÷ revenue) × (revenue ÷ assets) × (assets ÷ equity).

Why can a high ROE be a warning sign?

It may come from heavy borrowing rather than a profitable business. The equity multiplier in the DuPont breakdown shows how much.

What is a good ROE?

There is no universal level. Compare with similar companies and with what the owners could earn elsewhere for the same risk.

Related calculators

References

  1. Dahlquist J, Knight R. Principles of Finance. OpenStax, Rice University, 2022. Section 6.2 (operating efficiency: inventory turnover = cost of goods sold ÷ average inventory; receivables turnover = credit sales ÷ average receivables), section 6.4 (solvency: debt-to-assets = total liabilities ÷ total assets; debt-to-equity = total liabilities ÷ total stockholders’ equity; times interest earned = EBIT ÷ interest expense) and section 6.6 (return on assets and on equity on average balances; the DuPont method: profit margin × total asset turnover × equity multiplier).
  2. Atrill P, McLaney E. Accounting and Finance for Non-Specialists. Pearson. Return on capital employed = operating profit ÷ (share capital + reserves + non-current liabilities) × 100; return on ordinary shareholders’ funds; gearing. Definitions of capital employed vary between texts and companies.