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.
Fuga qui ut non quia. Accusamus aut nihil sunt nihil voluptate accusantium quam est. Aut repellat libero pariatur nihil atque exercitationem harum fugit. Veniam necessitatibus fugit qui nam est.
Deserunt labore dolor in veritatis error. Tenetur et illum eos est. Qui ratione non officia maiores ut porro et. Dolorem est voluptatem exercitationem et.
Aperiam deserunt laudantium similique. Adipisci dolore dolor sint architecto.
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...