
📊 Goodwill Valuation & Impairment Model (IFRS 3 / IAS 36)
The Goodwill Valuation & Impairment Model is a professionally built Excel template bundle designed to support purchase price allocation, goodwill recognition, recoverable amount testing, impairment analysis, valuation review, feasibility assessment, and executive-level dashboard reporting.
Created by PDMM, this bundle is built around the practical application of IFRS 3 and IAS 36, making it useful for finance teams, accountants, valuation analysts, consultants, audit support teams, students, business owners, and professionals who need a structured goodwill impairment analysis tool.
This listing includes two separate Excel models with different themes, different levels of detail, and different feature depth:
• Lite Excel Model
• Advanced Pro Excel Model
• Complete Bundle Option
━━━━━━━━━━━━━━━━━━━━
🟦 LITE GOODWILL VALUATION & IMPAIRMENT MODEL
The Lite version is designed for users who need a clean, practical, and easy-to-follow workbook for goodwill valuation and impairment testing.
It includes a simplified IFRS 3 purchase price allocation approach and an IAS 36 impairment testing framework for a cash-generating unit.
Key Lite Model Features:
• Input Assumptions Sheet
• Purchase Price Allocation Calculation
• Goodwill Recognition Analysis
• 10-Year CGU Forecast
• Value-in-Use Calculation
• Fair Value Less Costs of Disposal Calculation
• Recoverable Amount Analysis
• Impairment Test
• Headroom / Shortfall Analysis
• Sensitivity Matrix
• KPI Dashboard
• Formula Checks
• Disclaimer Page
• IFRS Notes
This version is ideal for users who want a streamlined model that is professional, editable, and easy to understand.
━━━━━━━━━━━━━━━━━━━━
🟨 ADVANCED PRO GOODWILL VALUATION & IMPAIRMENT MODEL
The Advanced Pro version is built for users who need a more detailed and comprehensive goodwill impairment model with deeper analysis, more schedules, and stronger reporting outputs.
It includes a 120-month forecast engine, multiple CGU-level calculations, detailed valuation logic, impairment allocation, scenario analysis, sensitivity analysis, QA checks, and an executive dashboard.
Key Advanced Pro Model Features:
• 120-Month Forecast Engine
• Annual Forecast Summaries
• Deal Purchase Price Allocation
• Identifiable Intangible Assets Schedule
• CGU Allocation Schedule
• Value-in-Use by CGU
• Fair Value Less Costs of Disposal by CGU
• Recoverable Amount Analysis
• Headroom / Shortfall Analysis
• Goodwill Impairment Allocation
• Impairment Allocation to Other Assets
• Scenario Manager
• Sensitivity Analysis
• Executive Dashboard
• Disclosure Checklist
• QA / Error Checks
• PDMM Support Page
This version is ideal for more advanced users, professional analysts, consultants, finance teams, audit support teams, and valuation professionals who require a deeper impairment testing structure.
━━━━━━━━━━━━━━━━━━━━
📈 WHAT THIS MODEL CAN HELP YOU ANALYZE
This Excel template bundle can support a wide range of goodwill valuation and impairment analysis tasks, including:
• Goodwill Recognition
• IFRS 3 Purchase Price Allocation
• IAS 36 Impairment Testing
• Cash-Generating Unit Analysis
• Recoverable Amount Testing
• Value-in-Use Analysis
• Fair Value Less Costs of Disposal
• Headroom and Shortfall Review
• Scenario Analysis
• Sensitivity Analysis
• WACC and Discount Rate Review
• Terminal Value Analysis
• DCF-Based Valuation Support
• Financial Feasibility Assessment
• Internal Management Review
• Audit Preparation Support
• Professional Financial Modelling Training
━━━━━━━━━━━━━━━━━━━━
📌 WHO CAN USE THIS TEMPLATE?
This model is suitable for:
• Finance Teams
• Valuation Analysts
• Accountants
• Business Owners
• Students
• Consultants
• Audit Support Teams
• Investment and Transaction Analysts
• Financial Modelling Professionals
Whether you are preparing an internal valuation review, learning goodwill impairment mechanics, supporting a transaction analysis, or building an impairment testing file, this template provides a structured and professional Excel framework.
━━━━━━━━━━━━━━━━━━━━
⚙️ HOW TO USE THE MODEL
Start by opening the Inputs or Global Inputs sheet and updating the highlighted assumption cells.
Then review the purchase price allocation, CGU carrying amounts, forecast assumptions, valuation outputs, recoverable amount, impairment result, headroom analysis, and dashboard KPIs.
The model includes sample assumptions for demonstration and testing purposes. These should be replaced with entity-specific assumptions, management-approved forecasts, supporting evidence, and professional accounting guidance before using the outputs for decision-making.
━━━━━━━━━━━━━━━━━━━━
⭐ WHY THIS MODEL STANDS OUT
• Two Separate Excel Models Included
• Lite and Advanced Pro Versions Available
• Professional Dashboard Layouts
• Built for IFRS 3 and IAS 36 Concepts
• Editable Excel Structure
• No Macros
• Formula-Based Workbook
• Example Data Included
• Scenario and Sensitivity Tools
• KPI and Dashboard Outputs
• Professional Checks and Disclaimer Pages
• Suitable for Learning, Analysis, Review, and Presentation
━━━━━━━━━━━━━━━━━━━━
📦 AVAILABLE DOWNLOAD OPTIONS
1. Lite Excel Model
Goodwill Valuation & Impairment Model Lite
2. Advanced Pro Excel Model
Goodwill Valuation & Impairment Model Advanced Pro
3. Complete Template Bundle
Lite + Advanced Pro Goodwill Valuation & Impairment Models
With this comprehensive 5- or 10-year monthly tool, investors can assess the viability of setting up... Read more
The Mobile App Financial Plan Template in Excel allows you to develop financial projections when lau... Read more
The Food Truck Financial Model helps entrepreneurs, founders, business owners, consultants, and anal... Read more
The Green Hydrogen from Wind Financial Model aims to comprehensively forecast a horizon of 40 years ... Read more
Protect your business secrets with ease using our Simple Mutual Non-Disclosure Agreement Template. S... Read more
The Solar Energy Financial Model Spreadsheet Template in Excel assists you in preparing a sophistica... Read more
Starting a restaurant without a financial plan is like driving a car blindfolded. You wouldn´t do i... Read more
You must log in to submit a review.
















