Formulate and solve an integer nonlinear optimization

Assignment Help Basic Statistics

Reference no: EM131939429

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 fi ve 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?

Reference no: EM131939429

Questions Cloud

What were the early challenges : How did he react to initial success? Was it a continuous increase in sales and opportunities or did he hit a few bumps in the road?

Investing in openly traded stocks : The stock fund is a mutual fund investing in openly traded stocks. The bond fund focuses on the bond market, which has a more stable but lower expected return.

Why did anti-communist hysteria sweep the country : Why did anti-Communist hysteria sweep the country in the early 1950s - Discuss both the supporters and the critics of the policy

What does the ratio measure : Choose a financial ratio that applies to the balance sheet (e.g.: Current Ratio, Debt to Equity ratio, Inventory Turnover, etc.). Describe the ratio.

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

An explanation about why you selected this career path : An explanation about why you selected this job or career path (e.g., What interests you about this career? How are you suited to this type of position?);

Find a solution that maximizes the mean return : Modify the spreadsheet model, and use OptQuest to find a solution that maximizes the mean return.

Describe the four stages of the product life cycle : Describe the four stages of the product life cycle. Identify the stage of life the product (DVDs) are currently in, providing rationale for this information.

What is a queuing system : 1. What is a queuing system? 2. What is an arrival process? Describe the most common arrival process used in practice.

User Account

All Pages