Project 8- Finance (Monte Carlo Simulation)

profilemharpermontes
project8MCsimulation2.xls

MCprog

Calculating Lognormal Mean and Sigma from Stock Price Data for Your Stock
Date Price (Adj. Close) Daily Return
Daily average 0.00% <-- =AVERAGE(C4:C1203)
0.00% <-- =LN(B4/B3) Daily standard deviation 0.00% <-- =STDEVP(C4:C1203)
0.00% <-- =LN(B5/B4)
0.00% <-- =LN(B6/B5) Annual average 0.00% <-- =H3*252
0.00% <-- =LN(B7/B6) Annual standard deviation 0.00% <-- =H4*SQRT(252)
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
&A
Page &P
&A
Page &P

MuSigma

Simulating Lognormal Price Paths with VBA Press [Ctrl]+A and [Ctrl]+B to operate the macros
Day Stock Price Simulations
0 200.00 Runs 250 chart title Simul 1 244.63
1 201.02 22:28:09 Lognormal Price Simulation Parameters: Mean = 12.18%, Sigma = 25.41% Simul 2 165.91
2 198.47 22:28:10 Simul 3 200.59
3 202.20 00:00:01 Current price 200 Simul 4 221.97
4 208.62 Mean 12% Simul 5 163.34
5 203.41 Counter 10 Sigma 25% Simul 6 181.15
6 204.22 Simul 7 178.56
7 207.75 Simul 8 228.88
8 212.74 Average Simulated Price for 1 year from today: 229.05 Simul 9 215.70
9 215.35 Simul 10 255.43
10 222.47 Simul 11 299.04
11 221.16 Simul 12 245.20
12 223.00 Simul 13 263.91
13 215.85 Simul 14 365.22
14 219.93 Simul 15 182.45
15 225.58 Simul 16 233.32
16 223.77 Simul 17 303.66
17 221.34 Simul 18 240.99
18 219.75 Simul 19 174.10
19 220.51 Simul 20 276.34
20 223.28 Note: You may have to rescale the y-axis on the graph Simul 21 215.85
21 229.24 for some runs of the simulation. Simul 22 301.13
22 222.94 Simul 23 317.91
23 218.43 Simul 24 231.52
24 217.24 Simul 25 288.49
25 224.47 Simul 26 214.28
26 228.56 Simul 27 243.49
27 224.43 Simul 28 128.46
28 218.06 Simul 29 160.88
29 223.15 Simul 30 163.67
30 221.70 Simul 31 185.79
31 216.92 Simul 32 287.11
32 215.38 Simul 33 310.54
33 218.78 Simul 34 360.43
34 219.76 Simul 35 151.97
35 220.54 Simul 36 290.13
36 218.08 Simul 37 191.19
37 214.82 Simul 38 142.01
38 215.56 Simul 39 242.24
39 220.65 Simul 40 246.93
40 221.75 Simul 41 257.47
41 214.79 Simul 42 188.69
42 213.23 Simul 43 190.95
43 206.64 Simul 44 187.29
44 207.40 Simul 45 196.46
45 207.94 Simul 46 298.60
46 209.48 Simul 47 228.84
47 208.82 Simul 48 235.00
48 207.67 Simul 49 309.21
49 209.37 Simul 50 239.40
50 205.95 Simul 51 261.80
51 206.76 Simul 52 251.62
52 204.46 Simul 53 177.48
53 199.94 Simul 54 242.11
54 195.80 Simul 55 388.14
55 196.69 Simul 56 243.37
56 200.51 Simul 57 230.14
57 199.17 Simul 58 197.17
58 194.03 Simul 59 238.22
59 197.81 Simul 60 211.27
60 200.82 Simul 61 205.11
61 200.09 Simul 62 191.46
62 199.48 Simul 63 187.42
63 198.02 Simul 64 240.85
64 195.68 Simul 65 252.64
65 194.61 Simul 66 226.62
66 193.17 Simul 67 194.62
67 193.72 Simul 68 209.88
68 197.91 Simul 69 208.30
69 196.31 Simul 70 219.35
70 198.65 Simul 71 195.36
71 199.90 Simul 72 268.27
72 200.91 Simul 73 233.47
73 201.54 Simul 74 237.97
74 196.16 Simul 75 221.73
75 198.63 Simul 76 182.68
76 198.84 Simul 77 191.70
77 196.26 Simul 78 303.77
78 195.19 Simul 79 217.65
79 194.79 Simul 80 245.68
80 202.03 Simul 81 302.70
81 203.31 Simul 82 245.89
82 205.04 Simul 83 213.27
83 206.90 Simul 84 212.92
84 208.06 Simul 85 276.25
85 209.73 Simul 86 212.14
86 217.59 Simul 87 132.02
87 220.89 Simul 88 157.07
88 220.94 Simul 89 256.34
89 222.55 Simul 90 174.58
90 222.84 Simul 91 210.88
91 216.48 Simul 92 194.44
92 218.07 Simul 93 268.57
93 223.80 Simul 94 174.84
94 224.20 Simul 95 493.58
95 225.95 Simul 96 189.56
96 232.93 Simul 97 203.71
97 233.95 Simul 98 219.07
98 229.87 Simul 99 224.68
99 229.76 Simul 100 223.98
100 222.30 Simul 101 282.80
101 220.99 Simul 102 215.34
102 220.52 Simul 103 282.01
103 217.04 Simul 104 166.81
104 216.86 Simul 105 224.58
105 219.87 Simul 106 159.70
106 225.81 Simul 107 258.26
107 223.45 Simul 108 205.88
108 223.79 Simul 109 231.04
109 227.99 Simul 110 151.64
110 225.34 Simul 111 121.06
111 222.08 Simul 112 279.05
112 224.42 Simul 113 229.02
113 224.68 Simul 114 257.47
114 227.02 Simul 115 181.61
115 227.92 Simul 116 305.24
116 235.02 Simul 117 230.21
117 236.65 Simul 118 295.74
118 227.82 Simul 119 269.24
119 233.03 Simul 120 305.65
120 235.38 Simul 121 209.01
121 234.48 Simul 122 156.17
122 228.63 Simul 123 227.20
123 226.18 Simul 124 160.94
124 227.21 Simul 125 151.91
125 227.04 Simul 126 284.33
126 234.07 Simul 127 299.83
127 232.53 Simul 128 201.75
128 227.76 Simul 129 233.81
129 234.18 Simul 130 143.12
130 238.00 Simul 131 184.63
131 246.60 Simul 132 256.15
132 247.81 Simul 133 331.18
133 244.92 Simul 134 167.63
134 249.52 Simul 135 203.67
135 250.93 Simul 136 212.74
136 253.25 Simul 137 204.42
137 248.75 Simul 138 235.39
138 252.42 Simul 139 235.56
139 247.39 Simul 140 258.77
140 248.97 Simul 141 166.46
141 248.84 Simul 142 237.09
142 249.50 Simul 143 318.30
143 252.78 Simul 144 333.62
144 248.16 Simul 145 210.00
145 250.57 Simul 146 196.78
146 243.99 Simul 147 166.18
147 248.87 Simul 148 247.84
148 246.99 Simul 149 171.50
149 252.52 Simul 150 246.49
150 251.98 Simul 151 272.83
151 245.43 Simul 152 299.63
152 240.61 Simul 153 148.85
153 246.32 Simul 154 388.14
154 245.84 Simul 155 305.80
155 242.01 Simul 156 241.37
156 243.72 Simul 157 192.34
157 248.36 Simul 158 215.65
158 239.29 Simul 159 204.63
159 238.75 Simul 160 297.49
160 234.50 Simul 161 212.04
161 238.47 Simul 162 159.18
162 235.50 Simul 163 207.29
163 238.12 Simul 164 212.08
164 240.26 Simul 165 208.20
165 244.17 Simul 166 236.80
166 242.84 Simul 167 152.60
167 239.79 Simul 168 217.55
168 244.09 Simul 169 207.81
169 251.22 Simul 170 327.87
170 250.44 Simul 171 159.41
171 260.70 Simul 172 194.02
172 266.18 Simul 173 163.61
173 272.11 Simul 174 211.04
174 273.64 Simul 175 202.90
175 272.87 Simul 176 252.50
176 275.07 Simul 177 248.82
177 276.88 Simul 178 346.09
178 276.14 Simul 179 248.59
179 273.51 Simul 180 205.11
180 275.53 Simul 181 197.95
181 274.06 Simul 182 248.04
182 274.72 Simul 183 274.74
183 273.40 Simul 184 252.21
184 269.28 Simul 185 184.75
185 271.26 Simul 186 247.32
186 270.85 Simul 187 142.53
187 270.33 Simul 188 200.22
188 275.35 Simul 189 218.60
189 269.02 Simul 190 205.54
190 275.61 Simul 191 195.89
191 270.92 Simul 192 213.25
192 272.14 Simul 193 164.99
193 274.20 Simul 194 283.06
194 266.15 Simul 195 142.61
195 265.29 Simul 196 178.52
196 263.55 Simul 197 355.66
197 258.02 Simul 198 244.18
198 254.15 Simul 199 105.78
199 247.85 Simul 200 162.04
200 247.60 Simul 201 414.02
201 249.90 Simul 202 149.13
202 250.32 Simul 203 285.06
203 251.25 Simul 204 222.85
204 249.53 Simul 205 301.64
205 244.35 Simul 206 194.58
206 246.73 Simul 207 149.79
207 243.99 Simul 208 167.15
208 250.41 Simul 209 227.32
209 252.82 Simul 210 151.84
210 254.36 Simul 211 197.32
211 253.21 Simul 212 330.69
212 247.50 Simul 213 162.22
213 252.66 Simul 214 207.06
214 254.10 Simul 215 222.95
215 246.99 Simul 216 219.95
216 246.52 Simul 217 230.63
217 238.32 Simul 218 389.72
218 242.76 Simul 219 297.78
219 245.44 Simul 220 133.22
220 243.09 Simul 221 226.04
221 250.22 Simul 222 210.58
222 241.85 Simul 223 314.45
223 242.99 Simul 224 283.26
224 236.26 Simul 225 233.78
225 240.05 Simul 226 161.10
226 234.82 Simul 227 199.24
227 236.21 Simul 228 310.36
228 236.60 Simul 229 132.25
229 241.41 Simul 230 138.09
230 242.38 Simul 231 225.70
231 240.80 Simul 232 221.76
232 234.22 Simul 233 367.05
233 237.12 Simul 234 205.74
234 243.41 Simul 235 275.07
235 243.67 Simul 236 307.33
236 250.21 Simul 237 184.68
237 256.04 Simul 238 211.87
238 251.23 Simul 239 131.87
239 250.22 Simul 240 211.02
240 249.79 Simul 241 227.18
241 248.11 Simul 242 184.93
242 247.92 Simul 243 202.04
243 252.70 Simul 244 155.05
244 253.52 Simul 245 244.00
245 252.99 Simul 246 214.53
246 260.10 Simul 247 306.90
247 256.82 Simul 248 143.66
248 256.51 Simul 249 164.55
249 255.49 Simul 250 181.41
250 255.43 Simul 251 167.77
Simul 252 199.67
Simul 253 264.59
Simul 254 172.88
Simul 255 204.05
Simul 256 235.28
Simul 257 208.48
Simul 258 280.70
Simul 259 202.00
Simul 260 233.22
Simul 261 192.05
Simul 262 195.21
Simul 263 262.25
Simul 264 307.86
Simul 265 232.23
Simul 266 181.22
Simul 267 174.17
Simul 268 134.98
Simul 269 231.68
Simul 270 202.21
Simul 271 308.42
Simul 272 187.56
Simul 273 337.09
Simul 274 268.37
Simul 275 246.36
Simul 276 298.97
Simul 277 214.98
Simul 278 181.22
Simul 279 174.56
Simul 280 233.33
Simul 281 176.59
Simul 282 174.53
Simul 283 236.02
Simul 284 214.27
Simul 285 157.46
Simul 286 266.90
Simul 287 182.72
Simul 288 269.45
Simul 289 223.53
Simul 290 209.87
Simul 291 204.92
Simul 292 240.37
Simul 293 221.30
Simul 294 240.32
Simul 295 278.93
Simul 296 239.29
Simul 297 439.06
Simul 298 186.29
Simul 299 253.41
Simul 300 142.99
Simul 301 235.41
Simul 302 353.92
Simul 303 331.53
Simul 304 295.55
Simul 305 298.50
Simul 306 283.68
Simul 307 161.55
Simul 308 279.40
Simul 309 244.62
Simul 310 140.14
Simul 311 225.42
Simul 312 257.69
Simul 313 189.39
Simul 314 138.11
Simul 315 271.36
Simul 316 167.37
Simul 317 212.07
Simul 318 228.67
Simul 319 163.82
Simul 320 384.02
Simul 321 225.51
Simul 322 318.12
Simul 323 204.08
Simul 324 168.96
Simul 325 169.74
Simul 326 276.19
Simul 327 282.91
Simul 328 183.61
Simul 329 164.05
Simul 330 241.70
Simul 331 214.15
Simul 332 203.26
Simul 333 393.84
Simul 334 210.20
Simul 335 239.36
Simul 336 197.23
Simul 337 170.91
Simul 338 251.10
Simul 339 153.84
Simul 340 108.82
Simul 341 321.74
Simul 342 331.18
Simul 343 338.36
Simul 344 223.55
Simul 345 244.14
Simul 346 333.94
Simul 347 216.61
Simul 348 174.97
Simul 349 165.26
Simul 350 279.35
Simul 351 180.15
Simul 352 192.60
Simul 353 289.89
Simul 354 256.26
Simul 355 110.02
Simul 356 234.47
Simul 357 204.00
Simul 358 211.44
Simul 359 141.14
Simul 360 216.69
Simul 361 402.68
Simul 362 261.63
Simul 363 170.48
Simul 364 179.87
Simul 365 272.66
Simul 366 166.16
Simul 367 176.10
Simul 368 237.75
Simul 369 253.44
Simul 370 225.76
Simul 371 222.14
Simul 372 308.98
Simul 373 291.91
Simul 374 286.96
Simul 375 309.06
Simul 376 251.89
Simul 377 212.32
Simul 378 145.93
Simul 379 199.27
Simul 380 237.03
Simul 381 160.86
Simul 382 165.90
Simul 383 237.66
Simul 384 282.56
Simul 385 212.41
Simul 386 233.69
Simul 387 328.88
Simul 388 195.91
Simul 389 226.80
Simul 390 255.56
Simul 391 303.68
Simul 392 182.36
Simul 393 157.84
Simul 394 213.23
Simul 395 207.82
Simul 396 170.37
Simul 397 221.79
Simul 398 259.14
Simul 399 221.63
Simul 400 275.12
Simul 401 179.70
Simul 402 187.64
Simul 403 310.73
Simul 404 293.61
Simul 405 219.54
Simul 406 185.50
Simul 407 208.43
Simul 408 206.69
Simul 409 226.28
Simul 410 185.74
Simul 411 125.98
Simul 412 111.54
Simul 413 355.42
Simul 414 267.84
Simul 415 180.23
Simul 416 175.79
Simul 417 180.38
Simul 418 258.50
Simul 419 175.33
Simul 420 229.51
Simul 421 374.64
Simul 422 203.82
Simul 423 163.73
Simul 424 216.93
Simul 425 224.88
Simul 426 220.75
Simul 427 287.52
Simul 428 200.83
Simul 429 264.44
Simul 430 231.49
Simul 431 274.92
Simul 432 128.39
Simul 433 218.61
Simul 434 247.08
Simul 435 234.04
Simul 436 208.03
Simul 437 322.51
Simul 438 369.61
Simul 439 314.98
Simul 440 220.16
Simul 441 230.57
Simul 442 308.43
Simul 443 171.72
Simul 444 313.10
Simul 445 265.78
Simul 446 409.79
Simul 447 250.79
Simul 448 285.51
Simul 449 198.75
Simul 450 225.36
Simul 451 192.38
Simul 452 226.89
Simul 453 173.04
Simul 454 289.53
Simul 455 256.79
Simul 456 361.75
Simul 457 286.76
Simul 458 206.37
Simul 459 261.15
Simul 460 216.94
Simul 461 119.37
Simul 462 233.51
Simul 463 157.22
Simul 464 264.79
Simul 465 265.84
Simul 466 439.63
Simul 467 228.37
Simul 468 230.69
Simul 469 173.22
Simul 470 210.37
Simul 471 224.47
Simul 472 219.09
Simul 473 277.26
Simul 474 232.61
Simul 475 241.39
Simul 476 250.22
Simul 477 238.74
Simul 478 159.55
Simul 479 115.77
Simul 480 201.95
Simul 481 83.04
Simul 482 287.00
Simul 483 282.39
Simul 484 120.83
Simul 485 277.86
Simul 486 172.36
Simul 487 257.24
Simul 488 241.19
Simul 489 345.84
Simul 490 185.16
Simul 491 166.30
Simul 492 281.75
Simul 493 202.77
Simul 494 173.19
Simul 495 206.69
Simul 496 196.50
Simul 497 346.24
Simul 498 201.83
Simul 499 167.57
Simul 500 223.31
Simul 501 258.21
Simul 502 262.16
Simul 503 164.32
Simul 504 255.86
Simul 505 378.77
Simul 506 342.54
Simul 507 232.40
Simul 508 208.16
Simul 509 266.46
Simul 510 238.08
Simul 511 254.09
Simul 512 177.27
Simul 513 191.62
Simul 514 178.88
Simul 515 176.53
Simul 516 189.16
Simul 517 220.75
Simul 518 307.63
Simul 519 124.77
Simul 520 254.10
Simul 521 258.43
Simul 522 242.16
Simul 523 254.05
Simul 524 179.32
Simul 525 223.66
Simul 526 175.50
Simul 527 174.79
Simul 528 207.67
Simul 529 280.49
Simul 530 162.89
Simul 531 196.27
Simul 532 194.32
Simul 533 151.52
Simul 534 358.03
Simul 535 311.78
Simul 536 240.05
Simul 537 228.25
Simul 538 214.20
Simul 539 231.22
Simul 540 195.71
Simul 541 155.74
Simul 542 261.22
Simul 543 178.84
Simul 544 263.05
Simul 545 151.27
Simul 546 267.41
Simul 547 168.03
Simul 548 250.84
Simul 549 300.33
Simul 550 378.74
Simul 551 215.52
Simul 552 214.95
Simul 553 274.51
Simul 554 198.63
Simul 555 179.95
Simul 556 277.16
Simul 557 358.37
Simul 558 158.73
Simul 559 199.51
Simul 560 188.90
Simul 561 190.73
Simul 562 203.27
Simul 563 262.82
Simul 564 150.41
Simul 565 159.34
Simul 566 292.84
Simul 567 188.02
Simul 568 213.10
Simul 569 209.28
Simul 570 162.78
Simul 571 225.26
Simul 572 142.23
Simul 573 208.98
Simul 574 188.80
Simul 575 262.82
Simul 576 138.58
Simul 577 239.06
Simul 578 176.63
Simul 579 302.87
Simul 580 287.42
Simul 581 305.21
Simul 582 226.75
Simul 583 187.08
Simul 584 211.58
Simul 585 258.10
Simul 586 224.06
Simul 587 248.88
Simul 588 192.84
Simul 589 198.60
Simul 590 280.40
Simul 591 177.94
Simul 592 223.79
Simul 593 226.59
Simul 594 219.26
Simul 595 198.09
Simul 596 290.46
Simul 597 287.20
Simul 598 157.51
Simul 599 188.24
Simul 600 258.35
Simul 601 317.33
Simul 602 257.10
Simul 603 185.75
Simul 604 169.57
Simul 605 212.68
Simul 606 135.99
Simul 607 181.65
Simul 608 153.83
Simul 609 255.86
Simul 610 243.45
Simul 611 145.53
Simul 612 172.04
Simul 613 372.43
Simul 614 251.66
Simul 615 168.43
Simul 616 193.12
Simul 617 233.73
Simul 618 178.05
Simul 619 149.94
Simul 620 205.72
Simul 621 393.60
Simul 622 452.87
Simul 623 220.63
Simul 624 190.28
Simul 625 202.22
Simul 626 272.70
Simul 627 159.77
Simul 628 182.02
Simul 629 254.89
Simul 630 253.99
Simul 631 257.28
Simul 632 263.61
Simul 633 157.07
Simul 634 222.17
Simul 635 219.13
Simul 636 184.11
Simul 637 186.73
Simul 638 228.73
Simul 639 215.06
Simul 640 266.12
Simul 641 234.77
Simul 642 225.21
Simul 643 171.77
Simul 644 146.12
Simul 645 302.54
Simul 646 262.97
Simul 647 133.98
Simul 648 180.11
Simul 649 301.28
Simul 650 232.48
Simul 651 191.88
Simul 652 357.39
Simul 653 228.20
Simul 654 234.62
Simul 655 252.93
Simul 656 282.62
Simul 657 254.79
Simul 658 305.97
Simul 659 229.20
Simul 660 246.04
Simul 661 269.32
Simul 662 186.90
Simul 663 231.92
Simul 664 231.64
Simul 665 157.57
Simul 666 173.38
Simul 667 295.56
Simul 668 212.89
Simul 669 158.52
Simul 670 178.09
Simul 671 218.12
Simul 672 343.38
Simul 673 197.59
Simul 674 268.05
Simul 675 288.35
Simul 676 269.39
Simul 677 178.67
Simul 678 137.61
Simul 679 242.79
Simul 680 256.14
Simul 681 225.91
Simul 682 173.95
Simul 683 115.19
Simul 684 287.92
Simul 685 252.15
Simul 686 130.77
Simul 687 144.53
Simul 688 333.55
Simul 689 225.23
Simul 690 173.57
Simul 691 177.24
Simul 692 200.83
Simul 693 235.79
Simul 694 203.76
Simul 695 271.02
Simul 696 150.91
Simul 697 196.88
Simul 698 260.74
Simul 699 405.32
Simul 700 239.26
Simul 701 247.40
Simul 702 244.34
Simul 703 256.95
Simul 704 269.71
Simul 705 321.23
Simul 706 231.76
Simul 707 258.49
Simul 708 209.25
Simul 709 219.41
Simul 710 258.90
Simul 711 409.39
Simul 712 166.40
Simul 713 186.84
Simul 714 244.38
Simul 715 296.06
Simul 716 310.44
Simul 717 241.85
Simul 718 391.28
Simul 719 223.77
Simul 720 186.55
Simul 721 159.91
Simul 722 260.22
Simul 723 320.43
Simul 724 169.87
Simul 725 207.36
Simul 726 345.60
Simul 727 214.22
Simul 728 193.10
Simul 729 292.77
Simul 730 229.89
Simul 731 303.04
Simul 732 293.62
Simul 733 285.92
Simul 734 263.73
Simul 735 215.39
Simul 736 199.38
Simul 737 213.25
Simul 738 200.88
Simul 739 181.87
Simul 740 270.53
Simul 741 226.19
Simul 742 158.67
Simul 743 224.34
Simul 744 232.12
Simul 745 169.62
Simul 746 258.01
Simul 747 170.26
Simul 748 250.65
Simul 749 273.31
Simul 750 159.15
Simul 751 206.40
Simul 752 252.47
Simul 753 269.00
Simul 754 418.42
Simul 755 170.19
Simul 756 223.19
Simul 757 372.90
Simul 758 196.33
Simul 759 204.69
Simul 760 241.54
Simul 761 231.15
Simul 762 228.37
Simul 763 194.43
Simul 764 132.28
Simul 765 247.37
Simul 766 213.03
Simul 767 251.17
Simul 768 264.51
Simul 769 350.35
Simul 770 173.32
Simul 771 269.76
Simul 772 318.01
Simul 773 285.15
Simul 774 270.71
Simul 775 142.93
Simul 776 233.36
Simul 777 206.85
Simul 778 366.41
Simul 779 162.22
Simul 780 388.12
Simul 781 283.17
Simul 782 137.90
Simul 783 289.34
Simul 784 219.69
Simul 785 174.42
Simul 786 265.07
Simul 787 297.61
Simul 788 247.44
Simul 789 258.10
Simul 790 279.04
Simul 791 271.58
Simul 792 222.35
Simul 793 263.05
Simul 794 277.45
Simul 795 220.90
Simul 796 288.54
Simul 797 279.75
Simul 798 289.04
Simul 799 154.00
Simul 800 206.04
Simul 801 305.73
Simul 802 297.59
Simul 803 219.08
Simul 804 295.28
Simul 805 279.46
Simul 806 187.82
Simul 807 208.70
Simul 808 176.03
Simul 809 221.17
Simul 810 223.78
Simul 811 240.23
Simul 812 200.56
Simul 813 238.84
Simul 814 215.42
Simul 815 159.03
Simul 816 173.11
Simul 817 170.47
Simul 818 199.24
Simul 819 237.83
Simul 820 290.98
Simul 821 231.60
Simul 822 159.87
Simul 823 121.43
Simul 824 171.58
Simul 825 298.55
Simul 826 213.85
Simul 827 187.09
Simul 828 221.43
Simul 829 259.54
Simul 830 130.96
Simul 831 218.27
Simul 832 164.80
Simul 833 380.72
Simul 834 201.98
Simul 835 288.31
Simul 836 180.00
Simul 837 252.73
Simul 838 253.77
Simul 839 246.49
Simul 840 266.44
Simul 841 203.79
Simul 842 145.96
Simul 843 189.34
Simul 844 193.97
Simul 845 336.15
Simul 846 211.90
Simul 847 142.54
Simul 848 237.22
Simul 849 215.07
Simul 850 134.67
Simul 851 147.78
Simul 852 228.70
Simul 853 141.68
Simul 854 204.65
Simul 855 148.06
Simul 856 202.34
Simul 857 204.87
Simul 858 180.63
Simul 859 151.51
Simul 860 258.94
Simul 861 294.97
Simul 862 185.67
Simul 863 302.43
Simul 864 128.76
Simul 865 259.58
Simul 866 212.28
Simul 867 266.49
Simul 868 298.20
Simul 869 203.08
Simul 870 188.38
Simul 871 184.89
Simul 872 151.70
Simul 873 180.76
Simul 874 233.88
Simul 875 150.55
Simul 876 221.89
Simul 877 197.87
Simul 878 294.13
Simul 879 227.41
Simul 880 207.79
Simul 881 135.52
Simul 882 186.80
Simul 883 307.98
Simul 884 184.13
Simul 885 125.27
Simul 886 220.95
Simul 887 195.51
Simul 888 262.76
Simul 889 258.26
Simul 890 170.26
Simul 891 267.52
Simul 892 334.85
Simul 893 245.42
Simul 894 286.95
Simul 895 231.18
Simul 896 215.87
Simul 897 306.42
Simul 898 397.78
Simul 899 266.39
Simul 900 146.78
Simul 901 384.54
Simul 902 177.89
Simul 903 190.60
Simul 904 237.13
Simul 905 125.19
Simul 906 285.04
Simul 907 229.09
Simul 908 202.24
Simul 909 169.94
Simul 910 284.48
Simul 911 175.18
Simul 912 341.84
Simul 913 283.74
Simul 914 235.29
Simul 915 137.43
Simul 916 244.31
Simul 917 252.64
Simul 918 200.27
Simul 919 153.79
Simul 920 186.02
Simul 921 176.92
Simul 922 245.61
Simul 923 234.70
Simul 924 231.66
Simul 925 228.57
Simul 926 215.18
Simul 927 185.59
Simul 928 244.31
Simul 929 148.61
Simul 930 367.16
Simul 931 178.60
Simul 932 308.03
Simul 933 259.31
Simul 934 143.74
Simul 935 204.45
Simul 936 150.10
Simul 937 128.36
Simul 938 189.99
Simul 939 210.71
Simul 940 239.78
Simul 941 212.39
Simul 942 298.68
Simul 943 135.01
Simul 944 197.93
Simul 945 129.18
Simul 946 228.92
Simul 947 151.82
Simul 948 292.59
Simul 949 250.89
Simul 950 268.11
Simul 951 128.04
Simul 952 253.70
Simul 953 302.97
Simul 954 150.98
Simul 955 224.90
Simul 956 218.57
Simul 957 242.06
Simul 958 186.84
Simul 959 266.24
Simul 960 213.85
Simul 961 431.84
Simul 962 274.74
Simul 963 217.16
Simul 964 284.69
Simul 965 345.29
Simul 966 277.14
Simul 967 170.39
Simul 968 204.82
Simul 969 224.23
Simul 970 137.59
Simul 971 191.29
Simul 972 227.41
Simul 973 167.17
Simul 974 159.22
Simul 975 226.03
Simul 976 204.23
Simul 977 233.48
Simul 978 163.44
Simul 979 301.51
Simul 980 222.15
Simul 981 371.73
Simul 982 202.61
Simul 983 296.85
Simul 984 153.77
Simul 985 163.10
Simul 986 191.24
Simul 987 342.22
Simul 988 180.82
Simul 989 337.73
Simul 990 290.32
Simul 991 232.61
Simul 992 220.30
Simul 993 247.15
Simul 994 246.90
Simul 995 268.72
Simul 996 203.94
Simul 997 230.95
Simul 998 243.87
Simul 999 192.88
Simul 1000 328.34
&CUN-12G

MuSigma

&A
Page &P
Day
Stock price ($)
Lognormal Price Simulation Parameters: Mean = 12.18%, Sigma = 25.41%