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.
Elevate your investment analysis with our free DCF model template. Understand discounted cash flow principles and perform accurate valuations in Excel.