I am struggling with this question, due tomorrow. I can upload the Excel sheet I started.

This question is about a merger bid. The acquired company has the following 1 million shares outstanding Target capital structure consisting of 30% debt beta is 1.55 Debt = $9.18 million traded at a 7.4% interest rate. Free cash flow0 = $2 million per year, at a constant rate of 5% a year. The acquisition company and acquired firm are in the 30% combined federal and state tax rate. Risk-free rate = 5% market risk premium = 7%. The forecast is a synergistic merger resulting in the following: Free cash flow = Year 1 = $2.4 million, Year 2 = $3.2 million, Year 3 = $3.3 million, and Year 4 = $3.91 million After year 4 the free cash flows will grow at a constant 5% rate. Assume the $9.18 million in debt (which has an 7.4% interest rate) will be aquired, and additional debt financing at the time of the acquisition. Estimated interest payments will be made in the following schedule: Year 1, 2, 3 = $1.5 million each year Year 4 = 1.44 million, After Year 3, a target capital structure of 30% debt will be maintained and the tax shield will grow at 5%. What is the range of bid prices that the acquisition company should be prepared to offer for each share of common stock? 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. I know my calculations are off in that I had a minimum bid of $24.84 and got lost in the horizon values to determine the upper limit of the bid price.