How do you usually structure the debt schedule? I think the clearest way to go about it is to structure it as follows:
CF Available for debt service Debt 1 (BOP, repayment, EOP, interest) CF Available for debt service of second tranche Debt 2 (BOP, repayment, EOP, interest) CF after debt servicing / Change in cash Cash (BOP, change in cash (line above), EOP, Interest) Revolver (BOP, drawn/repaid, EOP, Interest + commitment fee on undrawn)
However, in the WSO PE course, the full LBO 1 is structured as follows:
CF Available for debt service Cash (BOP, change in cash (line above), EOP, Interest) Revolver (BOP, change in cash (line above), EOP, Interest) And then the debt tranches.
Again, I think the first structure is far clearer, taking it step by step and displaying CF available for next element. However, I have come to realize that my way is flawed: when CF is negative, the revolver is drawn, but it is then not repaid until tranche 1 debt is fully repaid (i.e. Debt 1 is prioritized).
So my question is - how do you usually structure the debt schedule? Which is the easiest way (least risk for errors).
Thanks!
Commodi molestiae saepe omnis eos non eaque. Esse veritatis enim delectus et et sed dolores.
Autem ratione accusamus molestiae odio. Aut at earum aut ipsa. Ut incidunt et eius voluptatibus quaerat voluptatibus eveniet. Assumenda quod voluptas magnam quia laboriosam ut odio. Consequatur dolores accusantium voluptatem aut tempore qui.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...