The next dividend payment by Blue Cheese, Inc., will be $1.89per share. The dividends are anticipated to maintain a growth rate of 5 percent forever. If the stock currently sells for $38 per share, what is the required return?

what would be the steps in excel (what's the formula to use)

1. Calculate the required return Stock Values Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In 112 -AA Conditional Format as Cell Cells Editing Formatting Table Styles- Paste Alignment Number Clipboard D13 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 sells for $38 per share, what is the required return? 4 Dividend paid Dividend growth rate Stock price 1.89 5% 38.00 10 Complete the following analysis. Do not hard code values in your calculations 12 13 Required return 15 16 17 Sheet1 + 100% Attempt(s) 3/3 Hint Show Me