Finance & Accounting5.0 · 0 ratings
M&A Accretion / Dilution Analyzer
Models a deal's EPS accretion/dilution with financing mix, synergies, and a sensitivity to the offer premium.
Role-Based
Prompt
ROLE: You are a corporate development analyst running accretion/dilution on a proposed acquisition. CONTEXT: Acquirer: [ACQUIRER] (EPS [ACQ_EPS], shares [ACQ_SHARES], P/E [ACQ_PE]). Target: [TARGET] (net income [TGT_NI], shares [TGT_SHARES]). Offer: [OFFER_PRICE], premium [PREMIUM]. Financing mix: [CASH_DEBT_STOCK_SPLIT], cost of debt [KD], tax [TAX]. Expected synergies: [SYNERGIES], integration costs: [INT_COSTS]. TASK: 1. Compute purchase consideration and the sources/uses of funds. 2. Build pro forma net income: combine earnings, add after-tax synergies, subtract after-tax incremental interest on new debt, adjust for foregone interest on cash used. 3. Compute pro forma shares (new shares issued for the stock portion). 4. Compute pro forma EPS and compare to standalone acquirer EPS—state accretion/dilution in dollars and percent. 5. Find the breakeven (synergies needed, or max premium) for a neutral deal, and sensitize EPS impact to the premium. OUTPUT FORMAT: (A) Sources & uses. (B) Pro forma income bridge. (C) EPS accretion/dilution conclusion. (D) Breakeven and premium sensitivity table. CONSTRAINTS: Tax-effect synergies and interest. State whether year-one or run-rate synergies are used. Show the share count math for the stock component. Do not call a deal accretive without showing the bridge.
Recommended models
claudegpt-4ogemini
More in Finance & Accounting
Three-Statement Model Architect
Builds a fully integrated three-statement financial model with linked schedules, drivers, and circularity controls.
Read prompt
DCF Valuation With Sensitivity Grid
Produces a defensible discounted cash flow valuation with WACC build, terminal value cross-check, and sensitivity tables.
Read prompt
Month-End Close Checklist Builder
Generates a sequenced, owner-assigned month-end close checklist with cutoffs, dependencies, and review gates.
Read prompt
Variance Analysis Narrative Writer
Turns budget-versus-actual numbers into a crisp executive variance narrative with drivers, materiality, and actions.
Read prompt