5.[EXCEL] Present value of dividends: Fresno Corp. is a fast-growing company whose management expects it to grow
Question:
5.[EXCEL] Present value of dividends: Fresno Corp. is a fast-growing company whose management expects it to grow at a rate of 30 percent over the next two years and then to slow to a growth rate of 18 percent for the following three years. If the last dividend paid by the company was $2.15, estimate the dividends for the next five years. Compute the present value of these dividends if the required rate of return is 14 percent.
6.[EXCEL] Zero growth: Nynet, Inc., paid a dividend of $4.18 last year. The company's management does not expect to increase its dividend in the foreseeable future. If the required rate of return is 18.5 percent, what is the current value of the stock?
7.[EXCEL] Zero growth: Knight Supply Corp. has not grown for the past several years, and management expects this lack of growth to continue. The firm last paid a dividend of $3.56. If you require a rate of return of 13 percent, what is the current value of this stock to you?
8.[EXCEL] Zero growth: Ron Santana is interested in buying the stock of First National Bank. While the bank's management expects no growth in the near future, Ron is attracted by the dividend income. Last year the bank paid a dividend of $5.65. If Ron requires a return of 14 percent on such stocks, what is the maximum price he should be willing to pay for a share of the bank's stock?
9.[EXCEL] Zero growth: The current stock price of Largent, Inc., is $44.72. If the required rate of return is 19 percent, what is the dividend paid by this firm if the dividend is not expected to grow in the future?
10.[EXCEL] Constant growth: Moriband Corp. paid a dividend of $2.15 yesterday. The company's dividend is expected to grow at a steady rate of 5 percent for the foreseeable future. If investors in stocks of companies like Moriband require a rate of return of 15 percent, what should be the market price of Moriband stock?
11.[EXCEL] Constant growth: Nyeil, Inc., is a consumer products firm that is growing at a constant rate of 6.5 percent. The firm's last dividend was $3.36. If the required rate of return is 18 percent, what is the market value of this stock if dividends grow at the same rate as the firm?
12. [EXCEL] Constant growth: Reco Corp. is expected to pay a dividend of $2.25 next year. The forecast for the stock price a year from now is $37.50. If the required rate of return is 14 percent, what is the current stock price? Assume constant growth.
13.[EXCEL] Constant growth: Proxicam, Inc., is expected to grow at a constant rate of 7 percent. If the company's next dividend, which will be paid in a year, is $1.15 and its current stock price is $22.35, what is the required rate of return on this stock?
14.[EXCEL] Preferred stock valuation: X-Centric Energy Company has issued perpetual preferred stock with a stated (par) value of $100 and a dividend of 4.5 percent. If the required rate of return is 8.25 percent, what is the stock's current market price?
15.[EXCEL] Preferred stock valuation: The First Bank of Flagstaff has issued perpetual preferred stock with a $100 par value. The bank pays a quarterly dividend of $1.65 on this stock. What is the current price of this preferred stock given a required rate of return of 11.6 percent?
16.[EXCEL] Preferred stock valuation: The preferred stock of Axim Corp. is currently selling at $47.13. If the required rate of return is 12.2 percent, what is the dividend paid by this stock?
17.[EXCEL] Preferred stock valuation: Each quarter, Sirkota, Inc., pays a dividend on its perpetual preferred stock. Today the stock is selling at $63.37. If the required rate of return for such stocks is 15.5 percent, what is the quarterly dividend paid by Sirkota?