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.
| +255 | Return Rates For Interns Are Falling? | 104 | 6h |
| +136 | UBS Americas IB: The Kids’ Table of Wall Street | 18 | 12h |
| +111 | I am a drunk MD AMA | 39 | 22h |
| +72 | Article: Why UBS's Asian M&A bankers are thriving and UBS's American M&A bankers are not | 9 | 2m |
| +64 | VP Lifestyle at Top BB Coverage Groups | 40 | 1d |
| +60 | UBS Offer Day | 23 | 12h |
| +57 | An Outsider’s View of RX Banking Out of College | 6 | 4d |
| +50 | SharePoint makes IB hours HELL | 15 | 4d |
| +40 | WF Return offers | 27 | 7h |
| +36 | I hate Wells Fargo | 6 | 8h |
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
Id aut ea quia nam vel earum rerum quis. Eaque impedit ex qui non ipsa error eum. Et ipsum unde eveniet voluptatem.
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...