I have two portfolios, one "bad" and the other "good".
I construct the portfolios by taking the average monthly returns based on some criteria each year. In any given portfolio there could be between 150 and 500 companies (depending on the year). I update the portfolio yearly based on the criteria and I run the results through a Fama French model over 158 months.
My observations are that the bad portfolio intercept is not significant and thus has no alpha (which is what I was expecting/hoping for).
The bad portfolio
Call:
lm(formula = R_excess ~ Mkt_Rf + SMB + HML, data = .)
Residuals:
Min 1Q Median 3Q Max
-3.0599 -0.9060 -0.1252 0.7183 6.1812
Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) 0.12280 0.11987 1.024 0.307232
Mkt_Rf 1.01738 0.03114 32.675 < 0.0000000000000002 ***
SMB 0.81318 0.06017 13.514 < 0.0000000000000002 ***
HML 0.20162 0.05227 3.857 0.000168 ***
---
Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1
Residual standard error: 1.485 on 154 degrees of freedom
Multiple R-squared: 0.9302, Adjusted R-squared: 0.9288
F-statistic: 684 on 3 and 154 DF, p-value: < 0.00000000000000022
The second portfolio has a significant intercept and alpha of 0.33 basis points per month. The R2 on both regressions seem reasonable since I have so many companies in the portfolio. Portfolio 2 is slightly less correlated with the market with a Mkt_Rf of 0.95824
Given the outputs what else should I be looking at? Can you see any red flags based on the information I have said?
They seem a little "too good to be true" but I have been careful at each step.
The good portfolio
Call:
lm(formula = R_excess ~ Mkt_Rf + SMB + HML, data = .)
Residuals:
Min 1Q Median 3Q Max
-4.6116 -0.7663 0.0756 0.7980 7.4092
Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) 0.33116 0.10487 3.158 0.00191 **
Mkt_Rf 0.95824 0.02724 35.175 < 0.0000000000000002 ***
SMB 0.66303 0.05265 12.594 < 0.0000000000000002 ***
HML 0.31563 0.04574 6.901 0.000000000126 ***
---
Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1
Residual standard error: 1.299 on 154 degrees of freedom
Multiple R-squared: 0.9374, Adjusted R-squared: 0.9362
F-statistic: 769 on 3 and 154 DF, p-value: < 0.00000000000000022