Model - Debt Tranche 2
- 02:05
Understand how to model accelerated repayments.
Transcript
Here we want to go through two debt tranches, we want to look at the bond, and after that, we'll have a look at the term loan, the 6.375%. So for our bonds, my beginning balance is last year's ending, but we find we don't have any accelerator repayment on a bond, this is completely normal for a bond, repayment will only happen maturity. So my mandatory repayment can just link straight up to the assumptions, and at the moment, none has been paid off. My ending amount, the sum of those above.
Now, cash available for remaining accelerator repayments is just the 80.5 we had before, we haven't made any accelerator repayments involving the bond. So now, we move on to our third and final debt item, our beginning balance is last year's ending, the mandatory repayment is the minus minimum of the beginning balance, and we then compare that to that negative of the assumption.
I want to change the assumption, which is currently a negative into a positive, then I can compare beginning balance positive with the assumption positive.
We pay off nothing, the acceleration repayment, again, starts with the minus min, and we ask, "How much do we owe?" Well, I owe the 15,000 plus the zero that I paid off, and then I compare that to the 80.5 of cash that I've got available. So how much will I pay off? I'll pay off 80.5. I then want to multiply that by the acceleration switch, I'm going to lock onto that by pressing F4, and we pay off the 80.5. Let's just make available that formula, there it is. My ending balance, the sum of the items above, and now, the cash that we've still got available for the accelerated repayment is the 80.5 plus the 80.5 we spent. The only cash that we would have available after that to maybe going to next year's repayment is zero.