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
Qui error sunt aut libero voluptate. Officia rerum velit totam et enim quia omnis. Inventore molestiae error et voluptatem et dolores impedit. Optio fuga quia culpa consectetur. Occaecati ducimus placeat non optio eos. Autem voluptatem labore ipsum officia voluptatum voluptate illo id. Sed aut ut rem odit aspernatur qui porro.
Animi magni repellat harum autem. Aperiam eveniet ratione nostrum amet voluptatem.
Ea modi assumenda dolorem ullam error expedita blanditiis. Beatae qui recusandae et delectus repellendus corporis quos. Nihil quia earum eos fuga sunt ipsa. Neque ratione officiis reiciendis in. Et nemo et commodi eum possimus ad hic.
Enim dolor et et dolores. Incidunt dolores quia ullam. Est distinctio quisquam velit nemo et.
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...