What You'll Learn Today
By the end of this session, you will be able to:
Precedent Transactions โ Overview
Understanding M&A-based valuation through historical deal data
Why might an acquirer pay significantly more for a company than what its shares currently trade at in the open market?
Take 30 seconds to think about the concept of "control" and "synergies" before we discuss as a class
๐ What Are Precedent Transactions?
Imagine you own a 3BHK apartment in a housing society. You want to know what it's worth. You could check what similar apartments are currently listed for (that's like trading comps from Session 12). But a smarter approach is to look at what similar apartments actually sold for in recent months โ because listed prices and sold prices can be very different. The actual transaction prices tell you what real buyers were willing to pay, not what sellers are hoping to get.
Precedent Transaction Analysis works the same way for companies. Instead of looking at today's stock price (which is just what a small slice of the company trades at), you look at the actual prices paid in recent M&A deals for entire companies in the same industry. These real deal prices tell you what acquirers โ after months of due diligence, negotiation, and strategic analysis โ were genuinely willing to pay to take over a business.
๐งฉ The Core Logic โ Three Simple Steps
- Find similar deals: Look at recent M&A transactions where companies in the same industry were acquired โ same sector, similar size, same country.
- Extract the "price tag" multiple: For each deal, calculate how much the acquirer paid relative to the target's earnings (e.g., "they paid 9ร the target's EBITDA"). This is the transaction multiple.
- Apply it to your company: Multiply your target company's earnings by the median multiple from those deals. The result is an estimate of what your company might be worth if acquired today.
๐ข A Quick Numerical Example
Suppose 5 Indian pharma companies were acquired in the last 3 years. In each deal, the acquirer paid roughly 9 times the target's EBITDA (the median was 9.0ร).
Now you're valuing MedCore Therapeutics, which has:
- LTM EBITDA = โน920 Cr
- Net Debt = โน650 Cr
- Shares Outstanding = 20.0 Cr
Step 2: Implied Equity Value = โน8,280 Cr โ โน650 Cr (net debt) = โน7,630 Cr
Step 3: Implied Share Price = โน7,630 Cr รท 20.0 Cr shares = โน381.50/share
That's it โ you've just valued a company using precedent transactions. Everything else in this session is about doing this more rigorously.
๐ The Formal Definition
Precedent Transaction Analysis (also called "M&A Comps" or "Transaction Comps") is a relative valuation methodology that estimates the value of a target company by examining the valuation multiples paid in comparable, completed M&A transactions. Unlike trading comparables (Session 12), which use current market prices reflecting minority (non-control) value, precedent transactions capture the prices actually paid by acquirers to gain control of entire businesses โ making them especially relevant for M&A, takeover, and LBO scenarios.
e.g., Implied EV = Target's EBITDA ร Median EV/EBITDA from precedent deals
When you buy one share on the stock exchange, you're a passive investor โ you have no say in how the company is run. But when an acquirer buys the entire company, they gain control: the power to change management, redirect strategy, merge operations, and extract synergies. That control is valuable โ so acquirers pay a control premium (typically 15โ35% in India) above the market price. This means precedent transaction multiples are almost always higher than trading multiples for the same peer group โ and that's exactly what makes them useful for valuing potential acquisition targets.
๐ฏ When Do Bankers Use This Method?
Investment bankers use multiple methods to estimate the value of a company being considered for an acquisition or takeover. Typically, they will run three different approaches in parallel: discounted cash flow (DCF), trading comparables (market value), and precedent transactions (deal value). These three methodologies are used to arrive at a more accurate valuation estimate than by relying on any single methodology.
The first two approaches, DCF and trading comparables, are commonly used in the business world. DCF estimates a company's intrinsic value based on its future cash flows, while trading comparables estimate its market value based on the prices of similar companies traded on public exchanges.
However, precedent transactions play a specific and important role in this process. Precedent transactions are those in which real acquirers have actually paid for companies that are similar to the target company being valued. This approach allows investment bankers to answer the question "What have real acquirers actually paid for companies like this?" โ a question that neither DCF nor trading comps can answer directly.
By presenting all three approaches side-by-side in a "football field" chart, investment bankers can provide a more comprehensive and accurate estimate of the target company's value, taking into account different scenarios and uncertainties.
| โ Best Used When... | โ ๏ธ Less Useful When... |
|---|---|
| Valuing a company for a potential acquisition or takeover | No comparable M&A transactions exist in the sector |
| Determining a fair offer price โ "What should we bid?" | All available deals are too old (>5 years) or in different geographies |
| Defending against a takeover โ "Is the offer fair to our shareholders?" | The target is in a unique niche with no real peers |
| Preparing a fairness opinion for the target's board of directors | You need a going-concern value (not a takeover value) |
| Pricing an LBO / take-private transaction for a PE firm | The sector is undergoing a major disruption (past deals may not reflect new reality) |
| Building a "football field" valuation range alongside DCF and trading comps | Deal multiples are heavily distorted by one or two outlier transactions |
When Sun Pharmaceutical acquired Alembic Pharma's API unit, the investment banker's fairness opinion needed to justify the 18.5% control premium to Alembic's board. The banker cited precedent transaction multiples ranging from 8.0x to 11.8x EV/EBITDA in the Indian pharma sector โ showing that the implied 9.0x multiple fell squarely within the observed range. This is how precedent transactions directly influence real deal pricing and board approval decisions.
โ๏ธ Trading Comps vs. Transaction Comps
๐ Trading Comps (Session 12)
- โ Based on current market prices
- โ Reflects minority (non-control) value
- โ Data is readily available and timely
- โ Easily updated in real-time
- โ ๏ธ May not reflect M&A premium
- โ ๏ธ Subject to market sentiment and volatility
๐ฆ Transaction Comps (This Session)
- โ Based on actual prices paid in M&A
- โ Includes control premium
- โ Captures synergy expectations
- โ Better for M&A / takeover valuations
- โ ๏ธ Historical data may be outdated
- โ ๏ธ Fewer comparable transactions available
๐ The 5-Step Process
Identify completed M&A transactions in the same sector as your target. Screening criteria include:
- Sector match: Same or adjacent industry (e.g., Indian Pharma)
- Size proximity: Deal value within a reasonable range (ยฑ50-70%)
- Geography: Same country/region for regulatory comparability
- Recency: Typically last 3-5 years; more recent = more relevant
- Deal type: Comparable transaction structures (100% acquisition, asset purchase, merger)
For our session, we analyze 10 completed M&A transactions in the Indian pharmaceutical sector (2022-2024), covering deal sizes from โน3,600 Cr to โน12,400 Cr.
For each precedent transaction, gather the following data points:
| Data Category | Specific Items | Source |
|---|---|---|
| Deal Data | Announcement date, closing date, deal type, consideration mix (cash/stock) | BSE/NSE filings, SEBI announcements |
| Transaction Value | Equity value (offer price ร shares), Implied Enterprise Value (EV) | Press releases, Tender offer documents |
| Target Financials | LTM revenue, EBITDA, net income at announcement | Annual reports, Capital IQ, BSE filings |
| Share Price | Unaffected share price (pre-deal), Offer price per share | NSE/BSE historical data |
Compute the same multiples used in trading comps, but using the deal-implied values:
EV / Revenue = Implied Enterprise Value รท Target LTM Revenue
P / E = Offer Price Per Share รท Target LTM EPS
Control Premium = (Offer Price โ Unaffected Price) รท Unaffected Price ร 100
Compute summary statistics for the transaction set:
- Mean โ Average of all multiples (sensitive to outliers)
- Median โ Middle value (preferred โ robust to outliers)
- Min / Max โ Range of observed multiples
- 25th / 75th Percentile โ For framing a valuation range
A single outlier deal can distort the mean. Always report the median alongside the mean. If one deal has an EV/EBITDA of 25x while others cluster around 9x, investigate whether it involves unique strategic rationale (e.g., patent portfolio, market entry).
Apply the median/mean transaction multiples to the target's financials:
Implied Equity Value = Implied EV โ Net Debt
Implied Share Price = Implied Equity Value รท Shares Outstanding
Compare this to the target's current market price to assess whether the company is fairly valued, undervalued, or overvalued relative to what acquirers have historically paid.
Indian Pharma M&A Transaction Data
10 recent deals forming our precedent transaction universe
๐ Complete Transaction Data Table
All values in โน Crores unless otherwise stated
๐ How to Read This Table โ Understanding Each Column
The table below has 11 columns. They are not random โ they follow a logical calculation flow. Think of them in three groups:
Group 1 Deal Identification โ Who, Whom, When, How
| Column | What It Means | Example (Row 1) |
|---|---|---|
| Target Company | The company (or division) that was acquired. This is the company whose valuation we study. | Cipla Health (Consumer) |
| Acquirer | The company (or PE firm) that bought the target. Note whether it's a strategic buyer (another pharma company) or a financial buyer (PE firm like KKR). | Dr. Reddy's Labs |
| Announced | When the deal was publicly announced. More recent deals are more relevant for valuation. | Jan 2024 |
| Deal Type | How the deal was structured โ 100% acquisition, asset purchase, merger, strategic stake, etc. This affects comparability. | 100% Acquisition |
Group 2 Deal Sizing โ The Raw Numbers (How Much Was Paid & What Was Earned)
| Column | What It Means | Example (Row 1) |
|---|---|---|
| Txn Value (โน Cr) | The Transaction Equity Value โ total amount paid for the target's shares. Calculated as: Offer Price per Share ร Total Shares Outstanding. This is what the acquirer paid the shareholders. | โน8,500 Cr |
| Implied EV (โน Cr) | The Implied Enterprise Value โ total value of the entire business, including debt. Calculated as: Txn Value + Net Debt. EV is always โฅ Txn Value because it adds the target's debt obligations. | โน9,200 Cr (โน8,500 + โน700 debt) |
| LTM EBITDA (โน Cr) | The target's Last Twelve Months EBITDA (Earnings Before Interest, Taxes, Depreciation & Amortization) at the time of the deal. This is the target's operating profit โ the "base" to which we apply multiples. | โน780 Cr |
Group 3 Valuation Multiples โ The Calculated Ratios (The "Price Tags")
| Column | What It Means | Example (Row 1) |
|---|---|---|
| EV/EBITDA | = Implied EV รท LTM EBITDA โ "The acquirer paid 11.8ร the target's EBITDA." This is the most important multiple โ it tells you how many years of EBITDA the acquirer paid for. Higher = more expensive. | 11.8x (โน9,200 รท โน780) |
| EV/Revenue | = Implied EV รท LTM Revenue โ "The acquirer paid 2.9ร the target's annual revenue." Useful when EBITDA is volatile or negative. | 2.9x |
| P/E | = Offer Price per Share รท EPS โ Price-to-Earnings ratio at the deal price. Popular in India but affected by debt structure and tax rates. | 20.2x |
| Premium | = (Offer Price โ Unaffected Price) รท Unaffected Price ร 100 โ How much extra the acquirer paid above the target's pre-deal market price. This is the control premium. A 30.8% premium means the acquirer paid ~31% more than what the market valued the company at before the deal news. | 30.8% (โน680 offer โ โน520 unaffected) รท โน520 |
The Calculation Flow โ How Columns Connect:
The same Implied EV is divided by Revenue to get EV/Revenue, and Offer Price is divided by EPS to get P/E. The Premium is calculated independently from share prices.
| Target Company | Acquirer | Announced | Deal Type | Txn Value (โน Cr) | Implied EV (โน Cr) | LTM EBITDA (โน Cr) | EV/EBITDA | EV/Revenue | P/E | Premium |
|---|---|---|---|---|---|---|---|---|---|---|
| Cipla Health (Consumer) | Dr. Reddy's Labs | Jan 2024 | 100% Acquisition | 8,500 | 9,200 | 780 | 11.8x | 2.9x | 20.2x | 30.8% |
| Mankind Pharma Block | Bharat Biotech | Aug 2023 | Strategic Stake | 12,400 | 13,500 | 1,680 | 8.0x | 2.4x | 13.5x | 17.0% |
| Alembic Pharma (API) | Sun Pharmaceutical | Jun 2023 | Asset Purchase | 4,800 | 5,200 | 580 | 9.0x | 2.5x | 15.5x | 18.5% |
| Lupin (Brazil Sub.) | Zydus Lifesciences | Nov 2023 | Cross-border | 6,200 | 7,100 | 750 | 9.5x | 2.4x | 19.9x | 17.1% |
| Gland Pharma | Fosun Pharma (China) | Oct 2022 | 100% Acquisition | 7,800 | 8,900 | 920 | 9.7x | 2.6x | 15.3x | 16.5% |
| Biological E. (Generics) | Serum Institute | Apr 2023 | Merger | 5,400 | 6,100 | 680 | 9.0x | 2.3x | 15.0x | 14.0% |
| J.B. Chemicals | KKR (PE) | Jul 2022 | Take-Private | 7,200 | 8,000 | 820 | 9.8x | 2.9x | 15.3x | 12.4% |
| Marksons Pharma | Torrent Pharma | Feb 2024 | 100% Acquisition | 3,600 | 4,100 | 490 | 8.4x | 2.3x | 12.9x | 16.1% |
| Strides Shasun (OSD) | Mankind Pharma | Dec 2023 | Divestiture | 4,100 | 4,600 | 560 | 8.2x | 2.1x | 13.2x | 14.0% |
| Intas Pharma (Sterile) | Alkem Labs | Sep 2023 | Asset Purchase | 5,500 | 6,300 | 720 | 8.8x | 2.4x | 13.9x | 17.0% |
| Summary โ Median | - | - | - | 5,950 | 6,700 | 735 | 9.0x | 2.4x | 15.1x | 16.3% |
Calculating Implied Enterprise Value & Transaction Multiples
Given Data:
โข Transaction Equity Value (Offer Price ร Shares) = โน8,500 Cr
โข Target Net Debt = โน700 Cr
โข Target LTM EBITDA = โน780 Cr
โข Target LTM Revenue = โน3,200 Cr
Questions: (a) What is the Implied Enterprise Value? (b) Calculate EV/EBITDA and EV/Revenue multiples.
Implied EV = โน8,500 Cr + โน700 Cr
Implied EV = โน9,200 Cr
EV/EBITDA = โน9,200 Cr รท โน780 Cr
EV/EBITDA = 11.79x โ 11.8x
EV/Revenue = โน9,200 Cr รท โน3,200 Cr
EV/Revenue = 2.875x โ 2.9x
Transaction Multiples โ Deep Dive
Understanding EV/EBITDA, EV/Revenue, and P/E in an M&A context
๐ Transaction Multiple Selection Guide
| Multiple | Formula | When to Use | Key Consideration |
|---|---|---|---|
| EV/EBITDA | Implied EV รท LTM EBITDA | Most widely used; capital-structure neutral | Ensure EBITDA is normalized (adjust for one-time items) |
| EV/Revenue | Implied EV รท LTM Revenue | When EBITDA is negative or highly variable | Ignores profitability โ useful only when margins are comparable |
| P/E | Offer Price รท LTM EPS | For equity-level valuation; popular in India | Distorted by capital structure, tax, and non-recurring items |
Valuing a Hypothetical Target Using Precedent Multiples
PharmaVista Financials:
โข LTM EBITDA = โน1,200 Cr
โข LTM Revenue = โน4,800 Cr
โข LTM Net Income = โน660 Cr
โข Net Debt = โน900 Cr
โข Shares Outstanding = 18.0 Cr
Precedent Transaction Medians (from our Pharma universe):
โข Median EV/EBITDA = 9.0x | Median EV/Revenue = 2.4x | Median P/E = 15.1x
Questions: (a) Calculate implied EV, equity value, and share price using each multiple. (b) Which multiple gives the most reliable result?
Implied Equity Value = โน10,800 Cr โ โน900 Cr = โน9,900 Cr
Implied Share Price = โน9,900 Cr รท 18.0 Cr shares = โน550/share
Implied Equity Value = โน11,520 Cr โ โน900 Cr = โน10,620 Cr
Implied Share Price = โน10,620 Cr รท 18.0 Cr shares = โน590/share
Implied Share Price = โน36.67 ร 15.1x = โน553.7/share
Implied Equity Value = โน553.7 ร 18.0 Cr = โน9,967 Cr
Implied EV = โน9,967 Cr + โน900 Cr = โน10,867 Cr
Method B (EV/Revenue): Implied Price = โน590/share
Method C (P/E): Implied Price = โน554/share
Transaction multiples embed the acquirer's expectation of synergies. If an acquirer pays a 30% premium, they likely expect cost savings (overlapping operations, procurement efficiencies) or revenue synergies (cross-selling, expanded geographic reach) exceeding that premium. When applying precedent multiples to a target, consider whether the same level of synergies would be available to a potential acquirer of YOUR target.
Hands-On Practice Exercises
Build your own Precedent Transaction Analysis in Excel
๐ฅ Download Practice Files
Download these CSV files and open them in Excel to complete the exercises below. The practice file has key fields left blank for you to calculate. The premium analysis file contains supplementary data.
๐๏ธ Exercise 1: Calculate Implied Enterprise Value & Transaction Multiples
Open the lecture-13-precedent-transactions-practice.csv file in Excel. The "Implied EV", "EV/Revenue", "EV/EBITDA", and "P/E" columns are left blank.
- Step A: In Column B (Implied EV), calculate:
= [Transaction Value] + [Target Net Debt] - Step B: In Column O (EV/Revenue), calculate:
= [Implied EV] / [Target LTM Revenue]and format as "0.0x" - Step C: In Column P (EV/EBITDA), calculate:
= [Implied EV] / [Target LTM EBITDA]and format as "0.0x" - Step D: In Column Q (P/E), calculate:
= [Offer Price Per Share] / ([Target LTM Net Income] / [Shares Outstanding])and format as "0.0x" - Step E: At the bottom of each multiple column, compute the MEDIAN using
=MEDIAN(range)
โ Completed Transaction Multiples
| Target | Txn Value (โน Cr) | + Net Debt | = Implied EV (โน Cr) | รท Revenue | EV/Revenue | รท EBITDA | EV/EBITDA | P/E |
|---|---|---|---|---|---|---|---|---|
| Cipla Health | 8,500 | + 700 | 9,200 | รท 3,200 | 2.9x | รท 780 | 11.8x | 20.2x |
| Mankind Block | 12,400 | + 1,100 | 13,500 | รท 5,600 | 2.4x | รท 1,680 | 8.0x | 13.5x |
| Alembic (API) | 4,800 | + 400 | 5,200 | รท 2,100 | 2.5x | รท 580 | 9.0x | 15.5x |
| Lupin (Brazil) | 6,200 | + 900 | 7,100 | รท 2,900 | 2.4x | รท 750 | 9.5x | 19.9x |
| Gland Pharma | 7,800 | + 1,100 | 8,900 | รท 3,400 | 2.6x | รท 920 | 9.7x | 15.3x |
| Biological E. | 5,400 | + 700 | 6,100 | รท 2,600 | 2.3x | รท 680 | 9.0x | 15.0x |
| J.B. Chemicals | 7,200 | + 800 | 8,000 | รท 2,800 | 2.9x | รท 820 | 9.8x | 15.3x |
| Marksons | 3,600 | + 500 | 4,100 | รท 1,800 | 2.3x | รท 490 | 8.4x | 12.9x |
| Strides (OSD) | 4,100 | + 500 | 4,600 | รท 2,200 | 2.1x | รท 560 | 8.2x | 13.2x |
| Intas (Sterile) | 5,500 | + 800 | 6,300 | รท 2,600 | 2.4x | รท 720 | 8.8x | 13.9x |
| MEDIAN | - | - | - | - | 2.4x | - | 9.0x | 15.1x |
Implied EV: =H2+L2 (Transaction Value + Net Debt)
EV/Revenue: =I2/D2 โ format as "0.0"x"
EV/EBITDA: =I2/E2 โ format as "0.0"x"
P/E: =N2/(F2/M2) โ Offer Price รท (Net Income รท Shares Outstanding)
MEDIAN: =MEDIAN(P2:P11)
๐๏ธ Exercise 2: Value a Target Company Using Precedent Multiples
A new Indian pharma company, "MedCore Therapeutics", is being considered for acquisition. Use the precedent transaction multiples you calculated in Exercise 1 to value MedCore.
MedCore Therapeutics โ Financial Data:
- LTM Revenue: โน3,800 Cr
- LTM EBITDA: โน920 Cr
- LTM Net Income: โน510 Cr
- Net Debt: โน650 Cr
- Shares Outstanding: 20.0 Cr
- Current Market Price: โน310/share
- Task A: Using the median EV/EBITDA (9.0x), calculate Implied EV, Equity Value, and Implied Share Price
- Task B: Using the median EV/Revenue (2.4x), calculate Implied EV, Equity Value, and Implied Share Price
- Task C: Using the median P/E (15.1x), calculate Implied Share Price, Equity Value, and Implied EV
- Task D: Compare the implied share prices to MedCore's current market price (โน310). Is MedCore undervalued or overvalued?
- Task E: If a potential acquirer expects synergies of โน400 Cr, what is the maximum EV/EBITDA multiple they could justify paying?
Implied Equity Value = โน8,280 Cr โ โน650 Cr = โน7,630 Cr
Implied Share Price = โน7,630 Cr รท 20.0 Cr = โน381.50/share
Implied Equity Value = โน9,120 Cr โ โน650 Cr = โน8,470 Cr
Implied Share Price = โน8,470 Cr รท 20.0 Cr = โน423.50/share
Implied Share Price = โน25.50 ร 15.1x = โน385.05/share
Implied Equity Value = โน385.05 ร 20.0 Cr = โน7,701 Cr
Implied EV = โน7,701 Cr + โน650 Cr = โน8,351 Cr
EV/Revenue Implied Price: โน423.50 (premium to market: 36.6%)
P/E Implied Price: โน385.05 (premium to market: 24.2%)
With โน400 Cr synergies, combined EBITDA = โน920 + โน400 = โน1,320 Cr
At same implied EV of โน8,280: Multiple = โน8,280 รท โน1,320 = 6.3x
Alternatively: Max EV an acquirer would pay = (โน920 + โน400) ร 9.0x = โน11,880 Cr
Max EV/EBITDA (on standalone EBITDA) = โน11,880 รท โน920 = 12.9x
๐๏ธ Exercise 3: Control Premium Analysis
Open the lecture-13-premium-analysis.csv file. Complete the following:
- Task A: Verify the Market Cap Pre-Deal column:
= [Unaffected Share Price] ร [Shares Outstanding] - Task B: Verify the Transaction Equity Value column:
= [Offer Price] ร [Shares Outstanding] - Task C: Recalculate the Control Premium %:
= ([Offer Price] โ [Unaffected Price]) / [Unaffected Price] - Task D: Calculate the Synergy-to-Premium Ratio:
= [Synergies Estimated] / ([Transaction Equity Value] โ [Market Cap Pre-Deal]) - Task E: What patterns do you notice? Are higher premiums associated with strategic or financial acquirers?
Cipla Health: Premium = โน8,500 โ โน6,500 = โน2,000 Cr โ Ratio = โน1,200/โน2,000 = 0.60x
Mankind Block: Premium = โน12,400 โ โน10,600 = โน1,800 Cr โ Ratio = โน1,800/โน1,800 = 1.00x
Alembic (API): Premium = โน4,800 โ โน4,050 = โน750 Cr โ Ratio = โน600/โน750 = 0.80x
Lupin (Brazil): Premium = โน6,200 โ โน5,296 = โน904 Cr โ Ratio = โน950/โน904 = 1.05x
Gland Pharma: Premium = โน7,792 โ โน6,688 = โน1,104 Cr โ Ratio = โน1,100/โน1,104 = 1.00x
Biological E.: Premium = โน5,390 โ โน4,730 = โน660 Cr โ Ratio = โน700/โน660 = 1.06x
J.B. Chemicals: Premium = โน7,192 โ โน6,402 = โน790 Cr โ Ratio = โน900/โน790 = 1.14x
Marksons: Premium = โน3,600 โ โน3,100 = โน500 Cr โ Ratio = โน500/โน500 = 1.00x
Strides (OSD): Premium = โน4,104 โ โน3,600 = โน504 Cr โ Ratio = โน650/โน504 = 1.29x
Intas (Sterile): Premium = โน5,502 โ โน4,704 = โน798 Cr โ Ratio = โน800/โน798 = 1.00x
because they expect operational synergies from integration.
2. Financial sponsors (KKR) pay lower premiums (12.4%) because they focus on
financial engineering and operational improvements rather than synergies.
3. Most deals have a synergy-to-premium ratio close to or above 1.0x, meaning
acquirers expect synergies to at least cover the premium paid.
4. The Cipla Health deal has the lowest ratio (0.60x) โ Dr. Reddy's paid a premium
that exceeds expected synergies, possibly due to competitive bidding.
๐๏ธ Exercise 4 (Advanced): Football Field Valuation Range
Create a "football field" chart in Excel showing MedCore's valuation from different methodologies:
- Using the 25th and 75th percentile EV/EBITDA multiples from the precedent data, calculate a low and high implied share price
- Add the DCF range (assume โน340 โ โน420 per share from a prior DCF analysis)
- Add the trading comps range (assume โน310 โ โน380 from Session 12 methodology)
- Create a horizontal bar chart in Excel showing all ranges side by side
Hint: Use =PERCENTILE(range, 0.25) and =PERCENTILE(range, 0.75) in Excel.
25th Percentile: =PERCENTILE(range, 0.25) = 8.55x
Median (50th): =PERCENTILE(range, 0.50) = 9.0x
75th Percentile: =PERCENTILE(range, 0.75) = 9.65x
High (75th %ile): EV = โน920 ร 9.65x = โน8,878 Cr โ Equity = โน8,228 Cr โ โน411.40/share
โ Methodology Low High Current โน310 โ
โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโค
โ DCF Valuation โน340 โน420 โ
โ Trading Comps โน310 โน380 โ
โ Precedent Transactions โน361 โน411 โ
โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโค
โ Overlap Zone โน361 โน380 โ CONSENSUS โ
โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ
To create the chart in Excel:
1. List each methodology in rows with Low/High columns
2. Insert โ Bar Chart โ Stacked Bar
3. First series = Low value (transparent/no fill)
4. Second series = High โ Low (colored bars)
5. Add a vertical line at MedCore's current price (โน310)
Key Terms โ Click to Flip
Master the vocabulary of Precedent Transaction Analysis
Test Your Understanding
10 objective questions on Precedent Transactions Analysis
Key Takeaways
๐ What We Covered Today
- Precedent Transactions use actual M&A deal prices (not market prices) to derive valuation multiples โ they inherently include a control premium.
- The 5-step process: Select universe โ Source data โ Calculate multiples โ Analyze premiums โ Apply to target.
- EV/EBITDA is the gold standard transaction multiple for capital-intensive industries like pharma; always report median alongside mean.
- Control premiums in India range 15-35%; strategic acquirers pay more than financial sponsors due to synergy expectations.
- Deal structure (cash vs. stock) affects the effective premium โ 100% cash offers tend to have lower premiums than stock-based deals.
- Synergy-to-premium ratios should ideally be โฅ 1.0x โ meaning expected synergies at least cover the premium paid.
- A football field chart combines DCF, trading comps, and precedent transactions to present a valuation range to stakeholders.
Session 14: M&A Modeling โ I
We move from valuing companies to modeling actual acquisitions. Topics include acquisition assumptions, purchase price allocation, goodwill calculation, and building combined (pro forma) financials. Read: Rosenbaum & Pearl, Ch. 6