Free Template · IFRS / IAS 36

IAS 36 Goodwill & Asset Impairment Calculator in Excel

8-tab practitioner workbook pre-loaded with Vanguard Industrial Holdings plc (VIH). 357 live formulas, 13 automated audit controls, zero macros.

Download the Excel workbook (32 KB, .xlsx)

Direct download, no macros, no locked sheets, verified in LibreOffice with zero formula errors.

Download IAS_36_Goodwill_Impairment_Calculator.xlsx (32 KB) →

What is inside the 8 worksheets

Worksheet TabIAS 36 / IFRS ScopeKey Live Outputs
Summary_DashboardConsolidated Group OverviewFY2026 €104.90M impairment, €11.23M IAS 12 DTA, FY2027 €24.84M reversal
CGU_Alpha_VIU_SensIAS 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_WaterfallIAS 36.104-105€62.00M loss, €28.00M goodwill write-off, €42.00M building floor reallocation
CGU_Beta_Y2_ReversalIAS 36.109-125, IAS 36.124€24.84M reversal capped at historical cost ceilings, €0.00M goodwill reversal
CGU_Gamma_NCI_GrossUpIAS 36 Appendix C (C4-C8)€8.00M notional NCI gross-up, €42.90M P&L (€40.72M Parent / €2.18M NCI)
Corporate_Assets_2StageIAS 36.100-103Approach 1 allocation (€122.90M) vs. Approach 2 two-stage base (€6.19M headroom) & stress
IAS36_vs_USGAAPIAS 36 vs. ASC 350 / 360€62.00M IFRS vs. €28.00M US GAAP Year 1; €24.84M vs. €0.00M Year 2
ControlsAutomated Audit Gate13 dynamic reconciliation & journal-entry checks + overall ALL_PASS indicator

Companion handbook and deep-dive guides

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: