Model Risk During Transactions
Executive Summary
Key Takeaways
- ✓ Model risk during a transaction concentrates in mechanics that do not exist in either party's standalone model — purchase price allocation, financing structure, pro-forma consolidation, and synergies — each a new point of structural failure introduced specifically by the deal itself.
- ✓ Model risk is structurally independent of business risk — a target's underlying operations can be fundamentally sound while the model built to price the acquisition of those operations is structurally unsound, and the two should never be conflated during review.
- ✓ Due diligence adjustment integration is a distinct model risk category of its own — the point at which findings from other workstreams are translated into formulas is a common source of untraced or inconsistently applied adjustments.
- ✓ Hardcoded overrides are disproportionately consequential in a transaction model relative to an ordinary operating model, since a transaction model's headline output typically drives a specific, negotiated price rather than an internal planning decision.
- ✓ Every transaction-specific model risk category maps onto FMAE's existing structural rule set — this is not a new risk taxonomy, but a transaction-specific application of the same structural checks used across every other Knowledge Centre domain.
Objective¶
This guide maps where model risk concentrates specifically during a transaction, within the Financial Model Due Diligence pillar. It establishes the foundational distinction the rest of this pillar builds on: model risk is structurally independent of whether the underlying business being transacted is sound.
Where Transaction-Specific Model Risk Concentrates¶
| Risk Area | Why It Is Transaction-Specific | Existing Coverage |
|---|---|---|
| Purchase price allocation | Does not exist in either party's standalone model; introduces a new goodwill and incremental D&A calculation | Merger Model and Accretion/Dilution Structure |
| Financing structure | New debt sizing, share issuance, and interest/dilution mechanics specific to funding the deal | Merger Model and Accretion/Dilution Structure |
| Synergy assumptions | Frequently the least traceable figures in a deal model; no equivalent exists in a standalone forecast | Synergies |
| Pro-forma consolidation | Combines two independently built models, each potentially using different conventions | Acquisition Model Checklist |
| Due diligence adjustment integration | The translation point between workstream findings and model formulas, a distinct risk of its own | Covered in full below |
Model Risk Is Independent of Business Risk¶
A target company's underlying operations, customer relationships, and market position can be fundamentally healthy while the model built to price the acquisition of that business is structurally unsound — a hardcoded revenue override, a purchase price allocation that does not reconcile to the stated consideration, or a synergy figure entered as an unsupported top-level adjustment. Conversely, a structurally sound, well-built model can still support a poor transaction decision if the underlying business itself is genuinely weak. These are two independent risk dimensions, and a due diligence process that conflates "the model looks professional and well-organized" with "the model is structurally sound" is exposed to exactly the risk this guide addresses.
Due Diligence Adjustment Integration Risk¶
Every workstream — financial, commercial, operational, technical, legal, tax, ESG — produces findings intended to adjust the transaction model. The translation point between a documented finding and an actual model formula is itself a distinct, transaction-specific risk category:
Risk pattern: Financial due diligence identifies a $2M non-recurring expense to add back to EBITDA
Failure mode 1: Adjustment applied to the wrong period in the model
Failure mode 2: Adjustment applied once in the standalone model, then again in the pro-forma
consolidation, double-counting the benefit
Failure mode 3: Adjustment documented in the QoE report but never entered into the model at all
Each of these failure modes produces a materially different, and equally undetected, error in the model's headline output — testing for this integration risk requires reconciling the model's actual formulas against the due diligence findings log line by line, not merely confirming the findings log exists.
Structural Checks Specific to This Risk Category¶
| Check | What It Catches |
|---|---|
| Every due diligence finding requiring a model adjustment is reconciled against the model's actual formulas, not just its findings log | An adjustment documented but never entered, or entered inconsistently |
| Purchase price allocation reconciles exactly to the stated purchase consideration | A goodwill calculation that does not tie to the actual deal price |
| Every synergy line item traces to a specific driver and phasing schedule | An unsupported, aggregate synergy figure inflating the deal case |
| Forecast cells in the acquisition model are tested as live formulas, not accepted based on displayed output | A hardcoded override producing a favorable but unsupported projection |
Continue Reading¶
Prerequisites¶
- Financial Model Due Diligence — the parent pillar
Related Glossary¶
Related Technical Guides¶
Related Checklists¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
What is model risk during a transaction?
The risk that the financial model used to price, structure, or finance a transaction is structurally unsound — independent of whether the underlying business being transacted is fundamentally healthy — concentrated in mechanics specific to the transaction itself rather than either party's ordinary-course operating model.
Where does model risk concentrate most heavily in a transaction model?
In combination mechanics that do not exist in either party's standalone model — purchase price allocation, the financing structure, pro-forma consolidation — and in synergy assumptions, which are frequently the least traceable figures in a deal model.
How is model risk different from business risk in a transaction?
Business risk concerns whether the target company's underlying operations, market position, and financial performance are sound. Model risk concerns whether the financial model built to price the transaction calculates those figures correctly — a target's operations can be fundamentally healthy while the model pricing the acquisition of those operations is structurally unsound, and the two require separate, independent testing.
Why is due diligence adjustment integration treated as its own model risk category?
Because the point at which findings from financial, commercial, tax, and legal due diligence are translated into model formulas is a common source of error — a finding correctly identified and documented in a workstream report can still fail to be correctly, or completely, reflected in the model itself.
Why are hardcoded overrides especially consequential in a transaction model?
Because a transaction model's headline output typically drives a specific, negotiated price between two parties, unlike an internal operating model whose output informs an internal planning decision — a hardcoded override in a transaction model has a more direct, immediate, and quantifiable financial consequence.
Does this domain require new structural rules beyond FMAE's existing rule set?
No. Every transaction-specific model risk category described here maps onto one or more of FMAE's existing 26 structural rules (R001-R026) — the transaction context changes where and how these structural failures matter, not the underlying taxonomy of what can go wrong in a model.
Related Articles
Financial Model Due Diligence
Financial model due diligence is the discipline of testing whether the financial model used to price, structure, or finance a transaction is itself structurally sound — a distinct question from whether the target business's historical financials are reliable (the domain of financial due diligence) or whether its commercial prospects are durable (commercial due diligence). A model can be structurally unsound — an untraceable synergy figure, a broken purchase price allocation link, a hardcoded override masking the true output of a formula — independent of whether the underlying business is fundamentally healthy, and this risk is what financial model due diligence is specifically built to catch. This page is the hub for the Knowledge Centre's model-risk-in-transactions content: how model review differs by audience (independent, lender, investor, vendor), how it differs from a quality of earnings review, and how transaction-specific model risk maps onto FMAE's own structural rule set.
M&A and Transaction Due Diligence
Transaction due diligence is the structured process by which a party to a proposed transaction — most often a buyer, but also a seller preparing for sale or a lender financing the deal — investigates a target business before committing capital. It is organized into distinct workstreams (financial, commercial, operational, technical, legal, tax, ESG), run from one of three process postures (buy-side, sell-side, or vendor), and its findings feed directly into the financial model used to price the transaction and support the investment decision. This page is the hub for the Knowledge Centre's transaction due diligence content: what due diligence is, how each workstream and process posture differs, and how model risk specifically enters a transaction — the angle this platform is built to address in depth.
Merger Model and Accretion/Dilution Structure
A merger model tests whether a proposed acquisition increases or decreases the acquirer's earnings per share — the accretion/dilution result — by combining standalone projections for the acquirer and target with the mechanics specific to the transaction itself: purchase price allocation and the resulting goodwill, the financing structure (cash, new debt, or newly issued stock, in any combination), and any synergies expected from the combination. This guide covers the build sequence in full: standalone projections first, then purchase price allocation, then the financing structure and its effect on pro-forma shares and interest expense, then synergies traced to specific line items rather than a single aggregate assumption, and finally the accretion/dilution calculation itself, with the structural checks that catch the errors most specific to this model type.
Synergies
Synergies are the cost savings or revenue benefits a combined entity is expected to achieve that neither the acquirer nor the target could achieve standalone — eliminating a duplicated corporate function, negotiating better procurement terms at greater combined scale, or cross-selling one company's products through the other's customer base. In a merger model, synergies should be traced to specific, named drivers and phased in over a stated, realistic timeline rather than entered as a single aggregate addition to combined EBITDA, since an untraceable synergy figure is one of the most common ways a deal's headline accretion is overstated.
Purchase Price Allocation
Purchase price allocation (PPA) is the process, required under both IFRS and US GAAP acquisition accounting, of allocating the price paid for an acquired business between its identifiable net assets, recorded at fair value as of the acquisition date, and goodwill, the residual representing value the acquirer paid beyond those identifiable assets. The allocation directly determines the combined entity's post-transaction depreciation and amortization, since revalued tangible assets and newly recognized intangible assets each carry their own schedule going forward, distinct from goodwill, which is not amortized but is tested periodically for impairment.
Structural Risk
Structural risk in the context of financial modelling is the risk of model failure arising from errors, inconsistencies, or weaknesses in the model's design, architecture, and internal logic — as distinct from the risk arising from incorrect input assumptions or adverse external outcomes. Structural risk exists within the model itself, regardless of the accuracy of the assumptions fed into it. A model with high structural risk will produce incorrect outputs even when its inputs are correct. This makes structural risk particularly dangerous: it cannot be remediated by revising assumptions or updating market data. It requires identifying and correcting the model's internal logic.
Hardcode
A hardcode is a typed value, a number, date, or rate, entered directly into a formula cell rather than derived from a reference to an assumptions tab or another calculated cell. It is one of the most common and most consequential structural risks in Excel financial models, because a hardcoded value does not update when the model's stated assumptions change, silently disconnecting the model's output from its own inputs.