Question

In: Finance

Merger Analysis TransWorld Communications Inc., a large telecommunications company, is evaluating the possible acquisition of Georgia...

Merger Analysis TransWorld Communications Inc., a large telecommunications company, is evaluating the possible acquisition of Georgia Cable Company (GCC), a regional cable company. TransWorld's analysts project the following post-merger data for GCC (in thousand of dollars): 2015 2016 2017 2018 Net Sales $482 $540 $584 $631 Selling and administrative expense 42 52 61 69 Interest 18 21 24 27 Tax rate after merger 30% Cost of goods sold as a percent of sales 80% Beta after merger 1.663 Risk-free rate 6% Market risk premium 5% Continuing growth rate of cash flow available to TransWorld 7% If the acquisition is made, it will occur on January 1, 2015. All cash flows shown in the income statements are assumed to occur at the end of the year. GCC currently has a capital structure of 40% debt, but Trans World would increase that to 50% if the acquisition were made. GCC, if independent, would pay taxes at 20%; but its income would be taxed at 30% if it were consolidated. GCC's current market-determined beta is 1.50, and its investment bankers think that its beta will rise to 1.663 if the debt ratio were increased to 50%. The cost of goods sold is expected to be 80% of sales, but could vary somewhat. Depreciation-generated funds would be used to replace worn-out equipment, so they would not be available to TransWorld's shareholders. The risk-free rate is 6%, and the market risk premium is 5%. Do not round intermediate calculations. What is the appropriate discount rate for valuing the acquisition? % (to 2 decimals) What is the continuing value? $ thousand (to 1 decimal) What is the value of GCC to TransWorld? $ thousand (to 1 decimal)

Solutions

Expert Solution

Discount Rate for acquisition will be derived from CAPM. Hence, discount rate = Risk Free Rate + Market Risk Premium X Beta = 6% + 1.663 X 5% = 14.32%

Continuing Value of GCC would be based on current situation of business (without bringing in the effects due to TransWorld). The breakdown of free cash flow will be as follows:

2015 2016 2017 2018
Net Sales 482 540 584 631
COGS (80% of Sales) 386 432 467 505
Selling and administrative expense 42 52 61 69
EBITDA 54 56 56 57
EBITDA X (1-Tax Rate) 44 45 45 46

Considering depreciation is given as equal to capital expenditure. Hence, EBITDA X (1-Tax Rate) will be the free cash flow generated. Discount Rate in the continuing case is 13.5% (considering a beta of 1.5).

Using the standard FCF to EV calculation, we can calculate the continuing value as shown below:

Year 1 Year 2 Year 3 Year 4
Free Cash Flow 43.5 44.8 44.6 45.8
Terminal Value = FCF in Year 4 * (1+ Growth Rate)/(Discount Rate - Growth Rate) 753.3
Discounted Free Cash Flow 38.3 34.8 30.5 481.5
Enterprise Value 585.1

Hence, continuing value (in thousand of $) = $ 585.1

Now, to calculate value to TransWorld, we will change the applied discount rate & tax rate.

For transworld, free cash flow calculation will be:

2015 2016 2017 2018
Net Sales 482 540 584 631
COGS (80% of Sales) 386 432 467 505
Selling and administrative expense 42 52 61 69
EBITDA 54 56 56 57
EBITDA X (1-Tax Rate) 38 39 39 40

In this case, the EV calculation will be as follows:

Year 1 Year 2 Year 3 Year 4
Free Cash Flow 38.1 39.2 39.1 40.0
Terminal Value = FCF in Year 4 * (1+ Growth Rate)/(Discount Rate - Growth Rate) 585.7
Discounted Free Cash Flow 33.3 30.0 26.1 366.4
Enterprise Value 455.9

Hence, the value of GCC to TransWorld will be $ 455.9 (in thousands of $).


Related Solutions

*please show work thank you MERGER ANALYSIS TransWorld Communications Inc., a large telecommunications company, is evaluating...
*please show work thank you MERGER ANALYSIS TransWorld Communications Inc., a large telecommunications company, is evaluating the possible acquisition of Georgia Cable Company (GCC), a regional cable company. TransWorld’s analysts project the following post-merger data for GCC (in thousands of dollars):                                                       2015 2016 2017 2018 Net sales                                     $450 $518 $555 $600 Selling and administrative expense    45     53       60     68 Interest                                               18      21      24 27 Tax rate after merger 35% Cost of goods sold as a percent...
Merger Valuation with Change in Capital Structure VolWorld Communications Inc., a large telecommunications company, is evaluating...
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 year end of December 31): 2016 2017 2018 2019 2020 2021 Net sales $450.0 $518.0 $  555.0 $  600.0 $  643.0 Selling and administrative expense 45.0 53.0 60.0 68.0 73.0 Interest 40.0 45.0 47.0 52.0 54.0 Total net operating capital...
Martin Technologies Inc., a large electronics company, is evaluating the possible acquisition of Columbia Electronics, a...
Martin Technologies Inc., a large electronics company, is evaluating the possible acquisition of Columbia Electronics, a regional electronics company. Martin’s analysts project the following post-merger data for Columbia (in millions of dollars): 2015 2016 2017 2018 Net sales $300 $425 $475 $550 Selling and administrative expense 40 50 60 75 Interest 25 30 35 40 Tax rate after merger 35% Cost of goods sold as a percent of sales 75% Beta after merger 1.2000 Risk-free rate 4% Market risk premium...
Trans Corp, a large conlomerate is evaluating the possible acquisition of the chip company. Transcorp analysts...
Trans Corp, a large conlomerate is evaluating the possible acquisition of the chip company. Transcorp analysts project the following post merger incremental cash flows. Years                         CF 2003 12 2004 19 2005 23 2006 29 2007 and beyond       Constant growth rate at 10% Chip currently has a market value capital structure debt of 10%, but transcorp would increase it to 50% if the acquisition were made. Chip, if independent pays30% taxes, but its income would be taxed at 40% if...
APV Problem: SAE Corp., a large cap tech firm, is evaluating the possible acquisition of the...
APV Problem: SAE Corp., a large cap tech firm, is evaluating the possible acquisition of the Benchmark Company, an electronic manufacturer. SAE Corp’s analyst projects the following post-merger free cash flows in ($millions).                                                                                             2020              2021             2022              2023 Net Sales                                                          $       200.0 $       230.0 $       257.0 $       269.8 Cost of Goods Sold                                                 130.0             140.0            145.0            150.0 Selling/G&A Expenses                                              20.0               25.0              30.0              32.0 EBIT                                                                   $         50.0 $        ...
List at least three weaknesses of the Merger and Acquisition analysis.
List at least three weaknesses of the Merger and Acquisition analysis.
TTT Corp is evaluating the acquisition of KT Company.  TTT analyst projects the following post merger cash...
TTT Corp is evaluating the acquisition of KT Company.  TTT analyst projects the following post merger cash flows for KT Company if purchased by TTT Corp. Net Sales Year 1 $600 Year 2 $700       Oper Expenses        Year 1 $350 Year 2 $400         Interest Year 1 20 Year 2 25         Depreciation Year 1 10 Year 2   10          Net Investment Year 1 10 Year 2  10          In Operating Capital The current market beta for KT Company is 1.4 and its tax rate is 25%...
Star Computer and a small telecommunications company are considering a merger. A socially-minded member of Star...
Star Computer and a small telecommunications company are considering a merger. A socially-minded member of Star Computer's board of directors is against the merger, however, because she is concerned that the merger might not benefit society as a whole. Provide the board member with an argument for why it may be socially beneficial for the merger to take place. Write the argument in 500 or more words.
Star Computer and a small telecommunications company are considering a merger. A socially-minded member of Star...
Star Computer and a small telecommunications company are considering a merger. A socially-minded member of Star Computer's board of directors is against the merger, however, because she is concerned that the merger might not benefit society as a whole. Provide the board member with an argument for why it may be socially beneficial for the merger to take place. Write the argument in 500 or more words.
Company XYZ is analyzing the possible acquisition of a privately-held oil company called O&G Inc. The...
Company XYZ is analyzing the possible acquisition of a privately-held oil company called O&G Inc. The financial information for O&G is shown below: Revenues in 2018 $30 million COGS as % of revenues 64% Tax rate on income 35% Depreciation as % of revenues 2.25% CAPEX as % of revenues 3% Working capital as % of revenues 2% Company XYZ estimates that it can increase O&G’s free cash flows by reducing operating costs and capital expenditures. They estimate the following...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT