Create a model that will automatically calculate the minimum variance and optimal portfolio as well as be able to draw the efficient frontier for a 3 risky asset portfolio.
Data shown below that you need to use to create an efficient frontier. In addition to the efficient frontier you will need to find the optimal and the minimum variance portfolio as well as the Capital Market line. Make sure you graph all the required information and label your graph properly.
|
Group Name & Number
|
|
|
Student information
|
|
|
|
|
Student 1
|
|
Family Name
|
|
|
First Name
|
|
|
Student Number
|
|
|
|
|
Student 2
|
|
Family Name
|
|
|
First Name
|
|
|
Student Number
|
|
|
|
|
Student 3
|
|
Family Name
|
|
|
First Name
|
|
|
Student Number
|
|
|
|
|
Student 4
|
|
Family Name
|
|
|
First Name
|
|
|
Student Number
|
|
|
|