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.

 

Build Financial Models in Minutes

Enterprise-Grade Financial Modeling used by 80,000+ professionals across Investment Banking, Private Equity, and Corporate Finance. Ensure consistency, accuracy, and efficiency across your entire organization.

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

Download The State of M&A Transactions
Download this report for expert guidance on innovative structures, cost-effective financing, and antitrust strategies to accelerate deals.
Read more
DCF Excel Template
Elevate your investment analysis with our free DCF model template. Understand discounted cash flow principles and perform accurate valuations in Excel.
Read more
Operating Model Excel Template
Download our free operating model Excel template. Forecast revenue, expenses, and key financial metrics for better decision-making.
Read more
LBO Excel Model
Try LBO modeling with our comprehensive Excel template. Understand key concepts, calculate returns, and gain actionable insights.
Read more