Return on Equity Calculator

Return on Equity Calculator
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Description

Return on Equity Calculator

Measure how much net profit a business produces for each dollar of shareholders’ equity, then test how the ratio changes across different equity levels.

ROE 7.57% Net profit $34,500.00 Equity $456,000.00

Inputs

Enter amounts for the same reporting period. Net profit may be negative; equity must be greater than zero.

Use net income after taxes and preferred dividends when analyzing common shareholders’ return.

For period analysis, average beginning and ending equity is often more representative than a single closing balance.

Live results

Results update as you type and retain full precision until display.

Return on equity
7.57%

This falls below the 10%–15% reference band and should be interpreted against comparable businesses and the company’s capital structure.

Profit per $100 equity
$7.57

A dollar expression of the same ROE ratio.

Profit needed for 15% ROE
$68,400.00

Assumes the entered equity balance stays unchanged.

Equity supported at 15% ROE
$230,000.00

Available only when net profit is positive.

Gap to 15% benchmark
-7.43 pp

Percentage-point difference, not percent change.

Return on equity is 7.57 percent.

ROE sensitivity to the equity base

Net profit is held constant while equity ranges from 50% to 150% of the entered amount.

At the current inputs, ROE is 7.57%. Holding profit constant, a smaller equity base mechanically raises ROE while a larger equity base lowers it.

Sensitivity detail

The current-input row is highlighted. Every row uses the same net profit and a different equity multiplier.

Equity level Equity amount Net profit ROE 15% benchmark

Sensitivity is not a forecast. It isolates the mathematical effect of changing equity while holding profit constant; in practice, financing decisions can also change earnings, risk, and taxes.

What does return on equity measure?

Return on equity, or ROE, compares a company’s net profit with the shareholders’ equity used to support the business. It answers a focused question: how many dollars of accounting profit were produced for each dollar attributable to owners? An ROE of 12% means the company generated about $12 of net profit for every $100 of equity during the period.

ROE is most informative when the numerator and denominator cover compatible periods. Net profit comes from an income statement covering a quarter or year, while equity is a balance-sheet amount measured at a point in time. For a full-year analysis, many analysts use average equity: beginning equity plus ending equity, divided by two. Public-company figures can be checked in annual and quarterly filings; the SEC explains where those statements appear in its guide to reading Forms 10-K and 10-Q.

How should each input be entered?

Net profit

Enter net income for the reporting period in U.S. dollars. This is a required field, but it may be zero or negative. A positive value produces a positive ROE when equity is positive. A loss produces a negative ROE, signaling that the company reduced rather than increased book value through current-period earnings. Avoid mixing operating profit, EBITDA, or cash flow with shareholders’ equity because those measures exclude items that net income includes.

Shareholders’ equity

Enter positive common shareholders’ equity for the same analytical period. This field is required and must be greater than zero for a conventional ROE calculation. If beginning and ending equity differ materially, use their average unless a specific methodology calls for closing equity. Negative equity makes the standard ratio difficult to interpret because a positive profit divided by a negative book value produces a negative percentage that does not describe ordinary operating efficiency. The calculator therefore treats zero or negative equity as invalid rather than displaying a potentially misleading result.

For U.S. issuers, audited equity and net income are generally available in Form 10-K financial statements. Investor.gov’s overview of how to read a 10-K provides a practical map of the filing.

How is ROE calculated?

ROE = Net profit ÷ Shareholders’ equity × 100%

The calculator keeps the division at full precision and rounds only the displayed percentage. Using the initial example, $34,500 divided by $456,000 equals 0.0756579, or 7.57% after rounding. The “profit per $100 equity” result expresses the same ratio as a dollar amount. The benchmark outputs use 15% as a neutral comparison point: required profit equals equity multiplied by 15%, while supported equity equals positive net profit divided by 15%.

The gap result is measured in percentage points. For example, 7.57% is 7.43 percentage points below 15%. This is different from saying it is 49.5% lower, which would be a relative percentage comparison. Percentage points are usually clearer when comparing two rates.

How should the results, chart, and table be interpreted?

The primary ROE result shows current-period profitability relative to book equity. A higher positive value can indicate efficient use of shareholder capital, but it is not automatically better. Debt-funded share repurchases, write-downs, or a very small equity base can raise ROE without a matching improvement in operating quality. A low positive ROE can reflect weak margins, underused assets, conservative financing, or a temporary earnings decline. A zero value means the company broke even on a net-income basis, while a negative value reflects a net loss when equity remains positive.

The sensitivity chart changes only the equity denominator. The blue line shows calculated ROE at seven equity levels, and the teal line marks a constant 15% benchmark. Moving left represents a smaller equity base and generally raises a positive ROE; moving right represents more equity and lowers it when profit is held constant. The table exposes the exact values behind every plotted point, including the current-input row. This isolates denominator sensitivity rather than predicting how management decisions will affect future profit.

ROE should usually be compared with the company’s own history and with businesses that have similar economics and leverage. Industry structure matters: capital-light companies may sustain higher ROE than businesses that require large factories, inventories, or regulated capital. Investopedia’s ROE overview discusses common interpretations and limitations.

What are the main benefits and common mistakes?

ROE is compact, easy to calculate, and useful for tracking whether a business is converting owner capital into earnings. It can support trend analysis, peer screening, budgeting, and management review. The Excel export captures the current inputs, results, sensitivity rows, and methodological notes in a real workbook so the analysis can be documented or extended.

Common mistakes include using revenue instead of net profit, mixing quarterly profit with annual equity without annualizing, comparing closing equity with a period containing a major capital raise, ignoring preferred dividends, and treating a debt-driven increase in ROE as purely operational progress. Another error is comparing companies from unrelated industries. ROE is a starting point rather than a complete valuation, solvency, or cash-flow assessment. Review leverage, return on assets, margins, cash conversion, and one-time accounting items before drawing broader conclusions. This calculator provides general analytical information and does not provide personalized investment, legal, tax, or accounting advice.