Hastings Corporation is interested in acquiring Vandell Corporation. Vandell has 1 million shares outstanding and a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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.5%. Assume that the risk-free rate of interest is 3% and the market risk premium is 6%. Both Vandell and Hastings face a 35% tax rate. Vandell's beta is 1.25. 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.4 million, $3.1 million, $3.3 million, and then $3.98 million in Years 1 through 4, respectively. Suppose Hastings will increase Vandell's level of debt at the end of Year 3 to $34.5 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 6% 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. X 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. A $ What is the maximum total price that Hastings would bid for Vandell now? Assume Vandell now has $9.28 million in debt. Enter your answer in dollars. Fort 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. DZO 1 2 3 Current target capital structure: 4 Debt Equity Number of common shares outstanding Current debt amount 5 6 7 A Merger Valuation with Change in Capital Structure 8 9 10 Risk-free rate 11 Market risk premium 12 Tax rate Beta 13 14 15 Debt interest rate Interest payments, Years 1-3 Growth rate 16 Free cash flow, Year 1 17 Free cash flow, Year 2 18 Free cash flow, Year 3 19 Free cash flow, Year 4 20 21 Level of debt, Year 3 22 New interest rate at higher debt level 23 New target capital structure: 24 Debt 25 Equity 26 B 30.00% 70.00% 1,000,000 $9,280,000 7.50% 3.00% 6.00% 35.00% 1.25 $1,600,000 6.00% $2,400,000 $3,100,000 $3,300,000 $3,980,000 $34,500,000 8.00% 45.00% 55.00% 27 Calculate target firm's levered cost of equity 28 st. 29 30 Calculate target firm's unlevered cost of equity 31 U 32 33 Calculate target firm's unlevered value: 34 Unlevered horizon value of FCF 35 Unlevered value of operations 36 37 Calculate value of interest tax shields: 38 Tax shield, Year 1 39 Tax shield, Year 2 40 Tax shield, Year 3. 41 Tax shield, Year 4 42 Tax shield, Horizon value 43 44 Value of tax shields 45 46 Calculate target firm's per share value to acquiring firm: 47 Value of operations 48 Target firm's equity value to acquiring firm 49 Per share value to acquiring firm 50 Formulas #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 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.5%. Assume that the risk-free rate of interest is 3% and the market risk premium is 6%. Both Vandell and Hastings face a 35% tax rate. Vandell's beta is 1.25. 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.4 million, $3.1 million, $3.3 million, and then $3.98 million in Years 1 through 4, respectively. Suppose Hastings will increase Vandell's level of debt at the end of Year 3 to $34.5 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 6% 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. X 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. A $ What is the maximum total price that Hastings would bid for Vandell now? Assume Vandell now has $9.28 million in debt. Enter your answer in dollars. Fort 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. DZO 1 2 3 Current target capital structure: 4 Debt Equity Number of common shares outstanding Current debt amount 5 6 7 A Merger Valuation with Change in Capital Structure 8 9 10 Risk-free rate 11 Market risk premium 12 Tax rate Beta 13 14 15 Debt interest rate Interest payments, Years 1-3 Growth rate 16 Free cash flow, Year 1 17 Free cash flow, Year 2 18 Free cash flow, Year 3 19 Free cash flow, Year 4 20 21 Level of debt, Year 3 22 New interest rate at higher debt level 23 New target capital structure: 24 Debt 25 Equity 26 B 30.00% 70.00% 1,000,000 $9,280,000 7.50% 3.00% 6.00% 35.00% 1.25 $1,600,000 6.00% $2,400,000 $3,100,000 $3,300,000 $3,980,000 $34,500,000 8.00% 45.00% 55.00% 27 Calculate target firm's levered cost of equity 28 st. 29 30 Calculate target firm's unlevered cost of equity 31 U 32 33 Calculate target firm's unlevered value: 34 Unlevered horizon value of FCF 35 Unlevered value of operations 36 37 Calculate value of interest tax shields: 38 Tax shield, Year 1 39 Tax shield, Year 2 40 Tax shield, Year 3. 41 Tax shield, Year 4 42 Tax shield, Horizon value 43 44 Value of tax shields 45 46 Calculate target firm's per share value to acquiring firm: 47 Value of operations 48 Target firm's equity value to acquiring firm 49 Per share value to acquiring firm 50 Formulas #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
Expert Answer:
Answer rating: 100% (QA)
Unlevered Firm Value Calculation Forecasted Unlevered Free Cash Flows Year 1 2400000 Year 2 3100000 ... View the full answer
Related Book For
Differential Equations and Linear Algebra
ISBN: 978-0131860612
2nd edition
Authors: Jerry Farlow, James E. Hall, Jean Marie McDill, Beverly H. West
Posted Date:
Students also viewed these finance questions
-
Verification Verify that the vector functions , , and in Example 9 satisfy the IVP.
-
A combination air cooler and dehumidification unit receives outside ambient air at 35C, 100 kPa, 90% relative humidity. The moist air is first cooled to a low temperature T2 to condense the proper...
-
Apply the rank order clustering technique to the part-machine incidence matrix in the following table to identify logical part families and machine groups. Parts are identified by letters, and...
-
A student has six textbooks, each with a thickness of 4.0 cm and a weight of 30 N. What is the minimum work the student would have to do to place all the books in a single vertical stack, starting...
-
Hernandez Builders has a gross payroll for January amounting to $500,000. The following amounts have been withheld: Income taxes ........... $63,000 Social Security ........... 31,000 Medicare...
-
What are the primary sources of conflict between auditees and auditors? Discuss each.
-
Inland Equipment sells hand held engine analyzers to automotive service shops. Inland Equipment started April with an inventory of 85 units that cost a total of \($12,750.\) During the month, Inland...
-
Low Carb Diet Supplement Inc. has two divisions. Division A has a profit of $156,000 on sales of $2,010,000. Division B is only able to make $28,800 on sales of $329,000. Based on the profit margins...
-
DEF Company has the following production forecast for the upcoming year: Quarter 1 1 0 , 0 0 0 units to be produced Quarter 2 1 2 , 0 0 0 units to be produced Quarter 3 1 3 , 0 0 0 units to be...
-
Healthwise Medical Supplies Company is located at 2400 Second Street, City, ST 12345. The company is a general partnership that uses the calendar year and accrual basis for both book and tax...
-
] Decide if the following statements are True [] or False []. Correct the false ones if any: A log-distance shadowing model is useful when dealing with a more realistic situation IEEE 802.16d model...
-
For our upcoming executive retreat, the Strategy Group has been tasked with competing a strategic analysis of our business and our industry. While there are a number of different approaches that we...
-
Choose a microeconomic topic. Discuss contemporary topic about Problems of Public Housing, the goal, and the following outlines in the introduction. Identify what others have to say on the chosen...
-
Tiffany, who has no wealth, has a von Neumann Morgenstern utility function that is equal to u(c)=c 1/2 , where c is her terminal wealth. She has to choose between two job offers, each of which has a...
-
1. Many people say that organizational behavior (OB) is the "soft" part of business, implying that it's an easy subject and not as hard as the technical and statistical analysis of finance and...
-
Rather than use the hypothetical information above, determine from available news sources if the Fed is increasing, holding steady, or decreasing interest rates. Similarly, is the Federal Government...
-
Attitude is an interal presdispostition based on which consumers systematically react towards an object, a brand, an organization or a product category. Consumer attitude may be defined as a feeling...
-
Southwestern Punch was made by Frutayuda, Inc. and sold in 12-ounce cans to benefit victims of Hurricane Zero. The mean number of ounces placed in a can by an automatic fill pump is 11.7 with a...
-
A strain of tuberculosis bacteria grows at a rate proportional to its size. A researcher has determined that every hour the culture is 1.5 times larger than the hour before and that initially 1here...
-
Tandem with a Twist (a) Use the method of the previous problem to solve the systems (b) Explain how the calculation of part (a) can be used to solve the matrix equation For the unknown 3 ( 2 matrix...
-
Repeated Roots, Long-Term Behavior: Show that in the "repeated roots" case of equation (1), the solution, which is given by x(t) = c1e-(b/2a)t + c2te-(b/2a)t , for b/2a > 0, tends toward zero as t...
-
A medical researcher believed the number of ear infections in swimmers can be reduced if the swimmers use earplugs. A sample of 10 people was selected, and the number of infections for a four-month...
-
A study was done to detect hidden chemicals in various types of beers. Three beers were tested for glyphosate (a weed killer). The following amounts (in parts per billion) were found. The data are...
-
In a large department store, the owner wishes to see whether the number of shoplifting incidents per day will change if the number of uniformed security officers is doubled. A random sample of 7 days...
Study smarter with the SolutionInn App