Hi guys, really in desperate need for some help. I've built a model from scratch for the first time and it doesn't balance, I've been staring at it for some time and idk what to fix. Would appreciate anyone kind enough to help me with it 🙏
| +178 | Americas M&A League Table Q2 Updated | 74 | 29m |
| +132 | New Article: Dramatic Slide as UBS #22 (US) & New Leadership Desperately Needed | 27 | 17m |
| +109 | Restructuring: Anti-climactic Experience | 29 | 29m |
| +80 | IB Net Worth / Savings Check | 31 | 40m |
| +74 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 12 | 1d |
| +51 | Boutique firm wants access to my LinkedIn? | 40 | 1d |
| +39 | Investment Banking is Hard | 17 | 21h |
| +31 | PWP vs BofA | 23 | 3h |
| +25 | Who pays the highest right now? | 14 | 3h |
| +21 | Big 4 Transaction diligence (FDD) vs Valuations and modeling for goal to get in IB | 5 | 4d |
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.
I can help! I think you can attach the model to your discussion thread.
This is a rite of passage and you should probably try to figure out what’s going on by yourself. Just go down the cash flow statement line by line and make sure the balance sheet is picking up each one (other than through the net change in cash).
If that doesn’t work, you might have balance sheet lines that are changing without any impact to the cash flow statement
Agree with above. Doesn't matter if it takes a day or a week. Don't panic and get through this right of passage.
Agreed. Back when I was starting, usually the problem for me was that not all of the BS items were reflected properly on the Cash Flow. Once I got rid of that, never again I had to worry about balancing the BS. See if that's the problem maybe.
Post the model, would love to see it.
Hi everyone, thanks for the replies, I really appreciate them. Unfortunately, I cannot post a link to my model as I do not have enough points to do so. Can I kindly DM a kind soul to help me with it?
You can DM me, I'd want to see it
Hi thank you so much, I have DMed you
If your model doesn’t balance it’s because you didn’t build the cash flow statement correctly, assuming it’s a basic model without cash sweep or debt paydown assumptions feeding BOP cash balances.
Check that you didn’t accidentally flip the signs on balance sheet items. (Negatives as positives)
Check that as asset increase, cash decreases.
As L&E increase, cash increases.
Check that your cash / revolver is wired into the balance sheet correctly and you have accounted for cash draw to fund revolver if you have negative cash flows
Facere exercitationem suscipit sint. Illum adipisci deleniti non vel suscipit molestiae. Quae quaerat repudiandae cupiditate excepturi accusantium neque dolorem. Et blanditiis similique aut ut tempora cupiditate. Est possimus consequuntur ut deleniti ex est. Voluptatem aperiam excepturi numquam quo iure.
Nulla quidem quis praesentium animi ut eveniet eligendi. Dolore est reprehenderit et ipsam quod. Odio adipisci et earum ipsum excepturi aut soluta. Eum voluptatem inventore qui consequuntur quisquam voluptatem nihil. Perspiciatis nostrum inventore sunt animi expedita.
Voluptatem et accusantium quod libero numquam velit amet. Provident odit autem non aut libero iure animi. Et nam architecto et amet voluptatem veritatis sed. Adipisci ut illum consectetur atque quia.
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...