Multi-Entity Business Plan Model for an International Energy & Chemicals Group

United Arab Emirates  |  Energy & Chemicals  |  Institutional Financial Modelling

Finwiserr designed a multi-entity business plan model for a UAE-based international investment group operating across the global energy and chemicals sectors. With a 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 needed 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 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.

Our Approach & Solution

Building a multi-entity business plan model at this scale meant designing centralised control without sacrificing entity-level detail:

✔ Centralised Control & Data Architecture — 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 — 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 — IFRS, 100%-ownership, and proportionate-share reporting views, alongside ROIC, IRR, NOPAT, Invested Capital, and consolidated cash flow analysis.

✔ Dynamic Operational & Scenario Analysis — Asset-level operational KPI tracking, portfolio benchmarking, sensitivity analysis, and scenario comparison across key business drivers.

✔ Board-Ready Reporting & Model Governance — 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.

Why Multi-Entity Business Plan Models Are Hard to Get Right

Consolidating financial data across a multi-tier holding structure is one of the harder problems in corporate finance — different IFRS treatments apply depending on control levels, intercompany transactions must be eliminated without distorting entity-level performance, and reporting has to hold up to board, lender, and shareholder scrutiny simultaneously. Abacum’s research on multi-entity consolidation notes this is precisely why multinational corporations and holding companies need a structured, single-source-of-truth approach rather than a collection of disconnected entity-level spreadsheets. A multi-entity business plan model built the right way turns that complexity into a single control panel rather than a recurring reconciliation headache.

The Impact

• 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 — 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.