Explore BrainMass
Share

Explore BrainMass

    Intrinsic Value

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Using Microsoft Excel and historical daily data from http://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 calculate the intrinsic value for Harley-Davidson.

    From that analysis, comprise an investment strategy of buy, hold, or sell on Harley-Davidson.

    © BrainMass Inc. brainmass.com October 9, 2019, 9:46 pm ad1c9bdddf
    https://brainmass.com/business/accounting-for-corporations/intrinsic-value-197134

    Solution Preview

    Please see the attached files.

    Using Microsoft Excel and historical daily data from http://finance.yahoo.com, calculate the beta for Harley-Davidson in comparison to the S&P 500 Index over the past year.

    I have taken the data from Aug 16 2007 to Aug 15 2008 for HOG and S&P 500. This is in the attached file. The daily returns are calculated as (Price today-Price yesterday)/Price yesterday. We use the adjusted close values since these are adjusted for dividends and stock splits.

    The beta for Harley Davidson comes to 1.43.

    Then utilizing the dividend discount model calculate the intrinsic value for Harley-Davidson.

    Using the dividend discount model, the intrinsic ...

    Solution Summary

    The solution explains the calculation of intrinsic value using the example of Harley Davidson.

    $2.19