Introduction

In this tutorial, we will walk you through building an LBO model in Excel. Most other tutorials focus on building simple LBO models, but we will demonstrate how to build the type of complex LBO model used in leveraged finance at bulge-bracket investment banks. If you can follow this model, you can easily handle more basic ones. Throughout this section, we will assume that you have exposure to most of the accounting concepts we model here, or have read the other relevant sections on this site.

 

Create Financial Models 10x Faster with Macabacus

Gain access to 100+ shortcuts, formula auditing visualizations, easy Excel-to-PowerPoint linking and productivity tools to help you accelerate financial modeling and presentations.

Start your Free Trial
 

Good LBO models necessarily involve circular references arising from the calculation of interest expense. For example, interest expense figures into the calculation of net income, which figures into the calculation of cash flow available for debt repayment, which figures into the debt levels upon which interest expense is calculated, and so on. Although there are many different ways to approach an LBO model, we have sequenced our steps to group (to the maximum extent possible) related calculations and delay the introduction of the circular reference until the last possible moment. Even with this sequencing, it may seem like we are jumping around quite a bit to different parts of the model. This is necessary, as many of the sections in our model will be interconnected.

Also, we will build our LBO model on a single worksheet, rather than spreading it out across multiple tabs. Consolidating the model in this manner makes the model more intuitive, easier to build, and easier to check. If you need to format data in the model in a specific way for presentation in a pitch book, for example, you should create separate output tabs that link to the model and are formatted according to your specific needs.

At each step, you can download the spreadsheet in Excel format. To do so, just click on the gear icon in the upper right corner of the spreadsheet. Of course, you can also download the finished product as well.

Download Spreadsheet

The Macabacus DCF template implements key concepts and best practices related to DCF modeling.

Discover more topics

Build an operating model
In this tutorial, we will walk through how to build a general industry business operating model.
Read more
Build an M&A model
In this section, we demonstrate how to model a merger of two public companies in Excel.
Read more
Build an LBO model
In this tutorial, we will walk you through building an LBO model in Excel.
Read more
Asset and Stock Deals
The first step in purchase price allocation, or PPA, is to determine the purchase price.
Read more