Quick question for IB / PE analysts —
Have you ever had a deal where EBITDA or net debt changed and you had to manually update it in the model, deck, and IC memo… and still worried something was inconsistent?
I’m prototyping a tool that tracks where assumptions flow and flags everything that breaks when a number changes.
Curious if this is a real pain or just a “welcome to finance” thing.
| +150 | Senior Banker's Guide to IB Recruiting / Group Placement (with a Healthcare Bent) | 19 | 2h |
| +120 | Is pay at BofA really that bad? | 60 | 7h |
| +97 | As Lehman people reconvene at UBS, Barclays needs to hire (2023) | 18 | 1h |
| +88 | Day at Macquarie | 12 | 7h |
| +44 | Is the life of a VP at a 'top-bank' really good? | 15 | 3d |
| +44 | How bad did I mess up | 10 | 13h |
| +31 | Misrepresented Houston IB | 14 | 18h |
| +29 | Law school instead of MBA for RX Banking | 6 | 11h |
| +29 | No BB RO 2026 | 10 | 2d |
| +28 | JPM SMALL CAP or WF/JEF/RBC Coverage group | 13 | 3h |
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.
yes please
can you please share a bit more about how you've experienced this? :thank you!
i've been screamed at for everything not tieing in the deck
Do people not link things to FactSet cells and then update all links so it automatically ties back?
I still print stuff to tie it but that's just good practice, thought this was common across banks
I used to do the same when I was in banking but there'd be times that we'd adjust assumptions based on our view of company so in those cases we'd need to tie across multiple places
Know some banks do it and some banks don’t, mainly related to version control issues
No way I'd trust FactSet figures
FactSet add in lets you link any Excel file, it's just the functionality from the add in. My firm links all numbers directly to our models, just hit refresh all links to update
There is software that already exists like this for accounting in particular for making large regulatory documents like 10-K filings where one change impacts many others.
One thing that I don't like about these is while they update things easier, you're putting a lot of trust in the original data being correct. When you are ticking and tieing important docs, I still find myself having to double check where a particular number is coming from and whether it is correct. Then, you have to also make sure all the data is properly linked to the correct places. Again, another possibility for error and also after you've done that, I'm not sure that you've saved any time at all.
what software is that? auditing and trusting the source are the important features for these tools, i don't think there are many that we can confidently rely on
Quia consequatur odit sit numquam aliquid similique. Suscipit est eius provident ut non blanditiis vitae. Sed dignissimos aspernatur perferendis omnis assumenda. Veniam alias dolor omnis quas. Quaerat modi magnam a ratione. Ea voluptatibus est aut consequuntur dolorum.
Quia quo nobis facilis est consequatur architecto et amet. Est distinctio optio voluptas dicta et.
A rerum qui in ut provident architecto quaerat. Harum sed nam ut perferendis totam dolorem. Et est voluptatibus eum. Numquam voluptatem non sunt. Nisi voluptas voluptatem voluptate corrupti. Dolores atque id quasi itaque nesciunt omnis esse.
Iusto quos deserunt ut odit aperiam autem. Eos laboriosam consequatur qui ad et ut eos. Quae odit praesentium dolores a. Laudantium qui et quas eveniet.
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...