PPR – Enterprise Value

Our next step is to begin the purchase price ratio analysis (“PPR”). This analysis will show us what premiums and multiples the acquirer would be paying for the target at various transaction prices per share (i.e. the amount offered by the acquirer for each target share).

 

Build Models & Decks 10x Faster with Macabacus

Gain access to 100+ shortcuts, formula auditing visualizations, easy Excel-to-PowerPoint linking, and productivity tools to build models and presentations faster than ever.

By evaluating the premiums and multiples at various transaction prices, we can determine what is an appropriate price to pay for the target. You might use transaction comparables analysis to see at what multiples the target’s peers were acquired, and select an offer price that is inline with precedent transactions, but adjusted for the specific circumstances surrounding the contemplated transaction. For example, if TargetCo has no other viable options than to be acquired by BuyerCo, BuyerCo might seek to pay a multiple of EBITDA representing a discount to EBITDA multiples paid in precedent transactions.

The calculation of premiums and multiples is straightforward. The tricky part here is making sure you properly calculate fully diluted equity value and net debt, since whether options and convertible securities are in-the-money (“ITM”) depends on the transaction price. ITM convertibles are treated as equity and out-of-the-money (“OTM”) convertibles are treated as debt.

Note how we determined the range of transaction prices we wish to consider. First, we rounded the current share price up to the nearest dollar. We then added or subtracted one or more dollars from this value. Since most acquisitions of public companies offer the target’s shareholders a premium to the current share price, most of the transaction prices we consider should reflect this premium (note that we only considered one transaction price that is lower than the current share price).

For a given transaction price, you should generally observe that like multiples decrease from one year to the next as the denominator (e.g. revenue, EBITDA, etc.) increases year-over-year in healthy companies. For TargetCo, we see that this is not the case. Also, check that the total enterprise and diluted equity values calculated for the target and acquirer at their respective current share prices match the values calculated on the Assumptions tab.

Download Template

Download Template

PPR – Enterprise Value

Try Macabacus for free to accelerate financial modeling in Excel.

Discover more topics

Download The State of M&A Transactions
Download this report for expert guidance on innovative structures, cost-effective financing, and antitrust strategies to accelerate deals.
Read more
DCF Excel Template
Elevate your investment analysis with our free DCF model template. Understand discounted cash flow principles and perform accurate valuations in Excel.
Read more
Operating Model Excel Template
Download our free operating model Excel template. Forecast revenue, expenses, and key financial metrics for better decision-making.
Read more
LBO Excel Model
Try LBO modeling with our comprehensive Excel template. Understand key concepts, calculate returns, and gain actionable insights.
Read more