Free Template · IFRS / IAS 36
8-tab practitioner workbook pre-loaded with Vanguard Industrial Holdings plc (VIH). 357 live formulas, 13 automated audit controls, zero macros.
Direct download, no macros, no locked sheets, verified in LibreOffice with zero formula errors.
Download IAS_36_Goodwill_Impairment_Calculator.xlsx (32 KB) →
| Worksheet Tab | IAS 36 / IFRS Scope | Key Live Outputs |
|---|---|---|
| Summary_Dashboard | Consolidated Group Overview | FY2026 €104.90M impairment, €11.23M IAS 12 DTA, FY2027 €24.84M reversal |
| CGU_Alpha_VIU_Sens | IAS 36.30-57, IAS 36.134(f) | VIU €461.19M, Headroom €56.19M, 10.61% iterative vs. 11.33% naive pre-tax rate |
| CGU_Beta_Waterfall | IAS 36.104-105 | €62.00M loss, €28.00M goodwill write-off, €42.00M building floor reallocation |
| CGU_Beta_Y2_Reversal | IAS 36.109-125, IAS 36.124 | €24.84M reversal capped at historical cost ceilings, €0.00M goodwill reversal |
| CGU_Gamma_NCI_GrossUp | IAS 36 Appendix C (C4-C8) | €8.00M notional NCI gross-up, €42.90M P&L (€40.72M Parent / €2.18M NCI) |
| Corporate_Assets_2Stage | IAS 36.100-103 | Approach 1 allocation (€122.90M) vs. Approach 2 two-stage base (€6.19M headroom) & stress |
| IAS36_vs_USGAAP | IAS 36 vs. ASC 350 / 360 | €62.00M IFRS vs. €28.00M US GAAP Year 1; €24.84M vs. €0.00M Year 2 |
| Controls | Automated Audit Gate | 13 dynamic reconciliation & journal-entry checks + overall ALL_PASS indicator |
Every formula in this workbook is derived line by line in The IAS 36 Impairment of Assets Handbook. For worked walkthroughs of the core mechanics, read our three companion articles: