Click main image to view in full screen. Unlock all 11 preview images:
Mergers & Acquisitions (M&A) Model – Excel XLSX
Excel (XLSX) + supplemental PDF
M&A (MERGERS & ACQUISITIONS) EXCEL DESCRIPTION
A financial model for mergers and acquisitions (M&A) is a quantitative representation of the anticipated financial performance and outcomes resulting from the merger or acquisition of companies. It serves as a tool for analyzing the financial feasibility, valuation, and potential synergies of the transaction. In summary, a financial model for M&A provides a comprehensive analysis of the financial implications of combining two companies. It assists decision-makers in evaluating the strategic fit, financial impact, and potential risks associated with the transaction, ultimately supporting informed decision-making and successful integration post-merger
Setup Inputs:
• Name of Acquirer business
• Name of Target business
• Acquirer Share Price
• Target Share Price
• Acquirer Shares Outstanding
• Target Share Outstanding
• Currency
Scenario Inputs
Synergies
• Revenue enhancement
• COGS savings
• Marketing savings
• General & Admin savings
• Synergies in Year 1 (full yr.)
• Synergies in Year 2
• Synergies in Years 3+
Financing
• Debt Tranche
• Senior Debt A
• Senior Debt B
• Subordinated Debt
• Interest Rate
• Senior Debt A
• Senior Debt B
• Subordinated Debt
Transaction
• Takeover Premium
• Cash Consideration
Financial Statements
• Closing Balance Sheet
• Pro Forma Model (3-statements)
• Acquirer Model (3-statements)
Outputs:
• Discounted Cash flow (DCF) – Proforma model
• Discounted Cash flow (DCF) – Acquirer Model
• Discounted Cash flow (DCF) – Target Model
• Accretion/Dilution Analysis for Earnings per Share
• Accretion/Dilution Analysis for Cashflow per Share
• Share price impact
• Capital Structure
• Graphs
Please do not hesitate to contact us if you need any modifications to this model. We offer free assistance for any questions regarding your needs.
About us
At N Consulting, we specialize in delivering top-tier financial modeling services tailored to meet the unique needs of businesses across various industries.
Our expert team creates detailed financial models that support strategic decision-making, optimize financial performance, and drive business growth.
We navigate our customers in deep water of entrepreneurship by providing forecasting, budgeting, valuation, to empower your financial planning and ensure your company's success.
Help & Support
If you encounter any issues with this model, please do not hesitate to reach out to our support team for prompt and comprehensive assistance.
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in M&A (Mergers & Acquisitions), Integrated Financial Model Excel: Mergers & Acquisitions (M&A) Model Excel (XLSX) Spreadsheet, N Consulting
