Skip to content
Mike YeM&A · Corporate Development · Strategic Finance
M&A Library

Tool

Acquisition Target Pipeline & Deal Funnel

Manage acquisition targets from thesis through close with explicit next decisions, seller and control signals, evidence quality, private price discipline, and a durable pass-and-reopen record.

What this helps you decide

Where should the Corp Dev team spend its next increment of attention, and what must happen before each target advances?

The decision this tool answers

Where should the Corp Dev team spend its next increment of attention, and what must happen before each target advances?

A target pipeline should do more than show names and stages. It should preserve why the target belongs in the acquisition mandate, distinguish strategic fit from transactability, make the next decision explicit, and keep the institutional memory behind every pass.

Start with the working template

Download the Acquisition Target Pipeline & Deal Funnel Excel workbook · Version 1.0

The full Excel workbook uses the same structure with a Dashboard, Pipeline, Evidence Register, Pass Log, Decision Log, Stage Map, formulas, dropdowns, conditional formatting, and fictional examples. Replace the examples with transaction-specific facts before relying on the output.

Do not turn Corp Dev into a CRM

A contact date is useful, but it does not explain whether the asset serves the mandate, whether the owners can deliver control, what evidence supports the current view, or what would cause the buyer to stop. The pipeline should surface those questions before momentum becomes approval.

Each active target should have one accountable owner, one next decision, one concrete next action, and one material dependency or risk that could change the answer.

Separate strategic fit from transactability

A wonderful asset may still be a bad target today. Record strategic fit and scarcity separately from seller willingness and control clarity. A willing contact may not control the sale. A scarce capability may not transfer. A highly strategic target may still be unaffordable.

Do not let a high priority score override a failed required condition. The score orders work; it does not establish a probability of closing or an investment return.

Use evidence quality as a separate field

For each material claim, record whether the evidence is Unverified, Partial, or Verified. This describes the evidence—not whether the answer is favorable. A verified fact can weaken the thesis just as easily as it can support it.

Use the Evidence Register for the claims that matter: mandate fit, ownership, seller posture, customer concentration, earnings quality, transferability, valuation, financing, and integration dependencies.

Make the next decision visible

Use a simple stage path: Identified, Screened, Contacted, Conversation, NDA, Materials, First Look, LOI, Diligence, Signing, and Closed. Status is separate: Active, Hold, Passed, or Closed.

The stage tells the team where the process is. The next-decision field tells the team what must be decided. The next-action field names the work needed to reach that decision.

Keep the private price ceiling in the pipeline

Show the current estimated enterprise value and the buyer’s private hard price ceiling separately. Price headroom is useful only when both amounts are stated on the same basis.

A negative headroom should not be hidden by a higher strategic-fit score. Competitive tension, prior effort, or executive enthusiasm does not make the business more valuable or the downside more survivable.

Give every material issue a consequence

  • Investigate: name the missing evidence and who will obtain it.
  • Price: change value, required investment, financing, or the private ceiling when evidence supports it.
  • Protect: address a specific risk through structure, consent, retention, control, contract, or integration.
  • Walk: stop when a critical condition cannot be made acceptable.

The Pass Log is an asset

Do not delete passed targets. Record the stage at pass, date, reason category, detailed rationale, reopen trigger, signal worth monitoring, owner, and evidence source.

Six months later, the team should be able to answer three questions without restarting the work: Why did we pass? What would have to change? What signal would make us look again?

A recurring target that keeps reappearing without a changed fact should not consume the same analysis repeatedly.

Use the Decision Log to stop hindsight from rewriting the deal

For consequential commitments, preserve what the team believed at the time: the decision, rationale, evidence references, estimated value, private ceiling, conditions, and the facts that would reopen approval.

The purpose is not bureaucracy. It is to distinguish a bad outcome from a bad decision, and to make the next acquisition process smarter.

Connect the pipeline to the operating library

Use the Acquisition Mandate & Target Screen to establish why the target belongs. Use the Public Company Comps Workbench for market-reference evidence and Before You Buy: Follow the Work for deeper diligence and transferability testing.

When economics begin to take shape, use the LOI Economics & Risk Allocator, Synergy Underwriting & Value Bridge, and Capital Allocation & Deal Affordability Tool. Use the M&A Investment Committee Memo to record the approval decision and conditions.

The M&A Deal Workflow remains the process spine. After close, hand the operating commitments into After the Deal: Keep the Business Working.

Mike’s governing judgment

Frame before detail. Transactability is separate from strategic fit. Unknowns are findings. Pass without erasing the work.

The best acquisition pipeline is not the one with the most targets. It is the one that allocates attention well, preserves price discipline, and gets smarter every time the team advances or passes.

Version

Version 1.0. Published September 10, 2026. Practical Corp Dev target pipeline, evidence register, pass log, decision log, stage map, and executive dashboard framework.

Mike’s governing judgment: the target must serve the mandate; a high strategic-fit score does not cure poor transactability, weak evidence, or a breached price ceiling.

A passed target should remain useful. Record why the team said no, what would have to change, and what signal would justify reopening the work.

Mike Ye

Educational resources support analysis; they do not replace transaction-specific professional advice.