Question

In: Finance

*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 of sales 65%
Beta after merger 1.50
Risk-free rate 8%
Market risk premium 4%
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 35% if it were consolidated. GCC’s current market-determined beta
is 1.40, and its investment bankers think that its beta would rise to 1.50 if the debt ratio
were increased to 50%. The cost of goods sold is expected to be 65% of sales, but it
could vary somewhat. Depreciation-generated funds would be used to replace wornout
equipment, so they would not be available to TransWorld’s shareholders. The riskfree
rate is 8%, and the market risk premium is 4%.
a. What is the appropriate discount rate for valuing the acquisition?
b. What is the continuing value?
c. What is the value of GCC to TransWorld?

Solutions

Expert Solution

a). Appropriate discount rate will be the cost of equity for GCC after the merger.

Using CAPM, cost of equity = risk-free rate + beta*market risk premium

= 8% + (1.5*4%) = 14%

Formula

Year

(All numbers in $'000s

except %age)

2015 2016 2017 2018 2019
Time period (n) 1 2 3 4 Terminal
Growth rate (g) 7%
Net sales             450.00                 518.00                 555.00                 600.00
65%*Sales COGS             292.50                 336.70                 360.75                 390.00
SG&A                45.00                   53.00                   60.00                   68.00
Interest expense                18.00                   21.00                   24.00                   27.00
EBT                94.50                 107.30                 110.25                 115.00
Tax @ 35%                33.08                   37.56                   38.59                   40.25
Net income                61.43                   69.75                   71.66                   74.75                   79.98
FCFEterminal/(k-g);
k = 14%, g = 7%
Terminal value             1,142.61
FCFE                61.43                   69.75                   71.66                   74.75             1,142.61
1/(1+k)^n Discount factor @ 14%                0.877                   0.769                   0.675                   0.592                   0.592
(FCFE*Discount factor) PV of FCFE                53.88                   53.67                   48.37                   44.26                 676.52
Sum of all PVs Total equity value             876.69

b). Continuing value (or terminal value) = 1,142,607.14

c). Value of GCC to Transworld = 876,691.39


Related Solutions

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...
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...
PLEASE SHOW WORK IN EXCEL THANK YOU! Green-Log Manufacturing Capital Budgeting Analysis In 1997 Michelle Green...
PLEASE SHOW WORK IN EXCEL THANK YOU! Green-Log Manufacturing Capital Budgeting Analysis In 1997 Michelle Green started Green-Log Manufacturing, a company dedicated to manufacturing environmental friendly man made logs that can be burned in fire places, fire pits in the backyard, and when camping. The logs are made from environmental friendly products like cardboard and clean wax and emit fewer greenhouse gases and less harsh chemicals. The logs come in three pound and five pound sizes. Green-logs are also available...
Please show all work and explanations. Thank you On 1-1-2017 Avion, Inc. Sold Bonds with these...
Please show all work and explanations. Thank you On 1-1-2017 Avion, Inc. Sold Bonds with these particulars: Face amt. of Bonds 825,000 Matures on 1-1-2027, in 10 yrs. Stated annual rate of int. 12.00% Effective annual rate of interest 10.00% Int. is paid every six months; 6-30, 12-31 Req. 1, Assume the effective Interest Method in accounting for these Bonds, build a 10 year amortization table Req. 2, Give General Journal entries to record the sale of the bonds, and...
Please show all work and calculations, Thank you! On 1-1-2017 Avion, Inc. Sold Bonds with these...
Please show all work and calculations, Thank you! On 1-1-2017 Avion, Inc. Sold Bonds with these particulars: Face amt. of Bonds 630,000 Matures on 1-1-2027, in 10 yrs. Stated annual rate of int. 7.25% Effective annual rate of interest 6.00% Int. is paid every six months; 6-30, 12-31 Req. 1, Assume the effective Interest Method in accounting for these Bonds, build a 10-year amortization table Req. 2, Give General Journal entries to record the sale of the bonds, and the...
Please show all work and calculations, Thank you! On 1-1-2017 Avion, Inc. Sold Bonds with these...
Please show all work and calculations, Thank you! On 1-1-2017 Avion, Inc. Sold Bonds with these particulars: Face amt. of Bonds 630,000 Matures on 1-1-2027, in 10 yrs. Stated annual rate of int. 7.25% Effective annual rate of interest 6.00% Int. is paid every six months; 6-30, 12-31 Req. 1, Assume the effective Interest Method in accounting for these Bonds, build a 10-year amortization table Req. 2, Give General Journal entries to record the sale of the bonds, and the...
PLEASE show you work so it is easier to undersand, thank you!! There are two parts...
PLEASE show you work so it is easier to undersand, thank you!! There are two parts to this problem a) & b) A company made the following expenditures in connection with the construction of a new building: Architect’s fees $12,000 Cash paid for land and unusable building on the land 300,000 Removal of old building 18,000 Salvage from sale of old building materials -4,000 Construction survey 1,500 Legal fees for title search 3,000 Excavation for basement construction 25,000 Machinery purchased...
Please show work thank you! In a random sample of 519 judges, it was found that...
Please show work thank you! In a random sample of 519 judges, it was found that 285 were introverts. a) Let p represent the proportion of all judges who are introverts. Find a point estimate for p. b) Find a 99% confidence interval for p. Give a brief interpretation of the meaning of the confidence interval you have found. c) Do you think the confidence np > 5 and nq > 5 are satisfied in this problem? Explain why this...
Please show the work for how to get the answer. Thank you in advance. Assume that...
Please show the work for how to get the answer. Thank you in advance. Assume that all of the mass of a bicycle wheel is concentrated at its rim. Such a wheel of mass 1.2 kg and radius 30 cm starts from rest at the top of a hill 100 m long and inclined at 20� to the horizontal. What will be the speed of the wheel at the bottom of the hill if it rolls without slipping? (Answer: 15...
Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use...
Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use the stocks of Apple, SAP, IBM, Oracle, and Amazon Download the historical data of weekly stock prices and S&P 500 index prices from year 2017-2019 on the website of yahoo finance and save it on an excel file. B. Use a different sheet to save the market adjusted prices of Apple, SAP, IBM, Oracle, and Amazon t and the index. For each stock, compute...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT