Tejeda Investment Management, LLC manages 401K retirement plans. A client has asked them to recommend a portfolio.

Question:

Tejeda Investment Management, LLC manages 401K retirement plans. A client has asked them to recommend a portfolio. In discussing options with the client, 15 mutual funds were selected. The variance–covariance matrix and other relevant information are provided in the Problem 19 tab of the Chapter 14 Problem Data Excel file (using the quotation symbols for these funds). The client would like to achieve a minimum return of at least 10%. The company also recommends the following:

• At least five funds be selected.

• No more than three funds in the portfolio should have a Morningstar rating of three or less.

• At most two funds should have an above average risk rating.

• If a fund is selected, then at least 5% but no more than 25% should be invested in that fund.

a. Formulate and solve an integer nonlinear optimization model to minimize the portfolio variance and meet the recommended restrictions. Use Evolutionary Solver.

b. Suppose the client wants to maximize the expected return with the restriction that the portfolio variance be no higher than 15%. How does the solution change?

Mutual Funds
Mutual funds are like a pool of funds gathered by different small investors that have simalar investment perspective about returns on their investments. These funds are managed by professional investment managers who act smartly on behalf of the...
Portfolio
A portfolio is a grouping of financial assets such as stocks, bonds, commodities, currencies and cash equivalents, as well as their fund counterparts, including mutual, exchange-traded and closed funds. A portfolio can also consist of non-publicly...
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: