Business Unit and Segment Model Structure
Executive Summary
Key Takeaways
- ✓ A business unit or segment model extends the three-statement foundation across multiple internal operating units within one legal entity, distinct from a multi-entity consolidation, which combines separate legal entities.
- ✓ Each business unit's own revenue and directly attributable cost should be built and driven independently before any shared corporate overhead is allocated to it, so a unit's underlying operating performance remains visible before and after allocation.
- ✓ Overhead allocation should use a single, consistently applied, and documented method — headcount, revenue share, or direct usage — rather than a different basis chosen ad hoc for each unit or period.
- ✓ The sum of every business unit's allocated result must reconcile exactly to the group total; any gap indicates an allocation formula that does not fully distribute total overhead, or a unit's figures that are not correctly sourced from the same underlying model as the group total.
- ✓ Contribution margin (revenue less directly attributable variable cost, before any overhead allocation) is often a more useful measure of a business unit's standalone performance than its fully allocated profit, since it isolates results the unit's own management can actually control.
Institutional Definition¶
A business unit or segment model extends the standard three-statement foundation across more than one internal operating unit within a single legal entity, requiring two mechanics a single-unit model does not need: a defined overhead allocation methodology, and a reconciliation ensuring segment-level results sum exactly to the group total. This is structurally distinct from a multi-entity consolidation model, which combines separate legal entities rather than internal divisions of one entity — though the two mechanics can both apply together where a group operates through internal units and also holds separate legal subsidiaries.
Build Each Unit's Own Detail First¶
Each business unit's revenue and directly attributable cost should be built and driven independently, using the same driver-based discipline applied to any corporate forecast, before any shared corporate overhead is allocated to it. This ordering matters: it keeps a unit's own underlying operating performance visible on its own terms, separate from the effect of a corporate-level allocation decision the unit's own management typically has no control over.
Unit Contribution Margin = Unit Revenue − Unit Directly Attributable Variable Cost
Unit Fully Allocated Profit = Unit Contribution Margin − Allocated Share of Corporate Overhead
Contribution margin — the unit's result before any overhead allocation — is often a more useful standalone performance measure than the fully allocated figure, precisely because it isolates what the unit's own management can actually influence.
Overhead Allocation Methods¶
| Method | Basis | Best Suited To |
|---|---|---|
| Headcount allocation | Overhead split in proportion to each unit's employee count | Overhead functions whose cost scales roughly with staff supported (HR, general office costs) |
| Revenue-share allocation | Overhead split in proportion to each unit's revenue | A simple, widely understood proxy where no better driver is available, though it can penalize high-revenue, low-overhead-usage units |
| Direct usage allocation | Overhead split based on an actual measured driver (IT ticket volume, square footage occupied, transaction count) | Overhead functions where a genuine, trackable usage driver exists — generally the most defensible method where available |
Whichever method is chosen, it should be applied consistently across every unit and every period, and documented explicitly enough that a reviewer can independently recompute the allocation. Switching allocation methods between periods without disclosure, or applying a different basis to different units within the same period, undermines the comparability the segment structure exists to provide.
Building the Segment-to-Group Reconciliation¶
A dedicated reconciliation row or schedule should confirm that the sum of every business unit's fully allocated result equals the group's consolidated total exactly:
Sum of All Units' Fully Allocated Profit ?= Group Consolidated Profit
A gap here indicates one of two structural problems: the overhead allocation formula does not fully distribute 100% of total corporate overhead across the units (a common cause is an allocation percentage schedule that does not sum to 100%), or a unit's underlying figures are sourced inconsistently with the figures actually used to build the group total (for example, a unit's revenue pulled from a different, unreconciled data source than the group income statement).
Common Structural Errors¶
| Error | Consequence |
|---|---|
| Overhead allocated before unit-level contribution margin is visible | Unit management's own controllable performance is obscured by a corporate allocation decision |
| Allocation percentages that do not sum to 100% across units | Segment totals fail to reconcile to the group result |
| Allocation method changed between periods without disclosure | Unit-level trend comparisons become misleading |
| Different allocation basis applied to different units in the same period | Segment results are not genuinely comparable to each other |
| Unit-level figures sourced separately from the group model | Reconciliation gap, and no single source of truth for either the segment or group figures |
Continue Reading¶
Prerequisites¶
- Corporate Financial Modelling — the parent pillar
- Driver-Based Model Structure
Related Technical Guides¶
Related Glossary¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
What is a business unit or segment model?
A financial model that extends the standard three-statement foundation across more than one internal operating unit within a single legal entity, adding an overhead allocation methodology and a reconciliation ensuring segment-level results sum exactly to the group total.
How is a business unit model different from a consolidation model?
A consolidation model combines separate legal entities, adding intercompany elimination, non-controlling interest, and currency translation. A business unit model splits a single legal entity's results across internal operating divisions, adding overhead allocation and a segment-to-group reconciliation instead — see Consolidation Model Structure for the legal-entity case.
What are the common methods for allocating shared corporate overhead?
Headcount allocation (overhead split in proportion to each unit's employee count), revenue-share allocation (split in proportion to each unit's revenue), and direct usage allocation (split based on an actual measured driver, such as IT ticket volume or square footage occupied). Direct usage is generally the most defensible where a genuine usage driver exists; headcount and revenue share are common practical proxies where it does not.
Why should a business unit's directly attributable results be built before overhead is allocated?
So the unit's own underlying operating performance — the results its own management can actually influence — remains visible separately from the effect of an allocation methodology chosen at the corporate level, which the unit's management typically does not control.
What does it mean for segment results to "reconcile" to the group total?
The sum of every business unit's fully allocated result, added together, must equal the group's consolidated total exactly. A gap indicates either an overhead allocation formula that does not fully distribute 100% of total overhead across the units, or a unit's figures sourced inconsistently with the figures used to build the group total.
What is contribution margin, and why is it relevant to business unit reporting?
Contribution margin is revenue less directly attributable variable cost, calculated before any shared overhead allocation. It is often a more useful measure of a business unit's standalone performance than its fully allocated profit, because it isolates the results the unit's own management can actually control, distinct from the effect of a corporate-level allocation decision — see Contribution Margin.
Can a business unit model also need consolidation mechanics?
Yes, where the group both operates through internal business units and holds separate legal entities — for example, a group with two divisions, one of which is itself a partially owned subsidiary. In that case, both this guide's overhead allocation and reconciliation discipline and Consolidation Model Structure's elimination and non-controlling interest mechanics apply together.
Related Articles
Corporate Financial Modelling
Corporate financial modelling is the discipline of building financial models for operating companies — as distinct from a single asset, project, or development. Nearly every corporate model type is built on the same foundation, a fully integrated three-statement structure, and then specializes that foundation toward a specific purpose: a budget model constrains it to a fixed annual period, a driver-based model rebuilds it from operational units rather than percentage growth, a consolidation model extends it across multiple legal entities and currencies, a management reporting model extracts and re-presents its outputs as KPIs, and a transaction model (a merger model, an LBO) repurposes it to answer a specific capital-structure or ownership-change question. This page is the hub for the Knowledge Centre's corporate financial modelling content: the shared three-statement foundation, how each model type specializes it, and where each mechanic is covered in full technical depth elsewhere on this platform.
Contribution Margin
Contribution margin is revenue less directly attributable variable cost, calculated before any shared corporate overhead is allocated. It measures the amount a unit, product, or segment's own sales activity contributes toward covering shared fixed costs and, beyond that, toward group profit — distinct from a fully allocated profit figure, which also deducts a share of overhead the unit's own management typically does not control.
Consolidation Model Structure
A consolidation model combines multiple legal entities' individually correct financial statements into a single group result, and requires three mechanics a single-entity three-statement model does not need: intercompany elimination, removing transactions between group entities so they do not double-count; non-controlling interest allocation, splitting a partially-owned subsidiary's results between the parent and minority shareholders; and currency translation, converting foreign-entity statements into the group's presentation currency. This guide covers how each mechanic should be structured, the standard consolidation worksheet layout, and the most common consolidation errors — most of which originate in an incomplete elimination rather than any individual entity's own statements being wrong.
Management Reporting and KPI Dashboard Model Structure
A management reporting or KPI dashboard model is not a separate calculation engine — it is a presentation layer that extracts, re-derives, and re-presents figures already produced by an underlying three-statement model. This guide covers how that layer should be structured: every dashboard figure formula-linked back to its source in the underlying model rather than re-keyed or pasted, KPIs defined once with a documented formula rather than calculated inconsistently across different reports, and a clear separation between the calculation engine (where figures are produced) and the reporting layer (where they are selected, formatted, and presented) so that a change to the underlying model flows through to every report automatically.
Three-Statement Model
A three-statement model is a financial model in which the income statement, balance sheet, and cash flow statement are dynamically linked into a single integrated system, so that a change in any assumption flows through correctly to all three, and the balance sheet balances in every forecast period as a direct consequence of that linkage rather than as a plug engineered to force it. It is the structural foundation most other financial models — DCF, LBO, project finance — are built on top of.
Driver-Based Model Structure
A driver-based model forecasts each line from an operational unit — units sold, headcount, price per unit, capacity utilization — rather than a percentage growth rate applied to a prior period. This guide covers how to structure a driver-based build: selecting the right driver for a given revenue or cost line, separating volume drivers from price/rate drivers so each can be sensitized independently, building a driver tree that shows how granular drivers roll up into the income statement, and why this structure is materially more auditable than a blended growth-rate shortcut even where the two produce a similar headline result in the base case.