The stock price of Robin Tires, Inc., listed on the Stock Exchange is currently $20. The following probability distribution shows how the price per share is expected to change over a three-month period:

Stock Profit Change ($)	Probability
-3	0.25
-2	0.2
-1	0.05
0	0.15
+1	0.1
+2	0.15
+3	0.1

Month	RN for 3 mo. stock profit change	RN for 6 mo. stock profit change	RN for 9 mo. stock profit change	RN for 12 mo. stock profit change
3	0.420	0.382	0.390	0.617
6	0.460	0.156	0.368	0.648
9	0.936	0.363	0.212	0.408
12	0.601	0.212	0.554	0.788
15	0.639	0.642	0.230	0.506
18	0.288	0.976	0.292	0.801
21	0.025	0.926	0.832	0.260
24	0.413	0.819	0.438	0.845
27	0.434	0.191	0.329	0.242
30	0.214	0.742	0.583	0.808
33	0.197	0.811	0.182	0.427
36	0.025	0.447	0.625	0.853

a. Construct a spreadsheet model that computes the value of the stock profit in 3 months, 6 months, 9 months, and 12 months under the assumption that the change in profit over any 3-month period is independent of the change in profit over any other 3-month period.

b. Construct a simulation model (12 simulations) for stock profit in 3 months, 6 months, 9 months, and 12 months. With the current profit of $20 per share, simulate the profit per share for the next four 3-month periods. What is the average profit in 12 months? NOTE: use the random numbers above for the simulation.

c. Construct a simulation model (100 simulations) for stock profit in 3 months, 6 months, 9 months, and 12 months. With the current profit of $20 per share, simulate the profit per share for the next four 3-month periods.

d. Create a summary output on profit based on part (C) and comment.