• Discount up to 50% for first purchase. Free trial 7 days!
Get Started

Consolidation Models

Master complex group financial statements.

Course Curriculum

Module 1
Introduction to Consolidation

  • What is Consolidation in Financial Modeling?
  • Why Businesses Consolidate: Legal vs. Management View
  • Key Concepts: Control, Ownership, NCI, Elimination
  • Overview of Consolidated Financial Statements
  • IFRS vs. US GAAP considerations (high-level)

Module 2
Building the Foundation

Module 3
Consolidation Model Architecture

Module 4
Consolidated Income Statement

Module 5
Consolidated Balance Sheet

Module 6
Consolidated Cash Flow Statement

Module 7
Advanced Topics in Consolidation

Module 8
Case Study – Multi-Entity Group Model

Module 9
Automation and Controls

Module 10
Final Assessment & Certification

$120.00 $500.00

Course Features

Excel DCF Templates

Professional valuation models used by top investment banks

Step-by-Step Videos

Detailed screen recordings of model building process

Real Company Cases

Actual public company valuations and analysis

Advanced Formulas

Custom Excel functions for complex calculations

Industry Recognition

Certificate recognized by leading financial institutions

Practical Application

Build models you can use in real deal scenarios