You have $50,000 to invest in three stocks. Let Ri be the random variable representing the annual return on $1 invested in stock i. For example, if Ri = 0.12, then $1 invested in stock i at the beginning of a year is worth $1.12 at the end of the year. The means are E(R1) = 0.14, E(R2) = 0.11, and E(R3) = 0.10. The variances are Var R1 = 0.20, Var R2 = 0.08, and Var R3 = 0.18. The correlations are r12 = 0.8, r13 = 0.7, and r23 = 0.9. Determine the minimum-variance portfolio that attains an expected annual return of at least 0.12.
Answer to relevant QuestionsThe risk index of an investment can be obtained by taking the absolute values of percentage changes in the value of the investment for each year and averaging them. Suppose you are trying to determine the percentages of your ...Each hour from 10 A.M. to 7 P.M., a bank receives checks and must process them. Its goal is to process all checks the same day they are received. The bank has 13 check processing machines, each of which can process up to 500 ...Use the RAND function and the Copy command to generate a set of 100 random numbers.a. What fraction of the random numbers are smaller than 0.5?b. What fraction of the time is a random number less than 0.5 followed by a ...A company is about to develop and then market a new product. It wants to build a simulation model for the entire process, and one key uncertain input is the development cost. For each of the following scenarios, choose an ...Continuing the previous problem, assume, as in Problem 11, that the damage amount is normally distributed with mean $3000 and standard deviation $750. Run @RISK with 5000 iterations to simulate the amount you pay for damage. ...
Post your question