merger-model

To build a merger model in Excel for accretion dilution analysis, input acquirer and target financials, deal terms, and expected synergies to automate pro forma EPS calculations, sources and uses, and purchase price allocation across multiple deal structures.

Running sensitivity analysis on M&A deal terms in Excel requires adjusting variables like synergies, premiums, and financing mix to evaluate accretion and dilution across multiple scenarios, which this approach automates to inform negotiation strategy and board deck preparation.

Yes, Excel financial modelling can evaluate acquisition scenarios across a 3-year horizon by structuring inputs for the acquirer and target, calculating pro forma EPS, and generating sensitivity scenarios to assess long-term deal impact.

Preparing pro forma EPS and sources and uses for an M&A board deck involves gathering deal terms and financing mix data, then generating a structured Excel workbook that integrates purchase price allocation and sensitivity analyses for pitch materials.

Yes, this merger modelling approach supports analysis of different financing mixes and purchase prices by integrating sources and uses tables with sensitivity scenarios, allowing you to evaluate how premium adjustments and financing terms impact accretion and dilution.

To evaluate accretion dilution for an acquisition, you need acquirer and target financial data, deal terms including purchase price and financing mix, and expected synergies to generate a complete workbook with pro forma EPS and sensitivity analyses.