sheet 1

sheet 2

USE SHEET 1 " RAW DATA" TO COMPLETE SHEET 2

A W N 1 Date 2 2/1/2017 3 3/1/2017 4 4/1/2017 5 5/1/2017 6 6/1/2017 7 7/1/2017 8 8/1/2017 9 9/1/2017 10 10/1/2017 11 11/1/2017 12 12/1/2017 13 1/1/2018 14 2/1/2018 15 3/1/2018 16 4/1/2018 17 5/1/2018 18 6/1/2018 19 7/1/2018 20 8/1/2018 21 9/1/2018 22 10/1/2018 23 11/1/2018 24 12/1/2018 25 1/1/2019 26 2/1/2019 27 3/1/2019 28 4/1/2019 29 5/1/2019 30 6/1/2019 31 7/1/2019 32 8/1/2019 33 9/1/2019 34 10/1/2019 35 11/1/2019 36 12/1/2019 37 1/1/2020 B Closing Closing Market Price for Index value AMZN 2278.87 845.04 2363.64 886.54 2362.72 924.99 2384.20 994.62 2411.80 968.00 2423.41 987.78 2470.30 980.60 2471.65 961.35 2519.36 1105.28 2575.26 1176.75 2647.58 1169.47 2673.61 1450.89 2823.81 1512.45 2713.83 1447.34 2640.87 1566.13 2648.05 1629.62 2705.27 1699.80 2718.37 1777.44 2816.29 2012.71 2901.52 2003.00 2913.98 1598.01 2711.74 1690.17 2760.17 1501.97 2506.85 1718.73 2704.10 1639.83 2784.49 1780.75 2834.40 1926.52 2945.83 1775.07 2752.06 1893.63 2941.76 1866.78 2980.38 1776.29 2926.46 1735.91 2976.74 1776.66 3037.56 1800.80 3140.98 1847.84 3230.78 2008.72 D Closing Price for BAC 24.68 23.59 23.34 22.41 24.26 24.12 23.89 25.34 27.39 28.17 29.52 32.00 32.10 29.99 29.92 29.04 28.19 30.88 30.93 29.46 27.50 28.40 24.64 28.47 29.08 27.59 30.58 26.60 29.00 30.68 27.51 29.17 31.27 33.32 35.22 32.83 A B D E F G 1 Date losing Price for AMZI Monthly Return for AMZN Closing Price for BAC Monthly Return for BAC Closing Market Index value Monthly Market Return 2 2/1/2017 845.04 24.68 2278.87 3 3/1/2017 886.54 23.59 2363.64 4 4/1/2017 924.99 23.34 2362.72 5 5/1/2017 994.62 22.41 2384.20 6 6/1/2017 968.00 24.26 2411.80 7 7/1/2017 987.78 24.12 2423.41 8 8/1/2017 980.60 23.89 2470.30 9 9/1/2017 961.35 25.34 2471.65 10 10/1/2017 1105.28 27.39 2519.36 11 11/1/2017 1176.75 28.17 2575.26 12 | 12/1/2017 1169.47 29.52 2647.58 13 1/1/2018 1450.89 32.00 2673.61 14 2/1/2018 1512.45 32.10 2823.81 15 3/1/2018 1447.34 29.99 2713.83 16 4/1/2018 1566.13 29.92 2640.87 17 5/1/2018 1629.62 29.04 2648.05 18 6/1/2018 1699.80 28.19 2705.27 19 7/1/2018 1777.44 30.88 2718.37 20 8/1/2018 2012.71 30.93 2816.29 21 9/1/2018 2003.00 29.46 2901.52 22 10/1/2018 1598.01 27.50 2913.98 23 11/1/2018 1690.17 28.40 2711.74 24 12/1/2018 1501.97 24.64 2760.17 25 1/1/2019 1718.73 28.47 2506.85 26 2/1/2019 1639.83 29.08 2704.10 27 3/1/2019 1780.75 27.59 2784.49 28 4/1/2019 1926.52 30.58 2834.40 29 5/1/2019 1775.07 26.60 2945.83 30 6/1/2019 1893.63 29.00 2752.06 31 7/1/2019 1866.78 30.68 2941.76 32 8/1/2019 1776.29 27.51 2980.38 33 9/1/2019 1735.91 29.17 2926.46 34 10/1/2019 1776.66 31.27 2976.74 35 11/1/2019 1800.80 33.32 3037.56 36 12/1/2019 1847.84 35.22 3140.98 37 1/1/2020 2008.72 32.83 3230.78