Finance

profileSRK1992
indexFL3.xlsx
Home>Business & Finance homework help>Economics homework help>Finance

Sheet1

Start Date 1/1/10
End Date
SPX Index NDX Index FXAIX US Equity IRLSX US Equity SWPPX US Equity DJI Index MXUS Index B400 Index
#N/A Requesting Data... #N/A Requesting Data... #N/A Requesting Data... #N/A Requesting Data... #N/A Requesting Data... Last Price Last Price Last Price
Dates PX_LAST PX_LAST PX_LAST PX_LAST PX_LAST PX_LAST PX_LAST PX_LAST
1/29/10 1741.04 38.01 12.23 16.72 10067.33 1022.88 254.81
2/26/10 1104.49 1818.68 39.19 12.58 17.24 10325.26 1052.03 264.27
3/31/10 1169.43 1958.34 41.55 13.25 18.28 10856.63 1113.36 279.57
4/30/10 1186.69 2000.63 42.03 13.3 18.56 11008.61 1130.03 286.98
5/31/10 1089.41 1852.39 38.67 12.17 17.08 10136.63 1036.6 270.32
6/30/10 1030.71 1739.14 36.65 11.53 16.19 9774.02 979.88 256.99
7/30/10 1101.6 1864 39.03 12.36 17.32 10465.94 1047.14 269.46
8/31/10 1049.33 1767.43 37.26 11.76 16.54 10014.72 998.28 255.34
9/30/10 1141.2 1998.04 40.59 12.94 18.01 10788.05 1087.34 284.51
10/29/10 1183.26 2124.45 41.93 13.59 18.7 11118.49 1128.87 295.24
11/30/10 1180.55 2117.33 41.94 13.63 18.69 11006.02 1127.5 304.42
12/31/10 1257.64 2217.86 44.48 14.34 19.57 11577.51 1201 322.74
1/31/11 1286.12 2281.91 45.54 14.73 20.03 11891.93 1228.57 326.13
2/28/11 1327.22 2350.99 47.09 15.16 20.71 12226.34 1267.03 339.82
3/31/11 1325.83 2338.99 47.11 15.08 20.72 12319.73 1266.63 350.17
4/29/11 1363.61 2404.08 48.31 15.56 21.33 12810.54 1303.97 361.92
5/31/11 1345.2 2372.54 47.76 15.19 21.09 12569.79 1287.01 358.31
6/30/11 1320.64 2325.07 46.97 14.98 20.74 12414.34 1263.13 352.21
7/29/11 1292.28 2362.81 45.78 15 20.32 12143.24 1237.13 341.03
8/31/11 1218.89 2241.01 43.29 14.3 19.22 11613.53 1165.71 317.78
9/30/11 1131.42 2139.18 40.25 13.39 17.88 10913.38 1080.16 281.03
10/31/11 1253.3 2360.08 44.41 14.72 19.82 11955.01 1197.16 328.51
11/30/11 1246.96 2295.2 44.31 14.74 19.77 12045.68 1190.52 324.59
12/30/11 1257.61 2277.83 44.5 14.76 19.57 12217.56 1199.65 321.42
1/31/12 1312.41 2467.95 46.49 15.55 20.44 12632.91 1254.7 347.52
2/29/12 1365.68 2623.1 48.5 16.31 21.33 12952.07 1306.74 360.15
3/30/12 1408.47 2755.27 50.1 16.9 22.02 13212.04 1346.48 366.33
4/30/12 1397.91 2723.68 49.6 16.86 21.89 13213.63 1336.75 362.28
5/31/12 1310.33 2524.87 46.61 15.68 20.57 12393.45 1251.29 331.89
6/29/12 1362.16 2615.72 48.53 16.15 21.42 12880.09 1298.66 342.38
7/31/12 1379.32 2642.53 48.92 16.45 21.72 13008.68 1314.63 341.73
8/31/12 1406.58 2772.24 50.02 16.84 22.21 13090.84 1341.92 354.5
9/28/12 1440.67 2799.19 51.31 17.16 22.77 13437.13 1373.92 361.68
10/31/12 1412.16 2647.92 50.09 16.61 22.35 13096.46 1347.36 354.24
11/30/12 1416.18 2677.88 50.38 16.84 22.48 13025.58 1352.17 358.22
12/31/12 1426.19 2660.93 50.49 16.71 22.19 13104.14 1361.88 365.89
1/31/13 1498.11 2731.53 53.1 17.29 23.34 13860.58 1432.15 388.43
2/28/13 1514.68 2738.58 53.83 17.51 23.65 14054.49 1447.09 392.56
3/29/13 1569.19 2818.69 55.84 18.14 24.54 14578.54 1499.23 409.62
4/30/13 1597.57 2887.44 56.64 18.56 25.01 14839.8 1527.16 411.36
5/31/13 1630.74 2981.76 57.96 18.61 25.59 15115.57 1555.46 429.21
6/28/13 1606.28 2909.6 57.18 18.2 25.24 14909.6 1532.12 425.03
7/31/13 1685.73 3090.19 59.8 19.07 26.52 15499.54 1610.62 453.36
8/30/13 1632.97 3073.81 58.07 18.75 25.75 14810.31 1562.55 443.36
9/30/13 1681.55 3218.2 59.89 19.53 26.56 15129.67 1611.75 466.99
10/31/13 1756.54 3377.73 62.32 20.54 27.78 15545.75 1681.19 484.58
11/29/13 1805.81 3487.82 64.22 21.17 28.62 16086.41 1725.16 502.07
12/31/13 1848.36 3592 65.49 21.73 28.85 16576.66 1768.42 512.32
1/31/14 1782.59 3521.92 63.22 21.03 27.85 15698.85 1706.59 492.5
2/28/14 1859.45 3696.1 66.11 21.98 29.12 16321.71 1782.46 520.4
3/31/14 1872.34 3595.74 66.67 21.84 29.36 16457.66 1792.01 520.02
4/30/14 1883.95 3582.02 66.86 21.98 29.57 16580.84 1800.72 511.89
5/30/14 1923.57 3736.82 68.42 22.44 30.27 16717.17 1839.43 518.12
6/30/14 1960.23 3849.48 69.84 22.74 30.89 16826.6 1875.86 537.89
7/31/14 1930.67 3892.5 68.55 22.54 30.46 16563.3 1847.14 517.51
8/29/14 2003.37 4082.56 71.29 23.47 31.67 17098.45 1917.08 539.75
9/30/14 1972.29 4049.45 70.29 23.27 31.23 17042.9 1884.24 516.01
10/31/14 2018.05 4158.21 71.67 23.86 31.99 17390.52 1927.44 537.05
11/28/14 2067.56 4337.79 73.59 24.58 32.84 17828.24 1974.16 539.77
12/31/14 2058.9 4236.28 72.85 24.23 32.16 17823.07 1964.73 541.03
1/30/15 1994.99 4148.43 70.67 23.86 31.19 17164.95 1907.32 525.38
2/27/15 2104.5 4440.67 74.73 25.41 32.98 18132.7 2013.91 560.92
3/31/15 2067.89 4333.69 73.54 24.94 32.45 17776.12 1981.62 569.27
4/30/15 2085.51 4414.25 73.65 25.19 32.76 17840.52 1997.63 567.67
5/29/15 2107.39 4508.25 74.59 25.32 33.18 18010.68 2019.69 569.86
6/30/15 2063.11 4396.76 73.16 24.84 32.54 17619.51 1978.1 568.56
7/31/15 2103.84 4588.91 74.24 25.85 33.21 17689.86 2015.31 564.03
8/31/15 1972.18 4274.58 69.76 24.24 31.21 16528.03 1888.74 532.37
9/30/15 1920.03 4181.06 68.03 23.77 30.44 16284.7 1835.5 506.51
10/30/15 2079.36 4648.83 73.38 26.03 33 17663.54 1984.46 536.31
11/30/15 2080.41 4664.51 73.6 26.09 33.09 17719.92 1986.56 541.21
12/31/15 2043.94 4593.27 71.8 25.77 31.56 17425.03 1949.7 516.46
1/29/16 1940.24 4279.17 68.24 24.51 29.99 16466.3 1843.88 478.7
2/29/16 1932.23 4201.12 68.15 24.34 29.95 16516.5 1834.97 485.32
3/31/16 2059.74 4483.66 72.77 25.93 31.97 17685.09 1957.22 518.17
4/29/16 2065.3 4341.3 72.67 25.61 32.09 17773.64 1964.63 520.62
5/31/16 2096.96 4523.89 73.98 25.83 32.67 17787.2 1995.56 527.65
6/30/16 2098.86 4417.7 74.17 25.68 32.75 17929.99 1997.33 520.26
7/29/16 2173.6 4730.23 76.53 26.86 33.95 18432.24 2070.68 546.85
8/31/16 2170.95 4771.06 76.63 26.69 34 18400.88 2068.57 553.02
9/30/16 2168.27 4875.7 76.65 26.81 34 18308.15 2067.66 551.17
10/31/16 2126.15 4801.27 74.87 26.33 33.38 18142.42 2026.1 534.79
11/30/16 2198.81 4810.81 77.64 26.7 34.61 19123.58 2093.61 585.41
12/30/16 2238.83 4863.62 78.35 27.1 34.42 19762.6 2129.36 601.62
1/31/17 2278.87 5116.77 79.83 28 35.07 19864.09 2171.19 609.33
2/28/17 2363.64 5330.31 83 29.26 36.46 20812.24 2251.29 623.77
3/31/17 2362.72 5436.23 83.09 29.64 36.5 20663.22 2250.91 628.15
4/28/17 2384.2 5583.53 83.45 30.37 36.88 20940.51 2272.62 638.76
5/31/17 2411.8 5788.8 84.62 30.87 37.39 21008.65 2297.76 635.71
6/30/17 2423.41 5646.92 85.15 30.72 37.63 21349.63 2308.82 646.24
7/31/17 2470.3 5880.33 86.47 31.62 38.4 21891.12 2353.08 652.78
8/31/17 2471.65 5988.6 86.73 32.29 38.52 21948.1 2355.08 644.63
9/29/17 2519.36 5979.3 88.52 32.54 39.31 22405.09 2399.93 678.27
10/31/17 2575.26 6248.56 90.13 33.89 40.23 23377.24 2452.15 690.87
11/30/17 2647.58 6365.56 92.89 34.87 41.46 24272.35 2520.55 708.56
12/29/17 2673.61 6396.42 93.45 35.15 41.19 24719.22 2544.58 710.93
1/31/18 2823.81 6949.99 98.8 37.77 43.54 26149.39 2687.94 739.99
2/28/18 2713.83 6854.42 95.15 36.82 41.94 25029.2 2583.87 709.91
3/30/18 2640.87 6581.13 92.73 35.49 40.87 24103.11 2516.93 711.59
4/30/18 2648.05 6605.57 92.59 35.74 41.03 24163.15 2524.28 708.88
5/31/18 2705.27 6967.73 94.82 35.81 42.02 24415.84 2579.76 737.6
6/29/18 2718.37 7040.8 95.4 36.2 42.27 24271.41 2593.87 738.39
7/31/18 2816.29 7231.98 98.49 37.31 43.84 25415.19 2683.96 752.9
8/31/18 2901.52 7654.55 101.7 39.29 45.27 25964.82 2766.77 785
9/28/18 2913.98 7627.65 102.28 39.6 45.53 26458.31 2775.55 767.31
10/31/18 2711.74 6967.1 94.86 36.18 42.41 25115.76 2579.96 683.03
11/30/18 2760.17 6949.01 96.79 36.39 43.28 25538.46 2623.85 687.81
12/31/18 2506.85 6329.96 87.1 33.29 38.31 23327.46 2383.55 609.71
1/31/19 2704.1 6906.84 94.08 36 41.37 24999.67 2576.16 675.52
2/28/19 2784.49 7097.53 97.1 37.04 42.7 25916 2656.46 704.3
3/29/19 2834.4 7378.77 98.99 38.23 43.53 25928.68 2701.54 686.63
4/30/19 2945.83 7781.46 102.41 39.93 45.3 26592.91 2806.7 715.2
5/31/19 2752.06 7127.96 95.9 35.32 42.42 24815.04 2623.15 641.32
6/28/19 2941.76 7671.08 102.66 37.71 45.4 26599.96 2803.32 691.49
7/31/19 2980.38 7848.78 103.66 38.54 46.06 26864.27 2843.24 696.13
8/30/19 2926.46 7691 102.02 38.33 45.33 26403.28 2787.6 657.9
9/30/19 2976.74 7749.45 103.92 38.44 46.17 26916.83 2832.91 677.62
10/31/19 3037.56 8083.83 105.66 39.6 47.17 27046.23 2891.19 688.83
11/29/19 3140.98 8403.69 109.49 41.27 48.88 28051.41 2993.5 714.94
12/31/19 3230.78 8733.07 112.02 42.68 49.39 28538.44 3076.49 732.23
1/31/20 3225.52 8991.51 111.98 43.75 49.37 28256.03 3078.78 707.95
2/28/20 2954.22 8461.83 102.76 40.75 45.31 25409.36 2822.38 643.41
3/31/20 2584.59 7813.5 90.07 37.23 39.71 21917.16 2459.87 533.62
4/30/20 2912.43 9000.51 101.04 42.63 44.8 24345.72 2780.19 611.09
5/29/20 3044.31 9555.52 105.85 42.71 46.93 25383.11 2918.45 659.08
6/30/20 3100.29 10156.85 107.95 44.73 47.87 25812.88 2980.73 667.9
7/31/20 3271.12 10905.88 113.53 48.11 50.57 26428.32 3153.99 704.69
8/31/20 3500.31 12110.7 121.69 53.79 54.2 28430.05 3385.29 733.85
9/30/20 3363 11418.06 117.07 50.9 52.14 27781.7 3254.94 713.08
10/30/20 3269.96 11052.95 113.51 48.78 50.75 26501.6 3166.93 719.73
11/30/20 3621.63 12268.32 125.93 53.41 56.31 29638.64 3527.53 802.7
12/31/20 3756.07 12888.28 130.17 55.81 57.42 30606.48 3667.92 852.19
1/29/21 3714.24 12925.38 128.85 55.32 56.84 29982.62 3630.3 866.2
2/26/21 3811.15 12909.44 132.41 55.06 58.41 30932.37 3719.93 913
3/31/21 3972.89 13091.44 138.21 56.44 60.96 32981.55 3854.97 962.96
4/30/21 4181.17 13860.76 145.16 60.4 64.21 33874.85 4061.26 997.61
5/31/21 4204.11 13686.51 146.18 59.06 64.66 34529.45 4074.95 1011
6/30/21 4297.5 14554.8 149.59 62.66 66.17 34502.51 4183.8 1013.68
7/30/21 4395.26 14959.9 152.64 65.04 67.74 34935.47 4278.63 1024.19
8/31/21 4522.68 15582.51 157.27 67.5 69.8 35360.73 4399.11 1041.61
9/30/21 4307.54 14689.62 149.96 63.57 66.55 33843.92 4186.85 1004.2
10/29/21 4605.38 15850.47 159.9 69.28 71.21 35819.56 4475.12 1069.08
11/30/21 4567 16135.92 158.8 70.43 70.71 34483.72 4424.07 1062.63
12/31/21 4766.18 16320.08 165.32 72.15 72.94 36338.3 4593.59 1106.26
1/31/22 4515.55 14930.05 156.76 66.59 69.17 35131.86 4329.86 1016.83
2/28/22 4373.94 14237.81 152.07 63.33 67.1 33892.6 4196.99 1014.9
3/31/22 4530.41 14838.49 157.71 66.07 69.59 34678.35 4338.85 1017.6
4/29/22 4131.93 12854.8 143.53 57.95 63.52 32977.21 3942.29 943.84
5/31/22 4132.15 12642.1 143.79 51.48 63.63 32990.12 3926.84 969.19
6/30/22 3785.38 11503.72 131.92 47.33 58.38 30775.43 3596.34 861.18
7/29/22 4130.29 12947.97 143.46 52.95 63.76 32845.13 3927.71 959.29
8/31/22 3955 12272.03 137.61 50.29 61.16 31510.43 3767.45 922.08
9/30/22 3585.62 10971.22 124.93 45.24 55.53 28725.51 3413.25 836.84
10/31/22 3871.98 11405.57 134.43 47.65 60.02 32732.95 3680.53 930.9
11/30/22 4080.11 12030.06 141.94 49.7 63.37 34589.77 3873.16 986.16
12/30/22 3839.5 10939.76 133.12 45.68 58.76 33147.25 3640.19 920.39
1/31/23 4076.6 12101.93 141.48 49.42 62.45 34086.04 3875.93 998.38
2/28/23 3970.15 12042.12 138.03 48.78 60.92 32656.7 3776.88 981.75
3/31/23 4109.31 13181.35 143.1 52.71 63.16 33274.15 3904.8 937.47
4/28/23 4169.48 13245.99 144.78 53.48 64.14 34098.16 3950.69 917.44
5/31/23 4179.83 14254.09 145.41 53.5 64.42 32908.27 3969.21 895.36
6/30/23 4450.38 15179.21 155.01 57.07 68.67 34407.6 4228.59 980.2
7/31/23 4588.96 15757 159.36 58.99 70.88 35559.53 4370.1 1036.97
8/31/23 4507.66 15501.07 156.84 58.64 69.75 34721.91 4288.81 1004.27
9/29/23 4288.05 14715.24 149.36 55.37 66.42 33507.5 4083.33 963.1
10/31/23 4193.8 14409.78 145.68 54.86 65.03 33052.87 3985.59 919
11/30/23 4567.8 15947.87 158.98 60.74 70.96 35950.89 4352.86 987.88
12/29/23 4769.83 16825.93 165.49 63.11 73.1 37689.54 4552.01 1072.4
1/31/24 4845.65 17137.24 168.27 64.93 74.32 38150.3 4618.9 1064.76
2/29/24 5096.27 18043.85 177.25 69.26 78.29 38996.39 4859.23 1121
3/29/24 5254.35 18254.69 182.95 70.38 80.81 39807.37 5008.17 1166.53