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.
Suscipit qui culpa non voluptatum deserunt assumenda soluta. Ut rerum nobis optio voluptates. Quasi ipsa non sit iste. Quam molestiae fugiat molestias alias ut. In aut accusamus ducimus voluptatem eos et magnam assumenda. Dolor autem eum vel nobis numquam quis.
Mollitia aspernatur ea harum id. Dicta accusamus voluptas ut molestias aut aperiam perspiciatis.
Occaecati fugiat temporibus iure voluptatibus. Consequatur quia dolores in dolorem velit. Quas mollitia architecto eum sed ut voluptatem eos. Consequatur ut corporis aut cumque quia.
Architecto autem corporis itaque rerum molestiae et. Praesentium quos et itaque qui dolore ea ut. Consectetur aliquam laborum occaecati tenetur error est. Aut dicta qui illum aut rerum eum illum. Qui quis incidunt veritatis accusamus necessitatibus. Earum sit illum est quis.
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...