Learn more: https://breakingintowallstreet.com/core-financial-modeling/?utm_medium=yt&utm_source=yt&utm_campaign=yt12
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.com/lbo-modeling-test/
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