Ticker | MSFT | SPY |
---|---|---|
Mean (%) | 2.196 | 0.976 |
St. Dev. (%) | 6.239 | 4.405 |
Fall 2024
Example 1 (Variance Decomposition) Suppose that you have the following regression for stock A: R_{A} = \alpha_{A} + \beta_{A} R_{M} + e_{A}, where \alpha_{A} = 0.02, \beta_{A} = 1.2, \sigma(e_{A}) = 30\% and \sigma_{M} = 25\%. The variance of A can be computed as follows: \sigma_{A}^{2} = 1.2^{2} \times 0.25^{2} + 0.30^{2} = 0.09 + 0.09 = 0.18. In the previous expression, the systematic and idiosyncratic variances are the same. The standard deviation of A is then \sigma_{A} = \sqrt{0.18} = 42.43\%.
Example 2 (Decomposing the Variance) You run the regression R_{B} = \alpha_{B} + \beta_{B} R_{M} + e_{B}. Your regression package reports that \alpha_{B} = -0.01, \beta_{B} = 0.8 and the R-squared is 0.4. If the volatility of the market is 25% per year, the systematic variance is 0.8^{2} \times 0.25^{2} = 0.04. Since 40% of the variance is systematic, we have that \sigma_{B}^{2} = \frac{0.04}{0.4} = 0.10, which implies that \sigma_{B} = \sqrt{0.10} = 31.62\% per year. We also know that 60% of the variance is firm-specific, which means that \sigma^{2}(e_{B}) = 0.6 \times 0.10 = 0.06, so that \sigma(e_{B}) = \sqrt{0.06} = 24.49\% per year.
Ticker | MSFT | SPY |
---|---|---|
Mean (%) | 2.196 | 0.976 |
St. Dev. (%) | 6.239 | 4.405 |
OLS Regression Results
==============================================================================
Dep. Variable: MSFT R-squared: 0.488
Model: OLS Adj. R-squared: 0.484
Method: Least Squares F-statistic: 112.5
Date: Mon, 14 Oct 2024 Prob (F-statistic): 7.30e-19
Time: 21:50:46 Log-Likelihood: 203.31
No. Observations: 120 AIC: -402.6
Df Residuals: 118 BIC: -397.1
Df Model: 1
Covariance Type: nonrobust
==============================================================================
coef std err t P>|t| [0.025 0.975]
------------------------------------------------------------------------------
Intercept 0.0123 0.004 2.934 0.004 0.004 0.021
SPY 0.9894 0.093 10.605 0.000 0.805 1.174
==============================================================================
Omnibus: 10.257 Durbin-Watson: 2.269
Prob(Omnibus): 0.006 Jarque-Bera (JB): 14.540
Skew: 0.432 Prob(JB): 0.000696
Kurtosis: 4.470 Cond. No. 22.8
==============================================================================
Notes:
[1] Standard Errors assume that the covariance matrix of the errors is correctly specified.
coef
we can see that the estimate for the intercept is 0.0123 whereas the beta estimate for MSFT is 0.9894.The figure plots the excess monthly returns of the market portfolio labeled as RMRF and proxied by SPY, vs. the excess monthly returns of Citigroup (C), BlackRock (BLK), Nvidia (NVDA), and Tesla (TSLA) labeled RETRF, from June-1993 until June-2024.
Alpha | Beta | R-Squared | ||
---|---|---|---|---|
Estimate | P-value | |||
BLK | -0.0025 | 0.511 | 1.390 | 0.697 |
C | -0.0075 | 0.206 | 1.543 | 0.542 |
NVDA | 0.0380 | 0.000 | 1.807 | 0.348 |
TSLA | 0.0160 | 0.282 | 1.830 | 0.207 |
Correlation | Correlation Squared | |
---|---|---|
BLK | 0.835 | 0.697 |
C | 0.736 | 0.542 |
NVDA | 0.590 | 0.348 |
TSLA | 0.455 | 0.207 |
Example 3 (Computing a Covariance) Suppose that you have run regressions of excess returns of two securities A and B on the excess returns of the market. You find that \beta_{A} = 1.2 and beta_{B} = 0.9. If the variance of the market is 25% per year, then \operatorname{Cov}(R_{A}, R_{B}) = 1.2 \times 0.9 \times 0.25^{2} = 0.0675. If in addition we know that \sigma_{A} = 30\% and \sigma_{B} = 35\%, then we also have \rho_{A, B} = \frac{0.0675}{0.30 \times 0.35} = 0.643.