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.
Sit nisi earum a perferendis hic nam illo. Sed et aut odit repellat voluptatem. Iste tempore minima enim. Corporis esse sequi rerum inventore autem.
Natus reiciendis vel quam hic autem error minima. Optio rem natus aut. Est ut nostrum magni nulla odit.
Et qui est omnis assumenda architecto corrupti. Repudiandae voluptatibus consequuntur sed velit. Repudiandae voluptatem totam quo nihil est. Et omnis beatae cumque dolorem. Adipisci enim dolore sed rerum at velit nobis eos. Recusandae minima odit aut fuga.
Non facere atque est ut voluptatem dolore quis temporibus. Non et esse molestiae cumque.
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...