Find efficient frontier using capital asset pricing model

Reference no: EM131273063

Presentation

- Find the Efficient Frontier using Capital Asset Pricing Model
- Find the tangent portfolio weights (the efficient portfolio with highest Sharpe ratio)
- Go to google finance
- Download daily historical prices from Jan 2013 or more recent
- For:
- The Priceline Group Inc PCLN
- Alphabet GOOGL
- Skyworks Solutions SWKS
- Ocean Power Technologies, Inc OPTT
- Tripadvisor INc TRIP
- ENERGEN EGN
- Unit Corporation UNT
- McAfee Global Technologies MGT
- Grubhub GRUB
- 58.com WUBA
- SAE Exploration SAEX
- Chipotle CMG
- Chesapeake Energy Corp. CHK
- Northern Dynasty Minerals NAK
- 5 minute presentation of your results.
- Presentation must include a graph of the efficient frontier in the (return, risk) space j
- Provide excel sheet for calculations
- Provide of explanation for each step and assumptions specifically for the weight combos

- Need to compute as many combinations of weights for these 8 companies

As many portfolio s as you can

Portfolio	Average return	SD return
(1,0,0,0,0,0,0,0)
(0.9,0.1,0,0,0,0,0,0)
(0.9,0,0.1,0,0,0,0,0)
...
(0.9,0,0,0,0,0,0,0.1)
(0,1,0,0,0,0,0,0)
(0.1,0.9,0,0,0,0,0,0)
(0,0.9,0.1,0,0,0,0,0)
....
(0,0.9,0,0,0,0,0,0.1)

slides required excel doc and word doc for explanation

Attachment:- Assignment.rar

Reference no: EM131273063

Questions Cloud

How project manager determines whether project is successful : In a 2-3 page paper, discuss how a project manager determines whether a project is successful or not. Make sure to discuss project elements such as: Budget, project milestones, Human Capital and customer satisfaction.

Financial failure and its subsequent bailout : Discuss the role that AIG's corporate culture played in its downfall? How a stronger ethics program might have helped the company strengthen the ethics of its corporate culture? What could AIG have done differently to prevent its financial failure an..

What are the different types of objectives : Your textbook presents the criteria for selecting a planning model - also known as the Three Fs of Program Planning. Using a current health issue as your example, describe how you would use the Three Fs to select a planning model for your interven..

How will your plan affect the poor middle-class : Due to the general elections coming up soon, you hear a lot about what each of the candidates' plans are to "fix" the healthcare system in United States. Okay, well what do you think the U.S. should do to make the current healthcare system better..

Find efficient frontier using capital asset pricing model : Find the Efficient Frontier using Capital Asset Pricing Model and find the tangent portfolio weights (the efficient portfolio with highest Sharpe ratio)

What are your main concerns with the physics department : With the Massive Arena renovation, who are the people to whom you need to communicate hazards? What are your main concerns with the physics department? What are the hazardous material/waste spill response issues for the university, and how should you..

How might forensic dna applications be used to detect crimes : How might forensic DNA applications be used to detect these crimes and to ideally deter future occurrences of illegal poaching and smuggling operations?

Operations management question : Even though this technique claims to be flawless (DMAIC and/or DMADV ), what are some drawbacks to data collection and analysis? How can a company certify the information's accuracy?

What is the scientific name for the cheetah : What is the scientific name for the cheetah? What is another common name for the cheetah? In what red list category are cheetah classified? In what part of Africa are most cheetahs found?

User Account

All Pages