Forbes magazine experts said they rarely liked acquisitions, in terms of the value they created for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. Date June 2016 April 2016 Lions Gate Entertainment Corp. Comcast Corporation EXHIBIT 6: COMPARABLE MERGERS AND ACQUISITIONS TRANSACTIONS (IN US$) Acquirer Company Target Company Starz Inc. Deal Value $4.40 billion EBITDA Multiple 10.9x November 2012 News Corporation August 2009 The Walt Disney Company DreamWorks Animation SKG Inc. Yankee Entertainment and Sports Network Marvel Entertainment Group Inc. $3.80 billion 32.3x $3.90 billion 12.2x $4.24 billion 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 P/E Ratio EV/EBITDA Entertainment Division (Warner Brothers) The Walt Disney Company 16.23 9.51 21st Century Fox Inc. 15.93 9.01 CBS Corporation 15.29 10.97 Channels and Network division (Turner and HBO) AMC Networks Inc. 12.54 5.93 Discovery Communications Inc. 13.64 8.75 Scripps Networks Interactive Inc. 10.57 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 Free Cash Flow (2016) Inputs (in $ millions) 1.9 from Bloomberg 5% common practice for North America 35% marginal tax rate EBIT Depreciation & Amortization Capital Expenditure Working Capital 2016 Working Capital 2015 6,583 669 432 3,782 4,511 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. 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. Date June 2016 April 2016 Lions Gate Entertainment Corp. Comcast Corporation EXHIBIT 6: COMPARABLE MERGERS AND ACQUISITIONS TRANSACTIONS (IN US$) Acquirer Company Target Company Starz Inc. Deal Value $4.40 billion EBITDA Multiple 10.9x November 2012 News Corporation August 2009 The Walt Disney Company DreamWorks Animation SKG Inc. Yankee Entertainment and Sports Network Marvel Entertainment Group Inc. $3.80 billion 32.3x $3.90 billion 12.2x $4.24 billion 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 P/E Ratio EV/EBITDA Entertainment Division (Warner Brothers) The Walt Disney Company 16.23 9.51 21st Century Fox Inc. 15.93 9.01 CBS Corporation 15.29 10.97 Channels and Network division (Turner and HBO) AMC Networks Inc. 12.54 5.93 Discovery Communications Inc. 13.64 8.75 Scripps Networks Interactive Inc. 10.57 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 Free Cash Flow (2016) Inputs (in $ millions) 1.9 from Bloomberg 5% common practice for North America 35% marginal tax rate EBIT Depreciation & Amortization Capital Expenditure Working Capital 2016 Working Capital 2015 6,583 669 432 3,782 4,511 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.
Expert Answer:
Answer rating: 100% (QA)
Answer To calculate the Weighted Average Cost of Capital WACC we need to use the following inputs provided in Exhibit 8 Weight of Debt 21 Weight of Eq... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Here are data on two companies. The T-bill rate is 5.0% and the market risk premium is 6.2%. Company $1 Discount Store Forecast return 13% Standard deviation of returns 13% Beta 1.6 Everything $5 12%...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
1. Based on the information provided in the case below, what is the key strategic goal for Tim Hortons as of August 2014? It would be a year of dramatic change for Tim Hortons Inc. On August 26,...
-
Three charges are placed as shown in the figure below. A scale is provided for the distances. Match the numerical values with the appropriate force of interaction. 19=8c a. b. 9=-2C I'm 93=4...
-
Return on T- bills. Lauren purchased a $ 40,000 T- bill for $ 38,400. A few months later, Lauren sold the T- bill for $ 39,000. What was Laurens return on the T- bill?
-
According to Edelman (2011), the widely used online "trust" authorities issue certifications without adequate verification, giving rise to adverse selection. Edelman finds that TRUSTe certified sites...
-
You have overheard the following statements: (a) The role of independent auditors is to prepare the financial statements of the company. (b) International Accounting Standards (IASs) apply to all UK...
-
The county collector of Sun coast County is responsible for collecting all property taxes levied by funds and governments within the boundaries of the county. To reimburse the county for estimated...
-
On January 1, 2021, Dreamworld Co. began construction of a new warehouse. The building was finished and ready for use on September 30, 2022. Expenditures on the project were as follows: January 1,...
-
Over the past 70 years, the return on the market (S&P 500 index) exceeded the risk-free rate by an average of 6-8%. In other words, the market risk premium (RM-RRF) has averaged between 6-8%. For...
-
Qualitative variables can be divided into two types: and __________________. In Exercises 510, fill in each blank with the appropriate word or phrase.
-
A sample of convenience is when it is _____________________ reasonable to believe that there is no systematic difference between the sample and the population. (Choices: acceptable, not acceptable)
-
A ___________________ variable is a quantitative variable whose possible values can be listed. In Exercises 510, fill in each blank with the appropriate word or phrase.
-
A poll is conducted of 3500 households close to major national airports, and another 2000 that are not close to an airport, in order to study whether living in a noisier environment results in health...
-
In a randomized experiment, the treatment groups do not differ in any systematic way except that they receive different treatments. In Exercises 1116, determine whether the statement is true or...
-
37. funds are created when individuals or organizations contribute resources with the agreement that principal and/or income will be used to benefit individuals or private organizations. A) Custodial...
-
The following items were displayed in the statement of affairs for Lubbock Company: Fully secured liabilities ......... $90,000 Partially secured liabilities ....... 12,000 Unsecured liabilities...
-
In Caroline Company, total material costs are \($48,000\), and total conversion costs are \($60,000\). Equivalent units of production are materials 10,000 and conversion costs 12,000. Compute the...
-
Sota Company has the following production data for April: units transferred out 40,000, and ending work in process 5,000 units that are 100% complete for materials and 40% complete for conversion...
-
Motta Company has the following production data for April: units started and completed 40,000, and ending work in process 5,000 units that are 100% complete for materials and 40% complete for...
Study smarter with the SolutionInn App