Start with the partial model in the file IFM9 Ch26 P07 Build a Model.xls from the ThomsonNOW Web site. Wansley Portal Inc., a large Internet service provider, is evaluating the possible acquisition of Alabama Connections Company (ACC), a regional Internet service provider. Wansley's analysts project the following postmerger data for ACC (in thousands of dollars):
|
|
2007
|
2008
|
2009
|
2010
|
2011
|
|
Net sales
|
S500
|
$600
|
$700
|
5760
|
5806
|
|
Selling and administrative expense
|
60
|
70
|
80
|
90
|
96
|
|
Interest
|
30
|
40
|
45
|
60
|
74
|
If the acquisition is made, it will occur on January 1, 2007. All cash flows shown in the income statements are assumed to occur at the end of the year. ACC currently has a capital structure of 30 percent debt, which costs 9 percent, but Wansley would increase that over time to 40 percent, costing 10 percent, if the acquisition were made. ACC, if independent, would pay taxes at 30 percent, but its income would be taxed at 35 percent if it were consolidated. ACC's current market-determined beta is 1.40. The cost of goods sold, which includes depreciation, is expected to be 65 percent of sales, but it could vary somewhat. Required gross investment in operating capital is approximately equal to the depreciation charged, so there will be no investment in net operating capital. The risk-free rate is 7 percent, and the market risk premium is 6.5 percent. Wansley currently has $400,000 in debt outstanding.
a. What is the appropriate discount rate for valuing the acquisition?
b. What is the horizon value of the tax shields and the unlevered operations? What is the value of ACC's operations and the value of ACC's equity to Wansley's shareholders?