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.