Question

LINEAR PROGRAMMING, EXCEL SOLVER An investor has $20,000 to invest in a portfolio of three accounts....

LINEAR PROGRAMMING, EXCEL SOLVER

An investor has $20,000 to invest in a portfolio of three accounts. Account 1 offers a return of 2% and at a low risk. Account 2 offers a return of 4% and has a medium risk. Account 3 offers a return of 5% but at a relatively high risk. He decides to invest no more than $3000 in Account 3 and at least twice as much in Account 1 the investment in 2.

a. Formulate this as a linear programming problem (i.e. specify constraint equations and an objective function aimed at maximizing the overall return on investment)

b. Specify this problem in Microsoft Excel

c. Use Excel’s solver add-in to determine what amounts should be invested in each account in order to maximize the year end return?

Homework Answers

Answer #1

Now input this into excel. Use solver from the Data windowAfter solving we get the values in the highlighted box.

Hence investments will be as follows

Account 1- $0

Account 2- $17000

Account 3- $3000

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
In a portfolio problem, the investor has up to $50,000 to invest in stocks 1, 2,...
In a portfolio problem, the investor has up to $50,000 to invest in stocks 1, 2, and 3, which have selling prices of $15/share, $47.25/share, and $110/share, respectively. The investor can purchase multiple shares of multiple stocks. The expected returns on investment of the three stocks are 6%, 8%, and 11%. The stockbroker suggests limiting the investments so that no more than $10,000 is invested in stock 2, and the total number of shares of stocks 2 and 3 does...
Formulate but do not solve the following exercise as a linear programming problem. A financier plans...
Formulate but do not solve the following exercise as a linear programming problem. A financier plans to invest up to $500,000 in two projects. Project A yields a return of 11% on the investment of x dollars, whereas Project B yields a return of 14% on the investment of y dollars. Because the investment in Project B is riskier than the investment in Project A, the financier has decided that the investment in Project B should not exceed 40% of...
USE EXCEL AND SOLVER ONLY TO ANSWER THIS QUESTION Lauren Moore has sold her business for...
USE EXCEL AND SOLVER ONLY TO ANSWER THIS QUESTION Lauren Moore has sold her business for $500,000 and wants to invest in condominium units (which she intends to rent) and land (which she will lease to a farmer). She estimates that she will receive an annual return of $8,000 for each condominium and $6,000 for each acre of land. A condominium unit costs $70,000, and land costs $30,000 per acre. A condominium will cost her $1,000 per unit, an acre...
Formulate but do not solve the following exercise as a linear programming problem. A financier plans...
Formulate but do not solve the following exercise as a linear programming problem. A financier plans to invest up to $600,000 in two projects. Project A yields a return of 10% on the investment of x dollars, whereas Project B yields a return of 14% on the investment of y dollars. Because the investment in Project B is riskier than the investment in Project A, the financier has decided that the investment in Project B should not exceed 45% of...
A person plans to invest up to $10,000 in two stocks: stock A with an expected...
A person plans to invest up to $10,000 in two stocks: stock A with an expected annual return of 1% and a risk rating of 2 and stock B with an expected annual return of 7% and a risk rating of 8. The risk rating of a combinated investment is the weighted average of the risk rating of the individual investments. The person wants to (1)maximize 60% of the total and (2) the average risk rating of the combined investment...
A brokerage firm has just been instructed by one of its clients to invest $600,000 of...
A brokerage firm has just been instructed by one of its clients to invest $600,000 of her money. The analysts at the brokerage firm are considering the following options for investment:                                                                                           Projected Rate Investment Option            of Return (%) Municipal bonds                          2.4 Company A stocks                      8.0 Company B stocks                      10.2      Company C stocks                       9.5 The client has specified the following guidelines: - Municipal bonds should constitute at least 30% of the money invested. - At least 50% of...
A person wants to invest $10,000 into stocks: a high tech company (T) with an expected...
A person wants to invest $10,000 into stocks: a high tech company (T) with an expected annual return of 12% and a risk index of 8; and a regulated power company (P) with an expected annual return of 6% and a risk index of 2. To limit risk, the combined portfolio risk must be no more than 6 and the proportion of investment in T must be less than 60%. Find the portfolio that will maximize the annual return R...
1) Dr. Pierce wishes to invest his retirement fund of $2,000,000 so that his return on...
1) Dr. Pierce wishes to invest his retirement fund of $2,000,000 so that his return on investment is maximized, but he also wishes to keep the risk level relatively low. He has decided to invest his money in any of three possible ways: CDs that pay a guaranteed 4 percent; stocks that have an expected return of 14 percent; and a money market mutual fund that is expected to return 18 percent. He has decided that the total $2,000,000 will...
An investor wishes to invest $10,000 for the coming year and anticipates that the market will...
An investor wishes to invest $10,000 for the coming year and anticipates that the market will be in one of four different states at the end of the year. These states affect her investments in each of three possible stocks and a bond as shown in the following table. Unfortunately, she is uncertain about which market state will occur. Because she is risk-averse, the investor would like to invest in a manner so that the return in the worst-case, no...
Innis Investments manages funds for a number of companies and wealthy clients. The investment strategy is...
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 funds costs $50 and provides an annual rate of return of 10%; each unit of the money market funds costs $100 and provides an annual rate of return...