Inspect the denominator before reading the percentage
A company with a loss can display a positive return on equity if both net income and the equity denominator are negative. The spreadsheet division is mathematically valid, but treating that result as a favorable return reverses the meaning of the underlying loss. A dashboard needs an explicit rule for this case.
Book equity is an accounting measure. It can become small or negative through accumulated results, distributions, repurchases and other recorded movements. Research in NYU's archive discusses the difficulty of interpreting negative book equity, while Damodaran highlights limitations that accounting book values create for return measures.
Begin with the actual income and equity amounts, their signs and the averaging convention. Do not let a percentage-format cell conceal the values being divided. The purpose of this review is to decide whether the ratio communicates useful information, rather than to force every company into the same ranking.
References: NYU research: Going Negative, interpreting negative book equity; NYU Stern, Aswath Damodaran: Interpreting accounting returns on equity
See how two negative values produce a positive ratio
Suppose a fictional company reports a $40,000 annual net loss and average book equity of negative $100,000. Dividing negative $40,000 by negative $100,000 produces positive 40%. That percentage does not turn the loss into profit or demonstrate that shareholders earned a 40% investment return.
Now hold average equity at negative $100,000 and change the annual result to positive $40,000. The same formula produces negative 40%. An automatic ranking that places the first company above the second would reward the loss and penalize the profit because it ignores the denominator's sign.
Display both cases in a review test before approving a reporting rule. They show why a simple larger-is-better color scale cannot safely handle every ROE observation. The problem lies in interpretation and presentation, even when the underlying arithmetic has no formula error.
Taking the absolute value of negative equity changes the denominator's definition and conceals the original condition. If a separate analytical transformation is useful, label and justify it explicitly instead of presenting it as conventional ROE.
| Illustrative case | Annual result | Average book equity | Arithmetic ROE |
|---|---|---|---|
| Loss with negative equity | -$40,000 | -$100,000 | +40% |
| Profit with negative equity | +$40,000 | -$100,000 | -40% |
| Profit with small positive equity | +$40,000 | +$10,000 | +400% |
| Profit with zero average equity | +$40,000 | $0 | Undefined |
Handle a denominator close to zero
Even positive equity can produce an extreme percentage when it is very small. In the fictional table, $40,000 of profit divided by $10,000 of average equity gives 400%. Before presenting that as exceptional performance, explain why so little book equity remains and whether the comparison is meaningful.
If average equity is exactly zero, the ratio is undefined. Do not replace the denominator with a small invented amount to make the spreadsheet return a finite number. Similarly, a generic error handler that converts the result to zero can falsely suggest a measured zero return.
A period in which equity crosses zero needs particular care. An opening balance of negative $100,000 and a closing balance of positive $100,000 produce a zero two-point average, despite substantial movement during the year. More frequent balances may explain the path, but they do not automatically make a conventional ROE comparison appropriate.
Agree a reporting policy that distinguishes undefined, unsuitable-for-comparison and ordinary calculated values. A blank cell without explanation makes those cases indistinguishable. Use a brief label and make the underlying income and equity amounts available to the reader.
Reconcile why equity became negative
Build a bridge from opening to closing equity using the approved financial reporting schedules. Identify the contributions of earnings or losses, owner transactions and other movements relevant to the entity. A negative closing balance can have several causes, and the next management question depends on which ones apply.
Keep actual transactions separate from changes in accounting presentation or measurement. A share repurchase that reduces recorded equity has different cash implications from an accounting adjustment with no immediate cash movement. The bridge should preserve those distinctions without assuming that every reduction signals the same operating problem.
Also check whether the reported equity belongs to the same owners whose earnings appear in the numerator. Group statements, preference interests and noncontrolling interests can require additional care. A denominator problem should not distract the reviewer from a separate scope mismatch.
Use the reconciliation to identify the evidence needed next. Management may need a liquidity review, a financing discussion or a closer analysis of accumulated losses. The sign of book equity alone does not provide the dates and amounts required for those decisions.
Keep market value and payment capacity separate
Negative book equity is not a direct estimate of the market value of the company or its shares. Accounting balances and a market valuation answer different questions and can reflect different information. Do not infer a negative share price from a negative accounting denominator.
It also does not, by itself, tell you whether the company can pay a particular obligation next week. Review cash availability, expected receipts, contractual payments and financing access on their actual dates. Conversely, positive book equity should not be treated as proof that near-term cash obligations are covered.
For operating analysis, retain measures suited to the question, such as absolute profit, margin, cash generation or a consistently defined return on operating capital. Each alternative has its own limitations. Explain the choice instead of swapping to a different ratio solely because it gives a more attractive result.
Prevent misleading rankings and trend charts
Separate companies or periods with unsuitable equity denominators before calculating peer averages or percentile ranks. Record the exclusion rule and the excluded observations. An unexplained omission can bias a comparison just as an uncritical inclusion can distort it.
For a time series, mark the point where the denominator becomes unsuitable and retain the income and equity bridge beneath the chart. Connecting extreme positive and negative percentages with a smooth trend line can suggest changes in performance that mainly reflect a denominator crossing zero.
The final commentary should describe the underlying result directly. In the first fictional case, the company lost $40,000 and had negative average book equity; its positive arithmetic ROE is unsuitable as evidence of favorable performance. That explanation gives the reader a sound basis for the next review without hiding either number.
Sources
Requirements and product details can change. Check the linked guidance for the facts that apply to your situation.
Related reading
Need help with this work?
General information, not personalized accounting, tax, legal, or investment advice. Have the appropriate qualified professional review decisions that depend on your circumstances.