Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Excel Online Structured Activity: Merger Valuation Hastings Corporation is interested in acquiring Vandell Corporation. Vandell has 1 million shares outstanding and a target capital structure

image text in transcribed
image text in transcribed
Excel Online Structured Activity: Merger Valuation Hastings Corporation is interested in acquiring Vandell Corporation. Vandell has 1 million shares outstanding and a target capital structure consisting of 30% debt. Vandel's debt interest rate is 7.8%. Assume that the risk free rate of interest is 6% and the market risk premium is 4%. Both Vandell and Hastings face a 40% tax rate Hastings estimates that if it acquires Vandel, interest payments will be $1,500,000 per year for 3 years after which the current target capital structure of 30% debt will be maintained. Interest in the fourth year will be $1.461 million after which interest and the tax shield will grow at 4%. Synergies will cause the free cash flows to be $2.3 million, $3.0 million, $3.3 million, and then $3.58 million in Years 1 through 4, respectively, after which the free cash flows will grow at a 4% rate, The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. X Open spreadsheet What is the unlevered value of Vandell? Vandell's beth is 1.10. Enter your answer in dollars. For example, an answer of $1.2 million should be entered as 1,200,000, not 1.2. Do not round intermediate calculations. Round your answer to two decimal places $ What is the value of its tax shields? Enter your answer in dollars. For example, an answer of 1.2 million should be entered as 1,200,000, not 1.2. Do not found intermediate calculations. Round your answer to two decimal places $ What is the per share value of Vandel to Hastings Corporation Assume Vandell now has $9.00 million in debt. Do not round intermediate calculations. Round your answer to the nearest cent. per share Merger Valuation Current target capital structure: Debt Equity Number of common shares outstanding Current debt amount 30.00% 70.00% 1,000,000 $9,000,000 Debt interest rate Risk-free rate Market risk premium Tax rate Beta Interest payments, Years 1-3 Interest payment, Year 4 Growth rate Free cash flow, Year 1 Free cash flow. Year 2 Free cash flow, Year 3 Free cash flow, Year 4 7.80% 6.00% 4.00% 40.00% 1.10 $1,500,000 $1,461,000 4.00% $2,300,000 $3,000,000 $3,300,000 $3,580,000 Excel Online Structured Activity: Merger Valuation Hastings Corporation is interested in acquiring Vandell Corporation. Vandell has 1 million shares outstanding and a target capital structure consisting of 30% debt. Vandel's debt interest rate is 7.8%. Assume that the risk free rate of interest is 6% and the market risk premium is 4%. Both Vandell and Hastings face a 40% tax rate Hastings estimates that if it acquires Vandel, interest payments will be $1,500,000 per year for 3 years after which the current target capital structure of 30% debt will be maintained. Interest in the fourth year will be $1.461 million after which interest and the tax shield will grow at 4%. Synergies will cause the free cash flows to be $2.3 million, $3.0 million, $3.3 million, and then $3.58 million in Years 1 through 4, respectively, after which the free cash flows will grow at a 4% rate, The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. X Open spreadsheet What is the unlevered value of Vandell? Vandell's beth is 1.10. Enter your answer in dollars. For example, an answer of $1.2 million should be entered as 1,200,000, not 1.2. Do not round intermediate calculations. Round your answer to two decimal places $ What is the value of its tax shields? Enter your answer in dollars. For example, an answer of 1.2 million should be entered as 1,200,000, not 1.2. Do not found intermediate calculations. Round your answer to two decimal places $ What is the per share value of Vandel to Hastings Corporation Assume Vandell now has $9.00 million in debt. Do not round intermediate calculations. Round your answer to the nearest cent. per share Merger Valuation Current target capital structure: Debt Equity Number of common shares outstanding Current debt amount 30.00% 70.00% 1,000,000 $9,000,000 Debt interest rate Risk-free rate Market risk premium Tax rate Beta Interest payments, Years 1-3 Interest payment, Year 4 Growth rate Free cash flow, Year 1 Free cash flow. Year 2 Free cash flow, Year 3 Free cash flow, Year 4 7.80% 6.00% 4.00% 40.00% 1.10 $1,500,000 $1,461,000 4.00% $2,300,000 $3,000,000 $3,300,000 $3,580,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Foundations Of Financial Management

Authors: Stanley B Block, Geoffrey A Hirt

12th Edition

0073295817, 9780073295817

More Books

Students also viewed these Finance questions

Question

Solve the Initial Value Problem. (sin x)y'= (cos x)y + 1, y(/4) = 0

Answered: 1 week ago

Question

=+1. What is a stakeholder? Define the term in your own words.

Answered: 1 week ago