Financial Model Due Diligence

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.

What Is a Financial Model Audit?

A financial model audit is an independent, structured examination of an Excel based financial model to confirm that its mechanics, logic, and outputs are reliable enough to support a decision. It is not a check of whether the assumptions are optimistic or conservative. It is a check of whether the model actually calculates what its author believes it calculates. Every year, lenders extend debt, investment committees approve capital, and boards sign off on transactions using numbers that came out of a spreadsheet nobody outside the immediate deal team has independently verified. A financial model audit exists to close that gap before it becomes expensive.

What Is Model Risk?

Model risk is the risk that a decision is wrong not because the underlying business or investment case was flawed, but because the model used to evaluate it was. It is a distinct category of risk from market risk, credit risk, or operational risk, and it applies to any organisation that relies on a financial model, spreadsheet or otherwise, to support a material decision. Most published model risk content addresses statistical and regulatory capital models used inside banks. This page defines model risk specifically as it applies to Excel based financial models, the kind used every day for investment decisions, lending, and transaction evaluation, which is a related but distinct problem from the quantitative model risk literature most search results return.

Financial Due Diligence

Financial due diligence investigates a target company's historical financial performance — earnings quality, working capital trends, net debt, and off-balance-sheet obligations — to establish a reliable, normalized baseline before a transaction is priced. It is distinct from a forward-looking financial model review: financial due diligence establishes what actually happened historically and whether reported earnings are a reliable indicator of sustainable performance, while a model review tests whether the forecast built on top of that baseline is structurally sound. This guide covers financial due diligence's core areas and how its outputs — normalized EBITDA, the net working capital peg, net debt — flow directly into deal pricing.

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.

Acquisition Model Checklist

This checklist covers the structural checks specific to acquisition and M&A models, on top of the general financial model audit baseline. It focuses on the mechanics unique to deal models — synergy assumption traceability, purchase price allocation, debt and equity funding structures, and consistency between standalone and pro-forma combined entity figures. It is intended for buy-side and sell-side teams, and advisors, reviewing a model ahead of a transaction decision.

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.

Independent Model Review in Transactions

An independent model review, in a transaction context, is commissioned by the deal team itself for its own internal assurance ahead of investment committee approval — testing the transaction model's structural integrity separately from, and in addition to, the commercial and financial due diligence already underway. It shares its underlying methodology with the general independent model audit discipline, applied specifically to the transaction model and its combination mechanics.

Lender Model Review in Transactions

Lender model review in a transaction context tests the financing mechanics specific to an acquisition or transaction debt facility — new debt sizing against the target's pro-forma cash flow, covenant calculation integrity, and pro-forma leverage recalculated against the post-transaction capital structure. It shares its underlying covenant and debt-sculpting methodology with the existing lender model review discipline for ongoing project finance facilities, applied specifically to the acquisition-financing context, where pro-forma figures — not standalone historical ones — are what the lender is actually underwriting.

Investor Model Review

Investor model review, commissioned by an equity investor or limited partner ahead of a transaction, focuses on return calculation integrity — IRR and multiple-of-invested-capital mechanics, waterfall and carried interest calculation, and the completeness of sensitivity and scenario analysis around the base case return. It shares underlying structural audit methods with lender and independent model review, but its focus — the return the investor will actually realize, and how that return is allocated among co-investors — is distinct from a lender's focus on covenant compliance and debt service capacity.

Vendor Model Assurance

Vendor model assurance is the model-specific counterpart to vendor due diligence — an independent structural review of the seller's transaction model, commissioned by the seller and prepared by an independent advisor, for distribution to multiple prospective bidders alongside a vendor due diligence report. Its purpose is the same efficiency logic as vendor due diligence generally: substituting a single, independently verified model review for what would otherwise be duplicated structural review work by each bidder, provided the reviewing advisor's independence is genuine.

Model Governance During Transactions

Model governance during a live transaction faces a specific pressure the general discipline described on the existing Model Governance glossary page does not fully anticipate — a deal model typically changes rapidly, across multiple contributing parties (the deal team, advisors, sometimes the target's own team), against hard external deadlines, with version discipline the first casualty when time pressure is highest. This guide extends general model governance practice to that specific context: which version is authoritative at any given moment, who has sign-off authority to change a live deal model, and how documentation discipline should be maintained even as the model itself is under constant revision.

Quality of Earnings vs. Financial Model Review

Quality of earnings analysis and financial model review are frequently confused because both scrutinize a target company's numbers ahead of a transaction, but they test fundamentally different things and neither substitutes for the other. Quality of earnings establishes whether the target's historical earnings are a reliable, normalized baseline. Financial model review establishes whether the forward-looking model built on top of that baseline — often incorporating the quality of earnings findings directly as inputs — calculates correctly and is structurally sound. A transaction relying on only one of the two carries a specific, uncovered risk the other was never scoped to catch.

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.

Independent Model Audit

An independent model audit is a financial model audit performed by a party who is separate from both the model's author and the party relying on the model's output. Independence is one of the two features, alongside systematic coverage, that distinguish an audit from a lighter touch review. Independence can be provided by an internal team separate from the model's builder, a third-party advisory firm, or a deterministic audit engine run by a party other than the model's author — what matters is the structural separation between who built the model and who is checking it, not the specific form the checking party takes.

Deterministic Audit

A deterministic audit is a financial model audit performed by applying a fixed, disclosed rule set systematically to a model's formulas and structure, such that running the same audit against the same model produces the same findings every time. It is distinguished from both manual, judgement-based review and generative AI-based review, neither of which is guaranteed to be repeatable in this sense.

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.

Model Governance

Model governance is the organisational framework through which an institution defines, implements, and enforces policies and controls for the development, approval, use, validation, change, and retirement of financial models. It establishes accountability for model quality, a structured process for model oversight, and a documented record of model use and validation history. Effective model governance ensures that decisions made using financial models are based on outputs that have been developed to an appropriate standard, validated by a party independent of the developer, and used within the bounds for which they were designed.

Common Transaction Modelling Errors

This page synthesizes the specific errors that recur across every transaction type covered on this Knowledge Centre, cross-referenced back to the full guide covering each. It exists as a single, scannable reference for a deal team or reviewer who wants to know, at a glance, what tends to go wrong in a transaction model, without re-deriving each failure mode from first principles across a dozen separate guides.

Due Diligence Process

The due diligence process ties together every workstream and posture covered elsewhere on this Knowledge Centre into a single, phase-gated timeline — from a non-binding letter of intent through confirmatory diligence, transaction documentation, and the final approval gates a transaction must clear before closing. This guide sets out that end-to-end sequence explicitly, including where investment committee review, lender review, and independent assurance each sit within it, and how transaction documentation accumulates in parallel with the diligence findings that inform it.

Transaction Due Diligence Best Practices

This page synthesizes institutional best practice across the full M&A and Transaction Due Diligence domain into a single reference, drawing together the workstream coordination, model-risk, and process governance disciplines covered in depth elsewhere on this Knowledge Centre. It is the capstone page for this domain, intended as a starting orientation for a reader new to the domain and a quick reference for an experienced practitioner, in both cases pointing to the full dedicated guide for any practice that needs deeper treatment.

Financial Model Risk Register Template

Due diligence findings across a transaction's workstreams are frequently tracked in separate, siloed logs, one per workstream, with no single place showing whether each finding has actually reached a resolution. This template consolidates every finding — structural model risk and business/commercial risk alike — into a single register, tracking each through to one of three defined resolution outcomes, so nothing surfaced during diligence is silently lost between the workstream report and the final transaction terms.

Model Validation

Model validation is the structured, independent process of assessing whether a financial model is conceptually sound, mathematically correct, implemented as intended, and fit for its approved purpose. It is conducted by a reviewer who is independent of the model's developer and produces a documented assessment of the model's strengths, limitations, and any findings requiring remediation. Model validation is a component of model governance. The governance framework defines when validation is required, who conducts it, and what the validation must assess. The validation itself is the technical execution of that requirement.

Audit Trail

An audit trail is the documented chain of evidence connecting a financial model audit's findings and conclusions back to the specific cells, formulas, and inputs that support them, and connecting any change made to the model back to who made it, when, and why. It is what allows a third party, a lender, an investment committee, or a subsequent reviewer, to verify a review's conclusions without re-performing the entire exercise from scratch.