Advanced LBO Modeling

Skip to content

Topics
Pathways
Certified Courses
Ask An Instructor
Support
Log in

Topics
Pathways
Certified Courses

Data
Models
Account
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:28
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

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

A pro account is required for the Excel Add In

Find out more about our premium plan

Congratulations on completing

This field is hidden when viewing the form

Name(Required)

First Last

This field is hidden when viewing the form

Email(Required)

Overall Rating(Required)

Rate this course out of 5, where 5 is excellent and 1 is terrible.

54321

Were the stated learning objectives met?(Required)

Yes

No

Were the stated prerequisite requirements appropriate and sufficient?(Required)

Yes

No

Were the program materials, including the qualified assessment, relevant and did they contribute to the achievement of the learning objectives?(Required)

Yes

No

Was the time allotted to the learning activity appropriate?(Required)

Yes

No

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

Yes

No

Additional comments (Use this space to explain any particular scoring or make suggestions):

Thank you for already submitting feedback for this course.