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 🙏
| +433 | Don’t work at UBS - UBS Sucks | 40 | 28m |
| +327 | Article - UBS’ Investment Bank Keeps Losing Ground | 41 | 4d |
| +183 | Should My Intern Get a Return Offer? | 53 | 4h |
| +63 | When to Leave Office as Intern | 8 | 5d |
| +56 | F*ck it I'm Going to Med School | 19 | 1d |
| +39 | What do you say to ppl who don’t know EVR/LAZ/CVP/PJT | 29 | 23h |
| +39 | Would you rather be a Touse Squid or a Bouse Mogger in IB | 2 | 5d |
| +38 | Living in greenwich as an analyst? | 8 | 1h |
| +32 | STEM student lost in London IB recruiting | 18 | 6h |
| +28 | Getting Laid in IB? | 13 | 31m |
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
Fugiat dolorum rerum quia consequuntur. Provident impedit illum non in. Optio sed voluptatem eveniet sint non esse quasi. Quaerat aliquid dolorum neque est suscipit. Voluptatibus vel quisquam nam. Ea molestiae ut voluptatem voluptas voluptas. Consectetur facere ea sapiente voluptatibus ea est.
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...