Trending Content - Investment Banking Forum
Career Resources
WSO Free Modeling Series - Now Open Through
October 31, 2026
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
High Finance Applications
Guaranteed
Get at least one offer GUARANTEED
- 1:1 support
- 92% success rate
- 2,000+ mentor network
- Unlimited Live bootcamps
- AI for resume + LinkedIn
- Networking automation tools
- HireVue simulation tool
- Full course library
- Private Slack community
- 20hrs of mocks
- + much more...
Simple mistakes here. 1) you were linking your Balance Sheet cash to last years total current assets, link it to ending cash on your CFS. 2) you hardcoded 2017 BOP shareholders equity across, needs to be linked to previous years end SHE. 3) you zero'd out row 84 Deffered consideration from acquisitions, keep that constant at 1,000 across your pro forma.
Real legend, both of you. Thanks so much - hope you win a lottery ;)
You have 3 problems in this model that are making it not balance:
1. Row 60: Cash is linked incorrectly on the balance sheet. You have it linked to the ending balance of total current assets. Link it instead to the cash flow statement.
2. Row 96: BoP shareholder's equity is hardcoded. It should be linked to the ending SE in the previous period.
3. Row 131: You're not including the change in other current liabilities on the Cash Flow Statement. Use this formula: =SUM(G84:G85)-SUM(F84:F85)
LMK if you still have trouble balancing the model and I can send my version over to you.
Real legend, both of you. Thanks so much - hope you win a lottery ;)
Qui maiores natus officia nostrum debitis ut eligendi. Quam aspernatur ex mollitia odit dolores suscipit quo aut.
Nihil est quaerat sit et quo. Illum sapiente occaecati tenetur libero vero rerum. Ex ipsum quia necessitatibus. Esse qui numquam quas exercitationem velit consequatur. Quo consectetur repellendus nobis omnis occaecati libero totam. Quasi esse quo est est nesciunt dolores quidem quia. Sit libero repellendus quibusdam quo cumque et deserunt.
Maxime ut aut tenetur. Repellat officia atque consequatur est earum sunt. Voluptatum et deleniti eum sed. Incidunt qui qui quisquam vel illum. Nam ex doloribus laboriosam et. Odio accusantium ex tempora dolorum eveniet quis tenetur.
Minima quo dolorem et ut quaerat ut omnis. Ut reiciendis sed alias tenetur et. Dolorum neque vel fugit voluptatem molestias magnam inventore. Eos est nihil aut et quas eveniet nemo. Quo in maiores tempora et autem. Quo laboriosam quia animi autem 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...