finance homework
Problem 6.22
| Problem 6.22 | ||||||
| From Yahoo | From French | |||||
| S&P | GM | RF (T-bill) | Excess returns | |||
| Month | Return | Return | Return | Month | GM | S&P |
| Dec-99 | 1.35 | 0.56 | 0.07 | Dec-99 | 0.49 | 1.28 |
| Jan-00 | -1.32 | 0.00 | 0.06 | Jan-00 | -0.06 | -1.38 |
| Feb-00 | -1.89 | -3.19 | 0.09 | Feb-00 | -3.28 | -1.98 |
| Mar-00 | 1.70 | 0.00 | 0.08 | Mar-00 | -0.08 | 1.62 |
| Apr-00 | 1.85 | -0.25 | 0.06 | Apr-00 | -0.31 | 1.79 |
| May-00 | -3.22 | 2.39 | 0.08 | May-00 | 2.31 | -3.30 |
| Jun-00 | 0.25 | 1.69 | 0.1 | Jun-00 | 1.59 | 0.15 |
| Jul-00 | 1.00 | 1.51 | 0.11 | Jul-00 | 1.40 | 0.89 |
| Aug-00 | 1.29 | 0.08 | 0.11 | Aug-00 | -0.03 | 1.18 |
| Sep-00 | 4.46 | -1.17 | 0.11 | Sep-00 | -1.28 | 4.35 |
| Oct-00 | 3.01 | 1.97 | 0.15 | Oct-00 | 1.82 | 2.86 |
| Nov-00 | -2.24 | -3.02 | 0.16 | Nov-00 | -3.18 | -2.40 |
| Dec-00 | 2.09 | -0.24 | 0.16 | Dec-00 | -0.40 | 1.93 |
| Jan-01 | -1.83 | -15.28 | 0.16 | Jan-01 | -15.44 | -1.99 |
| Feb-01 | -1.87 | -7.84 | 0.21 | Feb-01 | -8.05 | -2.08 |
| Mar-01 | 3.22 | 2.25 | 0.21 | Mar-01 | 2.04 | 3.01 |
| Apr-01 | 0.15 | 4.91 | 0.24 | Apr-01 | 4.67 | -0.09 |
| May-01 | 3.82 | 5.44 | 0.23 | May-01 | 5.21 | 3.59 |
| Jun-01 | -0.93 | -8.88 | 0.24 | Jun-01 | -9.12 | -1.17 |
| Jul-01 | 0.80 | -5.37 | 0.3 | Jul-01 | -5.67 | 0.50 |
| Aug-01 | -2.36 | -7.77 | 0.29 | Aug-01 | -8.06 | -2.65 |
| Sep-01 | 4.39 | -7.52 | 0.27 | Sep-01 | -7.79 | 4.12 |
| Oct-01 | -0.19 | -4.31 | 0.31 | Oct-01 | -4.62 | -0.50 |
| Nov-01 | 2.41 | 12.61 | 0.32 | Nov-01 | 12.29 | 2.09 |
| Dec-01 | 0.57 | -3.43 | 0.35 | Dec-01 | -3.78 | 0.22 |
| Jan-02 | 1.65 | 6.04 | 0.34 | Jan-02 | 5.70 | 1.31 |
| Feb-02 | 1.26 | 1.23 | 0.37 | Feb-02 | 0.86 | 0.89 |
| Mar-02 | -3.01 | 6.39 | 0.36 | Mar-02 | 6.03 | -3.37 |
| Apr-02 | 0.26 | 5.18 | 0.43 | Apr-02 | 4.75 | -0.17 |
| May-02 | 0.45 | 4.63 | 0.4 | May-02 | 4.23 | 0.05 |
| Jun-02 | 2.18 | -1.41 | 0.4 | Jun-02 | -1.81 | 1.78 |
| Jul-02 | 2.70 | 6.11 | 0.42 | Jul-02 | 5.69 | 2.28 |
| Aug-02 | 3.16 | 3.60 | 0.41 | Aug-02 | 3.19 | 2.75 |
| Sep-02 | 1.99 | 0.61 | 0.41 | Sep-02 | 0.20 | 1.58 |
| Oct-02 | 0.77 | 0.52 | 0.42 | Oct-02 | 0.10 | 0.35 |
| Nov-02 | 1.51 | 6.70 | 0.4 | Nov-02 | 6.30 | 1.11 |
| Dec-02 | -1.96 | -0.16 | 0.44 | Dec-02 | -0.60 | -2.40 |
| Jan-03 | 1.16 | -0.73 | 0.38 | Jan-03 | -1.11 | 0.78 |
| Feb-03 | 4.42 | -0.08 | 0.43 | Feb-03 | -0.51 | 3.99 |
| Mar-03 | 3.39 | 1.87 | 0.44 | Mar-03 | 1.43 | 2.95 |
| Apr-03 | -1.46 | -0.24 | 0.41 | Apr-03 | -0.65 | -1.87 |
| May-03 | -3.13 | -6.32 | 0.4 | May-03 | -6.72 | -3.53 |
| Jun-03 | 1.28 | -4.78 | 0.4 | Jun-03 | -5.18 | 0.88 |
| Jul-03 | 3.88 | 8.79 | 0.42 | Jul-03 | 8.37 | 3.46 |
| Aug-03 | 1.35 | -0.25 | 0.32 | Aug-03 | -0.57 | 1.03 |
| Sep-03 | -3.87 | -6.86 | 0.32 | Sep-03 | -7.18 | -4.19 |
| Oct-03 | -1.13 | -5.59 | 0.34 | Oct-03 | -5.93 | -1.47 |
| Nov-03 | -6.04 | 11.18 | 0.27 | Nov-03 | 10.91 | -6.31 |
| Dec-03 | -2.58 | -3.13 | 0.21 | Dec-03 | -3.34 | -2.79 |
| Jan-04 | -0.90 | -9.60 | 0.13 | Jan-04 | -9.73 | -1.03 |
| Feb-04 | 4.77 | 8.78 | 0.17 | Feb-04 | 8.61 | 4.60 |
| Mar-04 | 1.51 | -6.48 | 0.17 | Mar-04 | -6.65 | 1.34 |
| Apr-04 | -8.35 | -15.56 | 0.17 | Apr-04 | -15.73 | -8.52 |
| May-04 | -0.90 | -11.01 | 0.17 | May-04 | -11.18 | -1.07 |
| Jun-04 | 1.55 | -4.92 | 0.15 | Jun-04 | -5.07 | 1.40 |
| Jul-04 | -9.42 | -29.61 | 0.12 | Jul-04 | -29.73 | -9.54 |
| Aug-04 | -16.52 | -13.77 | 0.15 | Aug-04 | -13.92 | -16.67 |
| Sep-04 | -6.96 | -26.04 | 0.08 | Sep-04 | -26.12 | -7.04 |
| Oct-04 | 0.99 | -25.44 | 0.02 | Oct-04 | -25.46 | 0.97 |
| Nov-04 | -8.22 | 23.02 | 0.09 | Nov-04 | 22.93 | -8.31 |
Comparison
The Fama-French market factor (Mkt) is better diversified than the SP 500, containing about 10 times as many stocks. However, the additional stocks in Mkt are relatively small, and hence the performance of the value weighted portfolios is expected to be quite similar, and the correlation of the excess returns very high. Notice also that a sample of 81 annual returns with as large a SD as we have here is still quite small.l
comparing the continuously compounded excess returns we see that the difference between the two portfolios is indeed quite small, and the correlation coefficient between their returns is 0.99, almost perfect. The SD of the two portfolios is indistinguishable. Both deviate from the normal distribution as seen from the negative skew and positive kurtosis (that is, they have fat tails -- although not large.) Accordingly, the VaR (5% percentile) of the two is smaller than what is expected from a normal with same mean and SD. This is also indicated by the lower minimum excess return for the period. The serial correlation is also small and indistinguishable across the portfolios.
As a result of all this, we expect the risk premium of the two portfolios to be similar, as we find from the sample. Notice that the SD of the 81-year average for the SP500 is somewhat higher (because of the small positive serial correlation) than 20.46/sqrt(81) = 2.27, and almost identical for the Mkt. This SD is far larger than the difference in the average of the two portfolios (0.02%).
Notice also that the excess return of both portfolios have a small negative correlation with the risk-free rate. Since we expect the risk-free rate to be highly correlated with the rate of inflation, this suggests that equities are not a perfect hedge against inflation. More rigorous analysis of this point is important, but beyond the scope of this question.
Analysis
The bond portfolio is less risky, its SD is less than half that of the stock portfolio. Yet, as the portfolio table shows, mixing 0.87% of bonds with 13% (riskier) stocks would have produced a portfolio less risky than bonds.
In the particular sample of these 20 years, the average return on the less risky portfolio (bonds) was higher than that of the riskier portfolio (stocks). This is exactly what is meant by 'risk,' expectation are not going to always be realized.
Analysis
(1) Five-year betas.
The beta of Ford has been quite aggressive, representing the sensitivity of sales to economic conditions.
The beta of GM is much lower than that of Ford, representing the large part of the finance arm of the company.
The Beta of Toyota is defensive for U.S, investors, reflecting the large part of Toyota's business abroad.
(2) Five-year alpha estimates.
The large negative alpha values of Ford and GM reflect the greater than expected deterioration of these companies. Toyota's positive alpha is due to the pre-crisis years, when its performance was stellar, better than expected.
(3) Beta over two-year (first and last) subperiods.
As a first pass we note that large standard deviation of the beta estimates. Non of the subperiod estimates deviates from the overall period estimate by more than two standard deviation. That is, the t-statistic of deviation from the overall period is not significant for any of the companies subperiod beta estimates.
Looking beyond the aforementioned observation, the differences can be attributed to different alpha values during the subperiods. The case of Toyota is most revealing: The alpha estimate for the first two years is positive and for the last two years negative (both large). Following a good performance in the "normal" years prior to the crisis, Toyota surprised investors with a negative perofrmance, beyond what could be expected from the index. This suggests that a beta of around 0.5 is more reliable. The shift of the intercepts from positive to negative when the index moved to largely negative returns, explains why the line is steeper when estimated for the overall period. Draw a line in the positive qudrant for the index with a slope of 0.5 and positive intercept. Then draw a line with similar slope in the negative quadrant of the index with a negative intercept. You can see that a line that reconciles the observations for both quadrants will be steeper.
The same logic explains part of the behavior of subperiod betas for Ford and GM.
Problem 6.22
| 1 | 1 |
Index level
26-week MA
Week of Year
Index and index MA
SP 500 index and 26-week moving average
1
1
| 1 | 1 |
FSRBX/SPY
26-week MA
Year.week
FSRBX/SP 500, MA
Relative strength FSRBX vs. SP 500
1
1
Analysis
It appears that FSRBX (fund investing in large financial firms) is consistently falling relative to the SP 500, with some semblence of recovery toward the end of 2008. However, this recovery doesn't yet show a clear trend.