Financial planner Minnie Margin has a substantial number of clients who wish to own a mutual fund portfolio that matches, as a whole, the performance of the Russell 2000 index. Her task is to determine what proportion of the portfolio should be invested in each of the five mutual funds listed below so that the portfolio most closely mimics the performance of the Russell 2000 index. a) Write out the (non-linear) program that would produce a portfolio that most closely mimics the performance of the Russell 2000 Index. b) Use Excel's Solver with "GRG Non-Linear" as the solution algorithm: what is the optimal solution, i.e., what percentages should be invested in each of the five funds?
Added by Brooke G.
Step 1
Let the proportion of the portfolio invested in each of the five mutual funds be $x_1, x_2, x_3, x_4,$ and $x_5$. Since the entire portfolio is invested in these five funds, we have the constraint: $$x_1 + x_2 + x_3 + x_4 + x_5 = 1$$ Show more…
Show all steps
Your feedback will help us improve your experience
Akash M and 98 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Innis Investments manages funds for a number of companies and wealthy clients. The investment strategy is tailored to each client's needs. For a new client, Innis has been authorized to invest up to $1.2 million in two investment funds: a stock fund and a money market fund. Each unit of the stock fund costs $50 and provides an annual rate of return of 10%. Each unit of the money market fund costs $100 and provides an annual rate of return of 4%. The client wants to minimize risk subject to the requirement that the annual income from the investment be at least $60,000. According to Innis's risk measurement system, each unit invested in the stock fund has a risk index of 8, and each unit invested in the money market fund has a risk index of 3. The higher risk index associated with the stock fund simply indicates that it is the riskier investment. Innis's client also specifies that at least $300,000 be invested in the money market fund. a. Determine how many units of each fund Innis should purchase for the client to minimize the total risk index for the portfolio. Let S = number of units purchased in the stock fund M = number of units purchased in the money market fund Optimal Solution: S =, M =, value = . b. How much annual income will this investment strategy generate? Annual income = $
Sri K.
Problem 1 (15pts) Mr. Rich is an individual investor who is considering investing his savings of up to $300,000. He wants to divide it among the following investment alternatives: Investment Type (Variable) Rate of Annual Return International Stock Fund (I) 8% Tech Stock Fund (T) 10% Energy Stock Fund (E) 6% Healthcare Stock Fund (H) 9% The investments are all evaluated after 1 year. However, each investment alternative has a different perceived risk to the investor, thus it is advisable to diversify. The following guidelines have been established for investment diversification and risk reduction: Constraint 1: The amount invested in Energy Stock Fund has to be at least 5% more than Healthcare Stock Fund. Constraint 2: At most 30% of the total investment should be in Tech Stock Fund. Constraint 3: To be safe, more should be invested in Tech Fund and Energy Funds than in International and Healthcare Stock Funds by a ratio of 1.2 to 1. Please formulate (not solve) this Linear Programming Model to help Mr. Rich maximize the return.
Adi S.
A fund manager has a portfolio worth $50 million with a beta of 0.87. The manager is concerned about the performance of the market over the next two months and plans to use three-month futures contracts on the S&P 500 to hedge the risk. The current level of the index is 1250, and one contract is on 250 times the index. The current 3-month futures price is 1259. 1) What position should the fund manager take to eliminate all exposure to the market over the next two months? 2) What position should the fund manager take to change the portfolio to be a reverse double leveraged index ETF over the next two months?
Akash M.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD