PLEASE ANSWER IN EXCEL USING FORMULAS

Q1 Assume Evco, Inc. has a current stock price of $53.41 and will pay a $2.25 dividend in one year; its equity cost of capital is 11%. What price must you expect Evco stock to sell for immediately after the firm pays the dividend in one year to justify its current price? We can expect Evco stock to sell for $ ___ . (Round to the nearest cent.)

Q2. Anle Corporation has a current stock price of $ 17.31 and is expected to pay a dividend of $ 1.00 in one year. Its expected stock price right after paying that dividend is $ 19.07. a. What is Anle's equity cost of capital? b. How much of Anle's equity cost of capital is expected to be satisfied by dividend yield and how much by capital gain? a. What is Anle's equity cost of capital? Anle's equity cost of capital is ____ %. (Round to two decimal places.)

Q3. Summit Systems will pay a dividend of $ 1.53 this year. If you expect Summit's dividend to grow by 5.9 % per year, what is its price per share if the firm's equity cost of capital is 11.5 %? The price per share is $ ____ (Round to the nearest cent.) Q4. Laurel Enterprises expects earnings next year of $3.91 per share and has a 30 % retention rate, which it plans to keep constant. Its equity cost of capital is 9 %, which is also its expected return on new investment. Its earnings are expected to grow forever at a rate of 2.7 % per year. If its next dividend is due in one year, what do you estimate the firm's current stock price to be? The current stock price will be $ _____. (Round to the nearest cent.)

Q5. DFB, Inc. expects earnings next year of $ 5.51 per share, and it plans to pay a $ 3.04 dividend to shareholders (assume that is one year from now). DFB will retain $ 2.47 per share of its earnings to reinvest in new projects that have an expected return of 14.4 % per year. Suppose DFB will maintain the same dividend payout rate, retention rate, and return on new investments in the future and will not change its number of outstanding shares. Assume next dividend is due in one year. a. What growth rate of earnings would you forecast for DFB? b. If DFB's equity cost of capital is 12.4 %, what price would you estimate for DFB stock? c. Suppose instead that DFB paid a dividend of $ 4.04 per share at the end of this year and retained only $ 1.47 per share in earnings. That is, it chose to pay a higher dividend instead of reinvesting in as many new projects. If DFB maintains this higher payout rate in the future, what stock price would you estimate for the firm now? Should DFB raise its dividend? a. What growth rate of earnings would you forecast for DFB? DFB's growth rate of earnings is ____ %. (Round to one decimal place.)

Q6. Assume Gillette Corporation will pay an annual dividend of $ 0.65 one year from now. Analysts expect this dividend to grow at 12.7 % per year thereafter until the 4th year. Thereafter, growth will level off at 1.5 % per year. According to the dividend-discount model, what is the value of a share of Gillette stock if the firm's equity cost of capital is 7.8 %? The value of Gillette's stock is $ _____. (Round to the nearest cent.)

Q7. CX Enterprises has the following expected dividends: $ 1.13 in one year, $ 1.22 in two years, and $ 1.28 in three years. After that, its dividends are expected to grow at 3.6 % per year forever (so that year 4's dividend will be 3.6 % more than $ 1.28 and so on). If CX's equity cost of capital is 11.9 %, what is the current price of its stock? The price of the stock will be $_____. (Round to the nearest cent.)

Q8. Assume Highline Company has just paid an annual dividend of $ 1.01. Analysts are predicting an 11.3 % per year growth rate in earnings over the next five years. After then, Highline's earnings are expected to grow at the current industry average of 5.1 % per year. If Highline's equity cost of capital is 9.5 % per year and its dividend payout ratio remains constant, for what price does the dividend-discount model predict Highline stock should sell? The value of Highline's stock is $ _____. (Round to the nearest cent.)

Q9. Halliford Corporation expects to have earnings this coming year of $ 3.266 per share. Halliford plans to retain all of its earnings for the next two years. Then, for the subsequent two years, the firm will retain 55 % of its earnings. It will retain 19 % of its earnings from that point onward. Each year, retained earnings will be invested in new projects with an expected return of 22.1 % per year. Any earnings that are not retained will be paid out as dividends. Assume Halliford's share count remains constant and all earnings growth comes from the investment of retained earnings. If Halliford's equity cost of capital is 8.2 %, what price would you estimate for Halliford stock? The stock price will be $ _____. (Round to the nearest cent.)

Q10. What required return is implied by the dividend-discount model for a stock that is selling for $77, is expected to pay a dividend next year of $1.69, and growth in dividends is expected to be 6.4% per year forever? (In percent, rounded to 4 decimals.) _____ %

Q11. A stock is selling for $53.51, and just paid a $6.5 annual dividend. If investors require 15.4% return on this stock, what is the expected price of this stock 2.1 years from now, according the the dividend growth model? (Rounded to the nearest 10 cents.) $ _____