Advanced LBO Modeling – Felix

Skip to content

Topics
Pathways
Courses
Data
Models
Ask An Instructor
Support
Log in

Topics
Pathways
Courses
Data
Models

Log in
Ask An Instructor

Advanced LBO Modeling

Introducing a buy-out with a detailed multi-tranche financing structure. The transaction happens mid-year, necessitating a stub period. A fully integrated buyout model for the stub period and forecast years is completed with a detailed debt sheet.

Show lesson playlist

01:59
Basic LBO Primer
- #1 of 33
03:01
Advanced LBO Model Tour
- #2 of 33
04:01
Flexible Deal Date - Why Do We Need A Stub Period
- #3 of 33
04:06
Deal Date Income Statement
- #4 of 33
02:49
Deal Date Balance Sheet
- #5 of 33
03:54
Deal Date Cash Flow Statement
- #6 of 33
03:05
Sources And Uses Of Funds
- #7 of 33
05:13
Immediately Post Deal Balance Sheet
- #8 of 33
04:13
Stub Period - Income Statement
- #9 of 33
03:25
Stub Period - Balance Sheet
- #10 of 33
05:23
Stub Period - Cash Flow Statement
- #11 of 33
03:30
Forecast - Income Statement
- #12 of 33
02:39
Forecast - Balance Sheet
- #13 of 33
04:53
Forecast - Cash Flow Statement
- #14 of 33
01:37
Debt Schedule and Sweep Explained
- #15 of 33
02:57
Debt Schedule Tour
- #16 of 33
04:59
Debt - Cash Flow Available For Debt Service
- #17 of 33
03:36
Debt - Revolver And Refinancing Facility
- #18 of 33
06:09
Debt - Cash For Sweep
- #19 of 33
03:52
Debt - Term Loan B, Second Lien, High Yield
- #20 of 33
01:16
What Is A Capex Facility
- #21 of 33
03:47
Debt - Mezzanine, Capex Facility
- #22 of 33
02:30
What Is An Original Issuer Discount
- #23 of 33
02:33
Debt - Original Issuer Discount
- #24 of 33
04:30
Debt - Ending Cash Checks
- #25 of 33
03:21
Putting Debt Into Balance Sheet
- #26 of 33
04:49
Interest - Revolver, Refin, Term Loan B
- #27 of 33
03:23
Interest - Second Lien, High Yield, Mezzanine
- #28 of 33
04:03
Interest - Capex Facility, Interest Income
- #29 of 33
05:30
Interest - Circular Interest in Income Statement
- #30 of 33
02:39
Debt - Refinancing Facility In Use
- #31 of 33
06:24
IRR
- #32 of 33
Advanced LBO Modeling Tryout
- #33 of 33

Prev: LBO Modeling Complexities Next: Carried Interest and Promotion Modeling

© Financial Edge Training 2024

Topics

Introduction to Finance Accounting Financial Modeling Valuation M&A and Divestitures Private Equity

Venture Capital Project Finance Credit Analysis Transaction Banking Restructuring Capital Markets

Asset Management Risk Management Economics Data Science and System

Request New Content

System Account User Guide Privacy Policy Terms & Conditions Log in

Content Requests and Questions

You are trying to access premium learning content.

Discover our full catalogue and purchase a course Access all courses with our premium plans or log in to your account

Help

You need an account to contact support.

Create a free account or log in to an existing one

Sorry, you don't have access to that yet!

You are trying to access premium learning content.

Discover our full catalogue and purchase a course Access all courses with our premium plans or log in to your account

You have reached the limit of annotations (10) under our premium subscription. Upgrade to unlock unlimited annotations.

Find out more about our premium plan

You are trying to access content that requires a free account. Sign up or login in seconds!

Create a free account or log in to an existing one

You are trying to access content that requires a premium plan.

Find out more about our premium plan or log in to your account

Only US listed companies are available under our Free and Boost plans. Upgrade to Pro to access over 7,000 global companies across the US, UK, Canada, France, Italy, Germany, Hong Kong and more.

Find out more about our premium plan or log in to your account

Congratulations on completing

Hidden

Name(Required)

First Last

Overall Rating(Required)

54321

Are you happy for us to use your feedback and details in future marketing?(Required)

Yes

No

Additional comments:

Thank you for already submitting feedback for this course.

A pro account is required for the Excel Add In

Find out more about our premium plan