Рет қаралды 102,528
Learn more: 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:
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