Need the following problem solved via excel. please see attached.

Problem 1 Nonconstant growth valuation Hart Enterprises recently paid a dividend, D0, of $4.00. It expects to have nonconstant growth of 19% for 2 years followed by a constant rate of 8% thereafter. The firm's required return is 11%. a. How far away is the horizon date? !. The terminal, or horizon, date is Year 0 since the value of a common stock is the present value of all future expected dividends at time zero. II. The terminal, or horizon, date is the date when the growth rate becomes nonconstant. III. This occurs at time zero. III. The terminal, or horizon, date is the date when the growth rate becomes constant. This occurs at the beginning of Year 2. IV. The terminal, or horizon, date is the date when the growth rate becomes constant. This occurs at the end of Year 2. V. The terminal, or horizon, date is infinity since common stocks do not have a maturity date. Please select one choice from above__________________ b. What is the firm's horizon, or continuing, value? Round your answer to two decimal places. $ _____________ c. What is the firm's intrinsic value today, P0? Round your answer to two decimal places. $_______________ Problem 2: Trivoli Industries plans to issue perpetual preferred stock with an $11.00 dividend. The stock is currently selling for $88.50; but flotation costs will be 5% of the market price, so the net price will be $84.08 per share. What is the cost of the preferred stock, including flotation? Round your answer to two decimal places. __________ % Problem 3: Microtech Corporation is expanding rapidly and currently needs to retain all of its earnings; hence, it does not pay dividends. However, investors expect Microtech to begin paying dividends, beginning with a dividend of $1.50 coming 3 years from today. The dividend should grow rapidly - at a rate of 49% per year - during Years 4 and 5; but after Year 5, growth should be a constant 7% per year. If the required return on Microtech is 12%, what is the value of the stock today? Round your answer to the nearest cent. $ ________________ Problem 4: Thomas Brothers is expected to pay a $2 per share dividend at the end of the year (that is, D1 = $2). The dividend is expected to grow at a constant rate of 5% a year. The required rate of return on the stock, rs, is 7%. What is the stock's current value per share? Round your answer to two decimal places. $_____________ Problem 5: Javits & Sons' common stock currently trades at $24.00 a share. It is expected to pay an annual dividend of $1.00 a share at the end of the year (D1 = $1.00), and the constant growth rate is 8% a year. What is the company's cost of common equity if all of its equity comes from retained earnings? Round your answer to two decimal places. ________________ % If the company were to issue new stock, it would incur a 20% flotation cost. What would the cost of equity from new stock be? Round your answer to two decimal places. _________________ % Problem 6: Warr Corporation just paid a dividend of $3.75 a share (that is, D 0 = $3.75). The dividend is expected to grow 10% a year for the next 3 years and then at 5% a year thereafter. What is the expected dividend per share for each of the next 5 years? Round your answers to two decimal places. D1 = $ D2 = $ D3 = $ D4 = $ D5 = $ Problem 7: The Heuser Company's currently outstanding bonds have a 8% coupon and a 13% yield to maturity. Heuser believes it could issue new bonds at par that would provide a similar yield to maturity. If its marginal tax rate is 35%, what is Heuser's after-tax cost of debt? Round your answer to two decimal places. ____________ % Problem 8: Tunney Industries can issue perpetual preferred stock at a price of $70.50 a share. The stock would pay a constant annual dividend of $7.00 a share. What is the company's cost of preferred stock, rp? Round your answer to two decimal places. ______________