Hastings estimates that if it acquires Vandell, interest payments will be $1.5 million 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.472 million, after which interest and the tax shield will grow at 5%. Synergies will cause the free cash flows to be $2.5 million, $2.9 million, $3.4 million, and $3.57 million in Years 1 through 4, respectively, after which the free cash flows will grow at a 5% rate.

1) What is the unlevered value of Vandell, and what is the value of its tax shields?

2)What is the per share value of Vandell to Hastings Corporation? Assume that Vandell now has $10.82 million in debt.

I come up with $41.54 but need to see how it is done in Excel.