Financial Modeling in an M&A Context: What Your Model Absolutely Must Contain

Transform your planning process with Workday adaptive planning. Manage all users as well as every step of the budget process.

In Canada, 642 merger and acquisition transactions were completed in Q3 2025 alone, with an announced value of $138.8 billion. Behind each of these deals sits a financial model — sometimes solid, often incomplete. The quality of that model can mean the difference between a value-creating transaction and an acquisition whose synergies never materialize. Whether you are the acquirer, the target, a financial advisor, or an investor, the M&A financial model is the central tool around which negotiation, due diligence, and the final decision are structured. This article details the components that every serious M&A model must contain.

Why the M&A Model Differs From Other Financial Models

A standard financial model — whether budgetary, forecasting, or sector-specific — is designed to manage an existing organization. The M&A model is built to answer a fundamentally different question: does this transaction create value, at what price, under what conditions, and with what risks?

This difference in purpose implies a difference in structure. The M&A model must simultaneously:

  • Model the target entity on a standalone basis, often with incomplete data
  • Consolidate the acquirer's and target's financial statements to project the combined entity
  • Quantify synergies and their realization timeline
  • Model the financing structure and its impact on post-acquisition profitability
  • Value the transaction from multiple angles (DCF, comparables, LBO as applicable) to establish a credible valuation range

According to PwC Canada, after a slowdown in 2023–2024, the Canadian M&A market returned to steady, sustained activity in 2025, with volume growth expected in 2026, driven in part by private equity funds looking to deploy significant liquidity reserves.

The Target's Financial Statements: The Foundation of the Model

Before projecting anything, you need to understand the target's true historical performance — not the picture presented in its raw financial statements. Normalization involves adjusting the accounts to remove non-recurring, non-representative, or deliberately flattering items.

Items to normalize systematically:

  • Above-market compensation for owner-managers (common in family-owned SMEs)
  • Personal expenses recorded through the business
  • Intragroup rents at non-arm's length terms
  • Exceptional provisions or non-recurring charges
  • Contracts or revenues not transferable to the acquirer
  • Accounting effects from changes in methodology

The result of this exercise is the normalized EBITDA, which becomes the basis for multiple-based valuation and the starting point for projections.

Common mistake: Accepting the target's figures without adjustment. An SME can legitimately show an EBITDA 30–40% below its true performance after normalization — or the reverse. Financial due diligence is inseparable from the modeling process.

Revenue Quality Analysis (Quality of Earnings)

Revenue quality is one of the most critical and most overlooked dimensions in M&A models built by less experienced buyers. Knowing that the target generates $20M in revenue isn't enough — you need to understand its nature, recurrence, and transferability.

Key questions to build into the model:

  • What is the revenue concentration? (Dependence on one or a few major clients)
  • Are contracts multi-year and transferable?
  • Are there change-of-control clauses?
  • What proportion of revenues is recurring vs. one-time?
  • Are there backlogs, pending orders, or measurable order books?
  • Have margins been stable, or were they artificially supported ahead of the sale?

Valuation: Building a Defensible Price Range

The DCF model (Discounted cash flow) is the most rigorous valuation method — and the most sensitive to assumptions. It involves projecting the target's free cash flows over a 5 to 10-year horizon, calculating a terminal value, and discounting everything at the transaction risk-adjusted cost of capital.

Critical DCF assumptions in M&A:

  • Revenue growth rate over the projection period, differentiated by segment where possible
  • Margin trajectory — accounting for cost synergies but also integration costs
  • Maintenance capex vs. growth capex: don't confuse sustaining existing operations with development investments
  • Working capital requirements: often underestimated in growth transactions
  • Adjusted WACC: incorporating the target-specific risk premium (size, sector, concentration)
  • Long-term growth rate for the terminal value: the model's most sensitive parameter

Best practice: The DCF should never be presented in isolation. It must be accompanied by a two-variable sensitivity analysis (typically: growth rate and WACC, or margins and discount rate), presented as a matrix table. This allows the board and investors to understand the valuation range and underlying assumptions, rather than a single figure that creates a false sense of precision.

The Comparables Method

The comparables method (trading comps and transaction comps) anchors valuation in market reality. It involves identifying similar publicly traded companies (trading comps) and recent comparable transactions (transaction comps), then applying their valuation multiples to the target.

In the Canadian mid-market, EV/EBITDA multiples generally range from 4x to 10x depending on sector, revenue recurrence, and target size. Transactions above $1B command significant premiums relative to mid-market SMEs.

The LBO Model (Leveraged Buyout)

If the acquirer is a private equity fund, or if the transaction is significantly leverage-financed, the LBO model is essential. Its objective differs from the DCF: it aims to determine the maximum payable price to achieve a target IRR (typically 20–25% for a Canadian PE fund) at exit, under different leverage and exit multiple scenarios.

Essential LBO model components:

  • Financing assumptions: senior debt, mezzanine, equity — with rates, amortization, and covenants
  • Debt schedule and repayment waterfall over the investment horizon (typically 4–7 years)
  • Exit scenarios: exit multiple × exit EBITDA, with entry price / exit multiple / leverage sensitivity
  • IRR and money-on-money (MoM) analysis under each scenario

Synergies: The Model's Riskiest Element

Synergies are often the primary justification for an acquisition premium. They are also the leading source of post-transaction failure when overestimated, poorly planned, or never realized. A rigorous M&A model treats them with the same discipline as revenues or expenses — with documented assumptions, a realistic timeline, and sensitivity analysis.

Revenue Synergies

Revenue synergies are the most appealing and the least reliable. They rest on the assumption that the combined entity will generate more revenue than the two separate entities — through cross-selling, access to new markets, or consolidated sales force. Include in the base model only those revenue synergies for which you can identify specific customers, potential contracts, or precise markets. Undocumented "market synergies" should appear only in the optimistic scenario.

Cost Synergies

Cost synergies are more predictable and faster to realize — but they carry an implementation cost that must be built into the model. The main sources of cost synergies in Canadian transactions include:

  • Consolidation of support functions (Finance, HR, IT, Legal) — the fastest to realize
  • Purchasing optimization and supplier contract renegotiation
  • Infrastructure and technology systems rationalization
  • Elimination of duplication in sales or operational teams
  • Tax optimization and post-acquisition structuring

Integration Costs (One-Time Costs)

Too often omitted or minimized, integration costs can represent 15–30% of expected synergy value. In your model, they must appear explicitly in the first 12 to 36 months post-closing:

  • Restructuring costs and severance packages
  • Systems migration and IT integration costs
  • Legal, tax, and advisory fees post-transaction
  • Investments required to upgrade the target's production infrastructure

Studies show that integration costs frequently reach 25–30% of total transaction value. Never omit them from the base model. They should be presented separately from synergies so the board has a clear view of actual value creation.

Financing Structure and Combined Financial Statements

A transaction can be financed in multiple ways — cash, bank debt, bonds, equity, earnout, vendor take-back — and the chosen combination has a direct impact on post-acquisition profitability, future investment capacity, and leverage ratios.

The M&A model must explicitly present:

  • Sources and uses of funds — a summary table of available funds and their deployment
  • The pro forma debt schedule with amortization and financial covenants (leverage ratio, DSCR)
  • The financing impact on the acquirer's credit rating and existing covenants
  • Earnout terms if applicable: mechanism, thresholds, litigation risks

The Combined Pro Forma Financial Statements

The pro forma financial statement is the central deliverable of the M&A model for management and the board. It presents the income statement, balance sheet, and cash flow statement of the combined entity, after incorporating all transaction assumptions.

Essential pro forma adjustments:

  • Elimination of intercompany transactions where applicable
  • Accounting for acquisition adjustments (Purchase Price Allocation — PPA) under IFRS 3
  • Amortization of intangible assets identified in the PPA
  • Adjustment of interest charges related to the new financing
  • EPS impact disclosure if the acquirer is publicly listed — accretion/dilution analysis

Every M&A model must systematically include: normalized financial statements over 3 years, 5-year projections with 3 scenarios, DCF with sensitivity matrix, comparables analysis, documented synergy table, sources and uses of funds, pro forma financial statements, and post-acquisition leverage ratio analysis.

Risk Management and Sensitivity Analysis

An M&A model without robust sensitivity analysis is an incomplete model. In the current Canadian context — marked by U.S. tariff uncertainty, CAD/USD exchange rate volatility, and investor caution — the ability to quantify risks has become a determining criterion for obtaining board and lender approval.

Essential sensitivity analyses:

  • Acquisition price sensitivity to discount rate and long-term growth rate
  • Combined EBITDA sensitivity to synergy realization level (50%, 75%, 100%)
  • Leverage ratio sensitivity to a 10–20% revenue decline
  • Impact of synergy realization delays (6 months, 12 months, 18 months)
  • Break-even analysis: at what performance level does the transaction stop creating value?

These analyses don't exist to weaken the case — they demonstrate that the leadership team has genuinely stress-tested its investment thesis.

An M&A Model Is Also a Conviction Tool

In a merger and acquisition transaction, the financial model serves multiple roles simultaneously: internal analysis tool, negotiation support, due diligence document, and communication instrument with lenders, shareholders, and the board.

Its technical quality is a necessary condition — but not a sufficient one. A good M&A model must also be readable, auditable, and defensible by people who had no part in building it. This is why documenting assumptions, maintaining structural clarity, and ensuring consistency controls are not details — they are core components of the transaction's credibility.

In a market where Canadian transactions exceeding one billion dollars are multiplying and private equity funds are actively looking to deploy their liquidity in 2026, having a solid M&A model is not a competitive advantage — it is a prerequisite. Contact us for a confidential introductory conversation.