How can I do this for my company Macy's, Inc. (M)? Please use excel.

Constant Growth Dividend Valuation Model Estimate the required rate of return using the constant growth dividend valuation model, For g, use analysts' forecasts of earnings growth for next years (may be available in many websites such as Yahoo!Finance). If your company does not pay a dividend, then required return of the stock -g