Effective tax rates: reconcile earnings before interpreting cash taxes

Start with the question a tax rate can answer

A lower effective tax rate can raise net income even when pretax profit is unchanged. Before calling that improvement stronger operating performance, rebuild the bridge from pretax income to the tax provision and then to net income. Keep cash taxes in a separate column. The three measures describe related parts of a business, but they are not interchangeable.

This exercise is a research worksheet, not personal tax advice or an estimate of a company's tax return. Its purpose is to identify how much of an earnings comparison comes from the assumed tax rate, which disclosures support that explanation, and what remains uncertain. Every numerical company example below is fictional unless expressly identified as a disclosure-format example.

Start with the original annual report rather than a rounded percentage in a headline. The SEC's introductory financial-statement guide distinguishes income measured over a period from balances measured at a date and from cash movements. That distinction is the foundation of this worksheet: tax expense, tax liabilities and taxes paid should each retain their own label.

Collect matching inputs before calculating

Create columns for reporting period, currency, units, accounting basis, pretax income, income-tax expense or benefit, and net income. Use the same reporting scope for the first two amounts. Do not combine a consolidated tax provision with a segment profit figure or use a continuing-operations denominator with an unrelated total tax amount.

Record where each number came from, including its statement or note heading. Investor.gov describes the annual report's financial statements and management discussion as complementary parts of the filing. Use the statements for the amounts, the tax note for their composition, and management's explanation as a claim to reconcile with those disclosures.

For this worksheet, define effective tax rate as the matched income-tax provision divided by matched pretax income. Preserve a tax benefit as a negative provision. Check the issuer's own definition before comparing your calculation with a reported percentage. If your inputs are rounded, a small difference from the disclosed rate may be rounding rather than a substantive accounting difference.

Build a complete hypothetical earnings bridge

Assume fictional Harbor Instruments reports annual pretax income of 100 million dollars and income-tax expense of 24 million in Year A. Assume there are no other items between that pretax subtotal and the net-income measure being used. The effective tax rate is 24%, and net income is 76 million. Label these assumptions beside the calculation.

In Year B, suppose pretax income increases to 120 million and tax expense is again 24 million. The effective rate falls to 20%, while net income becomes 96 million. Pretax income grew 20%; net income grew approximately 26.3%. The faster net-income growth cannot, by itself, establish that operating performance improved by 26.3%.

Hold Year A's 24% rate constant as an analytical comparison. Applying it to Year B's 120 million pretax income gives tax expense of 28.8 million and net income of 91.2 million. The difference between actual hypothetical net income of 96 million and that comparison is 4.8 million. This is a calculated sensitivity, not a replacement for reported earnings.

The total 20 million increase in net income can therefore be expressed as 15.2 million from the pretax increase after applying the old rate, plus 4.8 million from the rate difference on the new pretax base. State that ordering explicitly: alternative decompositions may allocate an interaction term differently while reaching the same total.

Read the rate reconciliation without inventing a cause

The arithmetic tells you how the rate affected the comparison under your chosen convention. It does not tell you why the rate changed. For that, read the issuer's reconciliation and accompanying explanations. Keep each disclosed reconciling item, its sign and its unit, rather than creating a story from the headline rate alone.

Microsoft's Form 10-K for the year ended June 30, 2026 provides a historical disclosure-format example. Its income-tax note presents a reconciliation using dollar amounts and percentages, and explains that it adopted ASU 2023-09 prospectively. It also presents earlier-year information using its previous disclosure format. This example establishes a comparability question; it is not a claim about Microsoft's future tax rate.

The same note explains changes in where certain foreign tax effects and credits are presented. A line that appears newly large is not automatically a newly large economic cost if the presentation has changed. Compare definitions before comparing individual rows. Preserve an issuer's explanation of classification changes alongside your spreadsheet.

For Harbor, suppose management attributes the lower rate to two factors but provides no numerical allocation between them. Record the two explanations and mark the allocation unknown. Do not split the 4.8 million calculated sensitivity between those factors simply to complete the table. Your sensitivity and management's causal explanation are different kinds of evidence.

Separate percentage points from percentage changes

Harbor's rate falls from 24% to 20%, a decline of four percentage points. Relative to the old rate, that is a reduction of approximately 16.7%. Those statements use different denominators and should not be swapped. In a research note, the percentage-point description is usually the clearest way to describe a rate bridge.

Keep the base visible when translating a rate difference into dollars. Four percentage points applied to Year B's 120 million pretax income produce 4.8 million, whereas applying them to Year A's 100 million would produce 4 million. Neither multiplication is difficult; the research error is failing to explain which question the selected base answers.

Avoid copying a rate difference into an earnings-growth sentence as though it were a directly comparable percentage. Net-income growth uses the prior net-income amount as its denominator. The tax-rate bridge uses pretax income. Show the actual dollar reconciliation before drawing a conclusion about the relative contribution.

Keep cash paid outside the expense calculation

Suppose Harbor's supplemental disclosure reports cash income taxes paid of 18 million in Year B. Retain that figure separately from the 24 million tax provision. The six-million difference is an unresolved comparison until the relevant timing, balances and other disclosures explain it. It is not automatically a six-million tax saving or a permanent reduction in obligations.

For a deliberately simplified second example, assume an opening current-tax payable of 5 million, current tax expense of 22 million, cash payments of 18 million and no other movements. Closing payable would be 9 million. If total tax expense were 24 million under these fictional assumptions, the remaining 2 million would need its separately identified explanation; do not insert it into the current-payable bridge by default.

Real disclosures can involve more than this four-line model. Use the company's actual categories and identify items your simplified bridge omits. An unexplained residual is a request for more evidence. It should remain visible instead of being labeled deferred tax, foreign exchange or a settlement without support.

Handle loss periods and forecasts cautiously

Now consider an unrelated hypothetical company with a pretax loss of 10 million and a tax benefit of 2 million. Using signed amounts gives negative 2 divided by negative 10, or a positive 20% rate. That result does not turn the loss into a profit: the assumed net loss remains 8 million.

Small or sign-changing denominators can make a rate comparison difficult to interpret. Keep the underlying amounts visible and explain why a percentage is not the main evidence in that case. Do not rank a loss-making company against Harbor using the rate alone, and do not convert an unusual rate into a claim that its taxes are unusually efficient.

For a future sensitivity, use several explicitly assumed rates instead of calling the most recent rate permanent. On assumed pretax income of 120 million, rates of 20%, 24% and 28% imply net income of 96 million, 91.2 million and 86.4 million in this simplified model. These are scenarios, not forecasts, and leave operating performance unchanged by construction.

Finish with an auditable research conclusion

A useful conclusion separates three sentences: what the company reported, what your bridge calculates, and which explanation remains unverified. For Harbor, the first two can state the fictional pretax and net-income changes and the 4.8 million rate sensitivity. The third should identify the missing allocation of management's explanations rather than pretend that the arithmetic solved it.

Before saving, check the reporting period and scope, the tax sign convention, the pretax denominator, percentage points versus percentage changes, and whether cash paid has been kept separate. Retain source references and assumptions so the next filing can be compared on the same basis. If a disclosure format changes, update the worksheet labels before calculating a trend.

The next research checkpoint is evidence that resolves the open explanation or changes the assumptions. It is not simply another headline describing a lower tax rate. A complete-looking spreadsheet is less useful than a clearly bounded one whose reported numbers, calculations and unanswered questions can each be traced.