One of the basic principles of investment management is diversification. By holding a portfolio of several...

Transcribed Image Text:

One of the basic principles of investment management is diversification. By holding a portfolio of several types of securities, for example, you can earn a rate of return that represents the average of the returns from the individual investments, while reducing your overall risk. LMD Trust Inc. invests client's funds in various types of securities. They have $75 million for immediate investment and wish to maximize the interest earned over the next year. They are considering four investment options including Municipal Bonds, Technology Stocks, Blue Chip Stocks, and CDO's (collateralized debt obligations). The expected return for each security is given in Table 1 below. Also included in Table 1 are beta values (market-related risk) and the variances for returns for the four securities. To control for market and return related risk. LMD has set a maximum weighted average beta of 0.2 and an average variance level of 4%. In addition, the maximum amount to be invested for each alternative is set at 40% of the total portfolio. The LP formulation is given below. Setup and solve the problem in the adjacent ('Solver Solution') worksheet, generate the answer and sensitivity reports, then answer the questions given on the first worksheet. Decision Variables M = amount (in dollars) invested in Municipal Bonds T = amount (in dollars) invested in Technology Stocks B = amount (in dollars) invested in Blue Chip Stocks C = amount (in dollars) invested in CDOS Objective Function Maximize average return = Constraints Total of 75M to invest Average beta of 0.2 or less Average variance of 4% or less No more than 40% in M No more than 40% in T No more than 40% in B No more than 40% in C Non-negativity: M,T,B,C>0 0.02M +0.08T+0.055B +0.045C M+T+B+C ≤75,000,000 -0.2M +0.14T-0.02B-0.1C <0 -0.04M +0.02T-0.01B -0.03C <0 0.6M - 0.4T -0.4B -0.4C ≤0 -0.4M +0.6T - 0.4B-0.4C <0 -0.4M -0.4T+0.6B - 0.4C <0 -0.4M - 0.4T-0.4B +0.6C <0 Table 1 Security Average Rate of Return M 2.0% T 8.0% B 5.5% C 4.5% beta 0 0.34 0.18 0.1 variance 0 6% 3% 1% How to set up for solver in excel? One of the basic principles of investment management is diversification. By holding a portfolio of several types of securities, for example, you can earn a rate of return that represents the average of the returns from the individual investments, while reducing your overall risk. LMD Trust Inc. invests client's funds in various types of securities. They have $75 million for immediate investment and wish to maximize the interest earned over the next year. They are considering four investment options including Municipal Bonds, Technology Stocks, Blue Chip Stocks, and CDO's (collateralized debt obligations). The expected return for each security is given in Table 1 below. Also included in Table 1 are beta values (market-related risk) and the variances for returns for the four securities. To control for market and return related risk. LMD has set a maximum weighted average beta of 0.2 and an average variance level of 4%. In addition, the maximum amount to be invested for each alternative is set at 40% of the total portfolio. The LP formulation is given below. Setup and solve the problem in the adjacent ('Solver Solution') worksheet, generate the answer and sensitivity reports, then answer the questions given on the first worksheet. Decision Variables M = amount (in dollars) invested in Municipal Bonds T = amount (in dollars) invested in Technology Stocks B = amount (in dollars) invested in Blue Chip Stocks C = amount (in dollars) invested in CDOS Objective Function Maximize average return = Constraints Total of 75M to invest Average beta of 0.2 or less Average variance of 4% or less No more than 40% in M No more than 40% in T No more than 40% in B No more than 40% in C Non-negativity: M,T,B,C>0 0.02M +0.08T+0.055B +0.045C M+T+B+C ≤75,000,000 -0.2M +0.14T-0.02B-0.1C <0 -0.04M +0.02T-0.01B -0.03C <0 0.6M - 0.4T -0.4B -0.4C ≤0 -0.4M +0.6T - 0.4B-0.4C <0 -0.4M -0.4T+0.6B - 0.4C <0 -0.4M - 0.4T-0.4B +0.6C <0 Table 1 Security Average Rate of Return M 2.0% T 8.0% B 5.5% C 4.5% beta 0 0.34 0.18 0.1 variance 0 6% 3% 1% How to set up for solver in excel?

Answer rating: 100% (QA)

The detailed ... View the full answer