Financial Model Due Diligence Checklist
Executive Summary
Key Takeaways
- ✓ This checklist assumes the general Financial Model Audit Checklist and the Acquisition Model Checklist have already been applied, and focuses specifically on due diligence adjustment integration and audience-appropriate review scoping.
- ✓ Every workstream finding requiring a model adjustment should be traced individually against the model's actual formulas, not confirmed as complete based on the existence of a findings log alone.
- ✓ The review's scope should be explicitly matched to its intended audience — independent, lender, investor, or vendor — since each carries a different emphasis and an incorrectly scoped review can miss the checks most relevant to its actual users.
- ✓ Model risk and business risk findings should be reported separately to the investment committee, since conflating a structurally sound model with a validated business case, or vice versa, misrepresents what each review actually confirmed.
Objective¶
This checklist operationalizes the Financial Model Due Diligence pillar into a working review tool. It assumes the general Financial Model Audit Checklist and, for a combination model, the Acquisition Model Checklist have already been applied, and focuses on the checks specific to the due diligence process itself: whether findings actually reach the model, and whether the review is correctly scoped to its audience.
Applicability¶
Applicable to any transaction model review commissioned as part of a due diligence process, regardless of transaction type or the specific audience (independent, lender, investor, or vendor) commissioning it. The audience-specific checks below (items 7-10) should be applied selectively based on which audience the review actually serves.
Checklist¶
| # | Check Item | Why It Matters | Evidence to Collect |
|---|---|---|---|
| 1 | General Financial Model Audit Checklist has been applied to the underlying model structure | Combination and due diligence integration checks are meaningless if the base structure is already unsound | General audit checklist results |
| 2 | For a combination model, the Acquisition Model Checklist has been applied | Synergy traceability, purchase price allocation, and pro-forma reconciliation are prerequisites to this checklist's checks | Acquisition model checklist results |
| 3 | Every workstream's material findings log is individually traced against the model's actual formulas | A finding documented in a report but never reflected in the model's formulas | Findings-to-formula traceability matrix |
| 4 | Financial due diligence's normalized EBITDA and net working capital peg tie exactly to the model's corresponding inputs | A discrepancy between the due diligence conclusion and the figure actually used to price the deal | Reconciliation of QoE and NWC peg to model inputs |
| 5 | Commercial due diligence findings are reflected as specific, named revenue or growth driver adjustments, not a generic discount | An untraceable, unsupported growth or churn adjustment | Driver-level traceability to commercial due diligence findings |
| 6 | Legal and tax due diligence's quantifiable exposures are reflected as explicit model reserves | A known, estimable liability omitted from the transaction price | Liability reserve reconciliation to legal/tax findings |
| 7 | (Lender review) Pro-forma leverage and coverage ratios are independently recalculated against the new capital structure | A credit decision based on a stale, pre-transaction metric | Independent pro-forma ratio recalculation |
| 8 | (Investor review) IRR and waterfall calculations are independently recalculated from underlying cash flow timing | A manually entered or formula-broken return figure | Independent IRR/waterfall recalculation |
| 9 | (Vendor review) Reviewing advisor's independence from the seller is documented and free of contingent, deal-linked fees | Bidder reliance undermined by a perceived conflict of interest | Advisor independence declaration |
| 10 | (Independent review) Reviewer has no role in building the model or advising commercially on the transaction | A conflicted review presented as independent assurance | Reviewer engagement scope and independence confirmation |
| 11 | Model risk findings and business/commercial risk findings are reported to the investment committee as separate, distinct conclusions | A structurally sound model mistaken for validation of a weak business case, or vice versa | Separated findings sections in the final report |
| 12 | Model governance discipline (version control, sign-off, documentation) was maintained through the final pre-signing period | An unreviewed, undocumented change relied upon in final deal terms | Version history and change log for the final review period |
Common Failures¶
- A due diligence finding correctly identified and documented but never actually entered into the transaction model, discovered only when the model and the findings log are reconciled line by line.
- A lender or investor model review conducted using a generic checklist not scoped to the specific audience's priorities, missing covenant or waterfall-specific checks.
- Model risk and business risk findings blended into a single conclusion, obscuring which risk category any given finding actually belongs to.
- Version control discipline abandoned during the final, highest-pressure period before signing, precisely when an unreviewed change is most likely to be relied upon without scrutiny.
Recommended Evidence¶
A completed financial model due diligence review should be accompanied by a findings-to-formula traceability matrix, a reconciliation of the model's key inputs against every relevant workstream's conclusions, and a report structure that clearly separates model risk findings from business and commercial risk findings, suitable for direct inclusion in an investment committee memo.
How to Use This Checklist¶
Apply the general Financial Model Audit Checklist and, where applicable, the Acquisition Model Checklist first. Then work through items 3-6 for every transaction review regardless of audience, apply the relevant audience-specific item (7-10) based on who commissioned the review, and close with items 11-12 covering reporting and governance discipline.
Continue Reading¶
Related Pillars¶
Related Technical Guides¶
- Model Risk During Transactions
- Independent Model Review
- Lender Model Review
- Investor Model Review
- Vendor Model Assurance
Related Checklists¶
Related Products¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
What does a financial model due diligence checklist verify that a general model audit checklist does not?
Whether due diligence findings from every workstream — financial, commercial, operational, technical, legal, tax, ESG — are actually and correctly reflected in the transaction model's formulas, and whether the review has been scoped appropriately to its intended audience, neither of which a general-purpose model audit checklist addresses.
Why is due diligence adjustment integration tested as a distinct item?
Because a finding correctly identified and documented in a workstream report can still fail to be correctly, completely, or consistently reflected in the transaction model — testing the findings log alone does not confirm the model itself was actually updated.
Why does the checklist require matching review scope to audience?
Because independent, lender, investor, and vendor model reviews share underlying methods but differ in emphasis — a lender review scoped without covenant and debt-sculpting focus, or an investor review scoped without waterfall and return-calculation focus, misses the checks most relevant to its actual users.
How does this checklist relate to the Acquisition Model Checklist?
The Acquisition Model Checklist covers combination-specific mechanics — synergy traceability, purchase price allocation, standalone-to-pro-forma reconciliation. This checklist assumes that baseline is already applied and adds the due diligence integration and audience-scoping checks specific to the due diligence process itself.
Should model risk findings and business risk findings be reported together?
No — they should be reported separately to the investment committee, since a structurally sound model does not validate a commercially weak business case, and a commercially strong case does not excuse a structurally unsound model; conflating the two misrepresents what each review actually confirmed.
References
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.
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.
Financial Model Audit Checklist
This checklist sets out the core structural checks that apply to any financial model regardless of sector or transaction type — formula integrity, circularity, linking, formatting, and output consistency. It is the flagship, general-purpose reference for teams running an internal review before a model is submitted for external audit, financing, or committee approval. Sector-specific and audience-specific checklists elsewhere in this section build on it rather than repeating it.
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.