| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Data Source | Monthly Investment | $200.00 | |||||||||||||||||
2 | Savings Account Interest Rate | 3.00% | Покупки Росса перед падениями | Покупки Чендлера на дне рынка | Ежемемячные покупки Джо | |||||||||||||||
3 | World's Worst Market Timer | World's Best Market Timer | Dollar Cost Averager | |||||||||||||||||
4 | DateYear | Date | S&P Price | S&P Dividend | Shares | Value Reinvested | Cash Saved | Shares Owned | Tiffany Total Value | Cash Saved | Shares Owned | Brittany Total Value | Shares Owned | SarahTotal Value | ||||||
5 | 1979 | 6/1/1979 | 101.7 | 5.34 | 1.00 | 101.70 | $200.00 | 0.00 | $200 | $200.00 | 0.00 | $200 | 1.97 | $200 | ||||||
6 | 1979 | 7/1/1979 | 102.7 | 5.4 | 1.00 | 103.15 | $400.50 | 0.00 | $401 | $400.50 | 0.00 | $401 | 3.91 | $403 | ||||||
7 | 1979 | 8/1/1979 | 107.4 | 5.45 | 1.01 | 108.34 | $601.50 | 0.00 | $602 | $601.50 | 0.00 | $602 | 5.75 | $623 | ||||||
8 | 1979 | 9/1/1979 | 108.6 | 5.51 | 1.01 | 110.02 | $803.01 | 0.00 | $803 | $803.01 | 0.00 | $803 | 7.57 | $833 | ||||||
9 | 1979 | 10/1/1979 | 104.5 | 5.56 | 1.02 | 106.31 | $1,005.01 | 0.00 | $1,005 | $1,005.01 | 0.00 | $1,005 | 9.45 | $1,005 | ||||||
10 | 1979 | 11/1/1979 | 103.7 | 5.6 | 1.02 | 105.96 | $1,207.53 | 0.00 | $1,208 | $1,207.53 | 0.00 | $1,208 | 11.34 | $1,201 | ||||||
11 | 1979 | 12/1/1979 | 107.8 | 5.65 | 1.03 | 110.65 | $1,410.54 | 0.00 | $1,411 | $1,410.54 | 0.00 | $1,411 | 13.15 | $1,455 | ||||||
12 | 1980 | 1/1/1980 | 110.9 | 5.7 | 1.03 | 114.33 | $1,614.07 | 0.00 | $1,614 | $1,614.07 | 0.00 | $1,614 | 14.89 | $1,703 | ||||||
13 | 1980 | 2/1/1980 | 115.3 | 5.75 | 1.04 | 119.37 | $1,818.11 | 0.00 | $1,818 | $1,818.11 | 0.00 | $1,818 | 16.57 | $1,978 | ||||||
14 | 1980 | 3/1/1980 | 104.7 | 5.8 | 1.04 | 108.85 | $2,022.65 | 0.00 | $2,023 | $2,022.65 | 0.00 | $2,023 | 18.41 | $2,004 | ||||||
15 | 1980 | 4/1/1980 | 103 | 5.85 | 1.04 | 107.58 | $2,227.71 | 0.00 | $2,228 | $2,227.71 | 0.00 | $2,228 | 20.27 | $2,180 | ||||||
16 | 1980 | 5/1/1980 | 107.7 | 5.89 | 1.05 | 113.02 | $2,433.28 | 0.00 | $2,433 | $2,433.28 | 0.00 | $2,433 | 22.04 | $2,491 | ||||||
17 | 1980 | 6/1/1980 | 114.6 | 5.94 | 1.05 | 120.81 | $2,639.36 | 0.00 | $2,639 | $2,639.36 | 0.00 | $2,639 | 23.69 | $2,862 | ||||||
18 | 1980 | 7/1/1980 | 119.8 | 5.98 | 1.06 | 126.83 | $2,845.96 | 0.00 | $2,846 | $2,845.96 | 0.00 | $2,846 | 25.27 | $3,205 | ||||||
19 | 1980 | 8/1/1980 | 123.5 | 6.03 | 1.06 | 131.30 | $3,053.07 | 0.00 | $3,053 | $3,053.07 | 0.00 | $3,053 | 26.79 | $3,518 | ||||||
20 | 1980 | 9/1/1980 | 126.5 | 6.07 | 1.07 | 135.03 | $3,260.71 | 0.00 | $3,261 | $3,260.71 | 0.00 | $3,261 | 28.27 | $3,818 | ||||||
21 | 1980 | 10/1/1980 | 130.2 | 6.1 | 1.07 | 139.54 | $3,468.86 | 0.00 | $3,469 | $3,468.86 | 0.00 | $3,469 | 29.71 | $4,145 | ||||||
22 | 1980 | 11/1/1980 | 135.7 | 6.13 | 1.08 | 146.00 | $3,677.53 | 0.00 | $3,678 | $3,677.53 | 0.00 | $3,678 | 31.08 | $4,537 | ||||||
23 | 1980 | 12/1/1980 | 133.5 | 6.16 | 1.08 | 144.17 | $3,886.72 | 0.00 | $3,887 | $3,886.72 | 0.00 | $3,887 | 32.46 | $4,680 | ||||||
24 | 1981 | 1/1/1981 | 133 | 6.2 | 1.08 | 144.19 | $4,096.44 | 0.00 | $4,096 | $4,096.44 | 0.00 | $4,096 | 33.85 | $4,881 | ||||||
25 | 1981 | 2/1/1981 | 128.4 | 6.24 | 1.09 | 139.74 | $4,306.68 | 0.00 | $4,307 | $4,306.68 | 0.00 | $4,307 | 35.28 | $4,930 | ||||||
26 | 1981 | 3/1/1981 | 133.2 | 6.28 | 1.09 | 145.55 | $4,517.45 | 0.00 | $4,517 | $4,517.45 | 0.00 | $4,517 | 36.66 | $5,335 | ||||||
27 | 1981 | 4/1/1981 | 134.4 | 6.32 | 1.10 | 147.44 | $4,728.74 | 0.00 | $4,729 | $4,728.74 | 0.00 | $4,729 | 38.01 | $5,605 | ||||||
28 | 1981 | 5/1/1981 | 131.7 | 6.35 | 1.10 | 145.04 | $4,940.56 | 0.00 | $4,941 | $4,940.56 | 0.00 | $4,941 | 39.39 | $5,713 | ||||||
29 | 1981 | 6/1/1981 | 132.3 | 6.39 | 1.11 | 146.29 | $5,152.91 | 0.00 | $5,153 | $5,152.91 | 0.00 | $5,153 | 40.76 | $5,963 | ||||||
30 | 1981 | 7/1/1981 | 129.1 | 6.43 | 1.11 | 143.32 | $5,365.80 | 0.00 | $5,366 | $5,365.80 | 0.00 | $5,366 | 42.15 | $6,042 | ||||||
31 | 1981 | 8/1/1981 | 129.6 | 6.48 | 1.11 | 144.48 | $5,579.21 | 0.00 | $5,579 | $5,579.21 | 0.00 | $5,579 | 43.54 | $6,290 | ||||||
32 | 1981 | 9/1/1981 | 118.3 | 6.52 | 1.12 | 132.43 | $5,793.16 | 0.00 | $5,793 | $5,793.16 | 0.00 | $5,793 | 45.05 | $5,966 | ||||||
33 | 1981 | 10/1/1981 | 119.8 | 6.56 | 1.12 | 134.72 | $6,007.64 | 0.00 | $6,008 | $6,007.64 | 0.00 | $6,008 | 46.53 | $6,269 | ||||||
34 | 1981 | 11/1/1981 | 122.9 | 6.59 | 1.13 | 138.84 | $6,222.66 | 0.00 | $6,223 | $6,222.66 | 0.00 | $6,223 | 47.97 | $6,661 | ||||||
35 | 1981 | 12/1/1981 | 123.8 | 6.63 | 1.13 | 140.48 | $6,438.22 | 0.00 | $6,438 | $6,438.22 | 0.00 | $6,438 | 49.40 | $6,940 | ||||||
36 | 1982 | 1/1/1982 | 117.3 | 6.66 | 1.14 | 133.70 | $6,654.31 | 0.00 | $6,654 | $6,654.31 | 0.00 | $6,654 | 50.89 | $6,804 | ||||||
37 | 1982 | 2/1/1982 | 114.5 | 6.69 | 1.15 | 131.13 | $6,870.95 | 0.00 | $6,871 | $6,870.95 | 0.00 | $6,871 | 52.42 | $6,873 | ||||||
38 | 1982 | 3/1/1982 | 110.8 | 6.72 | 1.15 | 127.51 | $7,088.13 | 0.00 | $7,088 | $7,088.13 | 0.00 | $7,088 | 53.99 | $6,884 | ||||||
39 | 1982 | 4/1/1982 | 116.3 | 6.75 | 1.16 | 134.51 | $7,305.85 | 0.00 | $7,306 | $7,305.85 | 0.00 | $7,306 | 55.47 | $7,462 | ||||||
40 | 1982 | 5/1/1982 | 116.4 | 6.78 | 1.16 | 135.28 | $7,524.11 | 0.00 | $7,524 | $7,524.11 | 0.00 | $7,524 | 56.95 | $7,705 | ||||||
41 | 1982 | 6/1/1982 | 109.7 | 6.81 | 1.17 | 128.11 | $7,742.92 | 0.00 | $7,743 | $7,742.92 | 0.00 | $7,743 | 58.51 | $7,496 | ||||||
42 | 1982 | 7/1/1982 | 109.4 | 6.82 | 1.17 | 128.42 | $7,962.28 | 0.00 | $7,962 | $7,962.28 | 0.00 | $7,962 | 60.07 | $7,714 | ||||||
43 | 1982 | 8/1/1982 | 109.7 | 6.84 | 1.18 | 129.44 | $8,182.19 | 0.00 | $8,182 | $8,182.19 | 0.00 | $8,182 | 61.62 | $7,976 | ||||||
44 | 1982 | 9/1/1982 | 122.4 | 6.85 | 1.19 | 145.18 | $8,402.64 | 0.00 | $8,403 | $8,402.64 | 0.00 | $8,403 | 62.99 | $9,145 | ||||||
45 | 1982 | 10/1/1982 | 132.7 | 6.86 | 1.19 | 158.13 | $8,623.65 | 0.00 | $8,624 | $8,623.65 | 0.00 | $8,624 | 64.26 | $10,161 | ||||||
46 | 1982 | 11/1/1982 | 138.1 | 6.86 | 1.20 | 165.28 | $8,845.21 | 0.00 | $8,845 | $8,845.21 | 0.00 | $8,845 | 65.47 | $10,820 | ||||||
47 | 1982 | 12/1/1982 | 139.4 | 6.87 | 1.20 | 167.52 | $9,067.32 | 0.00 | $9,067 | $9,067.32 | 0.00 | $9,067 | 66.66 | $11,167 | ||||||
48 | 1983 | 1/1/1983 | 144.3 | 6.88 | 1.21 | 174.12 | $9,289.99 | 0.00 | $9,290 | $9,289.99 | 0.00 | $9,290 | 67.81 | $11,807 | ||||||
49 | 1983 | 2/1/1983 | 146.8 | 6.9 | 1.21 | 177.84 | $9,513.21 | 0.00 | $9,513 | $9,513.21 | 0.00 | $9,513 | 68.94 | $12,260 | ||||||
50 | 1983 | 3/1/1983 | 151.9 | 6.91 | 1.22 | 184.74 | $9,737.00 | 0.00 | $9,737 | $9,737.00 | 0.00 | $9,737 | 70.02 | $12,935 | ||||||
51 | 1983 | 4/1/1983 | 157.7 | 6.92 | 1.22 | 192.52 | $9,961.34 | 0.00 | $9,961 | $9,961.34 | 0.00 | $9,961 | 71.06 | $13,680 | ||||||
52 | 1983 | 5/1/1983 | 164.1 | 6.93 | 1.23 | 201.07 | $10,186.24 | 0.00 | $10,186 | $10,186.24 | 0.00 | $10,186 | 72.05 | $14,487 | ||||||
53 | 1983 | 6/1/1983 | 166.4 | 6.94 | 1.23 | 204.60 | $10,411.71 | 0.00 | $10,412 | $10,411.71 | 0.00 | $10,412 | 73.03 | $14,942 | ||||||
54 | 1983 | 7/1/1983 | 167 | 6.96 | 1.23 | 206.06 | $10,637.74 | 0.00 | $10,638 | $10,637.74 | 0.00 | $10,638 | 74.00 | $15,248 | ||||||
55 | 1983 | 8/1/1983 | 162.4 | 6.98 | 1.24 | 201.08 | $10,864.33 | 0.00 | $10,864 | $10,864.33 | 0.00 | $10,864 | 74.99 | $15,080 | ||||||
56 | 1983 | 9/1/1983 | 167.2 | 7 | 1.24 | 207.76 | $11,091.49 | 0.00 | $11,091 | $11,091.49 | 0.00 | $11,091 | 75.96 | $15,781 | ||||||
57 | 1983 | 10/1/1983 | 167.7 | 7.03 | 1.25 | 209.11 | $11,319.22 | 0.00 | $11,319 | $11,319.22 | 0.00 | $11,319 | 76.91 | $16,083 | ||||||
58 | 1983 | 11/1/1983 | 165.2 | 7.06 | 1.25 | 206.71 | $11,547.52 | 0.00 | $11,548 | $11,547.52 | 0.00 | $11,548 | 77.88 | $16,099 | ||||||
59 | 1983 | 12/1/1983 | 164.4 | 7.09 | 1.26 | 206.44 | $11,776.39 | 0.00 | $11,776 | $11,776.39 | 0.00 | $11,776 | 78.85 | $16,278 | ||||||
60 | 1984 | 1/1/1984 | 166.4 | 7.12 | 1.26 | 209.71 | $12,005.83 | 0.00 | $12,006 | $12,005.83 | 0.00 | $12,006 | 79.80 | $16,735 | ||||||
61 | 1984 | 2/1/1984 | 157.3 | 7.15 | 1.26 | 198.94 | $12,235.84 | 0.00 | $12,236 | $12,235.84 | 0.00 | $12,236 | 80.81 | $16,076 | ||||||
62 | 1984 | 3/1/1984 | 157.4 | 7.18 | 1.27 | 199.82 | $12,466.43 | 0.00 | $12,466 | $12,466.43 | 0.00 | $12,466 | 81.81 | $16,348 | ||||||
63 | 1984 | 4/1/1984 | 157.6 | 7.22 | 1.27 | 200.84 | $12,697.60 | 0.00 | $12,698 | $12,697.60 | 0.00 | $12,698 | 82.81 | $16,631 | ||||||
64 | 1984 | 5/1/1984 | 156.6 | 7.27 | 1.28 | 200.33 | $12,929.34 | 0.00 | $12,929 | $12,929.34 | 0.00 | $12,929 | 83.80 | $16,788 | ||||||
65 | 1984 | 6/1/1984 | 153.1 | 7.31 | 1.28 | 196.61 | $13,161.67 | 0.00 | $13,162 | $13,161.67 | 0.00 | $13,162 | 84.82 | $16,676 | ||||||
66 | 1984 | 7/1/1984 | 151.1 | 7.33 | 1.29 | 194.81 | $13,394.57 | 0.00 | $13,395 | $13,394.57 | 0.00 | $13,395 | 85.85 | $16,724 | ||||||
67 | 1984 | 8/1/1984 | 164.4 | 7.36 | 1.29 | 212.82 | $13,628.06 | 0.00 | $13,628 | $13,628.06 | 0.00 | $13,628 | 86.79 | $18,470 | ||||||
68 | 1984 | 9/1/1984 | 166.1 | 7.38 | 1.30 | 215.82 | $13,862.13 | 0.00 | $13,862 | $13,862.13 | 0.00 | $13,862 | 87.71 | $18,930 | ||||||
69 | 1984 | 10/1/1984 | 164.8 | 7.43 | 1.30 | 214.92 | $14,096.78 | 0.00 | $14,097 | $14,096.78 | 0.00 | $14,097 | 88.64 | $19,052 | ||||||
70 | 1984 | 11/1/1984 | 166.3 | 7.48 | 1.31 | 217.69 | $14,332.02 | 0.00 | $14,332 | $14,332.02 | 0.00 | $14,332 | 89.56 | $19,497 | ||||||
71 | 1984 | 12/1/1984 | 164.5 | 7.53 | 1.31 | 216.14 | $14,567.85 | 0.00 | $14,568 | $14,567.85 | 0.00 | $14,568 | 90.49 | $19,559 | ||||||
72 | 1985 | 1/1/1985 | 171.6 | 7.57 | 1.32 | 226.33 | $14,804.27 | 0.00 | $14,804 | $14,804.27 | 0.00 | $14,804 | 91.37 | $20,681 | ||||||
73 | 1985 | 2/1/1985 | 180.9 | 7.62 | 1.32 | 239.48 | $15,041.28 | 0.00 | $15,041 | $15,041.28 | 0.00 | $15,041 | 92.21 | $22,081 | ||||||
74 | 1985 | 3/1/1985 | 179.4 | 7.66 | 1.33 | 238.32 | $15,278.89 | 0.00 | $15,279 | $15,278.89 | 0.00 | $15,279 | 93.05 | $22,175 | ||||||
75 | 1985 | 4/1/1985 | 180.6 | 7.69 | 1.33 | 240.77 | $15,517.08 | 0.00 | $15,517 | $15,517.08 | 0.00 | $15,517 | 93.88 | $22,603 | ||||||
76 | 1985 | 5/1/1985 | 184.9 | 7.71 | 1.34 | 247.38 | $15,755.88 | 0.00 | $15,756 | $15,755.88 | 0.00 | $15,756 | 94.69 | $23,423 | ||||||
77 | 1985 | 6/1/1985 | 188.9 | 7.74 | 1.34 | 253.61 | $15,995.27 | 0.00 | $15,995 | $15,995.27 | 0.00 | $15,995 | 95.47 | $24,213 | ||||||
78 | 1985 | 7/1/1985 | 192.5 | 7.77 | 1.35 | 259.32 | $16,235.26 | 0.00 | $16,235 | $16,235.26 | 0.00 | $16,235 | 96.25 | $24,959 | ||||||
79 | 1985 | 8/1/1985 | 188.3 | 7.81 | 1.35 | 254.52 | $16,475.84 | 0.00 | $16,476 | $16,475.84 | 0.00 | $16,476 | 97.03 | $24,696 | ||||||
80 | 1985 | 9/1/1985 | 184.1 | 7.84 | 1.36 | 249.70 | $16,717.03 | 0.00 | $16,717 | $16,717.03 | 0.00 | $16,717 | 97.83 | $24,429 | ||||||
81 | 1985 | 10/1/1985 | 186.2 | 7.86 | 1.36 | 253.45 | $16,958.83 | 0.00 | $16,959 | $16,958.83 | 0.00 | $16,959 | 98.62 | $24,995 | ||||||
82 | 1985 | 11/1/1985 | 197.5 | 7.88 | 1.37 | 269.77 | $17,201.22 | 0.00 | $17,201 | $17,201.22 | 0.00 | $17,201 | 99.36 | $26,806 | ||||||
83 | 1985 | 12/1/1985 | 207.3 | 7.9 | 1.37 | 284.10 | $17,444.23 | 0.00 | $17,444 | $17,444.23 | 0.00 | $17,444 | 100.07 | $28,429 | ||||||
84 | 1986 | 1/1/1986 | 208.2 | 7.94 | 1.37 | 286.24 | $17,687.84 | 0.00 | $17,688 | $17,687.84 | 0.00 | $17,688 | 100.77 | $28,843 | ||||||
85 | 1986 | 2/1/1986 | 219.4 | 7.98 | 1.38 | 302.60 | $17,932.06 | 0.00 | $17,932 | $17,932.06 | 0.00 | $17,932 | 101.43 | $30,692 | ||||||
86 | 1986 | 3/1/1986 | 232.3 | 8.02 | 1.38 | 321.36 | $18,176.89 | 0.00 | $18,177 | $18,176.89 | 0.00 | $18,177 | 102.05 | $32,795 | ||||||
87 | 1986 | 4/1/1986 | 238 | 8.05 | 1.39 | 330.19 | $18,422.33 | 0.00 | $18,422 | $18,422.33 | 0.00 | $18,422 | 102.65 | $33,896 | ||||||
88 | 1986 | 5/1/1986 | 238.5 | 8.07 | 1.39 | 331.82 | $18,668.38 | 0.00 | $18,668 | $18,668.38 | 0.00 | $18,668 | 103.26 | $34,263 | ||||||
89 | 1986 | 6/1/1986 | 245.3 | 8.1 | 1.40 | 342.24 | $18,915.06 | 0.00 | $18,915 | $18,915.06 | 0.00 | $18,915 | 103.84 | $35,539 | ||||||
90 | 1986 | 7/1/1986 | 240.2 | 8.14 | 1.40 | 336.05 | $19,162.34 | 0.00 | $19,162 | $19,162.34 | 0.00 | $19,162 | 104.44 | $35,096 | ||||||
91 | 1986 | 8/1/1986 | 245 | 8.19 | 1.40 | 343.73 | $19,410.25 | 0.00 | $19,410 | $19,410.25 | 0.00 | $19,410 | 105.02 | $36,098 | ||||||
92 | 1986 | 9/1/1986 | 238.3 | 8.23 | 1.41 | 335.26 | $19,658.77 | 0.00 | $19,659 | $19,658.77 | 0.00 | $19,659 | 105.62 | $35,409 | ||||||
93 | 1986 | 10/1/1986 | 237.4 | 8.25 | 1.41 | 334.96 | $19,907.92 | 0.00 | $19,908 | $19,907.92 | 0.00 | $19,908 | 106.21 | $35,577 | ||||||
94 | 1986 | 11/1/1986 | 245.1 | 8.26 | 1.42 | 346.83 | $20,157.69 | 0.00 | $20,158 | $20,157.69 | 0.00 | $20,158 | 106.79 | $37,037 | ||||||
95 | 1986 | 12/1/1986 | 248.6 | 8.28 | 1.42 | 352.77 | $20,408.09 | 0.00 | $20,408 | $20,408.09 | 0.00 | $20,408 | 107.36 | $37,872 | ||||||
96 | 1987 | 1/1/1987 | 264.5 | 8.3 | 1.42 | 376.37 | $20,659.11 | 0.00 | $20,659 | $20,659.11 | 0.00 | $20,659 | 107.89 | $40,606 | ||||||
97 | 1987 | 2/1/1987 | 280.9 | 8.32 | 1.43 | 400.75 | $20,910.75 | 0.00 | $20,911 | $20,910.75 | 0.00 | $20,911 | 108.39 | $43,436 | ||||||
98 | 1987 | 3/1/1987 | 292.5 | 8.34 | 1.43 | 418.33 | $21,163.03 | 0.00 | $21,163 | $21,163.03 | 0.00 | $21,163 | 108.86 | $45,541 | ||||||
99 | 1987 | 4/1/1987 | 289.3 | 8.4 | 1.43 | 414.74 | $21,415.94 | 0.00 | $21,416 | $21,415.94 | 0.00 | $21,416 | 109.35 | $45,350 | ||||||
100 | 1987 | 5/1/1987 | 289.1 | 8.46 | 1.44 | 415.45 | $21,669.48 | 0.00 | $21,669 | $21,669.48 | 0.00 | $21,669 | 109.83 | $45,628 |