NAME: STUDENT NUMBER: MODE OF STUDY: INSTURCTIONS: Q1 DATA: READ CAREFULLY. ALL CALCULATIONS MUST BE DONE IN EXCEL USING EXCEL APPI YOU ARE PRESENTED WITH EIGHT (8) STOCKS AND THEIR PRICES FROM 1ST JAN 2015 TO 51 ALL STOCKS BELONG TO THE LIVINGSTONE STOCK EXCHANGE ON 21ST JAN 2015 STOCK B HAS A 2 FOR 1 STOCK SPLIT AFTER THE CLOSE OF DAY ON 10TH JAN 2015 STOCK F HAS A 3 FOR 1 STOCK SPLIT AFTER THE CLOSE OF DAY CALCULATE THE DAILY INDEX AVERAGES FOR THE LIVINGSTONE ALL SHARE INDEX QUESTION 1: (LASI). ASSUME THE BASE DATE IS 1ST JAN 2020 AND BASE VALUE OF 100 DAY A B D E F 05/02/2015 1468.36 6456.90 8067.32 15307.78 2151.73 2745.83 04/02/2015 1481.14 6432.50 7870.52|15680.67 2207.16 2688.33 03/02/2015 1549.38 6721.601 8019.22 16737.63 2351.44 2643.49 02/02/2015 1526.75 6466.80 7861.51 16785.69 2187.97 2359.21 01/02/2015 1473.99 6303.30 7638.17| 16569.09 2062.08 2194.34 31/01/2015 1455.271 6360.10 7584.14| 17248.89 2180.25 2348.67 30/01/2015 1503.35 6607.90 8007.32 18138.36) 2190.87 2139.28 29/01/2015 1530.62 6621.407883.04 17875.75 2243.03 2084.32 28/01/2015 1482.371 6449.207408.87| 17400.41 2154.55 1999.17 27/01/2015 1420.861 6308.00 6917.03 17287.65 2102.78 1830.92 26/01/2015 1406.82 6171.501 6715.441 17604.12) 2067.641 1740.97 25/01/2015 1438.24 6203.10 6789.11 17383.42 2070.64 1757.26 24/01/2015 1418.30 6220.80 6596.921 17225.831 2090.461805.52 23/01/2015 1400.63 6048.80 6309.19| 16274.33) 1967.02 1718.96 22/01/2015 1377.94 6129.20 6268.92 16399.391781.68 1582.63 21/01/2015 1335.85 5960.80 6004.33 16127.58 1637.27 1534.61 20/01/2015 1303.82 5906.10 5859.57 16140.761 1662.84 1431.26 19/01/2015 1276.66 5928.30 5681.97 15456.81 1701.58 1351.65 18/01/2015 1270.20 5833.40 5683.31 15505.18 1711.09 1310.26 17/01/2015 1270.09 5723.80 5692.86 15467.33 1653.72 1330.00 16/01/2015 1310.61 6023.106009.89 16906.23 1908.61 1464.41 15/01/2015 1294.87 5964.60 5970.08 17059.66 1800.58 1322.97 14/01/2015 1280.66 5791.50 5796.04 16205.43 1714.05 1230.66 13/01/2015 1280.08 5760.30 5674.15 16649.82 1793.97 1232.32 12/01/2015 1248.29 5618.80 5408.26 16111.43 1543.31 1162.64 11/01/2015 1249.48 5423.20 5193.401 14872.15 1554.67 1096.64 10/01/2015 1207.01 5317.30 4929.07 13606.50 1608.86 1066.22 09/01/2015 1228.81 5477.70 5044.12 13574.30 1694.83 1079.28 08/01/2015 1220.33 5296.90 4829.69 12413.60 1581.65 1050.09 07/01/2015 1234.18 5282.30 4886.50 11899.60 1507.59 1182.30 06/01/2015 1191.33 5113.20 4586.28| 11584.01 1367.41 1122.38 05/01/2015 1191.50| 4964.00 4460.63 11276.59 1485.55 1088.17 04/01/2015 1156.85 4801.70 4184.84 11008.90 1348.35 1029.61 03/01/2015 1180.59 4894.40 4348.77 11668.95 1400.42 1080.17 02/01/2015 1203.60| 4968.50 4350.49 11740.60 1558.62 1073.83 01/01/2015 1181.27| 4852.30 4254.85 11387.59 1373.79 1045.44 G H 325.72 53.89 327.401 56.06 355.81 59.74 325.91 53.08 303.02 46.62 316.36 48.181 303.26) 47.37 292.65 46.10 276.41] 41.40 263.38 39.68 253.08) 37.42 251.24) 38.56 252.90 37.74 243.51 35.77 226.86 33.98 217.26 31.40 214.39 31.08 211.21 30.63 209.67 29.56 212.27) 28.531 234.08| 32.75 217.56) 29.61 216.89 30.16 218.92 30.241 200.47 25.32 188.52 25.14 175.271 23.21 186.52 24.26 171.79 20.99 173.75 19.68 163.53 18.55 158.89 17.60 154.56 16.30 159.97 16.54 171.30 17.93 158.61 15.85 DAY A B D E F 05/02/2015 1468.36 6456.90 8067.32 15307.78 2151.73 2745.83 04/02/2015 1481.14 6432.50 7870.52|15680.67 2207.16 2688.33 03/02/2015 1549.38 6721.601 8019.22 16737.63 2351.44 2643.49 02/02/2015 1526.75 6466.80 7861.51 16785.69 2187.97 2359.21 01/02/2015 1473.99 6303.30 7638.17| 16569.09 2062.08 2194.34 31/01/2015 1455.271 6360.10 7584.14| 17248.89 2180.25 2348.67 30/01/2015 1503.35 6607.90 8007.32 18138.36) 2190.87 2139.28 29/01/2015 1530.62 6621.407883.04 17875.75 2243.03 2084.32 28/01/2015 1482.371 6449.207408.87| 17400.41 2154.55 1999.17 27/01/2015 1420.861 6308.00 6917.03 17287.65 2102.78 1830.92 26/01/2015 1406.82 6171.501 6715.441 17604.12) 2067.641 1740.97 25/01/2015 1438.24 6203.10 6789.11 17383.42 2070.64 1757.26 24/01/2015 1418.30 6220.80 6596.921 17225.831 2090.461805.52 23/01/2015 1400.63 6048.80 6309.19| 16274.33) 1967.02 1718.96 22/01/2015 1377.94 6129.20 6268.92 16399.391781.68 1582.63 21/01/2015 1335.85 5960.80 6004.33 16127.58 1637.27 1534.61 20/01/2015 1303.82 5906.10 5859.57 16140.761 1662.84 1431.26 19/01/2015 1276.66 5928.30 5681.97 15456.81 1701.58 1351.65 18/01/2015 1270.20 5833.40 5683.31 15505.18 1711.09 1310.26 17/01/2015 1270.09 5723.80 5692.86 15467.33 1653.72 1330.00 16/01/2015 1310.61 6023.106009.89 16906.23 1908.61 1464.41 15/01/2015 1294.87 5964.60 5970.08 17059.66 1800.58 1322.97 14/01/2015 1280.66 5791.50 5796.04 16205.43 1714.05 1230.66 13/01/2015 1280.08 5760.30 5674.15 16649.82 1793.97 1232.32 12/01/2015 1248.29 5618.80 5408.26 16111.43 1543.31 1162.64 11/01/2015 1249.48 5423.20 5193.401 14872.15 1554.67 1096.64 10/01/2015 1207.01 5317.30 4929.07 13606.50 1608.86 1066.22 09/01/2015 1228.81 5477.70 5044.12 13574.30 1694.83 1079.28 08/01/2015 1220.33 5296.90 4829.69 12413.60 1581.65 1050.09 07/01/2015 1234.18 5282.30 4886.50 11899.60 1507.59 1182.30 06/01/2015 1191.33 5113.20 4586.28| 11584.01 1367.41 1122.38 05/01/2015 1191.50| 4964.00 4460.63 11276.59 1485.55 1088.17 04/01/2015 1156.85 4801.70 4184.84 11008.90 1348.35 1029.61 03/01/2015 1180.59 4894.40 4348.77 11668.95 1400.42 1080.17 02/01/2015 1203.60| 4968.50 4350.49 11740.60 1558.62 1073.83 01/01/2015 1181.27| 4852.30 4254.85 11387.59 1373.79 1045.44