Wall Street Prep

Boston
M&A and LBO Modeling Boot Camp|Boston

Master LBO and M&A modeling in this intensive instructor-led boot camp

What You'll Learn

  • Learn LBO and M&A and modeling and best practices in Excel
  • Taught by experienced bankers
  • Includes Excel model templates

Perfect for finance professionals and those looking to break into the industry, our M&A and LBO Modeling Boot Camp will teach you how to build models the way it's done on the job. This is the same intensive training used to prepare incoming analysts at top financial institutions.

Pricing

Full Boot Camp (Recommended)
$1,299
Group Rates
discount
available

Agenda

Day 1
8am - 5pm
M&A Modeling

Participants will build a merger model in Excel to reflect the pro forma impact of various acquisition scenarios. Key topics covered include a quick test of accretion / dilution in all-stock deals, pricing structures (exchange ratios, collars, "walk-away" rights), purchase accounting, and the step-by-step allocation of purchase price.

Day 2
8am - 5pm
LBO Modeling

Participants will learn typical deal structures of leveraged buyouts and current market metrics. They will then structure an Excel model for the valuation and analysis of an LBO transaction in line with those typical deal benchmarks using a real life case study.

Online
Pre-Seminar Excel training

This boot camp assumes proficiency in Excel. Enrollment includes access to our popular Excel Crash Course for those who need an Excel refresher.

Online
Post-Seminar Online Access

Enrollment includes lifetime access to the following online course(s): M&A ModelingLBO Modeling

Boot Camp Overview

This boot camp is an intensive instructor-led training program where trainees learn financial and valuation modeling in Excel using an intuitive, step-by-step approach. Participants will use real case studies to build financial models from scratch the way it is done at financial institutions. The program is a synthesis of Excel modeling, navigating through various financial reports, and the application of accounting, corporate finance, and valuation courses.

Schedule

Each day begins at 8am and ends at 5pm with a 1-hour lunch break as well as a midmorning and midafternoon break.

What’s Included?

Comprehensive training materials (manuals and online exercises), detailed reusable modifiable Excel model templates, unlimited e-mail support for content-related questions for 12 months post-seminar.

Experienced Instructors

Our instructors are all practitioners with years of directly relevant real- world experience and have a passion for teaching. They understand the importance of teaching in a way that empowers students to apply the lessons from the classroom directly on the job.

What to Bring

Laptop, Notepad, and Calculator.

Cancellation Policy

Participants may cancel up to 3 weeks prior to the event for a full refund. A 20% cancellation fee will apply up to 1 week prior to the event. No refunds will be granted for cancellations made within 1 week of the event. Wall Street Prep reserves the right to cancel the seminar if enrollment is insufficient. Trainees will be refunded in full in the event of a cancellation.

Seminar Location

Boston College, Fulton Hall,
140 Commonwealth Avenue,
Chestnut Hill,
MA 02467

Why attend a boot camp?

  • Comprehensive training

    Our live courses pulls no punches. Each boot camp is the same intensive training used to prepare incoming analysts at top financial institutions.

  • Learn by doing

    Attendees “learn by doing” by working through practical exercises and building financial models from scratch using real case studies.

  • Networking opportunity

    Boot camps provide an opportunity to network with MBAs and professionals from industries including investment banking, corp dev and FP&A.

  • Experienced instructors

    Our instructor-practitioners are experienced bankers who give real-world context by connecting training to their own experience on the desk.

  • Excel Mastery

    Our training reinforces speed, efficiency and consistency in Excel that investment banking analysts are expected to have on Day 1.

  • Continuing ed & webinars

    Enrollment includes lifetime access to our continuing education online training platform and our popular monthly webinar series.

Syllabus

M&A Modeling

Building a robust merger model

  • Setting up a control area for assumptions
  • Inputting deal assumptions (% cash vs. stock considerations, purchase premium, asset write-ups, advisory fees, financing fees, and severance fees)
  • Calculating shares outstanding using the treasury stock method
  • Appropriate treatment of convertible securities
  • Allocating purchase price and calculating goodwill
  • Preparing the pushed-down balance sheet
  • Making pro forma balance sheet adjustments
  • Calculating sources & uses of funds
  • Inputting operating & synergy projections
  • Calculating the stub year period
  • Building a pro forma income statement and making appropriate deal-related adjustments to arrive at accretion/dilution per share
  • Error-checking a merger model and inserting circuit breaker switches where appropriate
  • Sensitivity analysis: EPS accretion/dilution in stock vs. cash deal; interest rate assumptions, premium paid
  • Pre-tax synergies required to break-even, and break-even PE analysis
  • Revenue, EBITDA, and Net Income contribution analysis

Advanced merger accounting

  • Understanding the differences between asset sales (including 338h10 elections) and stock sales
  • Taxation issues, including deferred taxes created by the step-up of asset values
  • Legal considerations in acquisitions
LBO Modeling

Constructing a fully integrated LBO Model

  • Participants will learn typical deal structures of leveraged buyouts, along with current market metrics. They will then structure an Excel model for the valuation and analysis of an LBO transaction in-line with those typical deal benchmarks using a real life case study.
  • The LBO analysis will be driven off an integrated, dynamic three statement pro forma LBO projection model.
  • Participants will learn how to model the typical instruments of LBO financing, including cost assumptions and sources and uses of funds.
  • Learn to insert a revolving credit facility and cash sweep, integrate industry standard treatment of senior notes, PIK instruments, and preferred equity and equity.
  • Identify and error-proof the circularities and iteration problems inherent in an LBO model.

Exit and sensitivity analysis

  • Participants will build the sensitivity tables required for correct analysis of an LBO, including the construction of multiples, and IRR tables using both data tables and various sorting functions in Excel, including VLOOKUPS, OFFSET, CHOOSE, and INDEX.
  • Participants will design different scenarios for their LBO model, including: Base/Best/Worst Case.

Questions? We're standing by.

To learn more about this boot camp, fill out the form below or call us at: 617-314-7685









X

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.