Merger (M&A) Financial Model

Merger (M&A) Financial Model

Step-by-step training model guiding you through on how to build a merger model from scratch.

All Industries, Financial Model, General Excel Financial Models

Cash Flow Projections, Consolidation, Debt Amortization, Debt Schedule, Excel, Financial Analysis, Financial Feasibility, Financial Model, Financial Modeling, Financial Planning, Financial Projections, Financial Statements, Financing, Forecast, Forecasting, Income Statement, Investor Cash Flows, Mergers and Acquisitions Model, Pro-Forma, Profitability Analysis, Three Statement Model | Three Financial Statements

Key sections:

Inputs & Assumptions
- Transaction assumptions
- Sources & Uses
- Goodwill
Consolidated Financial Statements
- Consolidated Income Statement
- Consolidated Balance Sheet
- Consolidated Cashflow Statement
Supporting Schedules
- Depreciation
- Working capital
- Debt

Model tabs:

Summary tab – containing links and descriptions of all the steps needed to build the model from scratch
Inputs tabs – containing single and time-based inputs
Consolidated Financials tab – containing consolidated financial statements, including Pro-Forma adjustments
Acquirer & Target Financials tabs – containing individual company financials

Key takeaways:

Learn how to make projections
Learn how to value business combinations through pro-forma adjustments
Learn how to assess if a deal is accretive or dilutive

You must log in to submit a review.