Merger Modeling: How to Build a Merger Model in Excel

Merger Modeling: How to Build a Merger Model in Excel

Regular price $150.00

SAMPLE VIDEO

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

Sale

Unavailable

Sold Out