Please line up the data for using in a linear regression. There is a DATE variable to line up the rows. 1. Use the data to perform linear regression and to estimate three Fama-French beta coefficients for Berkshire: Beta coefficients are: 2. Use the beta coefficients you estimated earlier, and the data in the DATA worksheet, to use Fama French model to calculate expected monthly returns on Berkshire. 3. Calculate expected annual return on Berkshire. 4. Calculate Berkshire's alpha (annual).

A B D E F G H 1 J K RF(Risk-Free Rate) 0 0 0 0 0 0 -0.0398 0 0 1 FAMA-FRENCH FACTORS 2 DATE_YYYYMM Mkt-RF SMB HML 3 202110 0.0665 -0.0228 -0.0045 4 202109 -0.0437 0.008 0.0509 5 202108 0.029 -0.0048 -0.0013 6 202107 0.0127 -0.0396 -0.0175 7 202106 0.0275 0.018 -0.0776 8 202105 0.0029 -0.0028 0.0704 9 202104 0.0493 -0.0311 -0.0093 10 202103 0.0308 -0.0241 0.0741 11 202102 0.0278 0.0203 0.0718 12 202101 -0.0003 0.0712 0.0299 13 202012 0.0463 0.0482 -0.0143 14 202011 0.1247 0.0565 0.0213 15 202010 -0.021 0.0441 0.0416 16 202009 -0.0363 0.0002 -0.0262 17 202008 0.0763 -0.0026 -0.0292 18 202007 0.0577 -0.0228 -0.0153 19 202006 0.0246 0.0269 -0.0204 20 202005 0.0558 0.0245 -0.048 21 202004 0.1365 0.0247 -0.0118 22 202003 -0.1338 -0.0489 -0.1402 23 202002 -0.0813 0.0103 -0.0379 24 202001 -0.0011 -0.0313 -0.0624 25 201912 0.0277 0.0072 0.0179 26 201911 0.0387 0.008 -0.0202 27 201910 0.0206 0.0028 -0.0193 28 201909 0.0143 -0.0097 0.0683 29 201908 -0.0258 -0.0232 -0.0495 30 201907 0.0119 -0.0194 0.0042 31 0.0025 -0.0071 32 201905 -0.0694 -0.0134 -0.0237 33 201904 0.0396 -0.0174 0.0217 34 201903 0.011 -0.0298 -0.0405 35 201902 0.034 0.0204 -0.0268 0 0 0.0001 0.0001 0.0001 0.0001 0.0001 0.0001 0.0001 0.0001 0 0.0012 0.0012 0.0013 0.0014 0.0012 0.0015 0.0018 0.0016 0.0019 0.0018 0.0021 0.0021 0.0019 0.0018 DATE_YYYYMM BRKB-RF 202110 -0.03596 202109 0.05155 202108 -0.0449 202107 0.026878 202106 0.001331 202105 202104 0.0527 202103 0.076252 202102 0.062201 202101 0.05547 202012 -0.01735 202011 0.012831 202010 0.133679 202009 -0.05195 202008 -0.02349 202007 0.113599 202006 0.096645 202005 -0.0382 202004 -0.0095 202003 0.023577 202002 -0.11514 202001 -0.0819 201912 -0.01054 201911 0.026943 201910 0.034816 201909 0.020121 201908 0.021064 201907 -0.01173 201906 -0.03811 201905 0.077679 201904 -0.09111 201903 0.07685 201902 -0.00384 201906 0.0693