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
Career Resources
WSO Free Modeling Series - Now Open Through
May 31, 2024
9 Free Financial Modeling Lessons
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.
+Bonus: Get 27 financial modeling templates in swipe file
+Bonus: Get 27 financial modeling templates in swipe file
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.
Est autem sit recusandae harum. Molestiae rerum quia placeat officia blanditiis. Et veniam laboriosam et voluptatem perferendis impedit. Nisi nisi ipsam eos beatae id dolor.
Nihil qui vero sint rem. Quia vitae aut vero consequatur.
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...