Please include Excel formulas and Excel spread sheet for visual reference. I will have a thumbs up when answered! thank you very much!
Forbes magazine experts said they rarely "liked" acquisitions, in terms of the value they created for acquirers, and were often left "disappointed by how much the acquiring company overpays. 29 AT&T would pay $108.7 billion to acquire $5.1 billion of Time Warner's net operating profit after tax. According to the Forbes article, the return on invested capital (ROIC) would be 4.7 per cent, marginally improving AT&T's current ROIC of 4.6 per cent and equal to its weighted average cost of capital of 4.7 per cent. This deal would modestly improve AT&T's overall ROIC.30 Frank had to evaluate these differing opinions, and she needed to conduct a valuation analysis independently. She first collected data on previous comparable mergers (see Exhibit 6) and on comparable major competitors of Time Warner (see Exhibit 7). She found Time Warner's EBITDA for the trailing 12 months, which was $8,790 million, and its earnings-per-share ratio as of September 30, 2016, which was 4.62. She also obtained all the firm fundamental information she could find about Time Warner (see Exhibit 8). Frank believed that the synergies from the merger would potentially help Time Warner maintain 8 per cent growth in free cash flow for the following five years, based on the company's historic average growth rate. However, she also thought that a more modest 7 per cent growth rate for the next five years would be more realistic. For the terminal growth rate after the fifth year, Frank decided she would follow the common practice of the majority of the financial analysts who covered the media industry and use 3 per cent. Frank would call the AT&T and Time Warner CEOs without hesitation if she had any questions. But with all the information she had collected so far, she believed that she was ready to work on the valuation of Time Warner. Then, she would need to defend her valuation analysis in front of her investors. EXHIBIT 6: COMPARABLE MERGERS AND ACQUISITIONS TRANSACTIONS (IN USS) Date June 2016 April 2016 November 2012 August 2009 Acquirer Company Lions Gate Entertainment Corp. Comcast Corporation News Corporation The Walt Disney Company Target Company Starz Inc. DreamWorks Animation SKG Inc. Yankee Entertainment and Sports Network Marvel Entertainment Group Inc. Deal Value $4.40 billion $3.80 billion $3.90 billion $4 24 billion EBITDA Multiple 10.9% 32.3 12.2 12.7x Note: Note: EBITDA = earnings before interest, taxes, depreciation, and amortization Source: Created by the case authors using data from Bloomberg. EXHIBIT 7: MULTIPLES OF MAJOR COMPETITORS IN THE MEDIA INDUSTRY 7 P/E Ratio EV/EBITDA 16.23 15.93 15.29 9.51 9.01 10.97 Entertainment Division (Warner Brothers) The Walt Disney Company 21st Century Fox Inc. CBS Corporation Channels and Network division (Turner and HBO) AMC Networks Inc. Discovery Communications Inc. Scripps Networks Interactive Inc. 12.54 13.64 10.57 5.93 8.75 4.74 Exhibit 8: WACC Inputs Weight of Debt Weight of Equity Cost of Debt Risk-Free Rate Beta Market Risk Premium Tax Rate Notes: 21% 0.21435 79% 100% - weight of debt 3.50% most recent bank loan interest rate 2.31% long-term governance bond yield 1.9 from Bloomberg 5% common practice for North America 35% marginal tax rate Free Cash Flow (2016) Inputs (in $ millions) EBIT 6,583 Depreciation & Amortization 669 Capital Expenditure 432 Working Capital 2016 3,782 Working Capital 2015 4,511 11 1. Calculate the WACC using the given information. 2. Forecast 5 years of FCF using the assumptions given. 3. What is the value of Time Warner? 4. Is AT&T is making a good decision or bad decision by buying Time Warner for the price they're paying
