Purchase Solution

Intrinsic Value

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution

Solution Summary

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

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 ...

Purchase this Solution


Free BrainMass Quizzes
Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Motivation

This tests some key elements of major motivation theories.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.