Ask Financial Management Expert

'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 post merger data for ACC (in thousands of dollars):




2018 2019 2020 2021 2022
Net sales

$500 $600 $700 $760 $806
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, 2018. 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 to 40 percent debt, 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 werre consolidated. ACC's current market-determined beta is 1.40. The cost of goods sold is expected to be 65 percent of sales, but it could vary somewhat.

Gross investment in operating assets is expected to be equal to depreciation, so net investment in operating assets will be zero. The risk-free rate is 7 percent, and the market risk premium is 6.5 percent. Wansley currently has $400,000 in debt outstanding.

Tax rate of ACC before the merger

30%
Tax rate after merger


35%
Cost of goods sold as a % of sales

65%
Debt ratio (percent financed with debt) before the merger
30%
Cost of debt before merger

9%
Debt ratio (percent financed with debt) after the merger
40%
Cost of debt after merger


10%
Beta of ACC



1.40
Risk-free rate



7%
Market risk premium


6.5%
Terminal growth rate of free cash flow

6.0%
Pre-merger debt (in thousands)

$400

a. What is the unlevered cost of equity? (show your work)

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?

Before we can proceed with this problem, we must generate pro forma income statements for ACC's operations after the proposed merger so we can calculate free cash flow and interest tax shields.




2018 2019 2020 2021 2022
Sales






Cost of Goods Sold (including depreciation)




Gross Profit






Selling and admin. Costs





EBIT






Interest






EBT






Taxes






Net Income














EBIT






NOPAT






Investment in net operating capital




FCF






*In this scenario, we state that investment in net operating capital is zero. This arises from the fact that the only needed investments are those needed to replace worn out capital, and that they equal depreciation.

We must determine the tax shields.

From this point, we can derive horizon value from the basic DCF framework.

The tax shield is the interest multiplied by the post-merger tax rate.




2018 2019 2020 2021 2022
Interest (cf. Row 65)






Tax shield
















HVTS 2022 = TS2022 * (1+g) / (rsU - g)
HVTS 2022 =
*
/
-
HVTS 2022 =
/




HVTS 2022 =






To calculate the value of the tax shields add the horizon value of the tax shields to the 2022 tax shield to get the total tax shield cash flow in 2022. In the other years the total TS cash flow is just the annual TS.

Then find the NPV of this stream of tax shields at the unlevered cost of equity.




2018 2019 2020 2021 2022
Total TS Cash Flows













NPV of TS Cash Flows

This is the value of all of the tax shields.

To calculate the unlevered value of operations you need the unlevered horizon value and the the annual free cash flows.

To calculate the unlevered horizon value, we just need the free cash flow for 2022.

HVUL 2022 = FCF2022 * (1+g) / (rsU - g)
HVUL 2022 =
*
/
-
HVUL 2022 =
/




HVUL 2022 =






To calculate the unlevered value of operations, add the unlevered horizon value to the free cash flow in 2022 to get the total unlevered cash flow in 2022. In the other years the unlevered cash flow is just the annual free cash flow. The unlevered value of operations is the NPV of the unlevered cash flows at the unlevered cost of equity.

Year

2018 2019 2020 2021 2022
Total unlevered CFs













NPV of unlevered CFs

This is the unlevered value of operations
The value of operations is the value of the interest tax shields plus the unlevered value of operations


VTS + Vunlevered


Vops =
+



Vops =





To find the value of ACC to Wansley's shareholders take the value of operations, add in any non-operating assets (there are none for ACC) and subtract off the debt.









Vops =






Debt =






Equity =






Financial Management, Finance

  • Category:- Financial Management
  • Reference No.:- M92822523

Have any Question?


Related Questions in Financial Management

Assignment problems1 on the day harry was born his parents

Assignment Problems 1. On the day Harry was born, his parents put $1600 into an investment account that promises to pay a fixed interest rate of 5 percent per year. How much money will Harry have in this account when he ...

1 activities of a company that require the spending of cash

1) Activities of a company that require the spending of cash are known as: A) Uses of cash. B) Cash on hand. C) Cash receipts. D) Sources of cash. E) Cash collections. 2) Relationships determined from a firm's financial ...

Module discussion forumto prepare for this discussion

Module : Discussion Forum To prepare for this discussion, review "Basics of Speechwriting" and "Basics of Giving a Speech" in textbook Chapter 15. Then watch this video of Apple founder and CEO Steve Jobs giving the 2005 ...

Launching a new product linefor this portfolio project

Launching a New Product Line For this Portfolio Project Option, you will act as an employee in a large company that develops and distributes men's and women's personal care products. The company has developed a new produ ...

Question 1 discuss valuing bonds and how interest rates

Question : 1) Discuss valuing bonds and how interest rates affect their value. Also consider the importance of the yield-to-maturity (YTM). 2) Discuss common stocks and preferred stocks. Also, which common stock valuatio ...

Introductionlast week you determined the root causes of the

Introduction Last week, you determined the root cause(s) of the problem you are trying to resolve for your final paper. As a reminder, the decision you are working on is the one that you selected in week two. This week, ...

You have owned and operated a successful brick-and-mortar

You have owned and operated a successful brick-and-mortar business for several years. Due to increased competition from other retailers, you have decided to expand your operations to sell your products via the Internet. ...

You will be conducting an interview with a market research

You will be conducting an interview with a market research professional or a company representative. Use the results of your research to make specific recommendations on how market research can be applied to the Marketpl ...

Question 1 what is marketing research what are the two

Question 1: What is marketing research? What are the two primary types of research? Question 2: What factors influence marketing research? Question 3: The role of statistics in business decision-making? Assignment : Sele ...

Chapter 74 for commercial banks what is meant by a managed

Chapter 7 4. For commercial banks, what is meant by a managed liability? What role do liquid assets play on the balance sheet of commercial banks? What role do money market instruments play in the asset and liability man ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As