Compute monthly stock returns and standard deviation

Assignment Help Financial Management

Reference no: EM132430219

Project 2 (Efficient portfolios and Efficient frontier)

You are assigned with five stocks (See the assigned firm name and ticker on BB) and you are expected to build the investment opportunity set using those five stocks. Please collect monthly stock price from FINANCEYAHOO and employ the data range from Jan 1, 2015 to June 30, 2019. Then using the risk-free rate of 0.33%, you are expected to develop the complete portfolio and develop the efficient frontier of these six securities (T-bill and five stocks).

1. Collect monthly stock price data from Jan 1, 2015 to June 30, 2019 (See my example with the sheet entitled Data)

2. Compute monthly stock returns and standard deviation (See my example with the sheet entitled Data)

3. Develop Table of Covariance of these five stocks (See my example with the sheet entitled Data)

4. Find the Minimum-Variance risky portfolio (See my example with the sheet entitled MVP)

5. Find the Efficient Risky portfolios (See my example with the sheet entitled EF , Result, and Graph)

6. Develop the capital market line using T-bill rate of 0.33% (See my example with the sheet entitled MVP, Result, and Graph)

Attachment:- Choose five Companies.rar

Attachment:- Example.rar

Reference no: EM132430219

Questions Cloud

What role did both men envision for the military : How did both men see warfare as useful to their cause. What role did both men envision for the military?

Write an essay on Sexually Violent Predators : Write an essay on Sexually Violent Predators.Sexually violent predators are among the most feared and the most ridiculed individuals in our society.

Context of the development of the new empires : Find out all that you can about the Paris World's Fair of 1900 and Rodin's Gates of Hell and share your most interesting insights on this monumental artwork

Calculate the break-even point in units : Question - Break-Even Units and Sales Revenue: Margin of Safety. Calculate the break-even point in units. Calculate the break-even point in sales revenue

Compute monthly stock returns and standard deviation : Compute monthly stock returns and standard deviation. Develop Table of Covariance of these five stocks. Find the Minimum-Variance risky portfolio

Great britain and the american revolutionaries in 1776 : Describe the military advantages and disadvantages of Great Britain and the American revolutionaries in 1776.

Name the eight major groups of zooplankton : Name the eight (8) major groups of zooplankton and describe the characteristics of each group.

Explain the influence of culture and subculture on robert : Explain how the gang interprets "threats to honor" differently than other parts of society.Explain the influence of culture and subculture on Robert.

What is attributable to the net appreciation element of gift : A total of $58,500 of the gift tax what is attributable to the net appreciation element of the gift. How much is Jill's basis in home for purposes of gain

User Account

All Pages