13 Finance questions using the EXCEL PROGRAM!

FOLLOWING THE FORMAT IN THE YOUTUBE VIDEO IS IMPORTANT ------>https://www.youtube.com/watch?v=L9cs9behTRg

no credit if the format is not identical to the youtube video. Some answers in youtube video as well.

9.5 Present value of dividends: Fresno Corp. is a fast-growing company that expects to rate of 30 percent over the next two years and then slow down to a growth rate of 18 p the following three years. If the last dividend paid by the company was $2.15, estimate dividends for the next five years. Compute the present value of these dividends if the r rate of return was 14 percent. ompany that expects to grow at a to a growth rate of 18 percent for any was $2.15, estimate the f these dividends if the required 9.6 Zero growth: Nynet, Inc., paid a dividend of $4.18 last year. The company does not exp to increase its dividend for the next several years. If the required rate of return is 18.5 percent, what is the current price of the stock? r. The company does not expect uired rate of return is 18.5 9.7 Zero growth: Knight Supply Corp. has not grown for the past several years and expec growth to continue. The firm last paid a dividend of $3.56. If you require a rate of return what is the current stock price? ast several years and expects this lack of of you require a rate of return of 13 percent, 9.8 Zero growth: Ron Santana is interested in buying the stock of First National Bank. W expects no growth in the near future, Ron is attracted by the dividend income. Last ye dividend of $5.65. If Ron requires a return of 14 percent on such stocks, what is the m should be willing to pay for a share of the bank's stock? k of First National Bank. While the bank e dividend income. Last year the bank paid a such stocks, what is the maximum price he 9.9 Zero growth: The current stock price of Largent, Inc., is $44.72. If the required rate o percent, what is the dividend paid by this firm, if the dividend is not expected to grow 4.72. If the required rate of return is 19 d is not expected to grow in the near future? 9.10 Constant growth: Moriband Corp. paid a dividend of $2.15 yesterday. The company's d expected to grow at a steady rate of 5 percent for the next several years. If stocks of com Moriband require a rate of return of 15 percent, what should be the market price of Morib 5 yesterday. The company's dividend is several years. If stocks of companies like d be the market price of Moribund stock? 9.11 Constant growth: Nyeil, Inc., is a consumer products firm growing at a constant r firm's last dividend was $3.36. If the required rate of return is 18 percent, what is th stock? growing at a constant rate of 6.5 percent. The s 18 percent, what is the market value of this 9.12 Constant growth: Reco Corp. is expected to pay a dividend of $2.25 next year. The stock price a year from now is $37.50. If the required rate of return is 14 percent, wha stock price? Assume constant growth. nd of $2.25 next year. The forecast for the of return is 14 percent, what is the current 9.13 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? nt rate of 7 percent. If and its current stock 9.14 Preferred stock valuation: X-Centric Energy Company has issued perpetual preferr stated (par) of $100 and a dividend of 4.5 percent. If the required rate of return is 8.25 the stock's current market price? as issued perpetual preferred stock with a quired rate of return is 8.25 percent, what is 9.15 Preferred stock valuation: The First Bank of Ellicott City has issued perpetual prefe par value. The bank pays a quarterly dividend of $1.65 on this stock. What is the curr preferred stock given a required rate of return of 11.6 percent? ssued perpetual preferred stock with a $100 stock. What is the current price of this 9.16 Preferred stock: The preferred stock of Axim Corp. is selling currently at $47.13. If the of return is 12.2 percent, what is the dividend paid by this stock? ing currently at $47.13. If the required rate stock? 9.17 Preferred stock: Each quarter, Sirkota, Inc., pays a dividend on its perpetual preferred stock is selling at $63.37. If the required rate of return for such stocks is 15.5 percent, dividend paid by this firm? d on its perpetual preferred stock. Today the ch stocks is 15.5 percent, what is the quarterly