Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. how do i calculate this please show in excel and e

How do i calculate this please show in excel and explain? For this...

60.1K

Verified Solution

Question

Finance

imageimage

How do i calculate this please show in excel and explain?

For this question, round your answers to 3 decimal places and do not express your answers as percentages. A pension fund manager is considering three mutual funds. The first is a stock fund, the second is a long-term government and corporate bond fund, and the third is a T bill money market fund that yields a rate of 8%. The probability distribution of the risky funds is as follows (The correlation between the fund returns is 0.10 ): c. What are the investment proportions in the optimal risky portfolio of the two risky funds, and what is the Sharpe ratio, expected value and standard deviation of its rate of return? The optimal risky portfolio weight for Stock fund is The optimal risky portfolio weight for Bond fund is The expected return for optimal risky portfolio is The standard deviation for optimal risky portfolio is The Sharpe ratio for optimal risky portfolio is

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