Bill is considering investing $120,000 among two investments. He will invest $50,000 in the first investment which is known…

Bill is considering investing $120,000 among two investments. He will invest $50,000 in the first investment which is known to follow a uniform distribution with a rate of return that varies from 10% to 25%. He will invest $70,000 in the second investment which follows a normal distribution with an average rate of return of 10% and a standard deviation of 3%.
a) Use the following random numbers to simulate return rates for investment 1 for 3 years.
Year RN Rate of Return
1 364
2 895
3 139

b) Use the following random numbers to simulate return rates for investment 2 for 3 years.
Year RN Rate of Rturn
1 1.68
2 0.83
3 2.05

c) Complete the following simulation table to simulate Bill’s investments for a three-year period. Assume that the balances are cumulative.

Investment 1 Investment 2 Combined
Year RN Rate Return Balance RN Rate Return Balance Balance
1 364 1.68
2 895 -0.83
3 139 2.05