Model - Debt Schedule 1
- 01:50
Understand how to forecast ending balances for individual debt instruments
Glossary
Cash Sweep Debt Issuance Debt Repayment WaterfallTranscript
In order for the debt repayments to work properly in our cash flow statement, we need a debt schedule that's all filled in So we'll start with our revolver, our revolver balance at the moment is zero And I want grab the repayment that's been made from the cash flow statement So I scroll down to the cash flow statement and there's our revolver issuance for repayment at the moment we had zero revolver so we are paying off zero as well If I take the beginning balance and add on that repayment, that gives me an ending balance of zero Term loan A might make a bit more sense, so we have 425 as our beginning balance Let's scroll down to our cash flow statement and find that repayment. That repayment was 50.9 So I take the beginning balance, add on the repayment and my ending balance of 374.1 Term loan B, we need to do the same thing again Let's go down and find that repayment in the cash flow statement And that repayment is this case was zero So ending balance of term loan B still stays the same Let's copy those three items to the right, so revolver, term loan A and B So we take them into their 10 years, let's see what's happened to term loan A It gradually gets paid down down down And eventually gets paid off, and we might notice that when term loan A gets paid off Term loan B starts to be repaid Let's see what's happening in the cash flow statement there So in my cash flow statement, yes term loan A repayments happen And eventually as term loan A gets paid off Term loan B starts to be repaid I can see that the full 83.2 that we've got available in that year is spread over term A and term B There's the 83.2 there