Events Search
  Summary & Check Out (0)
Wednesday, February 10, 2027 Live Webcast

Mergers & Acquisitions (M&A) Modeling in Excel Part 2 – Pro Forma Integration & Analysis (X4-8673167)

3:00 PM - 4:37 PM EST
webcast

Vendor Platform

1.8 CPE Credits in SK

OVERVIEW

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

COURSE LEVEL

Advanced

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

PRICING

$89.00 - Member

$109.00 - Nonmember

Register Today


Note: Online pre-registration will close on February 10 at 2:30 PM.

ADDITIONAL OPTIONS

Remind me to register

Print a registration form

COURSE DEVELOPER

ACPEN