Skip to content
  • Merger and Acquisition Model Template Cover.
  • ma1_monthly_revenue_merger_acquisition_v02
  • 2. An example of forecasting revenue gains and synergies resulting from an acquisition or a merger of two companies.
  • ma3_merger_acquisition_opex_synergy
  • An example of calculating synergies after a company acquisition.
  • An example of operating cost and synergies resulting from a merger or acquisition.
  • ma6_merger_acquisition_financial_model_summary
  • An example of a Profit and Loss Statement resulting from a merger or acquisition.
  • An example of a graph showing the impact of company acquisition on consolidated revenues.
  • An example of estimating a fair value and the capital required to finance a merger or acquisition.
  • An example of a debt model calculation.
  • ma11_merger_acquisition_balance_sheet_forecast
  • ma12_acquisition_investment_return_calculation
  • ma13_scenario_analysis_excel_data_table

Merger and Acquisition Model Template

US$48.00

20% off with a purchase of two or more templates*

An Excel template with a Merger and Acquisition Model and calculations of Synergies, Levered and Unlevered Cash Flows, Headcount Projections, Balance Sheet, Return on Investment and Sensitivity Analysis.

The file is in Excel format, but you can convert it to Google Sheets using the instructionsย hereย [external link].

Learn More:ย How to Create a Merger and Acquisition Model

Order risk-free with a 30-day Money Back Guarantee

Category: Tag:

The Merger and Acquisition Model Template contains the following Excel sheets and sections:

  • Monthly Financial Model:ย The template shows the historical performance of the Target and the Acquiring Companies. It then shows how the revenues evolve after the consolidation, showing the resulting synergies.
  • Debt and Equity Financing: The model allows financing the Merger or Acquisition transaction through debt. It then shows the impact of the financing on equity requirement and the overall Return on Investment.
  • Profit and Loss and Balance Sheet:ย The template shows how the consolidation affects the Net Income of the Acquiring Company. It also includes an example of Fair Value and Goodwill calculations and their impact on the Balance Sheet.
  • Summary and Sensitivity Analysis:ย The model illustrates the consolidation’s synergies and impact on the Acquiring Company’s Cash Flow. It also uses Excel’s Data Tables to test the Return on Investment under different scenarios.

Click on product images for screenshots of the template.

Learn More:ย How to Create a Merger and Acquisition Model

*the 20% discount applies to the entire order with a purchase of two or more templates.