Merger Model Workflow Step 1: Gather Inputs Acquirer: - Company name, current share price, shares outstanding - LTM and NTM EPS (GAAP and adjusted) - P/E multiple - Pre-tax cost of debt, tax rate - Cash on balance sheet, existing debt Target: - Company name, current share price, shares outstanding (if public) - LTM and NTM EPS or net income - Enterprise value or equity value Deal Terms: - Offer price per share (or premium to current) - Consideration mix: % cash vs. % stock - New debt raised to fund cash portion - Expected synergies (revenue and cost) and phase-in timeline - Transaction fees a…