Question

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 while meeting the risk limitations. Homework 10a (10 points): Formulate the Investment Portfolio problem with the requirement of investing up to $10,000, and solve it graphically.Homework 10b (5 points): Compute the increase in annual return if the total investment is increased by $1,000.Homework 10c (5 points): Compute the increase in annual return if the constraint of portfolio risk index is increased from 6 to 7.

Answer 1

Answer

The answer and procedures of the exercise are attached in a microsoft excel document. Last version.

Explanation  

Please consider the data provided by the exercise. If you have any question please write me back. All the exercises are solved in a single sheet with the formulas indications.  

Download xlsx