Investment Maximization Problem
Not what you're looking for?
Welgo Mutual Funds, Inc.
Welgo Mutual Funds, Inc., is located in Philadelphia, Pa. Welgo just obtained $100,000 by converting industrial bonds to cash and is now looking for other investment opportunities for these funds. Based on Welgo's current investments, the form's top financial analyst recommends that all new investments be made in the oil industry, steel industry, or in government bonds. Specifically, the analyst identified five new investment opportunities and projected their annual rates of return as shown in the following table:
Investment / Projected Rate of Return (%)
Atlantic Oil / 7.3
Pacific Oil / 10.3
Midwest Steel / 6.4
Huber Steel / 7.5
Government Bonds 4.5
The management of Welgo imposed the following investment guidelines:
1. Neither industry (oil or steel) should receive more than $50,000.
2. Government bonds should be at least 25 percent of the steel industry investments.
3. The investment in Pacific Oil, the high-return but high-risk investment, cannot be more than 60 percent of the total oil industry investment.
What portfolio recommendations - investments and amounts - should be made for the available $100,000 given the goal of maximizing return?
(a) show the algebraic model for this portfolio selection problem; and,
(b) include your Excel Solver solution
Purchase this Solution
Solution Summary
The solution makes portfolio recommendations, showing algebraic models and including an Excel solution.
Solution Preview
Here is the algebraic formulation - hope it will help you learn
Algebraic Equation:
Let A,P,M,H,G be the % invested in each of the categories (these are decision ...
Education
- BE, Bangalore University, India
- MS, University of Wisconsin-Madison
Recent Feedback
- "Your explanation to the answers were very helpful."
- "What does 1 and 0 means in the repair column?"
- "Went through all of the formulas, excellent work! This really helped me!"
- "try others as well please"
- "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution
Free BrainMass Quizzes
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.
Probability Quiz
Some questions on probability
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.
Exponential Expressions
In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.
Graphs and Functions
This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.