Questions – i) using the new markowitz frontier ms-excel file

Document Preview:

I) Using the New Markowitz Frontier MS-Excel file, you need to obtain 5 years of weekly RETURNS (not prices; you may have to calculate returns from prices) for any two stocks of your choosing. You must modify the spreadsheet to use your data. A successful spreadsheet will allow the user to 1) see the efficient frontier, 2) the correlation of returns of the combined portfolio, 3) find the balance of the two stocks that results in a portfolio of minimum risk, 4) explain what is happening in a paragraph or two attached to the spreadsheet II) Using the Monte Carlo Pi MS-Excel file, you need to solve this problem USING Monte-Carlo Simulation. You do NOT need to learn calculus to do this. Technical details: You must turn in a single MS-Excel spread sheet which solves these problems. I) Using the New Markowitz Frontier MS-Excel file, you need to obtain 5 years of weekly RETURNS (not prices; you may have to calculate returns from prices) for any two stocks of your choosing. You must modify the spreadsheet to use your data. A successful spreadsheet will allow the user to 1) see the efficient frontier, 2) the correlation of returns of the combined portfolio, 3) find the balance of the two stocks that results in a portfolio of minimum risk, 4) explain what is happening in a paragraph or two attached to the spreadsheet II) Using the Monte Carlo Pi MS-Excel file, you need to solve this problem USING Monte-Carlo Simulation. You do NOT need to learn calculus to do this. Technical details: You must turn in a single MS-Excel spread sheet which solves these problems.

Don't use plagiarized sources. Get Your Custom Essay on
Questions – i) using the new markowitz frontier ms-excel file
Just from $13/Page
Order Essay

Calculator

Calculate the price of your paper

Total price:$26
Our features

We've got everything to become your favourite writing service

Need a better grade?
We've got you covered.

Order your paper