Find the weights for the market portfolio

Assignment Help Financial Management

Reference no: EM131874631

Using the ETF data from the previous problem:

a. Create a sample variance/covariance matrix using the ETF returns. Use the matrix algebra functions or the COVARIANCE.S function. (Hint: The matrix function will be less work.)

b. Using the Solver, find the weights for the minimum variance portfolio.

c. Using the Solver, find the optimal weights for a portfolio with a return of 2.0% per month. Now, create nine additional portfolios with returns between that of the minimum variance and maximum return portfolios.

d. Create a chart of the efficient frontier. Now add a new series that shows the returns and standard deviations of the individual ETFs. How does the efficient frontier compare to the ETFs?

e. Find the weights for the market portfolio. What is its return and standard deviation?

f. Add the capital market line (CML) to your chart.

Reference no: EM131874631

Questions Cloud

Explain the various forms of discrimination : All forms of discrimination are generally difficult to prove. It is difficult to know whether the accused party is intentionally discriminating or the evidence.

Develop a list of ways that mbwa : Develop a list of ways that MBWA could help them be more effective managers such as help to build trust, improve accountability and morale.

Potential effects of recruitment on the organization : After completing this activity you will better understand the potential effects of recruitment on the organization and how individual decisions can impact

How should the founders resonates with customers : How should the founders of Panda Sunglasses define unique sellin proposition for their company that a resonates with customers?

Find the weights for the market portfolio : Find the weights for the market portfolio. What is its return and standard deviation?

Expatriate management at astrazeneca : Expatriate Management at AstraZeneca." Your analysis should address the following questions:

The big german chemical and? health-care firm : He's thinking about investing in some foreign securities and is looking at stocks in ? (1) Bayer? AG, the big German chemical and? health-care firm,

When developing evaluation objectives : When developing evaluation objectives; it is imperative that they "measure what matters most" and align with the employee

Major steps in conducting a job analysis survey : What are the major steps in conducting a job analysis survey? What can you do for each step to help ensure a high quality result

User Account

All Pages