Skip to product information
1 of 3

eLearning

LBO Modeling

  • Description
  • Learning objectives
  • Key topics
  • Description
  • Learn how to structure an LBO and model the impact of the new financing structure. The focus of this course is to build out a full integrated model with an income statement, balance sheet and cash flow statement, together with a detailed analysis of the financing structures and returns

    10.5 hours of video content
    Estimated 21 hours to complete

  • Learning objectives
    • Build a detailed Sources & Uses table, including target cash, shareholder loan note and fees
    • How to build the initial balance sheet post buy out
    • How to forecast the income statement, balance sheet and cash flow, incorporating a detailed cash sweep / cash waterfall
    • How to calculate returns to all investors participating in equity, including the financial sponsor, management team, and mezzanine investors
    • How to build data tables to sensitize key outputs
  • Key topics
  • Complete topics step by step or jump to any of the below at any time.

    • Model overview
      • Sources and uses of funds at entry
      • Operating forecast
      • Distribution of proceeds at exit
      • Returns analysis
    • Sources and uses of funds at entry
      • Sources and uses of funds table
      • Ownership structure: Equity ownership at entry vs exit
      • Common equity (Sponsor and Management)
      • The use of different types of equity: Shareholder loan (PIK interest) and preferred stock
      • The use of different types of debt: term loans, subordinated debt, high yield, mezzanine (with PIK and cash interest)
    • Operating forecast
      • Creating the opening balance sheet
        • Deal goodwill
        • Deal adjustments, including amortization of debt issuance fees
      • Focus on cash flow drivers and sanity-checking preliminary assumptions
      • Cash flows available for debt servicing
      • Repayment schedules for individual debt instruments
      • Acceleration of debt payments using a cash sweep mechanism
      • Modeling the revolving credit facility
      • Circularities and the interest calculations
      • PIK interest
      • Credit ratios
      • Using the model outputs to identify key debt covenants
    • Distribution of proceeds at exit
      • Benefit of modeling out value to all investors at exit
    • Returns
      • Calculation and interpretation of returns to the equity investors
      • Calculation and interpretation of returns to mezzanine investors
      • Calculation and interpretation of returns to the management team
      • IRR and money multiple
      • Sensitizing the outputs of the analysis
      • Analysis of the output

     

    Regular price $171.00 USD
    Regular price Sale price $171.00 USD
    Sale Register Interest
    Shipping calculated at checkout.
    • Pre-requisites

      This course is open to all. To maximize the benefit of this course we recommend an understanding of Microsoft Excel.

    • Technical Requirements

      You will need an Internet connected device to access the videos and download supporting resources. Supporting resources can be used offline, which require Microsoft Excel 2003 or later and a PDF reader.

    • Comprehensive Resources

      Bite-size trainer led HD videos detailing step by step techniques and best practices. Download the slides and files as used in the videos, which can be completed while watching or saved for later. Open forum for quick problem solving.

    1 of 3

    Frequently Asked Questions

    How do I access the eLearning content?

    Once you have purchased our eLearning course, you will receive an order confirmation to access your course. You can also access using the 'My Courses' tab.

    What are the tech requirements?

    You can access your course either on desktop, tablet or mobile.

    You will also need access to a PDF reader in order to download and read the course notes.

    You will need a spreadsheet application to complete the practical exercises.

    How long will I have access?

    You will have access for 12 months from date of purchase

    Will I receive a certificate?

    Absolutely! All our eLearning comes with a digital certificate that can be added to your social media profiles, including LinkedIn!

    Can I learn through the AMT App?

    Yes! Complimentary app access is granted through your eLearning course.

    I have questions about the content

    Feel free to drop us an email at info@amttraining.com with any questions you have and we will have one of our experts respond

    Don’t see the training you need?

    Browse our parent company, Training the Street’s self-study financial training courses here.

    EXPLORE NOW