Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

5% Revenue growth per year in each of the next five years and improve the operating margin to 12% DPC value goes from $3,970 to

  1. 5% Revenue growth per year in each of the next five years and improve the operating margin to 12%
DPC value goes from $3,970 to $4,859, which is an increase of $889 million.
  1. Assume part a and that the division can be sold at 7.5 x EBITDA in five years (continue to use exhibit 9 for your calculations simply adjust the TV)
DPC value goes from $4,859 million to $5,102 million, which is an increase of $243 million.
  1. Assume part a and b and that debt financing equal to 6x forward EBITDA (yr1) can be obtained
    1. Begin by estimating total Debt Balance off 2012E EBITDA (input that into cell D21)
    2. Calculate interest expense per year and include in the model (row 31)
    3. Assume the residual cash flows are used to pay down the debt balance each year (update debt balance in row 21) Hint- each year should have a different interest expense as your debt is paid down over the holding period
    4. Calculate the PV of the tax shield and include that in the model
  1. Total debt balance off is $3,926
  2. Interest expense per year is $265
  3. Shown on Excel
  4. Calculated PV of tax shield as $210 million

5. If a PE sponsor has a target return of 20% on its funds (i.e. their equity contribution), what is the maximum affordable price it can offer DPC (assuming all the assumptions are held from Question 4)?

6. Assume that a PE firm purchases DPC for $4,800 million, what is the resulting IRR for the PE firm? Assume the same set of assumptions in Question 4.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Handbook Of Credit Portfolio Management

Authors: Greg Gregoriou, Christian Hoppe

1st Edition

0071598340, 978-0071598347

More Books

Students also viewed these Finance questions