Analysis of M&A Transactions (Precedent Transactions)

You are working as a Financial Analyst and have been asked to value a mid-sized Indian retail company that may be acquired by another company.

In the previous lab, you used Comparable Company Valuation (Comps) to understand how publicly traded companies are valued.

However, when a company is acquired, the buyer usually pays for control of the entire business. Therefore, the acquisition price can be higher than the value suggested by publicly traded companies.

In this lab, you will use Precedent Transactions to analyze past M&A deals, calculate EV/EBITDA multiples, compare them with the Trading Comps multiple, and estimate the Control Premium.

Topic : Valuation Techniques

1) Comparable company analysis

2) Precedent transaction analysis

3) Discounted cash flow (DCF)

4) Interpretation of valuation outputs

Analysis of M&A Transactions (Precedents) 

Understand the Transactions

In this activity, you will analyze three major real-world acquisitions involving Indian consumer, FMCG and beverage businesses.

The transactions are:

1. Hindustan Unilever acquires GSK Consumer India

2. Zydus Wellness acquires Heinz India

3. Diageo acquires a controlling stake in United Spirits

The transaction values and EBITDA figures provided for this exercise are based on publicly documented corporate or financial disclosures.

Open your Excel workbook and create a new section called:

Precedent Transactions

Create the following table:

1

Create the M&A Data Table

2

Enter the Data

3

Enter each M&A transaction in a separate row.

Make sure:

• Enterprise Value is entered in ₹ Crores.

• Target EBITDA is entered in ₹ Crores.

• Each transaction is entered correctly.

• Do not enter the x symbol in the raw data.

Excel Check

Your table should contain:

3 transactions + Enterprise Value + Target EBITDA

Once the data is entered correctly, move to Task 2

Task 2: Calculate Transaction Multiples

Now calculate the EV/EBITDA multiple for each acquisition.

Add a New Column

1

Add a column called:

Calculated EV/EBITDA

Your table should now look like:

Calculate EV/EBITDA

2

Use the formula:

EV/EBITDA = Enterprise Value ÷ Target EBITDA

If Enterprise Value is in B2 and EBITDA is in C2, enter:

=B2/C2

Press Enter.

Example:

For HUL / GSK Consumer:

=31700/1150

Result:

27.6x

Copy the Formula

3

Use the fill handle to copy the formula from D2 to D4.

Your results should be:

Calculate the Precedent Deal Average

4

Below the three transactions, create a row called:

Precedent Deal Average

Use the Excel formula:

=AVERAGE(D2:D4)

Your result should be:

Precedent Deal Average = 23.4x

Excel Checkpoint

Your final transaction table should show:

27.6x → 20.4x → 22.3x → Average = 23.4x

Task 3: Compare with Comparable Company Valuation

Now compare the Precedent Transaction multiples calculated in Task 2 with the Trading Comps multiple calculated in the previous lab.

For this activity, use:

• Trading Comps Average = 29.9x EV/EBITDA

• Precedent Transactions Average = 23.4x EV/EBITDA

Create the Comparison Table

1

In Excel, create a small table like this:

Calculate the Multiple Difference

2

We want to find out how much higher or lower the Precedent Transactions multiple is compared with Trading Comps.

Use the formula:

Multiple Difference = Precedent Transactions Average − Trading Comps Average

In Excel, enter:

=23.4-29.9

Your result should be:

−6.5x

Interpretation

The Precedent Transactions multiple is 6.5x lower than the Trading Comps average.

In simple words:

The companies in the selected M&A transactions were acquired at a lower EV/EBITDA multiple than the average multiple of the comparable publicly traded companies.

Calculate the Premium or Discount

3

Now calculate whether the Precedent Transactions multiple represents a premium or discount compared with Trading Comps.

Use the formula:

Premium / Discount = (Precedent Transactions Average ÷ Trading Comps Average) − 1

In Excel, enter:

=(23.4/29.9)-1

Format the cell as a percentage.

Your result should be approximately:

−21.7%

Because the result is negative, this represents a:

21.7% Discount

Interpret the Result

4

Answer the following questions:

1. Which multiple is higher?

Trading Comps = 29.9x

Precedent Transactions = 23.4x

Therefore, the Trading Comps multiple is higher.

2. Is there a premium or discount?

The Precedent Transactions multiple is approximately 21.7% lower than the Trading Comps multiple.

Therefore, the result indicates a 21.7% discount, rather than a control premium.

3. What does this mean?

The selected precedent transactions were completed at lower valuation multiples than the comparable public companies. This may be due to differences in company size, growth expectations, market conditions, profitability, or the specific circumstances of each acquisition.

Apply the Multiples to a Target Company

5

Assume the company being valued generates:

EBITDA = ₹500 crore

You will now calculate its estimated value using both methods.

A. Value Using Trading Comps

Trading Comps Average = 29.9x

Formula:

Value = EBITDA × Trading Comps Multiple

In Excel, enter:

=500*29.9

Result:

₹14,950 crore

B. Value Using Precedent Transactions

Precedent Transactions Average = 23.4x

Formula:

Value = EBITDA × Precedent Transactions Multiple

In Excel, enter:

=500*23.4

Result:

₹11,700 crore

Calculate the Difference in Valuation

6

Now compare the two values.

Formula:

Difference = Trading Comps Value − Precedent Transaction Value

In Excel, enter:

=14950-11700

Result:

₹3,250 crore

Final Interpretation

7

"The Trading Comps multiple of 29.9x gives the target company an estimated value of ₹14,950 crore, while the Precedent Transactions multiple of 23.4x gives an estimated acquisition value of ₹11,700 crore. The Precedent Transactions value is ₹3,250 crore lower. This indicates that the selected historical transactions were completed at a lower valuation multiple than the current Trading Comps benchmark."

"The Trading Comps multiple of 29.9x gives the target company an estimated value of ₹14,950 crore, while the Precedent Transactions multiple of 23.4x gives an estimated acquisition value of ₹11,700 crore. The Precedent Transactions value is ₹3,250 crore lower. This indicates that the selected historical transactions were completed at a lower valuation multiple than the current Trading Comps benchmark."

What if the situation is reversed?

If the Precedent Transactions multiple is higher than the Trading Comps multiple, the interpretation would be different.

For example:

• Trading Comps = 21.5x

• Precedent Transactions = 23.4x

The Precedent Transactions multiple is higher by 1.9x.

The interpretation would be:

"The Precedent Transactions multiple is higher than the Trading Comps multiple. This suggests that buyers paid a premium to acquire the target companies. The higher multiple may reflect the value of obtaining control, expected synergies, access to new markets, strong brands, cost savings, or future growth opportunities."

multiple may reflect the value of obtaining control, expected synergies, access to new markets, strong brands, cost savings, or future growth opportunities."

Note: A higher precedent multiple does not automatically mean the buyer overpaid. A premium may be justified if the acquisition provides significant strategic benefits, synergies, control, or future growth opportunities.