Precedent Transaction Analysis in Excel

Precedent transaction analysis values a company using the prices paid in past acquisitions of similar businesses. Because acquirers pay a premium to gain control, transaction multiples usually sit above trading multiples. You screen for relevant deals, compute the multiple paid in each, and apply the median to your target to imply an acquisition value.

How precedent transactions differ from trading comps

Trading comps reflect minority stake prices on the open market. Precedent transactions reflect what a buyer paid to acquire an entire company, which includes a control premium and any expected synergies.

The core multiple is the same shape, typically EV/EBITDA = transaction enterprise value / target EBITDA, but the enterprise value is the deal value the acquirer paid. The result tells you what acquirers have been willing to pay for comparable assets.

Worked example

Assume three deals with transaction EV/EBITDA multiples of 10.0, 11.0, and 12.0 times, a median of 11.0. Your target has EBITDA of 300 and net debt of 200.

1. List deal multiples in C2:C4 and compute =MEDIAN(C2:C4), which returns 11.0.
2. Apply to the target: implied transaction enterprise value =300*11.0 returns 3300.
3. Bridge to equity value: =3300-200 returns 3100.
4. Compare with a trading comps median of 9.25 times, which implied 2775; the gap of about 525 is the control premium.
5. Express the premium as a percentage: =(11.0-9.25)/9.25 returns about 19 percent.

Transaction multiples sit above trading multiples because acquirers pay for control and synergies.

Building the deal screen

A precedent transaction analysis is only as good as its deal screen. Document why each transaction belongs in the set.

• Screen for deals in the same industry, ideally within the last three to five years so pricing is relevant.
• Record the announcement date, acquirer, target, deal value, and the metric used for the multiple.
• Prefer deals where the target was a similar size, since small and large deals price differently.
• Note whether the multiple is based on trailing or forward EBITDA and keep it consistent.
• Watch for a control premium or synergy figure typed straight into a cell instead of derived from the deal data.

Pitfalls

Old deals struck in a different market environment distort the median. A transaction from a frothy cycle carries a multiple that no longer applies, so weight recent, comparable deals more heavily.

Hardcoded inputs are a quiet risk. Analysts often paste a deal value or premium as a literal number inside a formula. When the deal terms are revised, the constant is forgotten. Keep deal values and premiums as labeled inputs so they trace back to the source.