merger-model

You can build an M&A accretion dilution Excel model by providing acquirer/target inputs, deal terms, synergy phase-in assumptions, and financing mix to generate pro forma EPS, sensitivity tables, and breakeven analysis in one workbook.

Accretion dilution analysis in M&A evaluates whether an acquisition increases or decreases the acquirer's pro forma EPS, computing net income, share count, and synergy phase-in impacts over Year 1-3 to quantify deal profitability.

Yes, you can model synergy sensitivity and cash/stock consideration mix in Excel by generating scenario grids that evaluate EPS impact across varying synergy levels, offer premiums, and cash/stock financing outcomes.

openpyxl supports generating merger consequences models with formulas and styling by following excel-author conventions for named ranges, producing headless spreadsheets that require recalculation via recalc.py before final delivery.

To calculate the breakeven synergy needed for EPS neutrality, structure the purchase price and sources & uses of funds to determine the minimum Year 1 synergies required for a zero percent accretion/dilution outcome.

A key limitation of generating Excel M&A models with openpyxl is that headless spreadsheets require running a recalculation script before delivery to ensure formula outputs compute correctly outside the native Excel application.