Complete in Microsoft Excel

Kayne wants to open a business . Six years from now for $24, 000. She thinks she can invest $220 per month for the next six years.

Scenario 1: She is considering 2 plans: to put a fraction of the $220. Plan 1: Invest 70% in the first fund(CA) and 30% in the second(CB). Plan 2: Invest 30% (CA)in the first and 70% in the second (CB). You found 200 data points on this information for previous years.

Scenario 2: Table 1

CA | CB

mean= 1.0% | 0.90%

stan d= 2.0% | 0.20%

Complete the following: 1Develop a simulation model of the two suggested investment strategies (70:30 & 30:70) over the six-year period for both scenarios given below: a)Using the 200 data points (Scenario 1) b)Using the Normal Distribution (Scenario 2)

2) What is the total of each plan and say if any of the scenario reaches the goal. Illustrate. 3) Do 1000 replications of each plan in each of the scenario also compute and interpret a 95% for each of the strategies in each of the scenarios 4) Do a 2 way data- tab, under scenario 2, over 1000 replications, using the following standard deviations (holding the mean returns constant): 1%, 1.5%, 2.5, 3.5and 4.5%. a) Calculate the average returns (from the 1000 replications) and make the highlighting of the standard deviations that gives the maximum average returns randomly generated

b) Generate a graph of reflect what was done in 4 a, show on a different sheet.