Problem: Using Microsoft Excel and historical daily data from https://finance.yahoo.com, calculate the beta for Harley-Davidson in comparison to the S&P 500 Index over the past year.
Then utilizing the dividend discount model from your text, calculate the intrinsic value for Harley-Davidson.
From that analysis, comprise an investment strategy of buy, hold, or sell on Harley-Davidson.