With the structural foundation of your Mergers & Acquisitions (M&A) model in place, this course takes you through the final and most analytical phase of the process. You will integrate the acquirer and target company financials into a combined pro forma model, then evaluate the deal's impact by calculating accretion or dilution to key per-share metrics and running sensitivity analysis on critical assumptions. By the end of this course, you will have a complete, fully functional Mergers & Acquisitions (M&A) model in Excel and the analytical skills to interpret and present the results of a transaction.
DESIGNED FOR
This course is designed for finance professionals and learners who have completed Part 1 of this series and are ready to finalize and analyze a complete M&A model. It is particularly valuable for financial analysts, investment bankers, and corporate development professionals who need to evaluate deal outcomes and present transaction analysis to stakeholders.
BENEFITS
- Integrate the acquirer and the target company into a combined pro forma model
- Calculate the accretion or dilution of key per share metrics post-transaction
- Perform sensitivity analysis on key assumptions and assess the overall impact of the transaction
HIGHLIGHTS
This course is presented by the Corporate Finance Institute
- Investment Banking
- Financial Modeling
PREREQUISITES
Recommended courses: 3-Statement Modeling; Mergers & Acquisitions (M&A) Modeling in Excel Part 1 Model Setup Transaction Adjustments; Applied DCF Valuation Modeling
ADVANCE PREPARATION
None