Let’s now determine the sources and uses of funds in the deal for a range of transaction prices. The total sources of funds must always equal the total uses of funds.
Sources & Uses of Funds
Speed Up Financial Modeling with Macabacus
Save 100s of hours annually with custom shortcuts, formula auditing and linking Excel to PowerPoint.
When building the sources and uses, always include a “model check” as shown in the template to show that sources equal uses. If you prefer to conceal these cells for aesthetic purposes, you can color them white, group and hide the row (Alt>d>g>g + Alt>d>g>h), or set the row height to zero (Alt>o>r>e). It is best-practice to output all model checks to a single worksheet so that any user can quickly tell if the model contains errors.
Download Template
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