View the step-by-step solution to:

# Ford Motor Company (F) a) Get the last 5 years of monthly stock returns for this firm.

Ford Motor Company (F)

a) Get the last 5 years of monthly stock returns for this firm.
Choose at least 2 market indices (example S&P 500 and NASDAQ)
Calculate the monthly market returns
Now use the equation for calculating β – that is, the ratio of stock covariance with the market divided by the market variance to calculate two βs – one for each market index chosen

b) Repeat part (a) – but with 1 year of weekly returns

c) Calculate the β by performing regression analysis with 5 years of monthly stock returns – using the two market indices in turn

d) Find the β from a published source – such as Yahoo! Finance or Value Line

e) Now that you have seven different βs for this one stock* – say which one is the most appropriate. Be sure to reflect on the choice of market index, the length of time for observation, the methodology and most importantly, the current level of risk (business and financial) faced by the industry as well as the firm being analyzed.

* 7 βS are as follows: In part (a) 5 year monthly returns + S&P 500 and 5 year monthly returns + NASDAQ ; in part (b) 1 year weekly returns + S&P 500 and 1 year weekly returns + NASDAQ; in part (c) 5 year monthly returns regressed against S&P500 + 5 year monthly returns regressed on NASDAQ; in part (d) – a published β from a reliable sour

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.546482
R Square 0.298643
0.286551
Standard Error
0.191454
Observations
60
ANOVA
df
Regression
Residual
Total SS
MS
F Significance...

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents