Putting Debt Into Balance Sheet
- 03:21
Linking the debt schedule to the balance sheet of the forecast model
Glossary
Leveraged Buy Out PE Private EquityTranscript
In the debt schedule, we have a list of all the debt balances at the end of each period. We now need to put those figures into two places. The first one is on the deal date tab. We need to go to that balance sheet and put those figures into the three-month period ended December 18. We then need to go to the deal model tab and put the figures in for December 19th, December 20th and December 21, et cetera. So if we have a quick look at the deal date tab, we've currently got column I mostly empty. Those column I figures will then flow through into the deal model tab, column I on the deal model tab all linking to the deal date. But it's column J, we will then need to hook that up to the debt schedule so that we've then got a full deal model going forward. So let's start on that deal date tab. Historical long-term debt is just linked to the prior year. We know that that long-term debt's gone and it won't be coming back. So we start with the refinancing facility. I go to the debt schedule. I find that refinancing facility, and it's zero.
I can copy that all the way down to mezzanine. The figures flow through. We then go and get the unamortized debt issuance fees.
They need to go in as a negative 11.7. They're counted as a negative liability. We also need to put the revolving credit facility in, off the debt schedule again, and we can find that it was a zero. Now, at this stage, you might imagine that the balance sheet would balance. But if you go down and check it, it's off my naught .3 Luckily, there's a very good reason for this. It's the unamortized debt issuance fees. We've had amortization of naught .3. That's flown correctly into the balance sheet here, but we haven't put it into the income statement yet. That means my net income is slightly wrong, and my net income flows into my equity, which means my equity is slightly wrong by that naught .3. When we do interest in the income statements, we'll put that amortization of the debt issuance fees or the OID original issue discount, and then it will balance. We see that those figures have now flowed through into the deal model tab. I'll just check that the revolvers come through, and it has. So we now need to go get the remaining items. Historical long-term debts, that's just going to equal last year. Refinancing facility, remember, I'm in column J here, so I'll want to link to the debt schedules in column J as well. Refinancing facility, copy that down. I'll go get the unamortized debt issuance fees or the OID, original issuer discount. Remember, it has to be a negative 10.3. And I'll then go up, find the revolver, do exactly the same thing. My revolver was zero. If we have a look at the unamortized debt issuance fees, so it started at 12, it's now 10.3, so I should have amortization of 1.7 flown through two income statements.
I'm not, and that's why the balance sheet is unbalanced by 1.7.