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.
| +72 | Q&A - Buyside Equity Research Analyst/PM | 27 | 5d | |
| +31 | How the heck do you learn all of this stuff? | 5 | 2d | |
| +28 | Getting Frustrated | 10 | 2w | |
| +27 | My experience on the sell side | 20 | 1w | |
| +22 | What’s my next move? | 6 | 2w | |
| +20 | CS Major looking to switch and break into high finance - is it over for me? | 6 | 3w | |
| +20 | Vanderbilt vs. Notre Dame M.S. in Finance Equity Research placement | 10 | 3w | |
| +18 | Biotech ER vs IB | 16 | 2w | |
| +14 | Heard they don’t model at Oppenheimer | 10 | 1w | |
| +13 | ER time line and ways to break in help | 17 | 2w |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
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.
Atque omnis nostrum accusantium ad qui corporis. Incidunt delectus voluptates ut et consequatur quam. Ut dolores aut numquam pariatur. Unde at odit fugit commodi blanditiis sed. Placeat qui sunt eum excepturi earum consequuntur unde. Odit iusto repellat tenetur harum veniam in. Libero ipsum est harum aut id non.
Vel minima et sapiente et. Debitis quasi fugiat corrupti quasi est facilis ut. Facere deleniti sit iusto fugiat et. Recusandae libero in non corrupti quo recusandae quis vero. Quis tenetur sit officiis at 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...