Question

Data Given: 2017 2018 2019 2020 Net sales $500 $600 $700 $760 Selling and administrative expense...

Data Given:

2017

2018

2019

2020

Net sales

$500

$600

$700

$760

Selling and administrative expense

60

70

80

90

Interest

30

40

45

60

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

1. What is the levered cost of equity at old capital structure?

2. What is the unlevered cost of equity?

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.

Fill in the chart

2017

2018

2019

2020

2021

Sales

Cost of Goods Sold (incl. depreciation)

Gross Profit

Selling/admin. costs

EBIT

Interest

EBT

Taxes

Net Income

EBIT

NOPAT

Investment in net operating capital

FCF

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.

2017

2018

2019

2020

2021

Interest

0.0

0.0

0.0

0.0

0.0

Tax shield

HVTS 2020

=

TS2021

*

(1+g)

/

(rsU)

-

g)

HVTS 2020

=

*

/

-

HVTS 2020

=

/

HVTS 2020

=

To calculate the value of the tax shields add the horizon value of the tax shields to the 2021 tax shield

to get the total tax shield cash flow in 2021. 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.

2017

2018

2019

2020

2021

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 2021

HVUL 2021

=

FCF2021

*

(1+g)

/

(rsU

-

g)

HVUL 2021

=

*

/

-

HVUL 2021

=

/

HVUL 2021

=

To calculate the unlevered value of operations, add the unlevered horizon value to the free cash flow

in 2021 to get the total unlevered cash flow in 2021. 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

2017

2018

2019

2020

2021

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 non for ACC) and subtract off the debt.

Vops

=

Debt

=

Equity

=

Homework Answers

Answer #1
Risk free rate 7.00%
Beta (Considering it Company's levered beta) 1.4
market Premium 6.50%
levered cost of equity at old capital structure 16.10%

levered beta = Unlevered Beta * [1 + (1 - Tax Rate) * Debt / Equity ]

Hence Unlevered Beta = levered Beta / [1 + (1 - Tax Rate) * Debt / Equity ] = 1.1

Unlevered cost of equity at old capital structure = 14%

2017 2018 2019 2020 2021
Sales 500 600 700 760
Cost of Goods Sold (incl. depreciation) 325 390 455 494
Gross Profit 175 210 245 266
Selling/admin. costs 60 70 80 90
EBIT 115 140 165 176
Interest 30 40 45 60
EBT 85 100 120 116
Taxes 29.75 35 42 40.6
Net Income 55 65 78 75
EBIT 115 140 165 176
NOPAT 74.75 91 107.25 114.4
Investment in net operating capital NA NA NA NA
FCF 74.75 91 107.25 114.4

Financial for Year 2021 is not given.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
XYZ Corp estimates the following FCFs and interest expenses for 2019, 2020 and 2021. After 2020...
XYZ Corp estimates the following FCFs and interest expenses for 2019, 2020 and 2021. After 2020 the firm expects that both FCFs and interest expenses will be growing at a constant 5 percent rate indefinitely. XYZ’s unlevered cost of equity is 13%. Federal plus state tax rates are 25%. (14 points) 2019 2020 2021 FCF (millions) $35 $50 $70 Interest expense (millions) $4 $6 $8 What is the firm’s unlevered horizon value in 2021? What is the firm’s current unlevered...
XYZ Corp estimates the following FCFs and interest expenses for 2019, 2020 and 2021. After 2020...
XYZ Corp estimates the following FCFs and interest expenses for 2019, 2020 and 2021. After 2020 the firm expects that both FCFs and interest expenses will be growing at a constant 5 percent rate indefinitely. XYZ’s unlevered cost of equity is 13%. Federal plus state tax rates are 25%. 2019 2020 2021 FCF (millions) $35 $50 $70 Interest expense (millions) $4 $6 $8 What is the firm’s unlevered horizon value in 2021? What is the firm’s current unlevered value? What...
Considering the valuation of mergers, which of the following is NOT correct? A. In a merger...
Considering the valuation of mergers, which of the following is NOT correct? A. In a merger with true synergies, the post-merger value exceeds the sum of the separate companies' pre-merger values. B. Only if a target firm's value is greater to the acquiring firm than its market value as a separate entity will a merger be financially justified. C. If the capital structure is stable, and free cash flows are expected to be growing at a constant rate at the...
Current and projected free cash flows for Radell Global Operations are shown below. Actual 2018 2019...
Current and projected free cash flows for Radell Global Operations are shown below. Actual 2018 2019 Projected 2020 2021 Free cash flow $619.28 $679.96 $720.01 $770.41 (millions of dollars) Growth is expected to be constant after 2020, and the weighted average cost of capital is 11.85%. What is the horizon (continuing) value at 2021 if growth from 2020 remains constant? Do not round intermediate calculations. Enter your answer in millions. For example, an answer of $1 million should be entered...
JINGHUA 2018 and 2019 Partial Balance Sheets Assets Liabilities and Owners’ Equity 2018 2019 2018 2019...
JINGHUA 2018 and 2019 Partial Balance Sheets Assets Liabilities and Owners’ Equity 2018 2019 2018 2019 Current assets $ 3,700 $ 4,200 Current liabilities $ 1,480 $ 1,720 Net fixed assets 15,700 18,240 Long-term debt 8,000 8,600 Equity 9,920 12,120 JINGHUA 2019 Income Statement Info Sales $ 22,600 Costs 11,000 Depreciation 2,000 Interest paid 400 The tax rate is 35%. Long term debt trades at 125% of par. The firm has 500 shares outstanding. Free Cash Flow to the Firm...
QUESTION 24 [Q24-35] Your firm’s market value balance sheet is given as follows: Market Value Balance...
QUESTION 24 [Q24-35] Your firm’s market value balance sheet is given as follows: Market Value Balance Sheet Excess cash $30M Debt $230M Operating Assets $500M Equity $300M Asset Value $530M Debt + Equity $530M Assume that the you plan to keep the firm’s debt-to-equity ratio fixed. The firm’s corporate tax rate is 50%. The firm’s cost of debt is 10% and cost of equity is 20%. Now, suppose that you are considering a new project that will last for one...
Consider recent financials for Ellie's Essentials LLC: Balance Sheet 2018 2017 Current Assets $11,225.00 $10,000.00 Net...
Consider recent financials for Ellie's Essentials LLC: Balance Sheet 2018 2017 Current Assets $11,225.00 $10,000.00 Net PPE $31,000.00 $30,000.00 Total Assets $42,225.00 $40,000.00 Current Liabilities $8,441.00 $8,000.00 Long-term debt $13,970.00 $12,000.00 Total Liabilities $22,411.00 $20,000.00 Shareholder Equity $19,814.00 $20,000.00 Liabilities and Equity $42,225.00 $40,000.00 Income Statement 2018 2017 SALES $11,000.00 $10,000.00 COGS $4,400.00 $4,000.00 GROSS PROFIT $6,600.00 $6,000.00 S&A $1,100.00 $1,000.00 Depreciation $550.00 $500.00 EBIT $4,950.00 $4,500.00 INTEREST $1,272.00 $1,200.00 EBT $3,678.00 $3,300.00 TAXES (36.00%) $1,324.08 $1,188.00 NET INCOME $2,353.92...
Answer Q1-4 Given the following cash flows: Year 0 1 2 3 CF -3,500 600 1,000...
Answer Q1-4 Given the following cash flows: Year 0 1 2 3 CF -3,500 600 1,000 Cash flow will grow at a constant rate g=6% We choose the following capital structure plan: Debt Equity Plan 30% 70% Equity Benchmark: The unlevered beta is 2, tax rate is 40%. Market Return is 16%, risk-free rate is 3%. Debt Benchmark: Par:100, Annual Coupon: 6%, 10-year to maturity, Selling at $88.43 Q1) What is the before-tax cost of debt a) 7.7% b)8.5% c)6.3%...
Following are forecasts of Target Corporation's sales, net operating profit after tax (NOPAT), and net operating...
Following are forecasts of Target Corporation's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of January 30, 2016 Reported Horizon Period Terminal $ millions 2016 2017 2018 2019 2020 Period Sales $74,340 $75,827 $77,344 $78,891 $80,469 $81,274 NOPAT 3,345 3,412 3,480 3,550 3,621 3,657 NOA 22,302 22,748 23,203 23,667 24,141 24,382 Answer the following requirements assuming a terminal period growth rate of 1%, a discount rate (WACC) of 6%, common shares outstanding of 602 million,...
Use the following data to answer question Q14 - Q17 Given the following cash flows: Year...
Use the following data to answer question Q14 - Q17 Given the following cash flows: Year 0 1 2 3 CF -3,500 600 1,000 Cash flow will grow at a constant rate g=6% We choose the following capital structure plan: Debt Equity Plan 30% 70% Equity Benchmark: The unlevered beta is 2, tax rate is 40%. Market Return is 16%, risk-free rate is 3%. Debt Benchmark: Par:100, Annual Coupon: 6%, 10-year to maturity, Selling at $88.43 Q14. What is the...