How to Model Deferred Taxes

Deferred taxes arise when the tax you report on the income statement differs from the tax you actually pay, usually because book and tax depreciation run on different schedules. The model captures this gap as a deferred tax liability or asset that builds up and later reverses. Getting it right keeps cash taxes and book taxes reconciled across the forecast.

What deferred taxes capture

Book accounting and tax accounting often recognize the same expense in different periods. The most common driver is depreciation: companies frequently use straight-line depreciation for the books but an accelerated method for tax. Early on, tax depreciation is higher, so taxable income and cash taxes are lower than book.

The model captures the difference as a deferred tax liability (DTL). The income statement shows book tax expense, the cash flow statement shows lower cash taxes paid, and the gap accrues on the balance sheet as a DTL. When tax depreciation later falls below book depreciation, the difference reverses and the DTL unwinds.

Build it step by step

Lay out two depreciation lines, book and tax, then compute the temporary difference between them. Apply the tax rate to that difference to get the period's change in the deferred tax balance.

Build book tax on pre-tax income and cash tax on taxable income, then reconcile the two through the DTL.

1. Compute book depreciation (straight-line) and tax depreciation (accelerated) on separate lines.
2. Temporary difference is =tax_depreciation - book_depreciation for the period.
3. Change in DTL is =temporary_difference * tax_rate.
4. Book tax expense is =pretax_book_income * tax_rate; cash tax is =book_tax - change_in_DTL.
5. Ending DTL is =beginning_DTL + change_in_DTL.

=50*0.25 adds 12.5 to the deferred tax liability in Year 1.

The formulas and the reversal

The temporary difference drives everything: =tax_depreciation - book_depreciation. When this is positive, tax depreciation exceeds book and the DTL grows by =temporary_difference * tax_rate. Cash taxes are below book taxes by the same amount, which is why cash tax equals =book_tax - change_in_DTL.

The reversal is the crucial mechanic. Over an asset's full life, total depreciation is identical under both methods, so the cumulative temporary differences sum to zero. In later years tax depreciation falls below book, the temporary difference turns negative, and the DTL drains back toward zero. A DTL that grows forever and never reverses is a modeling error, not a feature of the business.

• Temporary difference: =tax_depreciation - book_depreciation.
• Change in DTL: =temporary_difference * tax_rate.
• Cash tax paid: =book_tax_expense - change_in_DTL.
• Ending DTL: =beginning_DTL + change_in_DTL, trending to zero over the asset life.

Pitfalls and what reviewers check

A frequent error is signs: if cash tax is below book tax, the DTL must increase, so the change adds to the liability rather than subtracting. Flipping the sign sends the deferred tax balance the wrong way and breaks the balance sheet.

Reviewers trace cash tax back to book tax and the change in DTL to confirm the reconciliation holds, check that cumulative temporary differences sum to zero over the asset life so the DTL fully reverses, and verify the tax rate is a single referenced input rather than a hardcoded percent scattered across cells. The reversal year is the most useful place to test, because that is where sign errors surface.