USE THE COMANY NETFLIX ONLY! USE A EXCEL FILE! PROVIDE A LINK TO WHERE...

90.2K

Verified Solution

Question

Finance

USE THE COMANY NETFLIX ONLY!

USE A EXCEL FILE!

PROVIDE A LINK TO WHERE THE DATA CAME FROM!

(i) Estimate the stock beta for a company. Select a publicly traded company (preferably large firms) and download the monthly closing prices for 5 years into Excel. Choose a market index (e.g. S&P 500) and download the monthly closing values for 5 years into Excel. Calculate the monthly returns for the selected company and the market index. Using the regression function in Excel, regress the stock return on the market index return.

(ii) Compare and contrast the stock beta you estimated with two other sources (e.g. Yahoo! Finance, CNBC, etc.).

USE THE COMANY NETFLIX ONLY!

USE A EXCEL FILE!

PROVIDE A LINK TO WHERE THE DATA CAME FROM!

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students