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
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.
