# Deferred Tax

Translate a 6-category book-tax temporary-difference panel plus a statutory rate, valuation-allowance ratio, and 5-year pretax forecast into a per-category temp-diff roll-forward, a deferred-tax balance schedule, a tax-provision walk reconciling current and deferred tax, and a dashboard with net DTA/DTL, average ETR, and traffic-light status.

- Canonical: https://finamodel.com/templates/deferred-tax
- Download (.xlsx): https://finamodel.com/templates/deferred-tax.xlsx
- Category: Corporate Finance
- Model type: Operating model
- Difficulty: Intermediate
- Audiences: CFOs & FP&A, Founders & operators
- Tags: deferred tax, dta, dtl, tax provision, valuation allowance

## Related templates

- [Depreciation](https://finamodel.com/templates/depreciation)
- [Stock-Based Compensation](https://finamodel.com/templates/stock-based-compensation)
- [3 Statement Model](https://finamodel.com/templates/3-statement)