# Question: Suppose you are going to invest equal amounts in three

Suppose you are going to invest equal amounts in three stocks. The annual return from each stock is normally distributed with mean 0.01 (1%) and standard deviation 0.06. The annual return on your portfolio, the output variable of interest, is the average of the three stock returns. Run @RISK, using 1000 iterations, on each of the following scenarios.

a. The three stock returns are highly correlated. The correlation between each pair is 0.9.

b. The three stock returns are practically independent. The correlation between each pair is 0.1.

c. The first two stocks are moderately correlated. The correlation between their returns is 0.4. The third stock’s return is negatively correlated with the other two. The correlation between its return and each of the first two is -0.8.

d. Compare the portfolio distributions from @RISK for these three scenarios. What do you conclude?

e. You might think of a fourth scenario, where the correlation between each pair of returns is a large negative number such as -0.8. But explain intuitively why this makes no sense. Try to run the simulation with these negative correlations and see what happens.

a. The three stock returns are highly correlated. The correlation between each pair is 0.9.

b. The three stock returns are practically independent. The correlation between each pair is 0.1.

c. The first two stocks are moderately correlated. The correlation between their returns is 0.4. The third stock’s return is negatively correlated with the other two. The correlation between its return and each of the first two is -0.8.

d. Compare the portfolio distributions from @RISK for these three scenarios. What do you conclude?

e. You might think of a fourth scenario, where the correlation between each pair of returns is a large negative number such as -0.8. But explain intuitively why this makes no sense. Try to run the simulation with these negative correlations and see what happens.

**View Solution:**## Answer to relevant Questions

The effect of the shapes of input distributions on the distribution of an output can depend on the output function. For this problem, assume there are 10 input variables. The goal is to compare the case where these 10 inputs ...A hardware company sells a lot of low-cost, high volume products. For one such product, it is equally likely that annual unit sales will be low or high. If sales are low (60,000), the company can sell the product for $10 per ...Simulation can be used to illustrate a number of results from statistics that are difficult to understand with non-simulation arguments. One is the famous central limit theorem, which says that if you sample enough values ...See how sensitive the results in Example 16.2 are to the following changes. For each part, make the change indicated, run the simulation, and comment on any differences between your outputs and the outputs in the example.a. ...Change the new car simulation from Example 16.4 as follows. It is the same as before for years 1 through 5, including depreciation through year 5. However, the car might sell through year 10. Each year after year 5, the ...Post your question