create a 3 asset efficient frontier using Microsoft Excel.

The purpose of this project is to create a 3 asset efficient frontier using Microsoft Excel. This is very similar to the 2asset example that we created as an in-class example.

For this project you will be required to do the following:

Using finance.yahoo.com download 10 years of monthly price data for 3 stocks into Excel. You may pick any three stocks you like, however stocks that are indifferent industries will give you the best graphical results.
Calculate the monthly returns for each stock.
Calculate the variance/standard deviation for each individual stock. You should calculate one stock using the long method that we did in class. For the other two stocks you can use the Excel built in functions.
Calculate the covariance between each asset. You should calculate one covariance using the long method that we did in class. For the other two, you can use the Excel built in function.
Set up the Variance/Covariance matrix and vectors for the weights and returns.
Using Matrix operations in Excel, calculate portfolio Variance/Standard Deviation and Returns.
Graph Each Asset
Using Solver, calculate (and graph) the minimum variance portfolio.
Using Solver, calculate (and graph) the efficient frontier. Pay attention to the range, and adjust accordingly.
Create (and graph) 25 random possible portfolios