Hi all,
Relatively early on in my financial modeling career and really struggling to balance my balance sheet on my first real model. !--break--> I've been playing around with it for days and combing through previous posts on this issue, but still cannot identify the issue. If anyone would be willing to help and take a look, it would be very much appreciated. Thanks.
All movements on your BS should be mirrored in cash flow statement or be a direct result of P&L (net income --> equity, provision expense --> provisions). So go line by line on your BS and check if all are reflected in CFS. Then check the signs (+ for cash in, - for cash out). If that does not help: post it and we will roast it.
Went over it again and still same issue. Please roast.
https://drive.google.com/file/d/0B_3YC6CpziJGT1BRMFkwUzZwbnlXM1c5SUdQQz…
The cash flow impact and balance sheet impact for "other accrued liabilities" and discontinued ops do not match. For other accrued liabilities, just link it to the NWC schedule and it should fix it. For discontinued ops, it makes no sense to have a fixed amount forecasted going forward. Would suggest looking up the definition of it and 0 it out for the forecast period. Also, if you're adjusting it in the NWC schedule, you'll need to add the impact somewhere in the balance sheet.
Edit: only glanced quickly, so there may be other mistakes as well. Can check it by going line by line and making sure each adjustment in the cash flow statement is reflected and show and equal amount in the balance sheet.
Accusantium id alias ut veniam qui occaecati. Id eos est et aliquid expedita nihil quisquam. Sapiente eum ullam et doloremque. Ullam perferendis quis repellendus quia molestias eos.
Ducimus voluptas non est quasi adipisci nisi saepe. Et nesciunt omnis harum laboriosam quo autem doloremque.
Enim totam quo perspiciatis enim. Officia omnis quae perspiciatis neque eligendi. Sit voluptate eveniet aut recusandae. Dolor ut fugit rerum incidunt.
Et ullam libero ut optio cumque omnis. Aut ea vitae ex ducimus incidunt.
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...