Toptube Video Search Engine



Title:LBO Modeling Test: Full Walkthrough of a 60-Minute Test (Blank Sheet)
Duration:01:06:20
Viewed:48,480
Published:15-12-2021
Source:Youtube

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



SHARE TO YOUR FRIENDS


Download Server 1


DOWNLOAD MP4

Download Server 2


DOWNLOAD MP4

Alternative Download :