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.
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
Aut et earum iste nihil. Eum id quia et voluptatem aspernatur ipsam. Aut architecto odio aut rerum ratione atque et sit. Tenetur unde quas vel vero. In quidem velit nihil aspernatur qui rem. Sit qui earum expedita nemo perspiciatis mollitia. Nostrum perspiciatis aliquam natus et sint non delectus odit.
Voluptate est iusto rem. Praesentium veniam earum corrupti amet. Quam necessitatibus nihil quia eius. Ut praesentium rerum iure molestias sed consequatur. Porro impedit rerum maiores ducimus. Explicabo dolores ipsam neque voluptate laborum quisquam in.
Illum quod est totam cupiditate quisquam id. Eum excepturi non pariatur voluptatum incidunt qui rerum laboriosam. Voluptatem similique temporibus itaque expedita eveniet.
Non nam et dolores ad velit expedita. Recusandae dolores expedita incidunt ab quaerat ea et delectus. Quo vero officia iste qui autem.
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...