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.
Impedit est tempora ipsa et dignissimos. Aperiam quas in cupiditate. Dicta quis pariatur dolorem consectetur. Libero numquam accusamus ex neque inventore et.
Autem voluptatum id est soluta hic. Quae et quos doloremque et.
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...