Weekly prices of NFLX, LLY, BAC, COST and SP500 are given in the Excel file...

90.2K

Verified Solution

Question

Finance

image

Weekly prices of NFLX, LLY, BAC, COST and SP500 are given in the Excel file on compass. Estimate the expected weekly returns and the covariance matrix of the returns. You are constructing portfolios using NFLX, LLY, BAC and COST. Assume no short selling. (1). Find the weights of the minimum variance portfolio and the corresponding mean and standard deviation of the portfolio return. (2). Could a portfolio with an expected return of 0.3% be efficient? Why? (3). Construct an efficient portfolio with an expected return of 0.6%. Report the weights and the corresponding standard deviation of the portfolio return. (4). Using SP500 as a proxy for the market portfolio, estimate the beta of LLY. Weekly prices of NFLX, LLY, BAC, COST and SP500 are given in the Excel file on compass. Estimate the expected weekly returns and the covariance matrix of the returns. You are constructing portfolios using NFLX, LLY, BAC and COST. Assume no short selling. (1). Find the weights of the minimum variance portfolio and the corresponding mean and standard deviation of the portfolio return. (2). Could a portfolio with an expected return of 0.3% be efficient? Why? (3). Construct an efficient portfolio with an expected return of 0.6%. Report the weights and the corresponding standard deviation of the portfolio return. (4). Using SP500 as a proxy for the market portfolio, estimate the beta of LLY

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