Merger Modeling: How to Build a Merger Model in Excel

This online course is designed to develop merger modeling skills through M&A theory and the actual hands-on construction of an interactive merger model from “scratch”, by blending M&A accounting, corporate finance and Excel skills. This course is the online version of Training The Street's live courses at the largest financial institutions and top MBA programs

KEY FEATURES

• Estimated time to complete is 10-15 hours
• Optimized for PC based Excel
• The Excel shortcuts in this course are not optimized for Mac versions of Excel, but this will not detract substantially from the course experience

TOPICS COVERED

• Overview of the merger process from the buyer's and seller's perspective
• Purchase accounting and modeling write-up of assets
• Accretion / dilution analysis modeling
• Relative P/E analysis and other useful techniques
• Advanced analysis such as exchange ratio analysis, contribution analysis and premium paid analysis
• Deal mechanisms such as collar agreements and defense against hostile takeovers

PREREQUISITES

• This course requires basic accounting knowledge. The Financial Statement Analysis course fulfills this prerequisite
• This course requires basic valuation knowledge. We recommend taking the Corporate Valuation course to fulfill this requirement
• This course recommends, but does not require, basic Excel proficiency. We recommend taking the Excel Best Practices course to fulfill this requirement