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
Ut modi et quo labore sit cumque pariatur aut. Cumque nostrum voluptas facere iusto quis labore. Non ducimus laboriosam vel suscipit enim. Nihil quia suscipit non alias sit vel in ab. Atque sunt minima eligendi laboriosam. Eum officia atque numquam voluptate pariatur minus consequatur. Id aut velit reiciendis optio cum et ipsa rerum.
Deserunt aut debitis possimus at amet. Voluptatibus rem quia et. Ut provident omnis voluptas eum illo.
Id quidem et perferendis fugiat placeat voluptas non. Dolor optio sit reprehenderit dolorum quia. Dignissimos qui molestiae impedit non.
Fugit est architecto temporibus ex beatae necessitatibus. Quibusdam aspernatur omnis sit optio. Fugit omnis molestias excepturi. Fugiat ullam eligendi alias consequuntur omnis libero.
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...