Integrated Business Plan Model for a Multi-Entity International Energy
The client is a UAE-based international investment group operating across the global energy and chemicals sectors. With an expanding portfolio spanning International Gas, Global Chemicals, and Group Companies across multiple geographies — including the United States, United Kingdom, Europe, the Caspian region, Africa, and the Middle East — the group required a single, institution-grade integrated financial model to consolidate its diverse asset base under one unified planning framework.
Structured through a holding company architecture comprising a Top Co., Hold Co. 1, Hold Co. 2, and an Hold Co. 3, the group manages both committed and pipeline assets at various stages of investment from closed transactions to early-stage project identification. As the portfolio scaled, the group needed a robust, auditable, and scenario-ready business plan model capable of supporting investment decision-making, board reporting, lender analysis, and long-range strategic planning.
| Project Snapshot | |
| Client Type | International Energy & Chemicals Investment Group |
| Geography | UAE (HQ) · UK · USA · Europe · Caspian · Africa · East Asia · Middle East |
| Sectors | International Gas · Global Chemicals · Energy Solutions · Group Companies |
| Entity Structure | Top Co. · Hold Co. 1 · Hold Co. 2 · Hold Co. 3 · Multiple Asset-Level Entities |
| Asset Coverage | 20+ Assets (Committed, Planned & Early Stage) |
| Model Type | Integrated Multi-Entity Business Plan (BP) Financial Model |
| Currency | USD Millions (AED parallel reporting) |
| Service | Financial Modelling Advisory |
The Challenge
Our Approach & Solution
The Impact
✅ Complex Multi-Entity Consolidation Structure requiring full integration across Top Co., Hold Co. 1, Hold Co. 2, and Hold Co. 3, with subsidiaries, joint operations, and associates subject to different IFRS consolidation treatments.
✅ Diverse Portfolio Across Multiple Sectors and Investment Stages spanning International Gas, Global Chemicals, Energy Solutions, and listed Group Companies, with assets ranging from early-stage investments to mature operations.
✅ Advanced Ownership and Reporting Requirements necessitating parallel reporting of both 100% asset-level performance and Top Co. ownership-share metrics for management, board, and shareholder reporting.
✅ Sophisticated Financing and Scenario Planning Framework incorporating inter-entity shareholder loans, capital structures, repayment schedules, and dynamic Base, Upside, and Downside scenario analysis through a single control mechanism.
✅ Institutional-Grade Governance and Reporting Standards requiring automated board-ready dashboards, management reporting, and comprehensive model integrity checks, including balance sheet balancing and cash flow reconciliation across all entities.
✅ Centralised Control & Data Architecture featuring a Scenario Control module for single-click scenario switching, a master MetaData registry for all assets, and consolidated HoldCo input assumptions covering financing, tax, liquidity, and operating costs.
✅ Integrated Multi-Entity Calculation Engine comprising independent financial models for Top Co. and all HoldCos, producing fully linked P&L, Balance Sheet, and Cash Flow statements with consistent inter-company flows and funding structures.
✅ Comprehensive Performance, Returns & Cash Flow Analytics delivering IFRS, 100%-ownership, and proportionate-share reporting views, alongside ROIC, IRR, NOPAT, Invested Capital, and consolidated cash flow analysis.
✅ Dynamic Operational & Scenario Analysis Capability enabling asset-level operational KPI tracking, portfolio benchmarking, sensitivity analysis, and scenario comparison across key business drivers.
✅ Board-Ready Reporting & Robust Model Governance supported by automated portfolio outputs, Power Query-driven aggregation, real-time model integrity checks, balance sheet and cash flow reconciliation, and a documented dependency framework for auditability and maintenance.
✅ Unified a fragmented planning environment into a single integrated financial model covering 20+ international assets, replacing multiple disconnected entity-level spreadsheets.
✅ Delivered full IFRS-compliant multi-entity consolidation across four holding company tiers, incorporating subsidiaries, joint operations, and associates with the appropriate consolidation treatments.
✅ Enabled dynamic scenario planning and reporting through a single-control framework allowing instant switching between Base, Upside, and Downside cases across the entire model.
✅ Produced board-ready management reporting and investment analytics, including dashboards, NOPAT, ROIC, IRR, and portfolio performance metrics, with outputs available in both USD and AED.
✅ Established institutional-grade model governance through fully reconciled financial statements, automated integrity checks, and a modular architecture that supports future asset additions, scenario expansion, and evolving reporting requirements.
Value Delivered
By designing a model architecture that matched the structural complexity of the client’s international investment platform, Finwiserr enabled the finance team to move from managing multiple disconnected spreadsheets to operating from a single source of truth and one that is auditable, scenario-ready, and built for growth.
The model now serves as the foundation for Board reporting, lender presentations, strategic planning cycles, and new investment evaluation — across a portfolio spanning three sectors and five continents.
If you are managing a multi-entity investment structure and need a robust, integrated financial model for business planning, board reporting, or investor engagement, we would be glad to explore how Finwiserr can support your organisation.
Interactive Deliverables & Client Impact
