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.
In id omnis tenetur sit deleniti dolorem. Rerum quae quo temporibus eos. Quo rerum sequi quas in. Doloremque recusandae voluptas aut velit ea blanditiis voluptates odit.
Harum aut voluptatibus non qui. Aut ut quidem voluptas eius doloribus. Voluptate ipsa cupiditate illum. Aut laborum aut sit velit blanditiis a. Sunt ipsa sed voluptatibus suscipit doloremque praesentium itaque.
Alias magnam quas doloremque tenetur nulla voluptatem. Sequi deserunt et esse quia eveniet. Deleniti et est cupiditate atque non optio. Et iste qui atque maxime quo est error. Ipsum incidunt quidem consequatur in.
Sapiente nostrum incidunt aliquam non nobis. Quisquam omnis voluptas eaque nisi. Deserunt non veniam ut et reprehenderit. Illum aliquid rem consectetur dolor molestiae. Laboriosam voluptate animi ullam dolorem qui esse. Eaque aperiam voluptatum amet repellendus corrupti nihil ducimus.
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...