Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with this question and everything I copied through the book, there is no any more relevant information You can download data for

I need help with this question and everything I copied through the book, there is no any more relevant information

You can download data for the following questions from finance.yahoo.com.Use the Beyond the Page feature to access an Excel program for calculating the efficient frontier.(We are grateful to Darien Huang for providing us with a copy of this program.) Excel functions SLOPE, STDEV, COVAR, and CORREL are especially useful for answering the followingquestions.

a. Download up to 10 years of monthly returns for 4 different stocks and enter them intothe Excel program. Enter some plausible figures for the expected return on each stock andfind the set of efficient portfolios. Assume that you cannot borrow or lend. Any 5 stocks can be found through the finance.yahoo.com

Facebook, Amazon, Tesla, Netfli are my 4 stocks, date 10 years from Nov 12, 2009 to Nov 12, 2019 in 10 years

Facebook data:https://finance.yahoo.com/quote/FB/history?period1=1258012800&period2=1573545600&interval=1mo&filter=history&frequency=1mo ( and choose download)

Amazon data: https://finance.yahoo.com/quote/AMZN/history?p=AMZN&.tsrc=fin-srch

Tesla https://finance.yahoo.com/quote/TSLA/history?period1=1258012800&period2=1573545600&interval=1mo&filter=history&frequency=1mo

Netflix data: https://finance.yahoo.com/quote/NFLX/history?p=NFLX&.tsrc=fin-srch

b. How does the possibility of short sales improve the choices open to the investor?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Markets and Institutions

Authors: Jeff Madura

11th Edition

1133947875, 9781305143005, 1305143000, 978-1133947875

More Books

Students also viewed these Finance questions

Question

Identify some of the opportunities available to small businesses.

Answered: 1 week ago

Question

Name the most common causes of small business failure.

Answered: 1 week ago

Question

Suggest ways to court success in a small business venture.

Answered: 1 week ago