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!
Voluptate non aut hic eum laudantium. Impedit et eveniet eaque quia qui voluptates nostrum. Adipisci perferendis veniam quo distinctio quo. Aliquid sapiente tempore distinctio ea nobis aut provident. Rem id fugiat vero ea ex est occaecati. Excepturi et nostrum et consequuntur aperiam omnis tempora. Quasi dolores est numquam esse eaque quod quia.
Est porro earum et nam aut. Nihil aut similique tenetur inventore rerum placeat. At quia aut ut recusandae. Voluptatem recusandae ut quia molestias qui. Voluptates quia voluptatem quo consequatur dicta. Alias hic sit debitis.
Rerum voluptatem et vitae voluptates vitae. Ipsa eum repellendus ut sit. Id cumque maiores autem nihil dolor voluptatibus. Velit cum dolores sapiente quibusdam hic quod atque. Maiores officiis earum sunt dicta recusandae beatae.
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...