Model - Debt Schedule 2
- 01:52
Understand how to forecast PIK notes and senior unsecured notes without prepayment
Glossary
Mezzanine Paid In Kind PIK Note Senior UnsecuredTranscript
In total there are five different types of debt in our debt schedule The revolver, term A and term B have been done But we still need to work on the mezzanine loan (or the PIK note) and the senior unsecured notes balance Let's start with our mezzanine loan The mezzanine loan had an ending balance and deal date of 75 That's how much went into the deal, my beginning balance is going to be the same figure But a PIK note does not have repayments during its term, it also doesn't have any interest payments That means the interest will gradually accrue up, so that the value of the loan increases That means at the end, debt holders are paid back more than they originally lend to us That's what we mean by paid in kind, they are paid more capital than they lend to us So my ending balance will be the beginning balance plus the interest My senior unsecured notes balance, interest is going to be paid on this But the senior unsecured notes won't be repaid in the short term That means my ending balance this year will be exactly the same as last year Lastly, we need our cash balance. Cash balance helps us calculate interest income That cash balance comes from the bottom of the cash flow statement, so I scroll all the way down an we can see the cash balance is zero Why is it zero? Because every time we get some cash, we spent it on debt repayment and we can see a good example here Cash available for debt repayments 50.9 is being fully used in this case to repay term loan A Let's copy all of these figures to the right, so my mezzanine loan, senior unsecured notes and cash balances are all filled in And we can see the cash balance does eventually start to go above zero once the revolver, term A, term B have been repaid