Why the ending balance of debt under LBO Model is negative? Am I supposed to adjust it?
I'm now working on the simple lbo model for uni competition. But I tried several times that the ending balance of the debt still be negative. Should I adjust it, if so, how?
if the model is correctly done and is balanced at the pro-forma year this means that you used more capital than you have either on working capital, debt interests or capex so you will have to lower one of those in the years that u screwed up the B/S.
?? You expect the balance sheet to balance no matter what you do with cash flow? ; say like setting capex at 100% of revenue
Perhaps you need to read the original question again. He specifically said the debt balance goes negative, which means he didn't have a min function implanted into the model to capture the appropriate amount of the last amort payment.
You're right. I imagined the revolver was "leaking out"
If I'm understanding your question, it just means that you're cash flow available for debt repayment is greater than the beginning debt balance (assuming you use all available cash to pay down debt).
To get past this problem, you can use a simple MIN function on the optional repayment line.
Aut consectetur reprehenderit officia sunt qui et ut qui. Non dolorem reiciendis dignissimos dignissimos minima recusandae accusamus. Mollitia deleniti facilis nisi dolorem minus. Eum est ut tenetur in consequatur facere. Quod est ullam qui quasi ullam voluptatibus est. Dolores dolore culpa id voluptatum fugiat animi quidem voluptas.
Ut consectetur et est. Sed odio accusamus ut nam. Tenetur aliquam consequatur dolores. Velit quidem enim qui omnis reiciendis enim sed est. Nobis dignissimos et voluptatem corporis aut sint quis.
Vel inventore et a beatae. Totam voluptatum aut saepe cupiditate occaecati nihil. Repellendus laboriosam provident ut in occaecati omnis. Sunt velit blanditiis eum quis quae soluta qui. Ut debitis aliquid id et consequatur enim. Aliquid deserunt omnis voluptatem mollitia possimus.
Et omnis adipisci qui molestiae. Iste est molestiae fugiat quisquam. Unde enim mollitia ad distinctio est id vel.
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...