Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. need in excel worksheet with all steps also show m

Need in Excel worksheet with all steps ALso show me Excel functions plz solve within...

60.1K

Verified Solution

Question

Finance

image

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!
Become a Member

Other questions asked by students