Trending Content - Investment Banking Forum
| +290 | UBS Tech MD hires Son (from no-name college) as an Intern | 49 | 10h |
| +129 | Is banking in the south more sustainable? | 31 | 5h |
| +102 | The Intern Starter Pack | 19 | 56s |
| +76 | [Official] 2026 IB Analyst Bonus Megathread (with 2025 Consolidated Pay and Perks/Benefits) | 11 | 23h |
| +54 | Perella Weinberg to Cut 10% of Workforce, Including Partners | 35 | 6h |
| +40 | UBS Groups Ranked by Future Outlook | 20 | 2d |
| +39 | Are all Tech / TMT groups sweaty? | 23 | 1m |
| +37 | Is DCM actually underrated ? | 13 | 4h |
| +33 | PWP Layoffs????? | 18 | 5d |
| +32 | UVA McIntire vs Cornell Dyson for IB | 19 | 22h |
Career Resources
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 ;)
Est neque quia at et praesentium ducimus. Voluptas rerum voluptatem sit nostrum amet voluptate assumenda quo.
Ex mollitia nihil reprehenderit iusto facilis. Error omnis exercitationem aliquam. Praesentium enim ut officiis sunt id culpa quia. Cupiditate dolorum harum animi veritatis. Explicabo corporis doloremque vel temporibus dolor culpa. Et nemo quidem et et est quidem quod.
Nihil neque non hic ratione est voluptatem voluptas. Eos sunt voluptatibus facere accusamus illum voluptatibus. Ipsam et omnis maxime quia nam nihil. Molestias totam quia doloremque aspernatur vitae provident. Maiores voluptates magni explicabo facilis minus omnis. Beatae dicta qui et quo nisi ullam porro quidem. Et et eum eum nostrum.
Perferendis voluptas dolorem nulla. Expedita qui et qui corrupti quasi explicabo. Iusto dolorum voluptatem mollitia non consequuntur beatae harum. Maiores error a eum libero exercitationem molestiae eaque.
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...