Answer the following questions (using Linear programming formulation: Decision variable, Objective function and Constraints). Provide the solution in Microsoft Excel.
a. Calculate the optimum portfolio of investments to maximize profit obtained at maturity. Do not consider the option of selling securities before maturity.
b. Study the appropriateness of changing the diversification criteria, changing the criteria individually and supposing the rest to remain constant.
c. Recalculate (a) and (b) above if Luis can obtain a credit line for at most 1 million dollars at interest of 2% after tax.
This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.
This is only a preview of the solution. Please use the purchase button to see the entire solution