Common Transaction Modelling Errors
Executive Summary
Key Takeaways
- ✓ The most consequential transaction modelling errors recur across nearly every deal type, and recognizing the pattern is faster than re-deriving each risk from first principles on a case-by-case basis.
- ✓ An untraceable synergy figure and a purchase price allocation that does not reconcile to the stated consideration are the two most common combination-mechanic errors, appearing across mergers, business combinations, and asset deals alike.
- ✓ Due diligence adjustment integration failures — a finding documented but never entered into the model — are a distinct error category from a model's own internal formula errors, and require a different check (reconciling the model against the findings log) to catch.
- ✓ Structure-specific errors — an incorrectly assumed tax basis step-up, a stale remaining concession term, an understated post-TSA cost base — each require the specific structural check covered on their respective dedicated guide, since a general-purpose checklist alone will not catch a structure-specific error.
- ✓ Governance failures under deal time pressure — an undocumented last-minute change, a stale model version relied upon by part of the deal team — are a recurring error category independent of the model's own formula correctness.
Purpose¶
This page synthesizes the recurring structural errors across every transaction type covered on this Knowledge Centre into a single, scannable reference. It is a starting point for pattern recognition, not a replacement for the detailed guide covering each error — every row below links to the full treatment.
Combination-Mechanic Errors¶
| Error | Where It Appears | Full Treatment |
|---|---|---|
| Untraceable, unsupported synergy figure | Mergers, business combinations, any deal with projected synergies | Merger Model and Accretion/Dilution Structure, Model Risk During Transactions |
| Purchase price allocation that does not reconcile to stated consideration | Any acquisition with goodwill or asset step-up | Merger Model and Accretion/Dilution Structure |
| Pro-forma leverage carried forward from a standalone model, not recalculated | Any debt-financed acquisition | Lender Model Review |
Due Diligence Integration Errors¶
| Error | Description | Full Treatment |
|---|---|---|
| Finding documented but never entered into the model | A quality of earnings, commercial, tax, or legal finding correctly identified but not reflected in a formula | Model Risk During Transactions |
| Normalized EBITDA mismatch between the QoE report and the model | The transaction model uses a different figure than the due diligence conclusion | Quality of Earnings |
| Net working capital peg calculated on a non-representative period | Peg does not reflect genuine ongoing working capital needs | Net Working Capital Peg |
Structure-Specific Errors¶
| Error | Deal Type | Full Treatment |
|---|---|---|
| Tax basis step-up assumed incorrectly for the actual deal structure | Asset vs. share deals | Asset Acquisition vs. Share Acquisition |
| Cash flow projected beyond the asset's actual remaining contractual term | Infrastructure, renewable, PPP secondary transactions | Infrastructure and Energy Transactions |
| Transitional service agreement costs treated as permanent rather than temporary | Carve-out transactions | Carve-Out Transactions |
| Distribution waterfall or dilution mechanics not matching the actual joint venture agreement | Joint venture transactions | Joint Venture Transactions |
| Going-concern assumptions untested, liquidation value not calculated as a price floor | Distressed transactions | Distressed Transactions |
Governance and Process Errors¶
| Error | Description | Full Treatment |
|---|---|---|
| Deal team working from a superseded model version | No single authoritative version maintained under deal time pressure | Model Governance During Transactions |
| Undocumented last-minute change relied upon in final terms | Documentation discipline abandoned during highest-pressure period | Model Governance During Transactions |
| Confirmatory diligence compressed to meet an arbitrary signing date | Realistic timeline not planned before the process began | Due Diligence Process |
How to Use This Page¶
Use this page as a first-pass scan when reviewing a transaction model or planning a review scope — identify which error categories are relevant to the specific deal type and structure, then apply the full checklist and guide for each relevant category rather than relying on this synthesis alone. See Financial Model Due Diligence Checklist for the operationalized review tool this page's error categories map onto.
Continue Reading¶
Prerequisites¶
- M&A and Transaction Due Diligence — the parent pillar
- Financial Model Due Diligence
Related Checklists¶
Related Technical Guides¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
What is the purpose of this page?
To synthesize the specific structural errors that recur across every transaction type covered on this Knowledge Centre into a single, scannable reference, cross-referenced back to the full guide covering each error in depth — a starting point for a deal team or reviewer, not a replacement for the detailed guides.
What is the single most common combination-mechanic error?
An untraceable synergy figure — entered as a single, unsupported top-level adjustment rather than traced to a specific driver and phasing schedule — appearing across mergers, business combinations, and any transaction involving projected cost or revenue synergies.
How is a due diligence adjustment integration failure different from a formula error?
A formula error is a mistake within the model's own internal calculation logic. A due diligence adjustment integration failure is a finding correctly identified in a workstream report that was simply never entered into the model at all — the model's formulas may be entirely correct, but a known adjustment is missing, requiring a different check (reconciling the model against the findings log, not tracing formulas) to catch.
Why can't a single general-purpose checklist catch every error on this page?
Because several of the most consequential errors are structure-specific — an incorrectly assumed tax basis step-up applies only to certain deal structures, a stale remaining concession term applies only to infrastructure secondary transactions, an understated post-TSA cost base applies only to carve-outs — and each requires the specific structural check covered on its own dedicated guide.
Are governance failures considered a modelling error?
Yes, in the sense that a governance failure — an undocumented last-minute change, part of the deal team relying on a stale model version — produces the same practical consequence as a formula error, namely a decision made on the basis of incorrect figures, even where every formula in the authoritative model version was itself correct.
Related Articles
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.
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.
Model Risk During Transactions
Model risk during a transaction concentrates in mechanics that do not exist in either party's ordinary-course, standalone model — purchase price allocation, financing structure, pro-forma consolidation, and synergy assumptions — each a new potential point of structural failure introduced specifically by the transaction itself. This guide maps where that risk concentrates and why it is structurally independent of whether the underlying business being acquired is fundamentally sound.
Financial Model Due Diligence Checklist
This checklist operationalizes the Financial Model Due Diligence pillar into a working review tool. It focuses on the checks specific to a transaction model that general model audit and the acquisition-model-specific checklist do not fully cover in combination — whether due diligence findings from every workstream are actually and correctly reflected in the model, and whether the review has been scoped correctly for its intended audience (independent, lender, investor, or vendor). It assumes the general Financial Model Audit Checklist and the Acquisition Model Checklist have already been applied to the underlying model structure.