Problem 22-03

Merger Bid

Hastings Corporation is interested in acquiring Vandell Corporation. Vandell has 1 million shares outstanding and a target capital structure consisting of 30% debt; its beta is 1.35 (given its target capital structure). Vandell has $10.69 million in debt that trades at par and pays an 7.2% interest rate. Vandell's free cash flow (FCF0) is $2 million per year and is expected to grow at a constant rate of 6% a year. Both Vandell and Hastings pay a 35% combined federal and state tax rate. The risk-free rate of interest is 6% and the market risk premium is 6%.

Hastings Corporation estimates that if it acquires Vandell Corporation, synergies will cause Vandell's free cash flows to be $2.3 million, $3.2 million, $3.4 million, and $3.60 million at Years 1 through 4, respectively, after which the free cash flows will grow at a constant 6% rate. Hastings plans to assume Vandell's $10.69 million in debt (which has an 7.2% interest rate) and raise additional debt financing at the time of the acquisition. Hastings estimates that interest payments will be $1.5 million each year for Years 1, 2, and 3. After Year 3, a target capital structure of 30% debt will be maintained. Interest at Year 4 will be $1.426 million, after which the interest and the tax shield will grow at 6%.

Indicate the range of possible prices that Hastings could bid for each share of Vandell common stock in an acquisition. Round your answers to the nearest cent. Do not round intermediate calculations.

The bid for each share should range between $___ per share and $___ per share.

If you could show me the excel I would appreciate it