question 12-22

part a, b,c, d thank you!

please show on an excel sheet

expected to grow at 7 percent per year in the $23 per share, its last dividend was $2.00, and the company will pay a dividend of $2.14 at the end of the current year. a. Using the discounted cash flow approach, what is its cost of retained b. If the firm's beta is 1.6, the risk-free rate is 9 percent, and the average return on the market is 13 percent, what is the firm's cost of equity using the CAPM approach? c. If the firm's bonds earn a return of 12 percent, what is rs using the bond. yield-plus-risk-premium approach? (Hint: Use the midpoint of the risk premium range discussed in the chapter.) d. Based on the results of parts (a) through (c), what would you estimate Talukdar's cost of retained earnings to be