Access the data in the spreadsheet data and determine the beta for both assets by running regressions against the market returns. Comment on your results.

(Note: be sure to calculate returns before running the regressions. You can use the change in prices only for this. No consideration of income is required.)

- For asset 2 in the data for question 9, calculate arithmetic mean, geometric mean and dollar-weighted mean (IRR) for the returns and comment on your answers.

(For the IRR, assume that an investor buys 100 shares of stock at the market price every month, starting with the first data point, and then sells all of the accumulated shares at the market price of the final month for which you have data)

(I can email you the data.)

Date Market level Date Asset 1 prices 2/1/21 3934.830078 2/1/21 91.519997 1/1/21 3714.23999 1/1/21 85.779999 12/1/20 3756.070068 12/1/20 84.999184 11/1/20 3621.629883 11/1/20 81.210281 1 10/1/20 3269.959961 10/1/20 73.115479 9/1/20 3363 9/1/20 75.089333 8/1/20 3500.310059 8/1/20 79.60611 7/1/20 3271.120117 7/1/20 71.32077 6/1/20 3100.290039 6/1/20 67.173691 5/1/20 3044.310059 5/1/20 62.724495 4/1/20 2912.429932 4/1/20 58.33007 3/1/202584.590088 3/1/20 50.701946 2/1/20 2954.219971 2/1/20 56.119675 1/1/20 3225.52002 1/1/20 60.083748 12/1/19 3230.780029 12/1/19 57.606682 11/1/19 3140.97998 11/1/19 55.397514 10/1/19 3037.560059 10/1/19 52.507275 9/1/19 2976.73999 9/1/19 50.46727 8/1/19 2926.459961 8/1/19 49.651722 7/1/192980.379883 7/1/19 51.141945 6/1/19 2941.76001 6/1/19 48.78952 5/1/19 2752.060059 5/1/19 45.32798 4/1/19 2945.830078 4/1/19 50.123352 3/1/19 2834.399902 3/1/19 46.892338 2/1/19 2784.48999 2/1/19 45.152943 1/1/19 2704.100098 1/1/19 42.830463 12/1/18 2506.850098 12/1/18 39.266064 11/1/18 2760.169922 11/1/18 42.718086 10/1/18 2711.73999 10/1/18 43.597042 Date Asset 2 prices 2/1/21 108.8926471 1/1/21 107.996002 12/1/20 107.665352 11/1/20 105.818428 10/1/20 102.191956 9/1/20 101.749084 8/1/20 102.741035 7/1/20 102.573624 6/1/20 97.338509 5/1/20 97.6248091 4/1/20 94.334244 3/1/20 89.830879 2/1/20 100.9918591 1/1/20 102.9461821 12/1/19 102.506668 11/1/19 100.9329451 10/1/19 100.34182 9/1/19 100.401451 8/1/19 100.0053561 7/1/19 99.346016 6/1/19 99.18924 5/1/19 96.193306 4/1/19 98.140549 3/1/19 96.857002! 2/1/19 95.6544571 1/1/19 94.743217 12/1/18 89.145477 11/1/18 91.7279211 10/1/18 92.412865 9/1/18 2913.97998 8/1/18 2901.52002 7/1/18 2816.29004 6/1/18 2718.37012 5/1/18 2705.27002 4/1/18 2648.05005 3/1/18 2640.87012 2/1/18 2713.83008 1/1/18 2823.81006 12/1/17 2673.61011 11/1/17 2647.58008 10/1/17 2575.26001 9/1/17 2519.36011 8/1/17 2471.6499 7/1/17] 2470.30005 6/1/17 2423.40991 5/1/17 2411.80005 4/1/17 2384.19995 3/1/17 2362.71997 2/1/17| 2363.63989 1/1/17 2278.87012 12/1/16 2238.83008 11/1/16 2198.81006 10/1/16 2126.1499 9/1/16 2168.27002 8/1/16 2170.94995 7/1/16 2173.6001 6/1/16 2098.86011 5/1/16 2096.94995 4/1/16 2065.30005 3/1/16_2059.73999 9/1/18 8/1/18 7/1/18 6/1/18 5/1/18 4/1/18 3/1/18 2/1/18 1/1/18 12/1/17 11/1/17 10/1/17 9/1/17 8/1/17 7/1/17 6/1/17 5/1/17 4/1/17 3/1/17 2/1/17 1/1/17 12/1/16 11/1/16 10/1/16 9/1/16 8/1/16 7/1/16 6/1/16 5/1/16 4/1/16 3/1/16 47.543865 47.989845 44.718479 43.591118 44.1633 41.08231 41.04509 42.74828 42.575031 39.643089 39.699108 39.355698 36.42841 36.39682 35.18676 33.872177 34.958256 33.506107 32.682907 31.952705 30.446344 28.998055 28.682154 28.597748 28.617411 28.033039 27.44626 25.243422 25.917189 24.524097 25.919081 9/1/18 8/1/18 7/1/18 6/1/18 5/1/18 4/1/18 3/1/18 2/1/18 1/1/18 12/1/17 11/1/17 10/1/17 9/1/17 8/1/17 7/1/17 6/1/17 5/1/17 4/1/17 3/1/17 2/1/17 1/1/17 12/1/16 11/1/16 10/1/16 9/1/16 8/1/16 7/1/16 6/1/16 5/1/16 4/1/16 3/1/16 94.304626 93.751976 93.157822 91.5342791 91.477882 91.7344971 91.270638 91.7852631 93.02729 92.248642 92.377693 92.736168 92.526291 91.974953 91.9035871 90.896271 90.9423521 89.913536 88.982391 89.25592 88.51255 86.5481721 85.324692 85.2215191 85.86335 84.9969941 83.440941 82.146431 80.25647 79.98394 77.1660541 | Date Market level Date Asset 1 prices 2/1/21 3934.830078 2/1/21 91.519997 1/1/21 3714.23999 1/1/21 85.779999 12/1/20 3756.070068 12/1/20 84.999184 11/1/20 3621.629883 11/1/20 81.210281 1 10/1/20 3269.959961 10/1/20 73.115479 9/1/20 3363 9/1/20 75.089333 8/1/20 3500.310059 8/1/20 79.60611 7/1/20 3271.120117 7/1/20 71.32077 6/1/20 3100.290039 6/1/20 67.173691 5/1/20 3044.310059 5/1/20 62.724495 4/1/20 2912.429932 4/1/20 58.33007 3/1/202584.590088 3/1/20 50.701946 2/1/20 2954.219971 2/1/20 56.119675 1/1/20 3225.52002 1/1/20 60.083748 12/1/19 3230.780029 12/1/19 57.606682 11/1/19 3140.97998 11/1/19 55.397514 10/1/19 3037.560059 10/1/19 52.507275 9/1/19 2976.73999 9/1/19 50.46727 8/1/19 2926.459961 8/1/19 49.651722 7/1/192980.379883 7/1/19 51.141945 6/1/19 2941.76001 6/1/19 48.78952 5/1/19 2752.060059 5/1/19 45.32798 4/1/19 2945.830078 4/1/19 50.123352 3/1/19 2834.399902 3/1/19 46.892338 2/1/19 2784.48999 2/1/19 45.152943 1/1/19 2704.100098 1/1/19 42.830463 12/1/18 2506.850098 12/1/18 39.266064 11/1/18 2760.169922 11/1/18 42.718086 10/1/18 2711.73999 10/1/18 43.597042 Date Asset 2 prices 2/1/21 108.8926471 1/1/21 107.996002 12/1/20 107.665352 11/1/20 105.818428 10/1/20 102.191956 9/1/20 101.749084 8/1/20 102.741035 7/1/20 102.573624 6/1/20 97.338509 5/1/20 97.6248091 4/1/20 94.334244 3/1/20 89.830879 2/1/20 100.9918591 1/1/20 102.9461821 12/1/19 102.506668 11/1/19 100.9329451 10/1/19 100.34182 9/1/19 100.401451 8/1/19 100.0053561 7/1/19 99.346016 6/1/19 99.18924 5/1/19 96.193306 4/1/19 98.140549 3/1/19 96.857002! 2/1/19 95.6544571 1/1/19 94.743217 12/1/18 89.145477 11/1/18 91.7279211 10/1/18 92.412865 9/1/18 2913.97998 8/1/18 2901.52002 7/1/18 2816.29004 6/1/18 2718.37012 5/1/18 2705.27002 4/1/18 2648.05005 3/1/18 2640.87012 2/1/18 2713.83008 1/1/18 2823.81006 12/1/17 2673.61011 11/1/17 2647.58008 10/1/17 2575.26001 9/1/17 2519.36011 8/1/17 2471.6499 7/1/17] 2470.30005 6/1/17 2423.40991 5/1/17 2411.80005 4/1/17 2384.19995 3/1/17 2362.71997 2/1/17| 2363.63989 1/1/17 2278.87012 12/1/16 2238.83008 11/1/16 2198.81006 10/1/16 2126.1499 9/1/16 2168.27002 8/1/16 2170.94995 7/1/16 2173.6001 6/1/16 2098.86011 5/1/16 2096.94995 4/1/16 2065.30005 3/1/16_2059.73999 9/1/18 8/1/18 7/1/18 6/1/18 5/1/18 4/1/18 3/1/18 2/1/18 1/1/18 12/1/17 11/1/17 10/1/17 9/1/17 8/1/17 7/1/17 6/1/17 5/1/17 4/1/17 3/1/17 2/1/17 1/1/17 12/1/16 11/1/16 10/1/16 9/1/16 8/1/16 7/1/16 6/1/16 5/1/16 4/1/16 3/1/16 47.543865 47.989845 44.718479 43.591118 44.1633 41.08231 41.04509 42.74828 42.575031 39.643089 39.699108 39.355698 36.42841 36.39682 35.18676 33.872177 34.958256 33.506107 32.682907 31.952705 30.446344 28.998055 28.682154 28.597748 28.617411 28.033039 27.44626 25.243422 25.917189 24.524097 25.919081 9/1/18 8/1/18 7/1/18 6/1/18 5/1/18 4/1/18 3/1/18 2/1/18 1/1/18 12/1/17 11/1/17 10/1/17 9/1/17 8/1/17 7/1/17 6/1/17 5/1/17 4/1/17 3/1/17 2/1/17 1/1/17 12/1/16 11/1/16 10/1/16 9/1/16 8/1/16 7/1/16 6/1/16 5/1/16 4/1/16 3/1/16 94.304626 93.751976 93.157822 91.5342791 91.477882 91.7344971 91.270638 91.7852631 93.02729 92.248642 92.377693 92.736168 92.526291 91.974953 91.9035871 90.896271 90.9423521 89.913536 88.982391 89.25592 88.51255 86.5481721 85.324692 85.2215191 85.86335 84.9969941 83.440941 82.146431 80.25647 79.98394 77.1660541 |