We have developed Gordon Growth Model in Excel template that you can use to value any stock using this model. The stock's intrinsic value today, P0, is the present value of the dividends during the nonconstant growth period plus the present value of the horizon value: To implement Equation 5-5, we go through the following three steps: 1.

Gordon Growth Model in Excel.

Joseph Koszelak 9,882 views Stock Valuation Non constant Growth - Duration: 2:17. The current dividend is $0.60 per share, the constant growth rate is 6%, and your required rate of return is 22%. To determine the intrinsic value, plug the values … This includes data such as beta, current year dividends, the stock’s current …

The excel template makes use of the MarketXLS hf_ functions to fetch all market data.

2. The excel template also showcases the Duke Energy example as shown above.

Find the PV of the dividends during the period of nonconstant growth.