Need in Excel worksheet with all steps ALso show me Excel functions plz solve within...
60.1K
Verified Solution
Link Copied!
Question
Finance
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)
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
