Financing Summary

1 minutes read
Last updated: November 6, 2023

Let’s now take the financing case selected by the cell we named “fin_case” and display the sources and uses of funds for this case in the transaction overview/assumptions block in our spreadsheet. To do this, simply link to the active financing case created in the last step. We will also calculate what percentage of the total sources and uses each source and use of funds represents, as well as the corresponding LTM EBITDA multiple. We have also created three columns that we will fill in later.

 

Download Template

Download Template

Financing Summary

Try Macabacus for free to accelerate financial modeling in Excel.

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.

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