NEED HELP WITH QUESTION TWO. PLEASE BE EXTREMELY DETAILED WITH THE STEPS AND THE FORMULAS ETC ON HOW TO DO IT IN EXCEL.
LO 1 LC LO2 LO1 then cease paying dividends forever. If the required return on this stock is 9.2 percent, what is the current share price? 8. Valuing Preferred Stock. Smiling Elephant, Inc., has an issue of preferred stock outstanding that pays a $3.45 dividend every year, in perpetuity. If this issue currently sells for $77.32 per share, what is the required return? 9. Voting Rights. After successfully completing your corporate finance class, you feel the next challenge ahead is to serve on the board of directors of Schenkel Enterprises. Unfortunately, you will be the only individual voting for you. If the company has 450,000 shares outstanding and the stock currently sells for $34. how much will it cost you to buy a seat if the company uses straight voting? Assume that the company uses cumulative voting and there are 4 seats in the current election: how much will it cost you to buy a seat now? 10. Growth Rates. The stock price of Baskett Co. is $73. Investors require a return of 10.5 percent on similar stocks. If the company plans to pay a dividend of $4.25 next year, what growth rate is expected for the company's stock price? 11. Voluing Preferred Stock. E-Eyes.com has a new issue of preferred stock it calls 20/20 preferred. The stock will pay a $20 dividend per year, but the first dividend will not be paid until 20 years from today. If you require a return of 7.1 percent on this stock, how much should you pay today? 12. Stock Valuation. Wesen Corp. will pay a dividend of $3.14 next year. The company has stated that it will maintain a constant growth rate of 45 percent a yo er. If you want return of 12 percent, how much will turn of 8 percent? What does this tell you lationshi red return and the stock price? 13. Stor LO 1 LO 1 you pay for the That if you LO 2 0. has earnings of 18. What stock price PE were 21