Date IBM AAPL MSFT start date 3/1/2015

3/1/2015 128.8953 114.5079 36.6625 end sate 2/19/2020

4/1/2015 137.5606 115.1705 43.85794
5/1/2015 136.2435 119.8914 42.25294
8/1/2019 131.0199 206.8366 136.5635 IBM International Business Management
9/1/2019 142.2372 222.7709 138.1811 AAPL Apple Inc.
10/1/2019 130.8031 247.4282 142.4946 MSFT Microsoft Corporation
11/1/2019 131.5073 265.8192 150.4557
12/1/2019 132.6548 292.9547 157.2704
1/1/2020 142.2447 308.7772 169.7663
2/1/2020 149.301 322.8538 186.7699
2/19/2020 150.86 323.62 187.28

Re sampling
10 trials

Rand()
randbetween(min,max)
INT(RAND)*max)+min
 Actual return calculate log return
IBM AAPL MSFT
1 6.51% 0.58% 17.92%
2 -0.96% 4.02% -3.73%
Management 53 -8.96% -2.04% 1.16%
54 8.21% 7.42% 1.18%
55 -8.38% 10.50% 3.07%
56 0.54% 7.17% 5.44%
57 0.87% 9.72% 4.43%
58 6.98% 5.26% 7.65%
59 4.84% 4.46% 9.55%

Random (1-59) forward 100 days IBM AAPL MSFT

145 300 180
1 41 1.06% 17.92% 5.72% 146.55 358.87 190.61
2 49 -0.59% 5.49% 10.20% 145.69 379.12 211.07
3 2 -0.96% 4.02% -3.73% 144.29 394.66 203.34
4 23 2.99% 12.12% -1.04% 148.68 445.53 201.23
5 4 -0.41% -3.35% 5.62% 148.06 430.86 212.86
6 49 -0.59% 5.49% 10.20% 147.19 455.17 235.71
7 30 2.47% -5.82% 0.16% 150.88 429.43 236.07
8 23 2.99% 12.12% -1.04% 155.46 484.78 233.63
9 21 3.20% 5.20% 3.75% 160.52 510.63 242.54
10 37 -5.68% -1.51% 2.44% 151.66 502.96 248.52
11 7 -3.43% 8.01% 17.34% 146.54 544.92 295.58
12 58 6.98% 5.26% 7.65% 157.13 574.35 319.06
13 45 -7.65% -12.06% -8.35% 145.56 509.09 293.51
14 48 3.29% 9.69% 5.57% 150.42 560.88 310.31
15 53 -8.96% -2.04% 1.16% 137.53 549.56 313.93
16 24 -2.42% 5.19% 3.50% 134.24 578.82 325.12
17 43 -27.00% -3.10% -6.84% 102.47 561.18 303.63
18 37 -5.68% -1.51% 2.44% 96.82 552.75 311.11
19 11 4.88% -0.67% -7.95% 101.66 549.06 287.34
20 29 -1.14% 9.77% 2.81% 100.50 605.43 295.52
21 40 3.68% 2.76% 7.30% 104.27 622.37 317.90
22 15 0.63% -3.75% -2.82% 104.93 599.45 309.07
23 46 16.77% 5.37% 2.78% 124.08 632.51 317.78
24 14 5.21% 6.32% 6.09% 130.71 673.80 337.72
25 58 6.98% 5.26% 7.65% 140.16 710.20 364.55
26 37 -5.68% -1.51% 2.44% 132.43 699.53 373.54
27 33 3.84% -1.18% 2.12% 137.61 691.34 381.53
28 44 7.38% -20.34% 3.75% 148.15 564.10 396.10
29 13 -3.71% -15.07% -10.21% 142.76 485.17 357.66
30 29 -1.14% 9.77% 2.81% 141.14 534.99 367.84
31 35 -4.93% 6.19% -1.31% 134.35 569.14 363.04
32 26 -4.90% 6.15% 2.00% 127.93 605.24 370.36
33 48 3.29% 9.69% 5.57% 132.20 666.81 391.56
34 26 -4.90% 6.15% 2.00% 125.89 709.10 399.46
35 32 -3.26% 1.65% 1.18% 121.85 720.88 404.21
36 35 -4.93% 6.19% -1.31% 115.99 766.91 398.94
37 42 4.25% -0.48% 2.18% 121.03 763.21 407.74
38 28 -6.14% 3.22% 5.32% 113.82 788.17 430.04
39 40 3.68% 2.76% 7.30% 118.09 810.23 462.62
40 35 -4.93% 6.19% -1.31% 112.41 861.96 456.58
41 6 -1.17% -1.90% 2.34% 111.10 845.77 467.41
42 59 4.84% 4.46% 9.55% 116.62 884.33 514.23
43 8 -0.47% -1.01% 3.20% 116.07 875.44 530.93
44 9 -0.37% -11.25% 2.73% 115.64 782.28 545.62
45 54 8.21% 7.42% 1.18% 125.54 842.55 552.08
46 56 0.54% 7.17% 5.44% 126.22 905.17 582.93
47 21 3.20% 5.20% 3.75% 130.32 953.45 605.18
48 43 -27.00% -3.10% -6.84% 99.49 924.39 565.17
49 59 4.84% 4.46% 9.55% 104.42 966.53 621.78
50 34 6.49% -1.07% 10.50% 111.42 956.25 690.62
51 35 -4.93% 6.19% -1.31% 106.06 1017.31 681.60
52 11 4.88% -0.67% -7.95% 111.36 1010.51 629.51
53 43 -27.00% -3.10% -6.84% 85.01 979.71 587.90
54 26 -4.90% 6.15% 2.00% 80.95 1041.85 599.75
55 59 4.84% 4.46% 9.55% 84.97 1089.34 659.82
56 41 1.06% 17.92% 5.72% 85.88 1303.10 698.70
57 15 0.63% -3.75% -2.82% 86.42 1255.11 679.29
58 1 6.51% 0.58% 17.92% 92.23 1262.37 812.61
59 11 4.88% -0.67% -7.95% 96.84 1253.94 750.51
60 37 -5.68% -1.51% 2.44% 91.50 1235.10 769.01
61 21 3.20% 5.20% 3.75% 94.47 1300.98 798.36
62 1 6.51% 0.58% 17.92% 100.82 1308.51 955.05
63 20 5.40% -2.70% 0.57% 106.42 1273.70 960.47
64 31 6.01% 9.24% 11.03% 113.00 1397.01 1072.52
65 17 -1.09% 1.80% 1.37% 111.78 1422.34 1087.28
66 19 -3.30% 0.43% 3.95% 108.15 1428.51 1131.07
67 32 -3.26% 1.65% 1.18% 104.68 1452.26 1144.53
68 15 0.63% -3.75% -2.82% 105.35 1398.77 1112.74
69 38 -2.55% 12.29% 5.53% 102.69 1581.68 1176.04
70 49 -0.59% 5.49% 10.20% 102.09 1670.94 1302.28
71 22 5.01% 4.66% 3.96% 107.34 1750.72 1354.89
72 36 -0.57% -5.57% -2.23% 106.72 1655.81 1324.96
73 46 16.77% 5.37% 2.78% 126.20 1747.14 1362.27
74 17 -1.09% 1.80% 1.37% 124.84 1778.82 1381.01
75 2 -0.96% 4.02% -3.73% 123.64 1851.74 1330.47
76 5 -9.11% -7.16% -7.05% 112.88 1723.81 1239.88
77 13 -3.71% -15.07% -10.21% 108.77 1482.61 1119.55
78 57 0.87% 9.72% 4.43% 109.72 1633.96 1170.26
79 4 -0.41% -3.35% 5.62% 109.27 1580.16 1237.85
80 32 -3.26% 1.65% 1.18% 105.77 1606.43 1252.58
81 5 -9.11% -7.16% -7.05% 96.56 1495.45 1167.29
82 3 -2.69% -3.38% -5.31% 94.00 1445.79 1106.93
 83 18 0.84% 6.89% 0.86% 94.80 1548.84 1116.54
84 24 -2.42% 5.19% 3.50% 92.53 1631.30 1156.32
85 57 0.87% 9.72% 4.43% 93.33 1797.83 1208.69
86 58 6.98% 5.26% 7.65% 100.08 1894.93 1304.73
87 51 9.42% 12.65% 8.35% 109.97 2150.50 1418.40
88 5 -9.11% -7.16% -7.05% 100.40 2001.93 1321.82
89 32 -3.26% 1.65% 1.18% 97.18 2035.21 1337.55
90 11 4.88% -0.67% -7.95% 102.04 2021.62 1235.34
91 10 -9.79% -7.82% -0.71% 92.53 1869.51 1226.65
92 34 6.49% -1.07% 10.50% 98.73 1849.63 1362.45
93 48 3.29% 9.69% 5.57% 102.02 2037.79 1440.45
94 30 2.47% -5.82% 0.16% 104.58 1922.55 1442.70
95 18 0.84% 6.89% 0.86% 105.46 2059.58 1455.23
96 54 8.21% 7.42% 1.18% 114.49 2218.24 1472.47
97 10 -9.79% -7.82% -0.71% 103.82 2051.34 1462.12
98 35 -4.93% 6.19% -1.31% 98.83 2182.31 1443.04
99 16 5.66% 8.62% 10.23% 104.58 2378.86 1598.42
100 16 5.66% 8.62% 10.23% 110.67 2593.10 1770.54
Random (1-59) forward 100 days IBM AAPL MSFT
145 300 180
Trial 1
Trial 2
Trial 3
Trial 4
Trial 5
Trial 6
Trial 7
Trial 8
Trial 9
Trial 10

Average
portfolio
625
portfolio return (portfolio)
625
$ 4,474.32 197%
$ 1,742.73 103%
$ 5,027.50 208%
$ 2,339.57 132%
$ 3,313.41 167%
$ 6,102.13 228%
$ 976.36 45%
$ 7,173.38 244%
$ 7,339.09 246%
$ 5,714.80 221%

$ 4,420.33 179%