LBO and M&A Transaction Modeling (2 days)

Develop a fundamental understanding and framework for corporate finance transaction analysis including modeling and pro forma financial effects used by investment banking and private equity professionals to analyse leveraged buyouts (“LBO”) and mergers & acquisitions (“M&A”). Apply theory and best practice principles to build comprehensive LBO and M&A models of target companies preparing you to perform on the job.

Day 1 – LBO analysis and modeling

Learning outcomes

  • Understand the concept, principles and rationale of LBOs and financing
  • Understand and perform returns and credit analysis
  • Construct a comprehensive LBO model in Excel

Key topics

  • Theoretical premise and concept
  • LBO target characteristics
  • Deal participants and process
  • Financing sources & uses
  • Transaction accounting
  • LBO modeling
  • IRR and participant returns analysis
  • Credit ratios

Day 2 – M&A analysis and modeling

Learning outcomes

  • Understand the concept, principles and rationale of M&A
  • Understand and perform financial effects and balance sheet analysis
  • Construct a comprehensive M&A model in Excel

Key topics

  • Transaction rationale
  • Synergies
  • Deal participants and process (sell-side and buy-side)
  • Deal financing and consideration (cash / debt, stock)
  • M&A accounting
  • M&A modeling
  • Accretion / (dilution) analysis
  • Balance sheet effects

Information

  • Career applications: investment banking, corporate finance, private equity, equity research, hedge funds, corporate business development, entrepreneurship
  • What to bring: laptop with Excel and pdf reader installed
  • All learning materials are provided including: Excel exercise files, subject company files, presentation handouts and discussion topics
  • Delegates will receive Advanced level financial modeling certification
  • Please contact us for details of upcoming courses