Income Tax

The tax line: pre-tax income times a rate

Tax expense is the simplest forecast in the model — and the easiest to get subtly wrong.

Tax sits near the bottom of the income statement, but it deserves real thought. The mechanic is deceptively simple: take earnings before tax (EBT, also called pre-tax income), multiply by a tax rate, and subtract the result to get net income. The art is choosing the right rate, because the rate you assume quietly scales every dollar of profit that reaches shareholders.

Tax Expense = Pre-tax Income × Effective Tax RateNet Income = Pre-tax Income − Tax Expense = Pre-tax Income × (1 − Effective Tax Rate).

Notice the second form: net income is just pre-tax income times one minus the rate. A model running a 21% rate keeps 79 cents of every pre-tax dollar; bump the rate to 25% and you have quietly knocked roughly 5% off net income and EPS. Tax is a small line with a large lever attached to it.

Forecast the rate, not the dollars Always drive tax from a rate assumption applied to pre-tax income, never from a hard-coded dollar figure. If you type last year's tax bill straight in, the line stops responding when revenue or margins change — and your net income breaks the moment you flex a scenario.

Statutory vs. effective rate

The headline rate the law sets is rarely the rate a company actually pays.

There are two rates you need to keep straight. The statutory rate is the headline rate set by law — in the U.S. the federal corporate rate has been 21% since 2018, before state and foreign taxes. The effective tax rate (ETR) is what the company actually books: total tax expense divided by pre-tax income. The two almost never match, and the gap between them is where the real analysis lives.

Effective Tax Rate = Total Tax Expense ÷ Pre-tax IncomePulled straight from the income statement; it blends federal, state, foreign, and permanent items.

Why the effective rate drifts from statutory

• State and local taxes stack on top of the federal rate, pushing the effective rate up.
• Foreign earnings taxed at lower rates abroad can pull the blended rate down for a multinational.
• Permanent differences — items that never become taxable or deductible, like certain tax credits or non-deductible expenses — shift the rate in either direction.
• One-off items (settlements, repatriation, valuation allowance changes) can make a single year's effective rate misleading.

Normalise before you project Don't anchor your forecast on one noisy year. Look at three to five years of effective rates, strip out obvious one-offs, and project a normalised rate. A company that printed a 12% effective rate because of a credit it won't repeat should not be modelled at 12% forever.

Current vs. deferred — and book vs. cash taxes

Total tax expense splits into cash paid now and timing differences that reverse later.

The tax expense on the income statement (the 'book' tax) is not the same as the cash a company writes to the tax authority. Book tax expense splits into two parts: current tax, which is the cash actually owed for the period, and deferred tax, which captures timing differences between accounting rules and tax rules that will reverse in future periods.

Total Tax Expense = Current Tax (cash) + Deferred Tax (timing)Only the current portion is a cash outflow this period; the deferred portion is an accrual.

Timing differences arise because the tax code and accounting standards measure income on different schedules. The classic example is depreciation: a company often uses accelerated depreciation for tax purposes (lowering taxable income early) and straight-line depreciation for its books. Early on it pays less cash tax than its book expense implies — the difference accrues as a deferred tax liability that unwinds in later years.

Deferred tax on the balance sheet

• A deferred tax liability (DTL) means the company has under-paid cash tax relative to book and will pay it later — common with accelerated tax depreciation.
• A deferred tax asset (DTA) means the company has over-paid or recognised a future deduction — common with NOL carryforwards, warranty reserves, or stock-comp timing.
• DTAs and DTLs sit on the balance sheet and unwind over time as the timing differences reverse.
• A valuation allowance reduces a DTA when it's unlikely the company will generate enough future profit to use it.

Net income is not cash Because book tax includes a non-cash deferred component, net income overstates or understates the cash actually kept. On the cash flow statement the deferred portion is added back (or subtracted) so that only real cash taxes hit the cash balance. Confusing book and cash taxes is a classic way to mis-state free cash flow.

NOL carryforwards are a special case worth knowing conceptually. When a company loses money, it generates a net operating loss it can carry forward to offset future taxable income. That shelters future profits from cash tax — so a recently unprofitable company may book a normal effective rate while paying little or no cash tax until the NOLs are exhausted. The NOL sits on the balance sheet as a deferred tax asset.

Tax in The Cash Flow Projector

One rate assumption drives the line; the engine keeps book and cash taxes consistent.

In a hand-built Excel model you would wire the tax line to a rate cell, build a separate deferred-tax schedule, and then thread the current portion into the cash flow statement by hand — three places to keep in sync and three places to break. In the tool you set one tax-rate assumption on the Assumptions tab and the engine does the rest.

1. Set the effective tax rate on the Assumptions tab — this is your single input.
2. The Income Statement applies that rate to pre-tax income to produce tax expense and net income.
3. The engine handles the current vs. deferred split so the deferred tax balances on the Balance Sheet stay consistent.
4. The Cash Flow tab reflects cash taxes, with the deferred portion treated as the non-cash item it is.
5. Because the statements are linked and the balance-sheet plug always ties, the cash-tax effect flows straight to the cash balance.

Consistency for free The hard part of tax modelling isn't the multiplication — it's keeping book tax, deferred balances, and cash taxes consistent across three statements while everything else moves. The engine enforces that consistency automatically, so changing the rate re-prices net income, the deferred balances, and the cash line together, and the model still balances.