What percent of the variance of stock ABC in Example 6.4 is systematic (market) risk? EXAMPLE Estimating

What percent of the variance of stock ABC in Example 6.4 is systematic (market) risk?

Transcribed Image Text:

EXAMPLE Estimating the Index Model Using Historical Data 6.4 The direct way to calculate the slope and intercept of the characteristic lines for ABC and XYZ is from the variances and covariances. Here, we use the Data Analysis menu of Excel to obtain the covariance matrix in the following spreadsheet. The slope coefficient for ABC is given by the formula BABC The intercept for ABC is = Cov(RABC, RMarket) Var(RMarket) 773.31 684.01 = 1.156 OLABC = Average(RABC) - BABC X Average (RMarket) = 15.20 - 1.156 × 9.40 = 4.33 Therefore, the security characteristic line of ABC is given by RABC = 4.33 + 1.156 RMarket This result also can be obtained by using the "Regression" command from Excel's Data Analysis menu, as we show at the bottom of the spreadsheet. The minor differences between the direct regression output and our calculations above are due to rounding error.