[GFA + TCC] Wall Street Prep - Leveraged Buyout Modeling

by Graduate Finance Association

Professional

Sat, Apr 27, 2019

9 AM – 5 PM EDT (GMT-4)

Add to Calendar

TPR 2110

5000 Forbes Avenue, Carnegie Mellon University, Pittsburgh, PA 15213, United States

View Map
35
Registered

Registration

Details

Trainees learn how to build a real, complex LBO model from scratch. We begin with basic LBO concepts, typical deal structures, and current industry dynamics before moving on to step-by-step modeling. Trainees learn the most common and challenging issues that emerge when modeling buyouts. We conclude with a sensitivity and scenario analysis, as well as how to build output tables that are key to any LBO analysis.

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 inline 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
• Identify and error-proof the circularities and iteration problems inherent in an LBO model
Dress Casual (jeans ok)
Food Provided (Lunch provided)

Where

TPR 2110

5000 Forbes Avenue, Carnegie Mellon University, Pittsburgh, PA 15213, United States

Hosted By

Graduate Finance Association | Website | View More Events
Co-hosted with: Consulting Club, Graduate Finance Association (OWNER)