Sources & Uses of Funds

In building our model, we want the flexibility to consider a number of possible financing scenarios. As you can see below, we have set up six such scenarios that contemplate two possible refinancing scenarios, three LBO scenarios, and one case in which no transaction occurs at all. In each scenario, the sources of funds must equal the uses of funds. To the right of these cases is the active case, set above in our main inputs and assumptions block.

 

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.

Perhaps the most confusing calculations in this section are those that calculate capitalized financing costs. Although these costs are capitalized and amortized over some period of time for accounting purposes, the cash outlays for these costs are paid up-front when the transaction closes. They are, therefore, uses of funds. For each scenario (except the no-deal case), we assume a revolver of a fixed size so that, in each scenario, there will be the same fee associated with the revolver. Parameters used to calculate other fees and expenses (e.g. principal amounts), however, vary from case to case. In the second part of these equations, we are simply multiplying the principal amounts for each case by the fee percentages applicable in all cases. For example, a 2% fee on a $100 loan equals $2.

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