Collect stock price data and Compute some data(Provide examples written by my classmate)

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)

Answers

Related Questions

Other : Resume and Cover letter - English homework...

Select a job description from an actual company, organization or college/university and design your cover letter to demonstrate your knowledge of that...

Business Law : Legal Memorandum for an Appeals Pro...

Many times a party feels as though the court was wrong, whether through the verdict at trial, or a case being dismissed before trial. When this occurs...

Other : Help needed ASAP...

Assignment: (Class presentation using power point slides and/or flipcharts)Galleon Shipping Lines has entered into a 50-50 joint venture with 2ROW Gro...

Other : Resume and Cover letter - English homework...

Select a job description from an actual company, organization or college/university and design your cover letter to demonstrate your knowledge of that...

Other : Resume and Cover letter - English homework...

Select a job description from an actual company, organization or college/university and design your cover letter to demonstrate your knowledge of that...

Other : The First Two Years: Cognitive Developmen...

Language Acquisition and Symbol Weaving—Conflicting or Complementing Views?  Scientists have developed a number of different theories about how (an...

Other : Resume and Cover letter - English homework...

Select a job description from an actual company, organization or college/university and design your cover letter to demonstrate your knowledge of that...

Other : DUE TODAY (Timeline of Abnormal Psychology...

MUST be done by 9:00 p.m. EST.If you can not start working NOW do not ask to do the work!I need a time line for abnormal psychology. Create a timeline...

Business : Project Management...

The final six to eight page paper must demonstrate understanding of new learning in the field of project management. It is mandatory to have research...

Application Writing : Recruitment, Interviewing, a...

Congratulations! You were successful in changing the CEO's requested requirements for the new position of a Claims Supervisor. Now it's time t...

History : 5 questions about civil war...

1What was the final major legislative effort to prevent the Civil War?The Compromise of 1850The Kansas-Nebraska ActThe Missouri CompromiseThe proposed...

Economics : Economics Question...

Assume that the industry for flour tortillas in Denver is perfectly competitive. There are 200 firms. 75 of the firms are “high-cost,” with short-...

Science : Bathymetric Data...

ONLY BATHYMETRIC PORTION REQUIRED Basically, in this lab you have to re-create diagram 4 that is included in your notes (on how to complete the lab)....

Writing : Research Methods...

In your final paper for this course, you will need to write a Methods section that is about 4 pages long where you will assess and evaluate the method...

Business Finance : industry for flour tortillas i...

Assume that the industry for flour tortillas in Denver is perfectly competitive. There are 200 firms. 75 of the firms are “high-cost,” with short-...

Other : Budget paper...

Write a clear, concise executive summary that will argue for the increase in the budget for the line item “Public Amenities Fund for the City of Nor...

Science : Soap notes- male reproductive, use uplo...

Create soap note form uploaded pt. health hx. Make sure you are including scholarly references no later than 5 yr. old. in your assessment (diagnoses)...

Management : develop a training needs analysis (TN...

Select or create an organization for the authentic assessment. In this assignment, you will begin to develop a training needs analysis (TNA) for your...

Business Law : Cite Florida Case law for these 2 q...

Ben and Jennifer got engaged. At the time, Ben bought her a 1.5 carat pink diamond engagement ring. After a tumultuous relationship and one postponed...

Accounting : value chain analysis case study...

The Question is :- Critically evaluate the case study provided in the attached (pdf) file . Highlight your analysis with recommendations . (800 words)...

Psychology : Research & Evaluation...

What conclusions can be drawn about school counseling services considering the results and effect sizes based on the example from the following: Whis...

Programming : Need SMS server/website to do the be...

Need SMS server/website to do the below (will provide sms hosting myself)- Sim will receive text message- Message will update on our server/website- S...

Engineering : Draw Sequence Diagram & Design Class...

PLEASE DO READ THE INSTRUCTION BEFORE BID , THANKSProblem: Design an access card system for a buildingThis building requires access cards to enter its...

Other : Help with organizational behavior question...

  Think again about the worst coworker you’ve ever had—the one who did some of thethings listed in Table 1-1 . Think about what that coworker’...

If you didn't find the right answer

Ask Your Questions, We'll notify you once someone answers it