LBO Model 2

This Q&A podcast focuses on Leveraged Buyouts (LBOs) and financial modeling. The instructor first recaps the previous session's LBO framework, then guides participants through a simplified LBO model ("LBO Challenge"), explaining concepts like sources and uses of funds, debt schedules, and IRR calculations. The second half involves a more complex LBO model ("Columbia LBO"), demonstrating the use of different debt instruments (senior, subordinated, mezzanine debt with payment-in-kind features), and the importance of iterative calculations in financial modeling. Specific examples of debt structures and their implications for returns are provided. The session concludes with instructions for completing the Columbia LBO model independently and offers optional follow-up sessions for troubleshooting.

Outlines

Part 1: Initial Setup & Introductions

Part 2: Session Overview & LBO Fundamentals

Part 3: LBO Challenge Model Walkthrough

Part 4: Columbia LBO Model Introduction

Part 5: Columbia LBO Model - Building the Model

Part 6: Conclusion & Next Steps

Sign in to continue reading, translating and more.

Open full episode in Podwise

Other Fin

Part 1: Initial Setup & Introductions

Initial Check-in and Scheduling

Welcoming Participants and Addressing Technical Issues

Participant Background and Cohort Information

Speaker 1's MBA Experience and Cohort Dynamics

Addressing Audio Issues with a Participant

Part 2: Session Overview & LBO Fundamentals

Beginning the Session and Setting Expectations

Recap of the Previous Day's Discussion and Session Plan

Q&A: Highly Leveraged Companies in LBOs

Recap of LBO Diagram and Return Calculation

Real-World LBO Process and Due Diligence

Part 3: LBO Challenge Model Walkthrough

Completing the LBO Challenge Model: Sources and Uses

Completing the LBO Challenge Model: Income Statement and Free Cash Flow

Completing the LBO Challenge Model: Debt Schedules and Mandatory Payments

Completing the LBO Challenge Model: Interest Expense Calculation and Circular References

Completing the LBO Challenge Model: Subordinated Debt and Cash Balance

Completing the LBO Challenge Model: Return Calculation and Sensitivities

Q&A: Impact of AI on Financial Modeling and LBO Exit Strategies

Part 4: Columbia LBO Model Introduction

Beginning the Columbia LBO Model

Overview of the Columbia LBO Model

Columbia LBO Model: Transaction Summary and Stock Options

Columbia LBO Model: Work Session - Building the Sources and Uses

Review of Sources and Uses and Addressing Participant Questions

Review of Columbia LBO Model: Transaction Summary Calculations

Part 5: Columbia LBO Model - Building the Model

Columbia LBO Model: Cash Flow Statement and Debt Service

Columbia LBO Model: Debt Schedule and Mandatory Repayments

Columbia LBO Model: Revolver, Term Loan A, and Accelerated Repayments

Columbia LBO Model: Term Loan B, High-Yield Bond, Mezzanine Debt, and Shareholder Loan

Part 6: Conclusion & Next Steps

Concluding Remarks, Homework Assignment, and Optional Troubleshooting Sessions

LBO Model 2

Other Fin

Part 1: Initial Setup & Introductions

00:05Initial Check-in and Scheduling

Initial Check-in and Scheduling

02:29Welcoming Participants and Addressing Technical Issues

Welcoming Participants and Addressing Technical Issues

03:37Participant Background and Cohort Information

Participant Background and Cohort Information

04:25Speaker 1's MBA Experience and Cohort Dynamics

Speaker 1's MBA Experience and Cohort Dynamics

04:56Addressing Audio Issues with a Participant

Addressing Audio Issues with a Participant

Part 2: Session Overview & LBO Fundamentals

05:28Beginning the Session and Setting Expectations

Beginning the Session and Setting Expectations

06:13Recap of the Previous Day's Discussion and Session Plan

Recap of the Previous Day's Discussion and Session Plan

14:12Q&A: Highly Leveraged Companies in LBOs

Q&A: Highly Leveraged Companies in LBOs

17:08Recap of LBO Diagram and Return Calculation

Recap of LBO Diagram and Return Calculation

20:40Real-World LBO Process and Due Diligence

Real-World LBO Process and Due Diligence

Part 3: LBO Challenge Model Walkthrough

21:40Completing the LBO Challenge Model: Sources and Uses

Completing the LBO Challenge Model: Sources and Uses

26:46Completing the LBO Challenge Model: Income Statement and Free Cash Flow

Completing the LBO Challenge Model: Income Statement and Free Cash Flow

32:22Completing the LBO Challenge Model: Debt Schedules and Mandatory Payments

Completing the LBO Challenge Model: Debt Schedules and Mandatory Payments

43:39Completing the LBO Challenge Model: Interest Expense Calculation and Circular References

Completing the LBO Challenge Model: Interest Expense Calculation and Circular References

53:55Completing the LBO Challenge Model: Subordinated Debt and Cash Balance

Completing the LBO Challenge Model: Subordinated Debt and Cash Balance

1:01:06Completing the LBO Challenge Model: Return Calculation and Sensitivities

Completing the LBO Challenge Model: Return Calculation and Sensitivities

1:04:21Q&A: Impact of AI on Financial Modeling and LBO Exit Strategies

Q&A: Impact of AI on Financial Modeling and LBO Exit Strategies

Part 4: Columbia LBO Model Introduction

1:17:26Beginning the Columbia LBO Model

Beginning the Columbia LBO Model

1:20:04Overview of the Columbia LBO Model

Overview of the Columbia LBO Model

1:26:04Columbia LBO Model: Transaction Summary and Stock Options

Columbia LBO Model: Transaction Summary and Stock Options

1:34:43Columbia LBO Model: Work Session - Building the Sources and Uses

Columbia LBO Model: Work Session - Building the Sources and Uses

1:43:35Review of Sources and Uses and Addressing Participant Questions

Review of Sources and Uses and Addressing Participant Questions

1:49:54Review of Columbia LBO Model: Transaction Summary Calculations

Review of Columbia LBO Model: Transaction Summary Calculations

Part 5: Columbia LBO Model - Building the Model

2:06:59Columbia LBO Model: Cash Flow Statement and Debt Service

Columbia LBO Model: Cash Flow Statement and Debt Service

2:18:22Columbia LBO Model: Debt Schedule and Mandatory Repayments

Columbia LBO Model: Debt Schedule and Mandatory Repayments

2:43:44Columbia LBO Model: Revolver, Term Loan A, and Accelerated Repayments

Columbia LBO Model: Revolver, Term Loan A, and Accelerated Repayments

3:03:39Columbia LBO Model: Term Loan B, High-Yield Bond, Mezzanine Debt, and Shareholder Loan

Columbia LBO Model: Term Loan B, High-Yield Bond, Mezzanine Debt, and Shareholder Loan

Part 6: Conclusion & Next Steps

3:08:01Concluding Remarks, Homework Assignment, and Optional Troubleshooting Sessions

Concluding Remarks, Homework Assignment, and Optional Troubleshooting Sessions