A:

The Gordon Growth Model, or the dividend discount model (DDM), is a model used to calculate the intrinsic value of a stock based on the present value of future dividends that grow at a constant rate.

The model assumes a company exists forever and pays dividends that increase at a constant rate. To estimate the value of a stock, the model takes the infinite series of dividends per share and discounts them back into the present using the required rate of return. The result is a simple formula, which is based on mathematical properties of an infinite series of numbers growing at a constant rate.

How to Use the Gordon Growth Model

The intrinsic value of a stock can be found using the formula (which is based on mathematical properties of an infinite series of numbers growing at a constant rate):

Intrinsic value of stock = D÷(k-g)

D is the expected dividend per share, k is the investor's rate of return required and g is the expected dividend growth rate.

How to Calculate Intrinsic Value Using Excel

Using the Gordon Growth Model to find intrinsic value is fairly simple to calculate in Microsoft Excel.

To get started, set up the following in an Excel spreadsheet:

  1. Enter "stock price" into cell A2
  2. Next, enter "current dividend" into cell A3.
  3. Then, enter the "expected dividend in one year" into cell A4.
  4. In cell A5, enter "constant growth rate." 
  5. Enter the required rate of return into cell B6 and "required rate of return" in cell A6.

For example, suppose you are looking at stock ABC and want to figure out the intrinsic value of it. Assume you know the growth rate in dividends and also know the value of the current dividend.

The current dividend is $0.60 per share, the constant growth rate is 6%, and your required rate of return is 22 percent. 

To determine the intrinsic value, plug the values from the example above into Excel as follows:

  1. Enter $0.60 into cell B3.
  2. Enter 6% into cell B5.
  3. Enter 22% into cell B6.
  4. Now, you need to find the expected dividend in one year. In cell B4, enter "=B3*(1+B5)", which gives you 0.64 for the expected dividend, one year from the present day.
  5. Finally, you can now find the value of the intrinsic price of the stock. In cell B2, enter "=B4÷(B6-B5)."

The current intrinsic value of the stock in this example is $3.98 per share.

RELATED FAQS
  1. How do you calculate present value in Excel?

    Learn what present value and future value are and how to use Microsoft Excel to calculate present value, given the future ... Read Answer >>
  2. What is the formula for calculating return on equity (ROE) in Excel?

    Find out more about return on equity, the formula to calculate it and how to calculate return on equity in Microsoft Excel. Read Answer >>
  3. Intrinsic Value vs Current Market Value

    Discover the differences between intrinsic and market values, what makes the former difficult to determine, and how investor ... Read Answer >>
  4. How do I calculate the expected return of my portfolio in Excel?

    Find out how to calculate the total expected annual return of your portfolio in Microsoft Excel using the value and return ... Read Answer >>
  5. How do you calculate a payout ratio using Excel?

    Learn what the payout ratio is, what dividends per share and earnings per share are, and how the payout ratio is calculated ... Read Answer >>
  6. How is a company's share price determined?

    Understand the concept behind the Gordon growth model and what it is used to measure. Learn how a company's share price is ... Read Answer >>
Related Articles
  1. Investing

    What Is The Intrinsic Value Of A Stock?

    Intrinsic value can be subjective and difficult to estimate. It’s a perception of a security’s value that factors tangible and intangible factors.
  2. Investing

    Digging Into The Dividend Discount Model

    The DDM is one of the most foundational of financial theories, but it's only as good as its assumptions.
  3. Investing

    Valuing A Stock With Supernormal Dividend Growth Rates

    If these calculations are off, it could drastically change the value of the shares.
  4. Investing

    Is Dividend Investing a Good Strategy?

    Understanding dividends and how they generate steady income for shareholders will help you become a more informed and successful investor.
  5. Investing

    Put Dividends to Work in Your Portfolio

    Find out how a company can put its profits directly into your hands.
  6. Investing

    AAPL: Apple Dividend Analysis

    Apple's dividend has had healthy growth ever since its 2012 reinstatement, thanks to Apple's continuously rising revenue, earnings and operating cash flow.
  7. Trading

    What Is Option Moneyness?

    In the money, at the money and out of the money define the current profitability of options positions.
  8. Investing

    The Top 5 Dividend Paying Oil Stocks for 2016

    Discover the top five dividend-paying oil companies for 2016 and what factors contribute to their ability to continue dividend payments.
RELATED TERMS
  1. Intrinsic Value

    Intrinsic value is the perceived or calculated value of a company, ...
  2. Dividend Discount Model - DDM

    The dividend discount model (DDM) is a system for valuing the ...
  3. Full Value

    An asset is said to have reached full value when its intrinsic ...
  4. Financial Modeling

    The process by which a firm constructs a financial representation ...
  5. Dividend

    A dividend is a distribution of a portion of a company's earnings, ...
  6. Value

    Value is the monetary, material or assessed worth of an asset, ...
Hot Definitions
  1. Volatility

    Volatility measures how much the price of a security, derivative, or index fluctuates.
  2. Money Market

    The money market is a segment of the financial market in which financial instruments with high liquidity and very short maturities ...
  3. Cost of Debt

    Cost of debt is the effective rate that a company pays on its current debt as part of its capital structure.
  4. Depreciation

    Depreciation is an accounting method of allocating the cost of a tangible asset over its useful life and is used to account ...
  5. Ratio Analysis

    A ratio analysis is a quantitative analysis of information contained in a company’s financial statements.
  6. Time Value of Money - TVM

    The time value of money is the idea that money presently available is worth more than the same amount in the future due to ...
Trading Center