Excel Online Structured Activity: Merger Valuation with Change in Capital Structure Hastings Corporation is interested in...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/66496ed4139c7_53166496ed388e85.jpg)
Transcribed Image Text:
Excel Online Structured Activity: Merger Valuation with Change in Capital Structure Hastings Corporation is interested in acquiring Vandell Corporation. Vandell has 1 million shares outstanding and a target capital structure consisting of 30% debt. Vandell's debt interest rate is 7.2%. Assume that the risk-free rate of interest is 3% and the market risk premium is 8%. Both Vandell and Hastings face a 35% tax rate. Vandell's beta is 1.20. Hastings estimates that if it acquires Vandell, interest payments will be $1,600,000 per year for 3 years. The free cash flows are supposed to be $2.3 million, $2.8 million, $3.3 million, and then $3.97 million in Years 1 through 4, respectively. Suppose Hastings will increase Vandell's level of debt at the end of Year 3 to $31.2 million so that the target capital structure will be 45% debt. Assume that with this higher level of debt the interest rate would be 8.0%, and assume that interest payments in Year 4 are based on the new debt level from the end of Year 3 and new interest rate. Free cash flows and tax shields are projected to grow at 5% after Year 4. 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. Open spreadsheet What is the value of the unlevered firm? 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 the tax shield? 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 maximum total price that Hastings would bid for Vandell now? Assume Vandell now has $11.94 million in debt. 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. $ Excel Online Structured Activity: Merger Valuation with Change in Capital Structure Hastings Corporation is interested in acquiring Vandell Corporation. Vandell has 1 million shares outstanding and a target capital structure consisting of 30% debt. Vandell's debt interest rate is 7.2%. Assume that the risk-free rate of interest is 3% and the market risk premium is 8%. Both Vandell and Hastings face a 35% tax rate. Vandell's beta is 1.20. Hastings estimates that if it acquires Vandell, interest payments will be $1,600,000 per year for 3 years. The free cash flows are supposed to be $2.3 million, $2.8 million, $3.3 million, and then $3.97 million in Years 1 through 4, respectively. Suppose Hastings will increase Vandell's level of debt at the end of Year 3 to $31.2 million so that the target capital structure will be 45% debt. Assume that with this higher level of debt the interest rate would be 8.0%, and assume that interest payments in Year 4 are based on the new debt level from the end of Year 3 and new interest rate. Free cash flows and tax shields are projected to grow at 5% after Year 4. 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. Open spreadsheet What is the value of the unlevered firm? 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 the tax shield? 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 maximum total price that Hastings would bid for Vandell now? Assume Vandell now has $11.94 million in debt. 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. $
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Selenic acid, H2SeO4, is a crystalline substance and a strong acid. Write the electron-dot formula of selenic acid.
-
Only quantitative outcomes are relevant in capital budgeting analysis. Do you agree? Explain.
-
For each of the following situations, calculate the standard error of the difference (s X1 - X2 ). a. N =9, s 3.00, N = 9, 52 = 6.00 b. N = 16, s = 8.00, N = 16, 52 = 12.00 c. N = 24,5 = 3.38, N =...
-
Backflush costing Similar to Self-Study Problem 2 J. Sewerd, Inc. uses backflush costing to account for its manufacturing costs. The trigger points for recording inventory transactions are the...
-
Devers Corporation issued $400,000 of 6% bonds on May 1, 2011. The bonds were dated January 1, 2011, and mature January 1, 2013, with interest payable July 1 and January 1. The bonds were issued at...
-
Consider the definite integral f, a3 dac. A. Find the right-hand rule Riemann sum approximation using 6 rectangles. B. Write the summation notation for the right-hand rule Riemann sum using n...
-
Complete the below table to calculate the price of a $1.5 million bond issue under each of the following independent assumptions (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1):...
-
1. Why should you train volunteers? 2. What is the event industry's most important resource? 3. Describe the following management styles in detail and give an example of each leadership. Autocratic...
-
Given the fixed beam shown in the figure below (Fig Q10) solve the following problem. Using three (3) elements of equal length calculate the displacement w, given the following parameters. 1. The...
-
Explains the nature (for example, the origin or reason why the law is imposed) of Puerto Rico's contributions. Define the following terms using the instructions manual of the Department of the...
-
10-year Treasury note ($1,000 principal) with 5.000% annual coupon rate, paid semi-annually, is purchased 26 days after the last coupon payment. The current coupon period contains 184 days. Calculate...
-
What will be your value-added proposition to your current/future employer? What are you discovering? How do you hope to transform your organization in the future? How can you impact your organization...
-
You have contracted to buy a house for $521,250 paying $104,250 as a down payment and taking a fully amortized 30-year mortgage for the balance at a 4.50% annual interest rate? The bank has offered...
-
How does health insurance risk differ from other types of insurance risk (e.g., automobile or homeowners insurance)? What is the difference between cost sharing and cost shifting? Is retiree health...
-
Why may a focus on operating revenue be preferable to a focus on total revenue?
-
Which approach do you think is best for valuing a business: the DCF approach or the market multiple approach? Explain the rationale behind your answer. p7
-
Why is EVA a better measure of financial performance than are accounting measures such as net income or earnings per share?
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App