This tool allows you to model the financial mechanics for Mergers and Acquisitions (M&A). With a few intuitive steps, you will get from the pre-merger valuation of the companies to the expected post-merger stock price of the acquiring firm. In the process, you will get valuable insights such as how the proposed deal structure allocates the deal value to the shareholders of the acquiring and the target firm and how the ultimate ownership structure is affected by the deal.
To use the tool, simply enter the characteristics of the planned transaction on the tab "Deal Structure." There, you will find a step-by-step guide through the most important elements of the analysis as well as a summary of the financial implications. The tab "Summary Deal Outcome" provides an abbreviated summary of the most important elements of the proposed deal. Finally, the tab "Different Actual Synergies" allows you to model the outcome of the deal if the market expects different net synergies than the management team. The logic behind the tool is explained in great detail in the Module "Mergers and Acquisitions (M&A)."