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

Sign up to view the entire interaction

Top Answer

Dear student Please find... View the full answer


Regression Statistics
Multiple R 0.546482
R Square 0.298643
Adjusted R Square
Standard Error
Total SS
F Significance...

Sign up to view the full answer

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

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online