Free Templates · IAS 12 & IFRIC 23

IAS 12 Deferred Tax & IFRIC 23 Calculator (Excel)

Six-tab dynamic workbook reproducing Veridian Industrial Group SE across FY 2025 and FY 2026: balance-sheet tax bases, single-transaction leases & AROs, outside basis, IFRIC 23 vs. FIN 48, Pillar Two, ETR proof, and 12 live controls.

Download the Excel Workbook

File: IAS_12_Deferred_Tax_IFRIC_23_Calculator.xlsx · 100% live Excel formulas · Zero macros · Nothing locked or hidden.

Download IAS_12_Deferred_Tax_IFRIC_23_Calculator.xlsx →

What is inside the six linked tabs

Tab NameScope & Live Mechanics
Deferred_Tax_Schedule17 domestic balance-sheet items, editable 25.00% to 28.00% rate change, origination vs. rate-change split across P&L (+EUR 1.55M), OCI (+EUR 0.90M), and Equity (-EUR 0.12M), and IAS 12.74 offsetting.
Single_Transaction_Lease_ARODay 1, FY 2025, and FY 2026 schedules for the EUR 58.97M IFRS 16 lease and EUR 15.35M IAS 37 ARO under IAS 12.15(b)(iii) and IAS 12.24(c).
Iberia_Losses_Outside_BasisVeridian Iberia S.A. tax loss recoverability (EUR 8.00M recognized DTA) and IAS 12.39 outside basis DTLs for Veridian Nordic AB and Helvetia Components AG.
IFRIC_23_UTP_ValuationUTP-1 binary R&D claim (EUR 12.00M MLA) and UTP-2 5-scenario transfer pricing band (EUR 8.20M to EUR 11.20M Expected Value) alongside ASC 740-10 (FIN 48) cumulative probability measurement (EUR 14.00M).
ETR_Proof_Pillar_Two_ASC740Pillar Two IAS 12.88B top-up tax (EUR 1.79M), full FY 2025 and FY 2026 IAS 12.81(c) ETR proofs (22.93% and 20.91%), and the quantitative IAS 12 to ASC 740 bridge.
Controls12 automated cross-sheet integrity checks (roll-forward closure, ETR closure, Day 1 neutrality, probability sums) returning ALL PASS dynamically.

Companion to The IAS 12 Income Taxes and IFRIC 23 Handbook

Every formula, journal entry, and audit defense point in this workbook is explained step by step in the full 16-chapter handbook.

Explore the handbook →