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.

The article How to Calculate the Regression of 2 Stocks Using Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days.