Precedent Transaction Analysis: The Guide to Create an Excel Model

Published by:
Updated on:
March 11, 2021

Using comparable company analysis techniques is just one technique in valuing a company. Another method you can use is the Precedent Transaction Analysis.

Precedent transaction assumes that given the same circumstances, the value of the company you are analyzing is about the same as the acquisition value of a company that was recently acquired.

Instead of using market values, the analyst uses acquisition values.

Thus, the multiples of Precedent Transactions are typically higher than those of Comparable transactions because of Control Premiums.

This guide will help you create an Excel Model for Precedent Transaction Analysis.

Well, you can download the Excel counterpart and use it as a template, but, upon finishing this guide, you will be able to create a model of your own.

Download the Excel counterpart of this guide because we will be using that to explain how to create your own Excel Model.

Let’s start with this question:

When should we use Precedent Transaction Analysis?

Uses of Precedent Transaction Analysis

Precedent Transaction Analysis Excel

There are different ways you can use Precedent Transaction such as:

  1. To provide an informed opinion as to the value of a certain company that is a target of an M&A or consolidation. This is true whether you are the advisor of the target company or the acquiring company.
  2. To value a company based on the market demand for acquiring a company rather than basing on an Exchange.
  3. To estimate the value of a company that does not have public trading comparables.
  4. For use in identifying possible buyers or potential sellers in a certain business sector.

As you gain more knowledge and experience, you might find other uses for the Precedent transaction.

But, you should be aware that using this method presents its advantages and shortcomings.

Advantages and Disadvantages of Precedent Transaction Analysis

Precedent transaction Analysis provides realistic valuations of companies.

For example, if Company A and Company B are similar, and Company C bought Company A at $50 Million, then it’s reasonable to value Company B at $50 Million also. We can, therefore, use multiples of Company A to estimate the value of Company B.

This model can also help analysts determine possible future acquisitions. For example, if the model revealed that Company A is a good buy and that Company B is in a position to buy A, we can expect a possible business acquisition.

This information could help us get a better view of the values of both Company A and B.

Furthermore, the data we gathered can help us in actual M&A negotiations and discussions.

The multiples we can produce does not simply reflect supply and demand pressure but rather, real-life deals. In a sense, we are getting more realistic valuations of companies.

Another advantage of using Precedent Transaction is that it is based on the publicly available public information.

This information is usually subjected to high levels of standards before getting to the public. Therefore we can guarantee the accuracy of these data.

On the other hand, the Precedent Transaction present some disadvantages.

One of which is that publicly available information is usually based on a past transaction that is not reflective of current market conditions.

To mitigate this risk, we need to aid our interpretations with knowledge of present-day circumstances.

Another thing to look out for is the difference between the market climate at the time of the deal, and at the time the model is being made.

Those differences could be significant and can make our conclusions misleading.

It is hard to find comparable Precedent transaction analysis; that is, all companies are unique on their own.

There will always be the risk that the valuations we gathered from Precedent transaction analysis don’t match the conditions of the company we are evaluating.

Suggested: Read more about Financial Modeling Careers

Difference between Precedent Transaction and Trading Comparables

The basic difference between the two is that instead of using market-driven values, the Precedent transaction uses the acquisition prices of comparable real-life acquisitions and divestitures.

The comparable company analysis, on the other hand, base the valuations on how comparable companies are being valued in the market.

Control Premiums

This is the premium paid to gain control of the target company and not just merely be part of the equity.

Premiums also represent the unrecorded values of a company such as brand recognition, technical expertise or potential continuous increase in earnings.

You can compute Premium Paid by percentage using the following formula:

Premium (%) = [(Acquisition Price - Last Trading Price) / Acquisition Price] x 100.

For example, if a company is trading $50 per share before the acquisition announcement, and the price paid was $60 per share, then the premium paid was 20%.

Now that you know the basic stuff about Precedent transaction Analysis, we will now move on to the practical part.

In the next post, we will soon be starting to create an Excel model for Precedent Transaction Analysis.

Learn the Same Secrets My Clients Used for a Career Boost

Career Coaching

Career Coaching

BIWS Discount + $397 Bonus + Money-Back Guarantee

Notify of
Inline Feedbacks
View all comments
Would love your thoughts, please comment.x