Unitranche
- 04:19
LBO modeling complexities Unitranche
Glossary
LBO LBO modeling Private Debt Private Equity unitrancheTranscript
For the unitranche, we're going to continue on in the same fashion. Now, for unitranche, in general, it's not going to be mandated because amortization is typically not part of unitranche facility. So we're just gonna go ahead and model it the same way, because having too much flexibility is generally not an issue in a model. So what we'll do here is, again, just for our cash flow available for unitranche, we're gonna take the cash flow that's available for second lien, and we'll net from that by way of adding the negative, the accelerated repayment from the second lien. Now, the likelihood that there would be second lien or first lien ahead of unitranche in a structure is obviously very slim, but because the way the waterfall works, the cash is gonna flow down, and it'll just keep flowing if there's no draw on the cash or there's no implementation of the cash in the first lien or second lien. So even if we have a unitranche that is the the sole provider of the financing in the structure, the waterfall will still work for us, if we model it in this way. So I'm gonna go ahead here and get my unitranche ending balance from my balance sheet proforma, and that's gonna be in row 24, combo year. And I think just to illustrate the model a little bit better, I'm gonna go ahead and turn my unitranche setting on, so that we can see what's happening here. So now, we see that I do have debt in the unitranche, and that's gonna become my beginning balance in the unitranche for 2016. In terms of what we repay, we've got an assumption here for the repayment above, so I'll simply just go ahead and link my repayment assumption to that beginning balance and anchor that beginning balance. And then, I'll set that against the beginning balance. So once again, we're not repaying more. So if I just wanted to test that assumption, if I had 25%, it's showing a repayment.
In terms of the acceleration, that's gonna be a minus min of the sum, or the net of my beginning and my repayment, set against whatever cash flow I have available for acceleration. And here it is showing that I have that, and as I said, it's typically not a part of unitranche that we accelerate. That's one of the reasons why they set these up, to give the sponsor the flexibility in managing the company to perhaps pool the cash and use it for other purposes, like investing in the company or M and A activity to help grow the EBITDA. So I am gonna go ahead and link this to my accelerator, and I'm gonna turn my accelerator off. So now my ending balance is simply the net of all of those. And for interest, once again, I'm gonna do an if, I'm gonna go back to my LBO page, I'm gonna take my rate for the unitranche. I'm gonna say, if that equals by chance, N/A, then I want a zero. If not, I wanna take that 9.5%, and I wanna multiply that by the average of my ending balances.
And I wanna flip this to be a negative, so that I get negative interest. And the last thing I need to do here is make sure that my J38 is anchored, and now we will be ready to copy when it's time. And I also wanna go back and just check my anchor to the acceleration toggle and make sure that that is anchored to E54 as well.