How Do I Calculate Stock Value Using the Gordon Growth Model in Excel?

The Gordon growth model, also known as the dividend discount model, is often applied in Microsoft Excel to determine the intrinsic value of a stock.