Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Now, using the Regression tool, estimate the Fama-French three-factor model for the retail portfolio. It requires MKT-RF, SMB, and HML as the independent variables. What

image text in transcribedimage text in transcribed

Now, using the Regression tool, estimate the Fama-French three-factor model for the retail portfolio. It requires MKT-RF, SMB, and HML as the independent variables.

What is the market beta estimated using the three-factor model?

\begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G \\ \hline 1 & & Mkt-RF & SMB & HML & RF & & Rtail \\ \hline 2 & 201807 & 0.0319 & -0.0223 & 0.0047 & 0.0016 & & 0.0356 \\ \hline 3 & 201808 & 0.0344 & 0.0113 & -0.0398 & 0.0016 & & 0.0916 \\ \hline 4 & 201809 & 0.0006 & -0.0228 & -0.0169 & 0.0015 & & 0.0061 \\ \hline 5 & 201810 & -0.0768 & -0.0477 & 0.0344 & 0.0019 & & -0.1025 \\ \hline 6 & 201811 & 0.0169 & -0.0068 & 0.0028 & 0.0018 & & 0.0159 \\ \hline 7 & 201812 & -0.0957 & -0.0237 & -0.0185 & 0.002 & & -0.0919 \\ \hline 8 & 201901 & 0.084 & 0.0289 & -0.0046 & 0.0021 & & 0.0884 \\ \hline 9 & 201902 & 0.034 & 0.0205 & -0.0267 & 0.0018 & & -0.0008 \\ \hline 10 & 201903 & 0.011 & -0.0303 & -0.041 & 0.0019 & & 0.0386 \\ \hline 11 & 201904 & 0.0397 & -0.0174 & 0.0214 & 0.0021 & & 0.0492 \\ \hline 12 & 201905 & -0.0694 & -0.0131 & -0.0235 & 0.0021 & & -0.0702 \\ \hline 13 & 201906 & 0.0693 & 0.0027 & -0.0072 & 0.0018 & & 0.0717 \\ \hline 14 & 201907 & 0.0119 & -0.0193 & 0.0047 & 0.0019 & & 0.0047 \\ \hline 15 & 201908 & -0.0258 & -0.0237 & -0.0477 & 0.0016 & & -0.0015 \\ \hline 16 & 201909 & 0.0143 & -0.0097 & 0.0674 & 0.0018 & & 0.0078 \\ \hline 17 & 201910 & 0.0206 & 0.0029 & -0.0192 & 0.0016 & & 0.0161 \\ \hline 18 & 201911 & 0.0387 & 0.0079 & -0.02 & 0.0012 & & 0.0207 \\ \hline 19 & 201912 & 0.0277 & 0.0073 & 0.0177 & 0.0014 & & 0.0127 \\ \hline 20 & 202001 & -0.0011 & -0.0311 & -0.0623 & 0.0013 & & 0.0113 \\ \hline 21 & 202002 & -0.0813 & 0.0107 & -0.0379 & 0.0012 & & -0.061 \\ \hline 22 & 202003 & -0.1339 & -0.0486 & -0.1395 & 0.0013 & & -0.0437 \\ \hline 23 & 202004 & 0.1365 & 0.0247 & -0.0126 & 0 & & 0.1864 \\ \hline 24 & 202005 & 0.0558 & 0.0247 & -0.0489 & 0.0001 & & 0.0425 \\ \hline 25 & 202006 & 0.0246 & 0.027 & -0.0217 & 0.0001 & & 0.0538 \\ \hline 26 & 202007 & 0.0577 & -0.0232 & -0.0137 & 0.0001 & & 0.1047 \\ \hline 27 & 202008 & 0.0763 & -0.0022 & -0.0296 & 0.0001 & & 0.0814 \\ \hline 28 & 202009 & -0.0363 & 0.0004 & -0.0268 & 0.0001 & & -0.0456 \\ \hline 29 & 202010 & -0.021 & 0.0437 & 0.0422 & 0.0001 & & -0.0292 \\ \hline 30 & 202011 & 0.1247 & 0.0581 & 0.0213 & 0.0001 & & 0.0758 \\ \hline 31 & 202012 & 0.0463 & 0.0489 & -0.015 & 0.0001 & & 0.0108 \\ \hline 32 & 202101 & -0.0003 & 0.0734 & 0.0297 & 0.0001 & & 0.008 \\ \hline 33 & 202102 & 0.0278 & 0.0206 & 0.0717 & 0 & & -0.0317 \\ \hline 34 & 202103 & 0.0308 & -0.0237 & 0.0739 & 0 & & 0.0536 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G \\ \hline 1 & & Mkt-RF & SMB & HML & RF & & Rtail \\ \hline 2 & 201807 & 0.0319 & -0.0223 & 0.0047 & 0.0016 & & 0.0356 \\ \hline 3 & 201808 & 0.0344 & 0.0113 & -0.0398 & 0.0016 & & 0.0916 \\ \hline 4 & 201809 & 0.0006 & -0.0228 & -0.0169 & 0.0015 & & 0.0061 \\ \hline 5 & 201810 & -0.0768 & -0.0477 & 0.0344 & 0.0019 & & -0.1025 \\ \hline 6 & 201811 & 0.0169 & -0.0068 & 0.0028 & 0.0018 & & 0.0159 \\ \hline 7 & 201812 & -0.0957 & -0.0237 & -0.0185 & 0.002 & & -0.0919 \\ \hline 8 & 201901 & 0.084 & 0.0289 & -0.0046 & 0.0021 & & 0.0884 \\ \hline 9 & 201902 & 0.034 & 0.0205 & -0.0267 & 0.0018 & & -0.0008 \\ \hline 10 & 201903 & 0.011 & -0.0303 & -0.041 & 0.0019 & & 0.0386 \\ \hline 11 & 201904 & 0.0397 & -0.0174 & 0.0214 & 0.0021 & & 0.0492 \\ \hline 12 & 201905 & -0.0694 & -0.0131 & -0.0235 & 0.0021 & & -0.0702 \\ \hline 13 & 201906 & 0.0693 & 0.0027 & -0.0072 & 0.0018 & & 0.0717 \\ \hline 14 & 201907 & 0.0119 & -0.0193 & 0.0047 & 0.0019 & & 0.0047 \\ \hline 15 & 201908 & -0.0258 & -0.0237 & -0.0477 & 0.0016 & & -0.0015 \\ \hline 16 & 201909 & 0.0143 & -0.0097 & 0.0674 & 0.0018 & & 0.0078 \\ \hline 17 & 201910 & 0.0206 & 0.0029 & -0.0192 & 0.0016 & & 0.0161 \\ \hline 18 & 201911 & 0.0387 & 0.0079 & -0.02 & 0.0012 & & 0.0207 \\ \hline 19 & 201912 & 0.0277 & 0.0073 & 0.0177 & 0.0014 & & 0.0127 \\ \hline 20 & 202001 & -0.0011 & -0.0311 & -0.0623 & 0.0013 & & 0.0113 \\ \hline 21 & 202002 & -0.0813 & 0.0107 & -0.0379 & 0.0012 & & -0.061 \\ \hline 22 & 202003 & -0.1339 & -0.0486 & -0.1395 & 0.0013 & & -0.0437 \\ \hline 23 & 202004 & 0.1365 & 0.0247 & -0.0126 & 0 & & 0.1864 \\ \hline 24 & 202005 & 0.0558 & 0.0247 & -0.0489 & 0.0001 & & 0.0425 \\ \hline 25 & 202006 & 0.0246 & 0.027 & -0.0217 & 0.0001 & & 0.0538 \\ \hline 26 & 202007 & 0.0577 & -0.0232 & -0.0137 & 0.0001 & & 0.1047 \\ \hline 27 & 202008 & 0.0763 & -0.0022 & -0.0296 & 0.0001 & & 0.0814 \\ \hline 28 & 202009 & -0.0363 & 0.0004 & -0.0268 & 0.0001 & & -0.0456 \\ \hline 29 & 202010 & -0.021 & 0.0437 & 0.0422 & 0.0001 & & -0.0292 \\ \hline 30 & 202011 & 0.1247 & 0.0581 & 0.0213 & 0.0001 & & 0.0758 \\ \hline 31 & 202012 & 0.0463 & 0.0489 & -0.015 & 0.0001 & & 0.0108 \\ \hline 32 & 202101 & -0.0003 & 0.0734 & 0.0297 & 0.0001 & & 0.008 \\ \hline 33 & 202102 & 0.0278 & 0.0206 & 0.0717 & 0 & & -0.0317 \\ \hline 34 & 202103 & 0.0308 & -0.0237 & 0.0739 & 0 & & 0.0536 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Social Finance Shadow Banking During The Global Financial Crisis

Authors: Neil Shenai

1st Edition

3030082318, 978-3030082314

More Books

Students also viewed these Finance questions

Question

Define self-esteem and discuss its impact on your life.

Answered: 1 week ago

Question

Discuss how selfesteem is developed.

Answered: 1 week ago