One of the basic principles of investment management is diversification. By holding a portfolio of several...
Fantastic news! We've Found the answer you've been seeking!
Question:
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?
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
One of the basic financial principles is that the value of any asset (whether it be a stock, a bond, or a firm as a whole) is the present value of that asset's future cash flows. As you learned in...
-
One of the basic economic laws is "the law of one price." It says that given certain assumptions one would expect that if free trade is allowed, the price of goods in countries should converge. a....
-
One of the basic laws of economics is the law of one price. It says that given certain assumptions one would expect that if free trade is allowed, the prices of goods in multiple countries should...
-
Given an array, Arr[] of integer numbers have size N. The task is to find out single or consecutive numbers from Arr[] with 0 sum. When found, print "1" otherwise "0". Example-1: Input: 4 (6,-2,3,-1)...
-
Find the momentum of each object. 1. m = 2.00 kg, v = 40.0 m/s 2. m = 5.00 kg, v = 90.0 m/s 3. m = 17.0 slugs, v = 45.0 ft/s 4. m = 38.0 kg, v = 97.0 m/s 5. m = 3.8 x 105 kg, v = 2.5 x 103 m/s 6. m =...
-
In Problems 1542, solve each system of equations using Cramers Rule if it is applicable. If Cramers Rule is not applicable, write, Not applicable. 2x + 4y = 16 3x-5y=-9
-
At present, 10-year Treasury bonds are yielding 5 percent, while a 10-year corporate bond is yielding 7 percent. If the liquidity-risk premium on the corporate bond is 0.5 percent, what is the...
-
Daniel B. Butler and Freida C. Butler, husband and wife, file a joint return. The Butlers live at 625 Oak Street in Corbin, KY 40701. Dan's Social Security number is 111-11-1112, and Freida's is...
-
1. Letter of the word INDIANOIL are arranged in all possible ways. The number of permutations in which A, I, O occur only at odd places, is : (a) 720 2. (b) 360 (c) 240 (d) 120 How many different...
-
A highway has an optional toll lane that drivers may take to reduce the time they spend driving. Drivers pay a small fee to enter the toll lane ($0.25). Then, once they leave the toll lane, they pay...
-
A Corporate bond currently yield 8.00%. Municipal bound with the same risk, maturity, and liquidity currently yield 5.5%. At what tax rate would investors be indifferent between the two bonds? 28.75%...
-
If the professor wants to raise the standard for passing the test to nine or more correct answers, what is the probability of a Type I error? Use the following information to answer question. A...
-
A questionnaire was sent to 500 of a dry cleaners customers to solicit their opinions about service received. Twenty-three customers were found to be unhappy with the service. On this evidence, can...
-
You are working for a VCR manufacturer. There are three shifts in the plant: morning shift, evening shift, and midnight shift. The manager suspects that the midnight shifts productivity is lower than...
-
The dean of the school of business wants the proportion of A grades given out by his faculty members to be around 10 %. He randomly surveys 2,000 students in 50 classes and finds that of the 2,000...
-
A food company claims that its new product, low-fat yogurt, is 99 % fat-free. The management wants to keep the proportion of bad (not 99 % fat-free) products below 2 %. Inspectors check 500 cups of...
-
Identify a target behavior that the person does not currently have but would like to have. Develop a social learning strategy for the person to acquire that behavior. Implement the strategy. ...
-
Prove the formula for (d/dx)(cos-1x) by the same method as for (d/dx)(sin-1x).
-
If rates of decomposition are higher in ecosystems with higher nutrient availability, how should nutrient enrichment affect rates of decomposition? Because of its effects on fungal diversity, could...
-
What are the relative advantages and disadvantages of being an herbivore, a detritivore, or a carnivore? What kinds of organisms were left out of our discussions of herbivores, detritivores, and...
-
In chapter 23, we briefly discussed how humans have more than doubled the quantity of fixed nitrogen cycling through the biosphere. In chapter 15, we reviewed studies by Nancy Johnson (1993) on the...
-
Many states have lotteries that involve the random selection of digits 0, 1, 2, ,
-
Birth weights in the United States are normally distributed with a mean (in grams) of 3420 g and a standard deviation of 495 g. If you graph this normal distribution, the area to the right of 4000 g...
-
Is the distribution of those digits a normal distribution? Why or why not?
Study smarter with the SolutionInn App