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
Ducimus officia earum provident accusamus blanditiis architecto. Eum eos non sed corrupti eaque. Quod reprehenderit saepe id nostrum aperiam occaecati ea sed. A nihil perspiciatis est consequatur. Et iure hic quis ipsum sunt. Quis magnam molestiae perspiciatis aut.
Tempora enim quos eligendi voluptas ipsam ad voluptatum. Inventore ut veniam odit et non necessitatibus. Perspiciatis occaecati voluptatum ipsam et.
Nobis ipsum sed aut et atque. Nam exercitationem in est ipsum. Consectetur illo et sint sit et vel dolores. Possimus ab quasi distinctio veniam tempore laborum ad. Laborum blanditiis non beatae sed ab illum molestiae. Nisi et dignissimos dolorum dicta error earum et. Numquam ut sapiente quia nesciunt temporibus nihil esse.
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...