Linking Debt to Balance Sheet
- 03:56
LBO modeling complexities linking debt to balance sheet
Glossary
LBO LBO modeling Private EquityTranscript
It's now time to rewire the balance sheet with the calculations from the debt page. As you recall, on the balance sheet, we have placeholders for the debt, which are primarily just linked to the previous year, or in this case the combo, the deal date year for the balance sheet. So we're gonna just link them back to the debt page. For the revolver, I'm going to start with, I'm gonna start with the revolver and I'll go back to the revolver section, make sure I'm picking up the ending balance. The line that's called debt is the pre-transaction debt, the debt that was refinanced. So we're actually not gonna do anything with that. I will move on to the first lien and I will pick up the ending balance of the first lie.
I will do the same for the second lien.
Moving on to Unitranche.
Bridge loan.
Lease liability.
And then finally, Mezzanine.
I'm also gonna wire in the preference shares which are technically not debt but they were calculated on the debt page. And we see from the Mezzanine and the Prefs that they're growing in value and that is due to the paid in kind nature of both the interest and the dividend. What I should do now is just make sure that this is working correctly from a wiring perspective. So I'm gonna go in here and just change over to the Unitranche, go back to the balance sheet and see if I've got a Unitranche balance sheet and I do. I've got Unitranche and my Prefs, change that. And then I'll go over to the lease. And what the lease should show is that I've got a bridge loan and then I've got that paid down. I've got the lease liability. I've also got first lien debt that's been paid down quite a bit. And the reason why that is, is if I look on the debt page what I can see that's happened here, if I go up to the top into my cash flows, is I've paid down the debt at 511 and I've taken on the lease liability at 709. That's because of the increased value of the assets that we sold. That difference, which is nearly 200, is being applied currently to pay down the first lien debt. That's because we haven't yet finished this transaction off by looking at the dividend that would most likely result from that transaction. So we will do that at the end of the model, but for right now, we're gonna let that excess cash flow of 198 flow through the model and pay down the debt. The next thing we wanna do is just take a look again at the balance sheet and make sure that we're still in balance because we'd already done the cashflow statement several steps ago and what we see actually is that low and behold, we are not in balance. We're actually out of balance by 110.7. Now normally that's cause for alarm. However, the way we've built this model that's actually not a problem at all. If we look at the Mezzanine and the Preference shares and what we see is that the Mezzanine and the Preference shares are increasing and they're creating actually a 110.7 change. That 110.7 is not currently being picked up on our cashflow statement anywhere because we're not showing the change in the preference shares or the Mezzanine because they're non-cash changes. So this will straighten out once we take care of the interest in the dividends in the next section.