Cable M_A Model.xlsx - ($ mil 2014E Revenues EBITDA Acquirer CHTR Target TWC 9,787 3,447 35 3 23,865 8,617 36 1,000 Cash New Debt Total Debt Net Debt

Cable M_A Model.xlsx - ($ mil 2014E Revenues EBITDA...

This preview shows page 1 - 3 out of 3 pages.

($ mil) Acquirer Target 2014E CHTR TWC Revenues 9,787 23,865 EBITDA 3,447 8,617 35% 36% Cash 3 1,000 New Debt Total Debt 14,023 23,718 Net Debt 14,020 22,718 New Equity Value New Shares Total Shares 112.1 280.9 Stock Price $128.91 $135.31 Equity Value 14,451 38,009 Enterprise Value 28,471 60,727 Net Debt/EBITDA 4.07x 2.64x Debt/EV 49% 39% EV/EBITDA 8.26x 7.05x EV/Sales 2.91x 2.54x Stock Deal Premium Synergies Equity Ownership 50.1%
Image of page 1
+ Premium Combined
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 3 pages?

  • Spring '11
  • RichardM.Levine
  • Debt, Valuation, total debt, new equity value

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes