Model - Sources and Uses of Funds 2
- 02:12
Understand how to calculate leverage ratios implied by a financing structure and relevant interest rates
Transcript
Once our sources and uses of funds have been done, we then want to do a check on it We want to check the leverage ratios i.e your debt to EBITDA So I'm going to start by looking at the revolver So I'm going to sum the revolver and strangely itself What I then want to do is I want to lock on the second of the G40s What I'm going to do is I'm going to copy this down and it will gradually include the revolver and term loan A And then the next one it will include term loan B, so it will gradually accumulate up the debt So I sum those items and then I want to divide them by the EBITDA And we've got that, a little bit further of the page of 123 Again I'm going to lock onto that So at the moment with the revolver we can see that's given us multiple of zero (so that's okay) As I copy it down, I can see that multiple goes up to 3.5 Now I know the kind of maximums I'm looking for here are 6.5 or 6 times EBITDA 6 is getting very very high So as we've included term loan A, it's gone up to 3.5 (that's okay). Let's include term B Get's up to 4.8, it's getting a bit high now. I include the PIK loan, gets up to 5.4 (getting quite high) And the senior unsecured notes? 6 and that is our maximum threshold there, so we're okay at the moment The last thing I want to do is I want to do interest rates I want the interest rate on the revolver and I can see that is currently a spread of 2%, so I need to add that onto something We've got over in our interest assumptions here and we're going to add that onto U.S. 3 month LIBOR I press F4 to lock onto that And I can now copy that down So I copy that down for all of the items underneath, so term loan A, B and the PIK loan But not for the senior unsecured notes For the senior unsecured notes, we're going to use a slightly different assumption We're going to take the spread but that spread is now going to be over benchmark government bonds of 1.8% Fantastic! And there are my interest rates all done with the formulas showing