Finding the minimum risk portfolio
Not what you're looking for?
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.
Purchase this Solution
Solution Summary
This solution discusses how to find a minimum risk portfolio.
Purchase this Solution
Free BrainMass Quizzes
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Paradigms and Frameworks of Management Research
This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.
Transformational Leadership
This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.
Writing Business Plans
This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.