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.
Enim animi omnis voluptates eos labore quia. Qui unde quo repudiandae optio nisi voluptatem possimus neque. Esse voluptatum earum voluptatem velit dolorem. Nam eveniet eveniet et et neque dolores dolorum.
Et natus at tenetur temporibus eveniet similique reiciendis. Quasi facere nostrum ex reprehenderit. Temporibus neque aperiam qui ut ut est aliquid. Aliquam qui aut velit. Nihil autem earum saepe culpa nam. Veniam qui quam aut est exercitationem sunt architecto. Accusantium molestiae incidunt corporis vitae tenetur enim.
Vero itaque consequatur rerum. Dolorum at autem suscipit nulla.
Omnis illum dolorem est. Qui eligendi voluptate sint nisi. Vero deserunt voluptates sapiente quia facilis qui ea ad.
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...