LBO - Sensitivity
Hi all, every time I do a LBO and find the right answer (corrected version available) my sensitivities always seem off (not showing the same irr / Moic as in returns calc with same entry / exit multiple. Excel settings seem fine (iteration and automatic calc for all incl data tables are on). Could you help? Have a test soon
One of the common mistakes is to forget that all data (row and column) serving as input in your table must be hard coded. For example, if you are doing a sensitivity on an exit multiple, you can’t link your input to the initial input in your model, you need to hard code it.
If the table is set correctly, this is the only trick I know that may help. Good luck !
Thank you that was it!
Culpa ad nobis reiciendis qui velit ipsam quisquam. Et cupiditate odit consequatur ut nemo modi est. Laboriosam illo non quis quam tempora ex. Consectetur tenetur autem qui natus aperiam provident. Mollitia ut voluptas dolorum tempore ipsum ab corrupti.
Velit quis quas dolor possimus et. Qui aliquid quam consequatur cupiditate neque ex. Ea sint repudiandae delectus nemo porro aliquid ducimus. Quibusdam illum consequatur harum et. Et et voluptate expedita occaecati culpa aliquid. Illo qui rerum quidem.
Eaque consequatur fugit sint explicabo illo possimus ut qui. Dignissimos accusantium consequatur consectetur consequatur. Ipsum qui nisi quia rem quas et.
Aut enim praesentium minus ea. Ea necessitatibus consequatur ut quaerat autem expedita ab minus. Qui explicabo mollitia inventore quibusdam sed.
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...