Operating Assumptions

We want our LBO model to have the flexibility to consider multiple operating scenarios (i.e. different levels of operating performance that are reflected in the income statement). The three scenarios we consider here are an up-side case, a down-side case, and a Wall Street analyst case. You might also include a management case if you have been provided with detailed management projections for the target. The analyst case is simply pulled directly from the income statement we created in the previous step, and the other cases represent your views how good or bad the target’s performance might be. In addition to entering these operating cases, we created an input cell that allows us to select from any of these hypothetical cases with the flip of a switch and flow the operating assumptions through the model.

 

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
 

In our model, we want to project the income statement beyond the horizon shown in the P&L. To do so, we typically flat-line the operating assumptions in each case since we rarely have visibility that far into the future.

Download Template

Operating Assumptions

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