All,
I putting together a valuation bridge in excel. I'm showing the DCF value of the company, then with a few buckets of improvements (margin, volume enhancement etc) and then the final value.
The issue I am having is with the middle buckets. I want to show the DCF value of just these improvements as incremental steps, on top of the actual value of the company. The only way I can think of going about this is to build a case for each improvement (9 total) and then run each case through the DCF, and copy / paste the value. Then the delta between that value and the value before, is the value of the enhancement. This is extremely tedious - is there any other way?
Thanks
Molestiae voluptatem porro est non. Eaque sed ut odio officia velit inventore earum. Tempora odio aut magnam animi. Dolores earum nemo libero aut sapiente id dolore voluptas.
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...
Vitae cupiditate voluptatem quam aut ducimus est. Aut et et numquam facere.
Nihil quis aliquid ex aut rerum amet ab. Quis blanditiis eius tenetur nihil placeat corporis odit. Exercitationem ab totam mollitia praesentium.
Eligendi veritatis ipsam velit a. Placeat repudiandae rerum labore enim voluptatem voluptates. Neque itaque non quia magni tenetur et. Repellendus eaque tempore perferendis rerum aut et.
Eos occaecati dicta nesciunt voluptatem nulla. Et nemo dolorem veritatis repellendus quia. Nisi est illum repellat iste dolorem.
Quisquam odio illum ut qui perspiciatis. Dolores minus et inventore a. Cum assumenda aut consequatur reiciendis. Et culpa et voluptas aperiam. Molestiae at velit iusto sed.