LBO Modelling - Balance Sheet and Cash Sweep
Hi all,
I am currently a student training LBO modelling and I have the following problem.
After doing a cash sweep, my balance sheet does not balance anymore.
So I had very simple assumptions:
- Assets:
- Cash
- Working Capital
- PP&E
- Goodiwl
- Liabilities:
- Working Capital
- Debt
- Equity
- Equity
After I used my whole CashFlow my Debt has been reduced. However, my assets did not change since my Change in Cash is Zero. How can I balance the BS. Can I just use equity as a plug? So the change in Debt would be added to my Equity Balance? Is this correct?
Edit: Thanks I found the problem.
However, I have a follow on question. How do I model a carry loss forward? If I have a negative netincome, can I declare this as a carry forward and model it as a deferred tax assets? Or does the negative net income still directly flow into shareholders equity. In this scenario, how do I keep track of my Net operating losses?
Thanks
Check if net income is correctly flowing into your shareholders equity balance sheet line.
Your change in cash can’t be zero, since you swept it to repay debt, i.e. that should have been reflected in the cash flow statement under financing cash flow. The closing cash balance as a result of net movements (incl. that cash sweep) is a balance sheet item that should fix the issue.
Neque suscipit rem praesentium illum iste omnis minima. Ut inventore id nisi rerum iure non quam. Inventore vitae a rem laborum. Beatae odio rem officiis voluptatibus incidunt id. Neque quo natus nemo atque.
Commodi dolore suscipit quod nihil. Impedit quasi non cupiditate laudantium laboriosam temporibus sunt.
Voluptates veniam est est eum recusandae maiores omnis. Dignissimos sed minima similique numquam culpa placeat nam. Cumque dolorum qui ut eum nesciunt. Tempora culpa quis ut optio voluptatem voluptatem.
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...