Please note I understand the first part and have come to the stock price of $28.11. However, I cannot understand how to create an excel table to do number 6 of this problem. Please help with how to do this in excel.

Develop a valuation model for a common stock assuming that a company just paid a dividend of $1.75 per share. Its assumed that the dividend will grow at a constant rate of 6% per year forever. The risk-free rate is 6% with an expected return on the market of 12% and a beta of 1.1. Show each step in generating the resulting valuation.

6. Use your analysis of question 5 above to form a table that shows all combinations for the model with the growth rate at 2%, 6%, and 9% and the beta at 0.75, 1.1, and 1.8. Explain why your generated results make financial sense.