Free Templates · IAS 12 & IFRIC 23
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.
File: IAS_12_Deferred_Tax_IFRIC_23_Calculator.xlsx · 100% live Excel formulas · Zero macros · Nothing locked or hidden.
| Tab Name | Scope & Live Mechanics |
|---|---|
| Deferred_Tax_Schedule | 17 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_ARO | Day 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_Basis | Veridian 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_Valuation | UTP-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_ASC740 | Pillar 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. |
| Controls | 12 automated cross-sheet integrity checks (roll-forward closure, ETR closure, Day 1 neutrality, probability sums) returning ALL PASS dynamically. |
Every formula, journal entry, and audit defense point in this workbook is explained step by step in the full 16-chapter handbook.