Question

Problem-3 Porter Investments needs to develop an investment portfolio for Mrs. Singh from the following list of possible investments (S) 700 1,000 390 500 750 640 300 Cost (S) Expected Return Investment 10,000 12,000 3,500 5,000 8,500 8,000 4,000 Mrs. Singh has a total of $40,000 to invest. The following conditions must be met: (i) if F is chosen, then G must also be chosen. (i) at least 4 investments must be chosen; (i) of A and B at most one can be included Formulate this problem as a linear programming problem. Solve the problem to determine what investments should be in Mrs. Singhs optimal portfolio. How much money will she invest and what is her expected return if she purchases this portfolio?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Investment Expected return 10000 3500 5000 8500 8000 700 1000 390 500 750 300 Decision Variables 10 Whether to invest in a investment type or not Variables are binary. 1 means to invest. 0 means dont invest Investment Yes/No 13 15 16 18 19 Objective function Maximise the returns 22 SUMPRODUCT(B13:B19,C2:C8) Constraints 24 SUMPRODUCT(B2:B8,B13:B19) 25 -B19-B18 26 SUM(B13:B19) 27B13+B14 ..Sheet206 Sheet207 ..

Add a comment
Know the answer?
Add Answer to:
Problem-3 Porter Investments needs to develop an investment portfolio for Mrs. Singh from the following list...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • M4_A5. Porter Investments needs to develop an investment portfolio from the following list of possible investments...

    M4_A5. Porter Investments needs to develop an investment portfolio from the following list of possible investments COST ($) INVESTMENTS EXPECTED RETURN ($) A 1,700 15,000 17,000 1,850 8,500 1,400 10,000 1,500 E 13,500 1,750 13,000 1,650 9,000 1,500 H 9,500 1,700 The client can invest up to $100,000. The following conditions should be met: (1) If investment C is chosen, then investment D must also be part of the portfolio, (2) at least four investments should be chosen, (3) of...

  • (Computing the standard deviation for a portfolio of two risky investments Mary Gulo recently graded from...

    (Computing the standard deviation for a portfolio of two risky investments Mary Gulo recently graded from Nichols State Unversity and is a s to begin investing her meget vigs as a way of ww what she has learned in business School Specifically, she is evaluating an investment in a pontono comprised of two firms common stock. She has collected the flowing information about the common stock of Fm Aandom BBW and standard deviation in portfolio a Mary invests at the...

  • sam is considering to take his retirement portfolio into internationaland local investments. He has the following...

    sam is considering to take his retirement portfolio into internationaland local investments. He has the following information;Investment FundExpected return Standard deviationS&P 500 Fund12.4%20%International Fund14%30%Freddy who is risk adverse has three options: i) Invest only in S&P 500 ii) Investonly in the international fund or iii) Invest equally his money in above assets. Helpout Freddy to decide. Also you must know that correlation coefficient (ρ) betweenabove assets is -0.65 Investment Fund S&P 500 Fund International Fund Expected return Standard deviation 12.4%...

  • 3. Kelly has investments with the following characteristics in her portfolio: Investment in Stock O Stock...

    3. Kelly has investments with the following characteristics in her portfolio: Investment in Stock O Stock R Stock S Beta 1.5 2.0 0.85 Amount invested $80,000 $50.000 $70,000 Given the risk free rate of 2% and the market return of 7%, what is the expected rate of return of Kelly's investment portfolio?

  • Freddy is considering to take his retirement portfolio into international and local investments. He has the...

    Freddy is considering to take his retirement portfolio into international and local investments. He has the following information; Investment Fund S&P 500 Fund International Fund Expected return 12.4% 14% Standard deviation 20% 30% Freddy who is risk adverse has three options: i) Invest only in S&P 500 ii) Invest only in the international fund or iii) Invest equally his money in above assets. Help out Freddy to decide. Also you must know that correlation coefficient (P) between above assets is...

  • Problem 1a (20 points) The Kennesaw State Gymnastics Team consists of 6 people. They must to repr...

    Problem 1a (20 points) The Kennesaw State Gymnastics Team consists of 6 people. They must to represent them at their next meet. The total score that each choose four total gymnasts individual gymnast can attain i1s V- team of four gymnasts must have at least three gymnasts that can compete in each of the three events. vault). example, if Gymnast 1 is selected, he/she will compete in both evens B and F.The Formulate an IP to maximize the total score...

  • Quantitative Problem: You are holding a portfolio with the following investments and betas: Stock Dollar investment...

    Quantitative Problem: You are holding a portfolio with the following investments and betas: Stock Dollar investment Beta A $300,000 1.15 B 200,000 1.5 C 300,000 0.8 D 200,000 -0.3 Total investment $1,000,000 The market's required return is 11% and the risk-free rate is 3%. What is the portfolio's required return? Round your answer to 3 decimal places. Do not round intermediate calculations. % Quantitative Problem: You are given the following probability distribution for CHC Enterprises: State of Economy Probability Rate...

  • 3. You have a risky portfolio that yields an expected rate of return of 15% with...

    3. You have a risky portfolio that yields an expected rate of return of 15% with a standard deviation of 25%. Draw the CAL for an expected return/standard deviation diagram if the risk free rate is 5%. a. What is the slope of the CAL? b. If your coefficient of risk aversion is 5, how much should you invest in the risky portfolio? 4. A pension fund manager is considering three mutual funds. The first is a stock fund, the...

  • 10 lay n- ow ay he 16-18 Stockbroker Susan Drexler has advised her client as shown in the followi...

    10 lay n- ow ay he 16-18 Stockbroker Susan Drexler has advised her client as shown in the following table. EXPECTED RETURN (THOUSANDS) (THUSANDS) COST INVESTMENT Andover municipal bonds Hamilton city bonds East Power & Light Co. Nebraska Electric Service Southern Gas and Electric Manuel Products Co. Builders Paint Co. Rest Easy Hotels Co 400 S 35 or ay ay ole nd $1,000 350 700 $100 s 30 65 50. S 490 S 45 ly $ 270 S 800 500...

  • 8.7. A stockbroker, Richard Smith, has just received a call from his most important client, Ann...

    8.7. A stockbroker, Richard Smith, has just received a call from his most important client, Ann Hardy. Ann has $50,000 to invest and wants to use it to purchase two stocks. Stock 1 is a solid blue-chip security with a respectable growth potential and little risk involved. Stock 2 is much more speculative. It is being touted in two investment newsletters as having outstanding growth potential, but also is considered very risky. Ann would like a large return on her...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT