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:
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.
-
What is the essence of the discounted cash flow methods?
-
Brook Ltd. purchased 70 Meissner AG 9%, 10-year, 1,000 bonds on January 1, 2020, for 70,000. The bonds pay interest annually on January 1. On January 1, 2021, after receipt of interest, Brook sold 40...
-
The three general phases of analysis, design, and implementation are part of a ( _________________ ). (a) system development study (b) systems approach (c) expert system (d) decision support system
-
For 2015, Parker Games has the following inventory transactions related to its traditional board games. Because of the increasing popularity of electronic video games, Parker Games continues to see a...
-
Venture capital required rate of return. Blue Angel Investors has a success ratio of 10% with its venture funding. Blue Angel requires a rate of return of 21.6% for its portfolio of lending, and the...
-
Ayala Corporation incurred the following costs during the current year in relation to property, plant and equipment: Cash paid for purchase of land Mortgage assumed on the land purchased, including...
-
What organizational enablers and impediments shape the effectiveness and resilience of multifunctional teams, spanning factors such as leadership dynamics, resource allocation, performance...
-
A point charge q with charge q = 4 . 0 nC is at the point ~r 0 = ( 4 . 0 cm , 4 . 0 cm , 0 ) . Calculate the electric field at the point ~rP = ( 8 . 0 cm , 1 2 . 0 cm , 0 ) . A point charge q with...
-
Let S(0) 100, R = 0.05, U = 0.2, D = -0.2, and N = 3, and consider the payoff of following European butterfly spread: -30- -20- -10- 50 = 60 70 80 90 100 110 120 130 140 (a) You can construct this...
-
Evaluate the following 2 A [ (x 1) e + + x dr
-
Analyze the role of emotional intelligence (EI) in leadership effectiveness and organizational performance, integrating perspectives from Mayer and Salovey's model of EI and Goleman's emotional...
-
Write down all structural isomers of alkan with the closed formula C6H14.
-
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...
-
Match the internal control function from the left-hand column with the area of responsibility in the ta dedshetak utnisgsee! right-hand column: 1. Prepares deposit receipt. a Retail sales supervisor...
-
Identify the element of the fraud triangle associated with each of the following statements: 1. "I take full responsibility for what happened. But saying that, I know in my mind that I did nothing...
-
Match the activities from column 1 with the activities described in column 2. 1 a. Manage accounts receivable b. Manage inventory levels c. Manage accounts payable d. Invest excess cash 2 1. Acquire...
Study smarter with the SolutionInn App