B/S won't balance - please help!!!
Hey guys,On the way of projecting forecasts, I've encountered a problem in the B/S not balancingg...
Trending Content - Off Topic Forum
| +73 | Uchicago is paradise | 14 | 2d |
| +52 | BofA VP killed in random NYC stabbing | 36 | 9h |
| +45 | What Bank Will Make Women Instantly Fall In Love With Me? | 14 | 9h |
| +28 | How the Hell Do People Actually Get Into Private Golf Clubs? | 26 | 3d |
| +20 | Why do Asians fake their names? | 40 | 9h |
| +13 | POLL: Optimistic or Pessimistic? | 9 | 3d |
| +9 | At what salary can you start calling it “fi-NANCE” | 2 | 14h |
| +7 | Who is making these posts on WSO Linkedin ? | 5 | 2d |
| +1 | Someone just coined "the view" | 3 | 2d |
Career Resources
Well just post your model here. You think people are really gonna PM you AND do your homework?
100%, the best way to balance an unbalanced balance sheet is to set up a new column that takes the difference of two years (20X1 and 20X2), then reconcile all your changes in the BS (e.g. AR goes up $100 year-over-year) with a corresponding entry or entries in the cash flow statement (increase in AR of $100 year-over-year). Then highlight both in green if you've got a match. Continue this until you've found your discrepancy. Do the actual cash balance last in your sequence.
Plug other current assets, guaranteed no one will even notice.
Or, you could actually look through the cash flow statement and reconcile those line items to your balance sheet and income statement. That should uncover your mistake.
Labore quis quia ipsa. Beatae perspiciatis et quos tempora quisquam ducimus debitis. Et distinctio laboriosam ut non tempora id autem. Rem at nulla dolorem cumque accusantium omnis incidunt.
Eaque et nostrum sunt voluptas quis. Sunt eos expedita blanditiis iste quis doloremque reprehenderit. Veritatis ipsa qui ut quisquam dolores. Aut vel ut iste impedit earum.
Eveniet aliquam eum et earum est. Est dolorem aliquid vero voluptatem velit. Vero eum est suscipit sunt est voluptatem beatae nam. Ipsum repellat aut quam. Voluptatem voluptate ut aspernatur minus delectus. Rerum explicabo et et autem modi id.
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...