i want to know what functions im inputing for these. for example for the required return on the excel sheet do I enter =rate(d1,d2...etc)

1. Celculate the required retum. The next dividend payment by Blue Cheese, Inc., will be $1.89 per share. The dividends are anticipated to maintain a growth rate of 5 percent forever. If the stock currently solls for $38 per share, what is the required return? Complete the following analysis. Do not hard code values in your calculations. 1. Calculate the stock price for each company. Red, Inc., Yellow Corp., and Blue Company each will pay a dividend of $2.65 next year. The growth rate in dividends for all three companies is 5 percent. The required return for each company's stock is 8 percent, 11 percent, and 14 percent, respectively. What is the stock price for each company? Complete the following analysis. Do not hard code values in your calculations