Explore BrainMass
Share

Explore BrainMass

    Finding the minimum risk portfolio

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    I need to be able to substitute a new fund for one of the original funds but I think I'm not entering the constraints properly because I get the result that no solution is possible. I set up the objective cell for minimum risk and checked the non-negative box. What gets entered where in the Problem Solver boxes to generate the original solution?

    I might be missing a formula for one or more of the cells. I have attached the spreadsheet solution. Besides the original solution, I need to find a solution for replacing GEF with IIF, another solution replacing GEF with TCOIF, and another solution eliminating GEF and not replacing it at all.

    © BrainMass Inc. brainmass.com October 10, 2019, 1:30 am ad1c9bdddf
    https://brainmass.com/business/strategy-and-business-analysis/finding-minimum-risk-portfolio-337762

    Attachments

    Solution Summary

    This solution discusses how to find a minimum risk portfolio.

    $2.19