Basic Inputs

We begin our LBO model by creating the target’s P&L as described in the section on M&A modeling. We won’t bother to retrace those steps here. We have also begun to enter some basic inputs to our LBO tab in the spreadsheet below to get us started, and will be adding many more inputs as we require them.

 

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
 

Note that on the LBO tab, we are assuming a specific premium to the current share price to compute a single transaction price. Recall that in the M&A model we built, we considered a range of transaction prices. We are using a single theoretical transaction price here because using a range would make the LBO model far too complex. However, you can compute returns (e.g. IRRs) for a range of premiums using Excel’s tables later.

Download Template

Basic inputs to the LBO model

Try Macabacus for free to accelerate financial modeling in Excel.

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