Question: Need in Excel worksheet with all steps ALso show me Excel functions plz solve within 2 hrs 23. The table below presents the variance -

 Need in Excel worksheet with all steps ALso show me Excel

Need in Excel worksheet with all steps ALso show me Excel functions

plz solve within 2 hrs

23. The table below presents the variance - covariance matrix and the mean returns for six different stocks of financial institutions, based on their monthly data. A B D E G H F GS FRE WM STT C --- FRE WM STT JPM GS 0.0052 0.0033 0.0015 0.0039 0.0068 0.0010 0.0033 0.0120 0.0034 0.0072 0.0063 0.0015 0.0015 0.0034 0.0046 0.0058 0.0039 0.0015 JPM 0.0039 0.0072 0.0058 0.0379 0.0073 0.0023 0.0068 0.0063 0.0039 0.0073 0.0389 0.0023 0.0010 0.0015 0.0015 0.0023 0.0023 0.0018 Mean returns 0.24% -0.89% 0.48% 0.44% -1.46% 1.04% a. Calculate the Global Minimum Variance Portfolio (GMVP). b. Calculate the efficient portfolio, assuming the monthly risk free rate is 0.45%. c. Draw the efficient frontier with the expected return on the vertical axis, the standard deviation on the horizontal axis, and use convex 8 combinations between the GMVP and the efficient portfolio from (a) and (b), correspondingly (notice that the whole efficient frontier can be drawn from any two points on it, therefore since we know how to find the GMVP and the efficient portfolio it is enough to depict the complete efficient frontier)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!