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.

 

Speed Up Financial Modeling with Macabacus


Try the leading Microsoft 365 add-in for finance and banking. Create complex financial models and branded presentations in record time.

Start a 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