See Volworld.docx

Answer all questions please using excel ,

Hints are given

Merger Valuation with Change in Capital Structure VolWorld Communications Inc., a large telecommunications company, is evaluating the possible acquisition of Bulldog Cable Company (BCC), a regional cable company. VolWorld's analysts project the following post-merger data for BCC (in thousands of dollars, with a December 3 1 year-end): If the acquisition is made, it will occur on January 1, 2010. All cash flows shown in the income statements are assumed to occur at the end of the year. BCC currently has a capital structure of 40% debt, which costs 10%, but over the next 4 years VolWorld would increase that to 50%, and the target capital structure would be reached by the start of 2014. BCC, if independent, would pay taxes at 20%, but its income would be taxed at 35% if it were consolidated. BCC's current market-determined beta is 1. 40. The cost of goods sold is expected to be 65% of sales. a. What is the unlevered cost of equity for BCC? Hint = 10.96% b. What are the free cash flows and interest tax shields for the first 5 years? MILLIONS HINT : FCF1= $ 23.12 , TS1 = $14 , FCF3 = $12.26 , TS3=$ 16.45 , FCF5 =$23.83 , TS5= 18.90 c. What is BCC's horizon value of interest tax shields and unlevered horizon value? Hint : HVts = $510.68 million , HVul= $ 643.89 million d. What is the value of BCC's equity to VolWorld's shareholders if BCC has $300,000 in debt outstandingnow? Hint : Value of equity = $ 508.57 million