LBOS and sensitivity tables: easy question
hi team. quick question for all.
so for a data table in an LBO, the inputs need to be on the same tab for the data table to run properly. but if someone is trying to bring in an operating model with many tabs to link into the LBO income statement, how can you sensitize around operating model inputs (since there will be many inputs spread across several different tabs)....? do you have to somehow recreate the operating model to just be simply on 1 tab (where the LBO analysis would also be)?
thanks in advance guys. much appreciated!
https://www.sumproduct.com/thought/data-tables-with-off-sheet-inputs
Is this something you have seen deployed before?
Yes, do this all the time. PE ppl love their goddamn sensitivities so damn near every important input ends up being this.
Hardcode the input on the same tab with the data table and then link that back to the other tabs where that input is needed. That way, you can use the data table and also have that input work throughout the rest of the model.
Consequatur voluptas quos assumenda aspernatur dignissimos. Magnam ab excepturi ab eum qui earum. Velit et earum tempora provident et officiis aut.
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...