LBO Modeling Test: Full Walkthrough of a 60-Minute Test (Blank Sheet)

Learn more: https://breakingintowallstreet.com/co...

In this tutorial, you’ll learn how to complete a full 60-minute LBO modeling test starting from a blank sheet in Excel, and you’ll learn how to simplify and work efficiently so you finish on time.

NOTE TO VIDEO: At 42:50 – 43:10, we make a mistake calculating the Ending Cash balance. We fix this mistake at 45:42 – 46:02.

Table of Contents:

For all the files and resources, please see:

https://www.mergersandinquisitions.co...

0:00 Introduction

2:24 Part 1: Likely Requirements in Modeling Tests

7:43 Part 2: Transaction Assumptions and Sources & Uses

17:24 Part 3: Model Drivers and Income Statement

32:14 Part 4: Free Cash Flow and Debt Schedule

46:04 Part 5: Returns and Sensitivities

56:22 Part 6: Answers to the Case Study Questions

1:03:12 Recap and Summary