Every mid-market acquisition looks compelling on paper. The vendor’s narrative is polished, the growth story is attractive, and the headline EBITDA tells a clean story. But beneath that surface, the assumptions driving those numbers can make or break a deal.
Financial modelling due diligence is where we move beyond the narrative and into the mechanics. It’s the discipline of building a bespoke financial model that stress-tests every assumption, isolates risk, and gives buyers the commercial clarity they need before committing capital.
We’ve seen mid-market deals collapse over metrics that were buried two layers deep in a spreadsheet. The businesses that avoid those outcomes are the ones that model properly, early, and without optimism bias.
Standard Financials vs. Due Diligence-Grade Models
There’s a meaningful difference between reviewing a target’s historical financials and building a due diligence-grade model. Standard financials tell you what happened. A purpose-built model tells you what’s likely to happen under various conditions, and whether the deal still works when assumptions shift.
A strong financial modelling due diligence process will:
- Uncover assumptions hidden in the target’s growth narrative
- Distinguish between one-off performance and sustainable earnings
- Separate operational reality from accounting presentation
Stress-test modelling and scenario-based modelling play distinct roles here. Stress testing pushes individual variables to breaking point. Scenario modelling combines multiple variable shifts to simulate real-world conditions. Both are essential. Neither replaces the other.
The Most Important Metrics to Track in Mid-Market Acquisitions
Normalised EBITDA
This is where valuation credibility begins. Normalised EBITDA strips away one-off costs, owner salaries above market rate, private expenses run through the business, and any other adjustments that distort true operating performance.
Why it matters: banks, investors, and acquirers all price off this number. If your normalisation is flawed, your valuation is flawed, and your financing structure is built on sand.
Working Capital Movements
Post-deal liquidity is one of the most frequently underestimated risks in mid-market transactions. Changes in receivables, payables, and inventory directly impact how much cash the business actually generates after settlement.
A two-week deterioration in receivables collection post-close can create a cash burn problem that the buyer didn’t price into the deal. The model needs to capture these dynamics clearly.
Revenue Quality
Not all revenue is created equal. We look at:
- Concentration risk — how dependent is the business on a small number of customers?
- Customer churn — what’s the retention profile, and is it deteriorating?
- Deferred income and contract terms — how much forward revenue visibility actually exists?
Revenue quality determines whether the earnings you’re acquiring are repeatable or fragile. This metric is often missed, but it’s where hidden value and hidden risk both live.
CAPEX and Maintenance Costs
Underreported maintenance CapEx is a classic mid-market issue. Sellers may defer maintenance to inflate short-term profitability, or capitalise costs aggressively to keep them off the P&L.
A due diligence model needs to identify what the business actually requires in ongoing capital expenditure to maintain current performance, not just what the vendor chose to spend.
Debt and Contingent Liabilities
Off-balance sheet obligations are where surprises hide. Staff entitlements, warranty provisions, unresolved disputes, and earn-out structures all represent contingent liabilities that can reshape the economics of a deal.
This is where the legal-financial interplay in modelling becomes critical. The model must account for what the balance sheet doesn’t show.
Synergy Mapping and Integration Forecasts
Synergy assumptions are where optimism most often overrides reality. We’ve seen acquirers model aggressive cost savings and revenue uplift without any operational plan to deliver them.
Caution: spreadsheet integration is not operational integration. If synergies aren’t backed by a credible execution plan, they shouldn’t be modelled as certain.
What Does a High-Quality Due Diligence Model Look Like?
The models that actually support sound decision-making share common features:
- Granular and modular structure — scenario toggles that allow real-time sensitivity analysis
- Integration with operational KPIs — sales volumes, retention rates, churn, pipeline conversion
- Full audit trail — every assumption linked to source data, clearly documented
- Real-time update capability — the model evolves as new information emerges during the process
A model without these features is a reporting tool. A model with them is a decision-making instrument.
Stress Testing: A Strategic Planning Tool, Not Just a Sensitivity Table
Stress testing isn’t about running a pessimistic scenario for the sake of it. It’s about understanding where the deal breaks, and whether that breaking point is plausible.
Practical examples we build into mid-market models:
- A 10% drop in gross margin due to supplier renegotiation or input cost escalation
- A three-month delay in key client contract renewals
- A 15% increase in staff costs driven by retention challenges post-acquisition
This is where real-time strategic thinking supports decision-making under uncertainty. The acquirer who understands their downside scenario is the acquirer who negotiates from strength.
Red Flags That Modelling Uncovers
Financial modelling due diligence consistently reveals patterns that standard reviews miss:
- Revenue smoothing or sandbagging — manipulating recognition timing to present consistent growth
- Overly optimistic growth forecasts unbacked by marketing spend, pipeline data, or market conditions
- Tax implications ignored in financing assumptions — particularly around structure, deductibility, and cross-border considerations
These aren’t theoretical risks. They’re the patterns we see repeatedly in mid-market transactions where the vendor’s story doesn’t survive forensic scrutiny.
How We Support This Process
We approach financial modelling due diligence as a strategic exercise, not a compliance one. Our role extends beyond building the model. We interpret it, challenge it, and use it to reshape negotiation strategy where the numbers warrant it.
In a recent mid-market engagement, our modelling identified a material working capital deterioration that the vendor’s presented financials obscured. That single insight reduced the acquisition price by over 12% and restructured the payment terms to protect post-deal liquidity.
Our approach integrates:
- Forensic financial analysis
- Board-level advisory input
- Real-time scenario modelling as new data surfaces
- Direct support through negotiation and deal structuring
We’re not just modellers. We’re strategic advisers who use financial models as the foundation for commercial decisions.
For those looking to explore extended modelling strategies in more technical depth, this resource on applying financial modelling to due diligence provides a useful complement to the advisory process.
Frequently Asked Questions
What is financial modelling due diligence?
Financial modelling due diligence is the process of building a bespoke financial model to test the assumptions, risks, and commercial viability of a target business during an acquisition. It goes beyond reviewing historical accounts to simulate future performance under various scenarios.
Why is normalised EBITDA important in acquisitions?
Normalised EBITDA provides a credible view of a business’s true operating earnings by removing one-off items, personal expenses, and above-market owner remuneration. It forms the basis of most mid-market valuations and financing structures.
What red flags can financial modelling uncover?
Common red flags include revenue smoothing, underreported maintenance CapEx, off-balance sheet liabilities, overly optimistic growth assumptions, and working capital deterioration that impacts post-deal cash flow.
How does stress testing differ from scenario modelling?
Stress testing pushes individual variables to extreme levels to identify breaking points. Scenario modelling combines multiple variable changes to simulate plausible real-world conditions. Both are essential components of a robust due diligence model.
When should financial modelling due diligence begin in an acquisition?
It should begin as early as possible in the process, ideally during the initial evaluation phase. Early modelling identifies deal-breaking risks before significant time and capital are committed to the transaction.
Considering an acquisition? Let’s pressure-test your assumptions before the deal goes live. Contact us to speak with our M&A advisory team.