Model - Sources and Uses of Funds 1
- 02:15
Understand how to set up the sources and uses table
Glossary
Acquisition Equity Value Equity Fees Mezzanine Term LoanTranscript
In calculating the sources and uses of funds table, a couple of assumptions are going to be important to us Firstly the debt financing fees and you want to hear of 1% of the debt issued Also advisory fees, 1% of acquisition EV So let's go down to our sources and uses, our first use is the acquisition equity value i.e we need to use funds to buy the company So we've got that further up the page, acquisition equity value of 2,193 Next up we need those debt financing fees, back up to our assumptions, there is 1% of debt raised Now the debt raised is over in our sources, we've already been out to bank and asked them "Hey, how much debt will you give us?" I'm not going to include the revolver because there isn't any, So we're just going to include the term loan A, B, mezzanine loan PIK (paid in kind) and senior unsecured notes Getting me debt financing fees of 7.4 Next up the advisory fees, the advisory fees are 1% of EV. Again that's a bit further up the page Of 2,100.6 So my total uses of funds add up to 2,221.4 Now we need our sources of funds to be the same So what can we use as our sources of funds? Well the first one we can go looking for is cash from the target's balance sheet So again we've got that a little further up the page We saw that they had net debt, it was actually net cash of 92.3 So we can use that, I'm going to turn the sign around on that one to make sure it's a positive. Great, we've got some cash. As well as using cash, we're going to use all of those debt items and then lastly equity. Equity is going to be the plug I know that my total uses are 2,221.4, I'm going to subtract off the sources I've already got Which will give me an equity plug of 1,389.1 I sum up my sources and I get exactly the same figure 2,221.4 as the uses, 2,221.4