This exchange ratio template shows you how to calculate an exchange ratio using the offer price for the target’s shares and the acquirer’s share price.
Here is a screenshot of the exchange ratio template:
Download the Free Template
Enter your name and email in the form below and download the free template now!
In mergers and acquisitions (M&A), the share exchange ratio measures the number of shares the acquiring company has to issue for each individual share of the target firm. For M&A deals that include shares as part of the consideration (compensation) for the deal, the share exchange ratio is an important metric. Deals can be all cash, all shares, or a mix of the two.
The formula for calculating the exchange ratio is:
Exchange Ratio = Offer Price for Target’s Shares / Acquirer’s Share Price
Importance of the Exchange Ratio
In the event of an all-cash merger transaction, the exchange ratio is not a useful metric. In fact, in this situation, it would be fine to exclude the ratio from the analysis. Often times, M&A valuation models will note the ratio as “0.000” or blank, when it comes to an all-cash transaction. Alternatively, the model may display a theoretical exchange ratio if the same value of the cash transaction were, instead, to be carried out by a stock transaction.
More Free Templates
For more resources, check out our business templates library to download numerous free Excel modeling, PowerPoint presentation, and Word document templates.