Leveraged Buyout (LBO) Modeling- On-demand

Leveraged Buyout (LBO) Modeling- On-demand
CFI is a global provider of online financial training courses with a focus on practical applications. Most courses involve hands on Excel tutorials, which take participants beyond the theory to develop job-based skills. All participants are automatically issued certificates of completion after successfully finishing each course. The price of the course varies and are based on a function of a few criteria including, (1) their duration (CPD hours), (2) level of difficulty, and (3) demand for the topic.


EL19200171

Learn to build an LBO model from scratch in CFI's leveraged buyout modeling course. This advanced class covers how to set up and build an LBO model step-by-step including assumptions, financing, forecast income statement, balance sheet, cash flow, debt schedule, DCF, IRR, sensitivity analysis, error checks, all formulas, functions, and formatting.

LEARNING OBJECTIVES

  • Layout and structure - how to effectively set up the model in Excel

  • Assumptions - general transaction details, operating scenarios, financing terms, sources and uses of cash, etc.

  • Historical financial statements - linking the 3 statements in Excel

  • Building the forecast- using operating scenarios and other assumptions to drive the forecast

  • Transaction balance sheet - calculating all adjusting entries to create a pro forma balance sheet (goodwill, recapitalization, etc)

  • Debt schedule - model all tranches of debt and interest using dynamic formulas

  • Credit metrics - model all necessary debt covenants such as debt/EBITDA, EBIT/Interest, fixed-charge coverage ratio, and more

  • DCF & IRR- incorporate a discounted cash flow (DCF) analysis and internal rate of return (IRR) by investor type

  • Sensitivity analysis - create data tables to sensitize the IRR based on changes in key assumptions and drivers

  • Charts & graphs - show outputs and results from the LBO model

WHO WILL BENEFIT
This LBO model course is designed for advanced financial practitioners. It is most suitable for professionals working in investment banking and private equity, although it may also be useful for professionals in equity research, corporate development, and other areas of finance.

1 Passport Day Plus $100 - 7 PD Hours

When
4/1/2019 - 3/31/2020
Where
On-line