I've constructed a simply model in relation to a software company, and can't get the BS to balance.
The annual difference is 9.9 but I can't locate the problem anywhere?
Any help would be greatly appreciated!!
| +202 | UBS preparing for a October Layoff Massacre | 177 | 2h |
| +84 | Work and Suicide | 37 | 7h |
| +79 | A Message to Students Who Think this Job Will Fix Their Life | 15 | 2h |
| +52 | Is 7 years in banking enough to retire, or am I delusional? | 29 | 5d |
| +47 | Do actual investment bankers despise IB TikTokers as much as I think they do? | 28 | 1d |
| +32 | UBS IB Balance Sheet Set to take a Hit | 9 | 13h |
| +27 | Should I escape the matrix | 5 | 1d |
| +23 | LevFin, First Interview (Ever) Help! | 5 | 1d |
| +21 | JPMorgan Banker Hospitalized | 7 | 2d |
| +19 | Interview with BofA | 10 | 1d |
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.
Is the difference also in the historicals? If so, your historicals are wrong and that's the problem.
If not, hit CTRL + ~ to see all formulas (and if you hit it again it turns off) and look through all the cells in the first year and see if there's a hardcoded number somewhere.
Edit: also, unhide all rows
Unfortunately the historical balance sheets balance, it's only when I forecast from 2020 onwards where the error occurs.
However, you were right and I could eliminate the 9.9 difference..now I'm only out by 1.2.
Any tips to find this last variance?
Thanks again, you have no idea how long I've been looking at this model for!
Unfortunately the historical balance sheets balance, it's only when I forecast from 2020 onwards where the error occurs.
However, you were right and I could eliminate the 9.9 difference..now I'm only out by 1.2.
Any tips to find this last variance?
Thanks again, you have no idea how long I've been looking at this model for!
what i like to do is
highlight all B/S items that change and thus affect the CFS and make sure they are correctly linked 1 by 1 then unhighlight them as you go along
create a new version and strip out all the drivers, then the model should balance, then add them back one by one to either balance it or find out where the imbalance lies
also would check that your NWC changes are calculating correctly
Sounds stupid and you probably have already done it, but also check for typos somewhere, or maybe you added one line to many. The mistake could also lie in retained earnings, so look at your incom statement as well.
Look out for cash flows. They should be 100% linked back to your balance sheet correctly. Most common errors are an opposite sign for WC. GL.
Officiis fugiat est non nesciunt sapiente consequatur. Occaecati reprehenderit dicta iure aut laudantium tempora. Magnam ex repellendus inventore corporis. Dignissimos distinctio ab voluptate labore ullam dicta.
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...
Beatae atque voluptatum ea et id quisquam dolores. Alias laborum placeat explicabo et aut voluptatem. Veniam rerum aut voluptate quo nulla dolores qui. Error quia occaecati blanditiis possimus voluptatem eos. Aperiam est amet iure. Temporibus sed labore est consequatur cupiditate necessitatibus quasi.
Assumenda incidunt quos iure ut dignissimos a eaque. Suscipit quidem sed possimus commodi voluptate vel est. Aut asperiores doloremque ut alias fugit vel.
Sint sed accusamus repudiandae quia ut eos dolorem nisi. Est suscipit dicta inventore voluptas voluptatibus hic. Ut et voluptatem dignissimos quas molestiae officiis. Veritatis aspernatur libero dolor repudiandae quod iste et molestiae. Porro iste doloribus consequatur ipsa labore ut et. Dicta molestiae est eos dolores ipsa recusandae. Dolor vel quia velit laboriosam.
Laudantium enim voluptate voluptas molestiae inventore quam iure. Amet quae fuga voluptas quos aut consequuntur. Aspernatur voluptatum eius sunt alias. Consequatur dolorum delectus dolore unde at.