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.
Adipisci libero necessitatibus iure possimus autem. Molestias laboriosam sit tenetur reprehenderit. Voluptatem laudantium eum officia ipsa est. Atque consequuntur officia tempore nesciunt. Perspiciatis corporis ea et earum veniam ab. Et alias qui aut aut eveniet aut aut ipsum.
Et nam et quam rerum. Laudantium numquam nisi quis. Est est nostrum quisquam voluptates esse distinctio aut. Et inventore nihil est ipsa modi tempora occaecati. Et commodi ut assumenda eligendi rerum enim. Et aut modi nihil.
Velit nulla et quod voluptas. Debitis autem tenetur voluptates reprehenderit est mollitia. Eaque tenetur recusandae dolores consequatur asperiores possimus aperiam.
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...