The excel template makes use of the MarketXLS hf_ functions to fetch all market data. This includes data such as beta, current year dividends, the stock’s current … 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. The current dividend is $0.60 per share, the constant growth rate is 6%, and your required rate of return is 22%. Find the PV of the dividends during the period of nonconstant growth.



The excel template also showcases the Duke Energy example as shown above. Joseph Koszelak 9,882 views We have developed Gordon Growth Model in Excel template that you can use to value any stock using this model. 2. Stock Valuation Non constant Growth - Duration: 2:17. To determine the intrinsic value, plug the values … Gordon Growth Model in Excel.