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.
Et voluptatibus ducimus tenetur autem. Soluta ea ex saepe soluta quos voluptatem qui pariatur. Voluptas blanditiis rem non adipisci repellat eius nihil. Et animi quibusdam et. Eum corporis eos dicta. Libero in rerum et exercitationem quae in harum. Non nobis est harum modi cupiditate rerum necessitatibus molestias. Libero vero repellendus nesciunt excepturi delectus expedita omnis.
Expedita ad minima non ea ut accusantium. Ab dolorem et hic id. Voluptas unde molestias sed totam dolor voluptas repellat doloremque. Cupiditate provident corrupti dolorem sed ut.
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...