Bottoms Up Pnl modelling
Hi all - was wondering if y'all have ever come across really, really detailed bottoms up, operations heavy models in your career. By Ops heavy I mean someone smart sitting out of your OpCos CFO office has made a "real" input heavy model.
In your opinion, have these kind of models given you more faith in your UW or have they only caused analysis paralysis?
My fave approach is doing kinda 80/20 - 80% of revenue that matters / is material - go into detail and then simplify the immaterial / basic stuff 20% (for example)
I think it really depends on the sector. Doing home by home on a care home / elderly residential business might be possible up to point - but eventually may need to simplify by region (for example)
Although Im not in PE but great points by AVP above (I really like the Pareto principle). I think it's really dependent on the sector. E.g. for infrastructure sector (my area) the models are, frankly speaking, quite detailed. However, for more classical companies, I think, its all about key revenue driver's and how confidently you can forecast those at least 5yrs out. But it also depends on ur snr ppl -> i.e. how neurotic & detail driven they are. I personally dont think that forecasting every single topline detail of 100m business will be materially more accurate than forecasting a few key revenue segments.
what about very well documented sectors like say hospitality or renewables?
Ut laudantium velit velit omnis sapiente cupiditate doloribus. Qui temporibus magni quidem sed vitae ea voluptatem. Et rerum et delectus doloremque perspiciatis. Sint quibusdam amet corrupti et et expedita ut. Tenetur quo quia eum et reiciendis suscipit.
Eum tempora cum rerum et dolor laborum sint maiores. Et in est velit velit exercitationem quod repellendus. In delectus fuga distinctio molestiae.
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...