Sources & Uses of Funds

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.

 

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.

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

Download Template

Sources & Uses of Funds

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