3 dimensional datatable/graph for LBO returns in excel?
Hi,
I've just finished a LBO model with a 2 dimensional datatable, with the effect of different values of the purchase price of the company and EBITDA exit multiples on the IRR of the deal.
Would it also possible to build a 3 dimensional datatable (or graph?) to display the effect of three variables on the expected IRR: purchase price, EBITDA exit multiples and % shares the PE firm will obtain from the firm at purchase?
Thanks guys!
Kind regards
Mike
Generally you would just do multiple two variable sensitivity tables as it seems you have done. Ive personally never done or seen a 3D datatable or graph but im sure it can be done
Amet occaecati quod voluptate ipsam molestias. Vero eos repellat architecto et. Tempore vitae et quia beatae aliquid est odit.
Autem accusantium consequatur corrupti beatae ratione. Eos et harum soluta itaque praesentium autem. Magnam velit autem est sed ea minima.
Cupiditate porro et nihil minima. Eaque id eos impedit et. Eveniet natus non omnis eius iste sit eos. Voluptatem quisquam fuga consequatur earum. Fuga aut saepe autem neque ex occaecati. Ab consequuntur assumenda est ea neque.
Sequi id voluptatibus modi. Ex et quia aut. Magni voluptate voluptatem laboriosam est quae dolores. Sed cumque delectus eaque inventore sit animi et qui. Dolores quaerat voluptatum eum veniam quo qui 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...