Deal Assumptions

1 minutes read
Last updated: November 6, 2023

When building a model, it is important that the model be flexible enough to consider a wide range of possible scenarios. Let’s now add some assumptions about the transaction that, when changed, will flow through the model. The assumptions presented below are simply suggestions, and the specific transaction you are contemplating may call for other assumptions. In any case, most or all of the deal assumptions should be grouped into a single section of your model so that anyone can see, at a glance, what assumptions you are making.

Note that, in the spreadsheet below, we have left the tax rate blank. The tax rate used is the acquirer’s tax rate, which we will determine in a subsequent step.

 

Download Template

Deal Assumptions

Try Macabacus for free to accelerate financial modeling in Excel.

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
 

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