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 n & 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

Managing the financial planning for a globally diversified investment group with over 20 assets, multiple holding entities, and distinct investment structures across three asset verticals presented a series of interconnected modelling and analytical challenges:

• Fragmented multi-entity financial architecture requiring full consolidation across Top Co., Hold Co. 1, Hold Co. 2, and Hold Co. 3
• Diverse asset structures including subsidiaries, joint operations, and associates — each with distinct consolidation treatments under IFRS
• Assets at varying investment stages requiring flexible modelling logic
• Multi-sector complexity spanning International Gas, Global Chemicals, Energy Solutions, and listed Group Companies
• Requirement to model both Top Co. ownership share metrics and 100% asset-level metrics in parallel for internal and external reporting
• Scenario-driven planning requirements across Base, Upside, and Downside cases with a single-switch scenario control mechanism
• Inter-entity shareholder loan structures with complex capitalisation, tenor, and repayment schedules across multiple Hold Cos
• Need to produce board-quality, ready outputs and management dashboards simultaneously with the underlying model
• Requirement to pass a comprehensive model integrity check before any outputs could be shared covering Balance Sheet balances and Cash Flow reconciliation across all entities

  Our Approach & Solution

Fin-Wiser designed and delivered a fully integrated, multi-entity Business Plan financial model built around a modular, dependency-mapped architecture that ensures every calculation layer flows correctly from inputs through to final outputs. The solution was structured in four layers:

1. Control & Inputs Architecture

• A dedicated Scenario Control module enabling single-click switching between scenarios, feeding all downstream calculations automatically
• A MetaData sheet acting as the master asset registry — capturing entity names, geographies, investment stages, HoldCo mappings, IFRS consolidation treatment, and unique counters for each asset
• A centralised Hold Co. Inputs sheet consolidating all key assumptions: shareholder loan facilities (amount, tenor, capitalisation dates, repayment schedules), interest rates, HQ operating expenses, minimum cash balances, and tax rates across all four holding entities

2. Flat File & Calculation Engines

• A Master Flat File capturing all asset-level assumptions in a single structured table, feeding all Metrics and Cash Flow sheets without manual re-entry
• Four independent entity calculation engines (Top Co., Hold Co. 1, Hold Co. 2, Hold Co. 3) each producing full P&L, Balance Sheet, and Cash Flow statements with internally consistent inter-entity flows
• A TopCo. Funding module modelling the Top Co. debt facility, drawdown schedule, interest expense, and credit coverage ratios
• A HoldCo & TopCo Financial Statements table aggregating entity-level outputs into a structured format for downstream reporting

3. Metrics, Returns & Cash Flow

• Asset-level metrics produced on three bases: IFRS consolidated view, 100% ownership basis, and proportionate share enabling both internal benchmarking and investor-ready reporting
• A Returns Summary computing NOPAT, Invested Capital, ROIC, and IRR by asset and HoldCo sourced dynamically from the Master Flat File and Metrics sheets
• A standalone and consolidated Cash Flow Summary covering EBITDA, Capex, working capital, cash tax, investing activities, financing flows, and closing cash balances
• Operational Metrics tracking production volumes and operational KPIs by asset, feeding the Operational Pivot Tables
• A Sensitivity module allowing scenario comparison across key financial variables with toggle-based outputs

4. Output & Quality Assurance

• A Master Output File and Financial Pivot Tables enabling Power Query-driven aggregation of all asset data for portfolio-level analysis
• A master Checks sheet providing a real-time model integrity dashboard — Balance Sheet balance checks and Cash Flow reconciliation checks across all entities — with a hard gate requiring all checks to read TRUE before outputs are circulated
• A model Dependency Map clearly documenting every sheet’s upstream and downstream linkages, enabling efficient QA, auditability, and future model maintenance

  The Impact

• A single integrated model replacing fragmented entity-level spreadsheets across a 20+ asset international portfolio
• Full multi-entity consolidation with correct IFRS treatment for subsidiaries, joint operations, and associates across four holding company tiers
• Real-time scenario flexibility: switching between Base, Upside, and Downside cases with a single control cell, with all 30+ model sheets updating automatically
• Parallel reporting in both USD millions and AED millions, with a consistent number format convention applied across all output sheets
• Management-ready dashboards and integrated outputs enabling board-level presentations to be produced directly from the model without manual reformatting
• A fully reconciled Cash Flow Statement and Balance Sheet across all entities with a live integrity check ensuring model reliability before every distribution
• An auditable, modular model architecture with a documented dependency map, enabling the finance team to onboard new assets, scenarios, and reporting requirements with minimal structural rework
• A returns and KPI framework covering NOPAT, ROIC, and IRR providing the investment team with a consistent lens for evaluating new opportunities against the existing portfolio

Value Delivered

By designing a model architecture that matched the structural complexity of the client’s international investment platform, Fin-Wiser Advisory 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 Fin-Wiser Advisory can support your organisation.