M&A Acquisition Analysis Model - Ready to use Excel Template with Dynamic Dashboard

M&A Acquisition Analysis Model - Ready to use Excel Template with Dynamic Dashboard

This workbook analyses the acquisition of one company by another. Enter the two forecasts, the financing, the fair values and the synergies, then type an offer premium and a mix of cash and shares beside the Dashboard. The model prices the offer, funds it, allocates the purchase price, combines the two businesses for five years and shows whether the deal adds to or dilutes the acquirer's earnings per share, what synergies are needed to break even, how much debt the group carries and the return on the investment.

Instructions and guidance for using the template are included within the workbook.

This is a generic, standard template designed for use across most industries. You may need to add, remove or change items to match your own reporting systems and policies.

© Thefinanceintellect.com. Licensed for use within your own organization; not for resale or redistribution. This workbook is a general-purpose tool and is not financial, tax or legal advice. Results depend entirely on the data you enter: review them before relying on them for any decision.