Go to assignment2 sheet in the Chapter 3 Excel file. Compute the 60 monthly log returns of Coca-Cola and S&P 500 using their 61 monthly adjusted prices/indices from August 2015 to August 2020, and then report the beta of Coca-Cola using the computed log returns. H Coca-Cola Stock Price 2015-2020 Date Adj Close % Return 8/1/2015 39.32 9/1/2015 40.12 10/1/2015 42.35 11/1/2015 42.62 12/1/2015 42.96 1/1/2016 42.92 2/1/2016 43.13 3/1/2016 46.39 4/1/2016 44.80 5/1/2016 44.60 6/1/2016 45.33 7/1/2016 43.63 8/1/2016 43.43 9/1/2016 42.32 10/1/2016 42.40 11/1/2016 40.35 12/1/2016 42.00 1/1/2017 41.57 2/1/2017 41.96 3/1/2017 42.44 4/1/2017 43.15 5/1/2017 45.47 S&P 500 Index 2015-2020 Date Index % Return 8/1/2015 1972.18 9/1/2015 1920.03 10/1/2015 2079.36 11/1/2015 2080.41 12/1/2015 2043.94 1/1/2016 1940.24 2/1/2016 1932.23 3/1/2016 2059.74 4/1/2016 2065.30 5/1/2016 2096.95 6/1/2016 2098.86 7/1/2016 2173.60 8/1/2016 2170.95 9/1/2016 2168.27 10/1/2016 2126.15 11/1/2016 2198.81 12/1/2016 2257.83 1/1/2017 2278.87 2/1/2017 2363.64 3/1/2017 2362.72 4/1/2017 2384 20 5/1/2017 2411.80 D . | S&P 500 Date Ir A B Coca-Cola Stock Price 2015-2020 Date Adj Close % Return Just need formula that goes here? And how to calculate 8/1/2015 39.32 beta? 9/1/2015 40.12 10/1/2015 42.35 11/1/2015 42.62 12/1/2015 42.96 1/1/2016 42.92 2/1/2016 43.13 3/1/2016 46.39 4/1/2016 44.80 5/1/2016 44.60 6/1/2016 45.33 7/1/2016 43.63 8/1/2016 43.43 9/1/2016 42.32 10/1/2016 42.40 3 11/1/2016 40.35 12/1/2016 42.00 8/1/2015 9/1/2015 10/1/2015 11/1/2015 12/1/2015 1/1/2016 2/1/2016 3/1/2016 4/1/2016 5/1/2016 6/1/2016 7/1/2016 8/1/2016 9/1/2016 10/1/2016 11/1/2016 12/1/2016 Go to assignment2 sheet in the Chapter 3 Excel file. Compute the 60 monthly log returns of Coca-Cola and S&P 500 using their 61 monthly adjusted prices/indices from August 2015 to August 2020, and then report the beta of Coca-Cola using the computed log returns. H Coca-Cola Stock Price 2015-2020 Date Adj Close % Return 8/1/2015 39.32 9/1/2015 40.12 10/1/2015 42.35 11/1/2015 42.62 12/1/2015 42.96 1/1/2016 42.92 2/1/2016 43.13 3/1/2016 46.39 4/1/2016 44.80 5/1/2016 44.60 6/1/2016 45.33 7/1/2016 43.63 8/1/2016 43.43 9/1/2016 42.32 10/1/2016 42.40 11/1/2016 40.35 12/1/2016 42.00 1/1/2017 41.57 2/1/2017 41.96 3/1/2017 42.44 4/1/2017 43.15 5/1/2017 45.47 S&P 500 Index 2015-2020 Date Index % Return 8/1/2015 1972.18 9/1/2015 1920.03 10/1/2015 2079.36 11/1/2015 2080.41 12/1/2015 2043.94 1/1/2016 1940.24 2/1/2016 1932.23 3/1/2016 2059.74 4/1/2016 2065.30 5/1/2016 2096.95 6/1/2016 2098.86 7/1/2016 2173.60 8/1/2016 2170.95 9/1/2016 2168.27 10/1/2016 2126.15 11/1/2016 2198.81 12/1/2016 2257.83 1/1/2017 2278.87 2/1/2017 2363.64 3/1/2017 2362.72 4/1/2017 2384 20 5/1/2017 2411.80 D . | S&P 500 Date Ir A B Coca-Cola Stock Price 2015-2020 Date Adj Close % Return Just need formula that goes here? And how to calculate 8/1/2015 39.32 beta? 9/1/2015 40.12 10/1/2015 42.35 11/1/2015 42.62 12/1/2015 42.96 1/1/2016 42.92 2/1/2016 43.13 3/1/2016 46.39 4/1/2016 44.80 5/1/2016 44.60 6/1/2016 45.33 7/1/2016 43.63 8/1/2016 43.43 9/1/2016 42.32 10/1/2016 42.40 3 11/1/2016 40.35 12/1/2016 42.00 8/1/2015 9/1/2015 10/1/2015 11/1/2015 12/1/2015 1/1/2016 2/1/2016 3/1/2016 4/1/2016 5/1/2016 6/1/2016 7/1/2016 8/1/2016 9/1/2016 10/1/2016 11/1/2016 12/1/2016