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.
When building the sources and uses, always include a "model check" as shown above 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.comments powered by Disqus