Question 07 ATAT The following table shows 60 monthly excess percent returns of Bitcoin and S&P 500, the market. What is the market beta of Bitcoin for the last five years? Hint: Assignment 2 Question 4-Use SLOPE(Y.X) RBitcoin,t = a + BR$P500, +t % SP500 % Bitcoin 0.03 80 B 60 0.61 1.02 8.25 40 D 20 % Return 0 mah 2801812 201612 201AV 208.12 40 -60 Month 3.39 80 Date % SP500 % Bitcoin 201512 -1.77 14.1 01/31/16 -5.09 -14.37 02/29/16 -0.44 18,67 03/31/16 6.57 -4.82 04/30/16 0.25 7.56 05/31/16 1.52 18.51 06/30/16 0.07 26,69 07/31/16 3.54 -7.25 08/31/16 0.14 -7.90 09/30/16 -0.15 5.93 10/31/16 - 1.96 14.94 11/30/16 6.36 12/31/16 1.78 29,20 01/31/17 1.75 0.65 02/28/17 3.68 21.55 03/31/17 -0.08 -9.21 04/30/17 0.85 25.70 05/31/17 1.09 69.56 06/30/17 0.40 8.42 07/31/17 1.85 15.82 08/31/17 -0.03 63.49 09/30/17 1.85 -7.84 10/31/17 2.13 49.00 11/30/17 0.28 58.12 12/31/17 3.33 38.23 01/31/18 5.51 -27 91 02/28/18 -4.01 1.61 03/31/18 -2.82 2202 40 Bitcoin Return 20 -60 40 1 2 20 40 60 40 SP500% Return 7 Microsoft Excel can't run VBA macros. D M -40 SP500% Return 11/30/17 12/31/17 01/31/18 02/28/18 03/31/18 04/30/18 05/31/18 06/30/18 07/31/18 08/31/18 09/30/18 10/31/18 11/30/18 12/31/18 01/31/19 02/28/19 03/31/19 04/30/19 05/31/19 06/30/19 07/31/19 08/31/19 09/30/19 10/31/19 11/30/19 12/31/19 01/31/20 02/29/20 03/31/20 04/30/20 05/21/20 06/30/20 07/31/20 08/31/20 09/30/20 10/31/20 11/30/20 0.28 3.33 5.51 -4.01 -2.82 0.13 2.01 0.33 3.45 2.86 0.26 -7.12 1.60 -9.37 7.68 2.78 1.59 3.74 -6.78 6.70 1.14 -1.98 1.56 1.90 3.28 2.73 -0.29 -8.54 -12.61 12.68 4.52 1.83 5.50 7.00 -3.93 -2.77 10.75 58 12 38.23 27.91 1.61 -33.07 32-37 -19 05 -14.70 21 34 -9.71 -6.03 4.83 -36.60 -7.03 -7.80 11.29 6.30 30.14 60.05 25.96 6.93 -4.68 -14.04 10.27 -17.84 -5 10 29.86 -8.16 -25.23 34.48 9.26 -3.43 23.91 3.15 -7.65 27.74 42.41 05 06 07 08 09 10 11 12 Question 07 ATAT The following table shows 60 monthly excess percent returns of Bitcoin and S&P 500, the market. What is the market beta of Bitcoin for the last five years? Hint: Assignment 2 Question 4-Use SLOPE(Y.X) RBitcoin,t = a + BR$P500, +t % SP500 % Bitcoin 0.03 80 B 60 0.61 1.02 8.25 40 D 20 % Return 0 mah 2801812 201612 201AV 208.12 40 -60 Month 3.39 80 Date % SP500 % Bitcoin 201512 -1.77 14.1 01/31/16 -5.09 -14.37 02/29/16 -0.44 18,67 03/31/16 6.57 -4.82 04/30/16 0.25 7.56 05/31/16 1.52 18.51 06/30/16 0.07 26,69 07/31/16 3.54 -7.25 08/31/16 0.14 -7.90 09/30/16 -0.15 5.93 10/31/16 - 1.96 14.94 11/30/16 6.36 12/31/16 1.78 29,20 01/31/17 1.75 0.65 02/28/17 3.68 21.55 03/31/17 -0.08 -9.21 04/30/17 0.85 25.70 05/31/17 1.09 69.56 06/30/17 0.40 8.42 07/31/17 1.85 15.82 08/31/17 -0.03 63.49 09/30/17 1.85 -7.84 10/31/17 2.13 49.00 11/30/17 0.28 58.12 12/31/17 3.33 38.23 01/31/18 5.51 -27 91 02/28/18 -4.01 1.61 03/31/18 -2.82 2202 40 Bitcoin Return 20 -60 40 1 2 20 40 60 40 SP500% Return 7 Microsoft Excel can't run VBA macros. D M -40 SP500% Return 11/30/17 12/31/17 01/31/18 02/28/18 03/31/18 04/30/18 05/31/18 06/30/18 07/31/18 08/31/18 09/30/18 10/31/18 11/30/18 12/31/18 01/31/19 02/28/19 03/31/19 04/30/19 05/31/19 06/30/19 07/31/19 08/31/19 09/30/19 10/31/19 11/30/19 12/31/19 01/31/20 02/29/20 03/31/20 04/30/20 05/21/20 06/30/20 07/31/20 08/31/20 09/30/20 10/31/20 11/30/20 0.28 3.33 5.51 -4.01 -2.82 0.13 2.01 0.33 3.45 2.86 0.26 -7.12 1.60 -9.37 7.68 2.78 1.59 3.74 -6.78 6.70 1.14 -1.98 1.56 1.90 3.28 2.73 -0.29 -8.54 -12.61 12.68 4.52 1.83 5.50 7.00 -3.93 -2.77 10.75 58 12 38.23 27.91 1.61 -33.07 32-37 -19 05 -14.70 21 34 -9.71 -6.03 4.83 -36.60 -7.03 -7.80 11.29 6.30 30.14 60.05 25.96 6.93 -4.68 -14.04 10.27 -17.84 -5 10 29.86 -8.16 -25.23 34.48 9.26 -3.43 23.91 3.15 -7.65 27.74 42.41 05 06 07 08 09 10 11 12