Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Calculating Beta Coefficients: A Guide to Estimating Stock Volatility, Schemes and Mind Maps of Statistics

Learn how to calculate beta coefficients using historical data and simple linear regression methods. Understand the significance of beta coefficients in determining stock volatility and riskiness. Follow step-by-step instructions for calculating beta using a financial calculator and a spreadsheet.

Typology: Schemes and Mind Maps

2021/2022

Uploaded on 09/27/2022

seymour
seymour 🇬🇧

4.8

(16)

216 documents

1 / 7

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Calculating Beta Coefficients
The CAPM is an ex ante model, which means that all of the variables represent
before-the-fact, expected values. In particular, the beta coefcient used in the SML
equation should reect the expected volatility of a given stocks return versus the
return on the market during some future period. However, people generally cal-
culate betas using data from some past period and then assume that the stocks
relative volatility will be the same in the future as it was in the past.
To illustrate how betas are calculated, consider Figure 8A.1. The data at the
bottom of the gure show the historical realized returns for Stock J and for the
market over the last ve years. The data points have been plotted on the scatter
diagram, and a regression line has been drawn. If all the data points had fallen on
a straight line, as they did in Figure 8.7 in Chapter 8, it would be easy to draw an
accurate line. If they do not, as in Figure 8A.1, then you must t the line either by
eyeas an approximation or with a calculator.
Recall what the term regression line,orregression equation, means: The equation
Y = a + bX + e is the standard form of a simple linear regression. It states that the
dependent variable, Y, is equal to a constant, a, plus b times X, where b is the slope
coefcient and X is the independent variable, plus an error term, e. Thus, the rate
of return on the stock during a given time period (Y) depends on what happens to
the general stock market, which is measured by X = rM.
Once the data have been plotted and the regression line has been drawn on
graph paper, we can estimate its intercept and slope, the a and b values in Y = a +
bX. The intercept, a, is simply the point where the line cuts the vertical axis. The
slope coefcient, b, can be estimated by the rise-over-runmethod. This involves
calculating the amount by which rJincreases for a given increase in rM. For
example, we observe in Figure 8A.1 that rJincreases from 8.9 to +7.1% (the rise)
when rMincreases from 0 to 10.0% (the run). Thus, b, the beta coefcient, can be
measured as shown below.
b¼Beta ¼Rise
Run ¼ΔY
ΔX¼7:1ð8:9Þ
10:00:0¼16:0
10:0¼1:6
Note that rise over run is a ratio, and it would be the same if measured using any
two arbitrarily selected points on the line.
The regression line equation enables us to predict a rate of return for Stock J,
given a value of rM. For example, if rM= 15%, we would predict rJ=8.9% + 1.6
(15%) = 15.1%. However, the actual return would probably differ from the pre-
dicted return. This deviation is the error term, e
J
, for the year, and it varies ran-
domly from year to year depending on company-specic factors. Note, though,
that the higher the correlation coefcient, the closer the points lie to the regression
line, and the smaller the errors.
In actual practice, monthly, rather than annual, returns are generally used for
rJand rM, and ve years of data are often employed; thus, there would be 5 × 12 =
60 data points on the scatter diagram. Also, in practice one would use the least
squares method for nding the regression coefcients a and b. This procedure
minimizes the squared values of the error terms, and it is discussed in statistics
courses.
The least squares value of beta can be obtained quite easily with a nancial
calculator. The procedures that follow explain how to nd the values of beta and
the slope using either a Texas Instruments or Hewlett-Packard nancial calculator;
or a spreadsheet program, such as Microsoft Excel.
WEB APPENDIX 8A WEB APPENDIX 8A WEB APPENDIX 8A WEB APPENDIX 8A WEB APPENDIX 8A WEB APPENDIX 8A WEB APPENDIX 8A
WEB APPENDIX 8A
8A-1
pf3
pf4
pf5

Partial preview of the text

Download Calculating Beta Coefficients: A Guide to Estimating Stock Volatility and more Schemes and Mind Maps Statistics in PDF only on Docsity!

Calculating Beta Coefficients

The CAPM is an ex ante model, which means that all of the variables represent before-the-fact, expected values. In particular, the beta coefficient used in the SML equation should reflect the expected volatility of a given stock’s return versus the return on the market during some future period. However, people generally cal- culate betas using data from some past period and then assume that the stock’s relative volatility will be the same in the future as it was in the past. To illustrate how betas are calculated, consider Figure 8A.1. The data at the bottom of the figure show the historical realized returns for Stock J and for the market over the last five years. The data points have been plotted on the scatter diagram, and a regression line has been drawn. If all the data points had fallen on a straight line, as they did in Figure 8.7 in Chapter 8, it would be easy to draw an accurate line. If they do not, as in Figure 8A.1, then you must fit the line either “by eye” as an approximation or with a calculator. Recall what the term regression line, or regression equation, means: The equation Y = a + bX + e is the standard form of a simple linear regression. It states that the dependent variable, Y, is equal to a constant, a, plus b times X, where b is the slope coefficient and X is the independent variable, plus an error term, e. Thus, the rate of return on the stock during a given time period (Y) depends on what happens to the general stock market, which is measured by X = r (^) M. Once the data have been plotted and the regression line has been drawn on graph paper, we can estimate its intercept and slope, the a and b values in Y = a + bX. The intercept, a, is simply the point where the line cuts the vertical axis. The slope coefficient, b, can be estimated by the “rise-over-run” method. This involves calculating the amount by which r (^) J increases for a given increase in r (^) M. For example, we observe in Figure 8A.1 that r (^) J increases from – 8.9 to +7.1% (the rise) when r (^) M increases from 0 to 10.0% (the run). Thus, b, the beta coefficient, can be measured as shown below. b ¼ Beta ¼ Rise Run ¼ ΔY ΔX ¼ 7 : 1 −ð− 8 : 9 Þ 10 : 0 − 0 : 0 ¼ 16 : 0 10 : 0 ¼ 1 : 6 Note that rise over run is a ratio, and it would be the same if measured using any two arbitrarily selected points on the line. The regression line equation enables us to predict a rate of return for Stock J, given a value of r (^) M. For example, if r (^) M = 15%, we would predict r (^) J = – 8.9% + 1. (15%) = 15.1%. However, the actual return would probably differ from the pre- dicted return. This deviation is the error term, e (^) J, for the year, and it varies ran- domly from year to year depending on company-specific factors. Note, though, that the higher the correlation coefficient, the closer the points lie to the regression line, and the smaller the errors. In actual practice, monthly, rather than annual, returns are generally used for r (^) J and r (^) M, and five years of data are often employed; thus, there would be 5 × 12 = 60 data points on the scatter diagram. Also, in practice one would use the least squares method for finding the regression coefficients a and b. This procedure minimizes the squared values of the error terms, and it is discussed in statistics courses. The least squares value of beta can be obtained quite easily with a financial calculator. The procedures that follow explain how to find the values of beta and the slope using either a Texas Instruments or Hewlett-Packard financial calculator; or a spreadsheet program, such as Microsoft Excel.

WEB APPENDIX 8A WEB APPENDIX 8A WEB APPENDIX 8A WEB APPENDIX 8A WEB APPENDIX 8A WEB APPENDIX 8A WEB APPENDIX 8A

WEB APPENDIX 8A

8A-

TEXAS INSTRUMENTS BA-II PLUS

  1. Press (^) 2nd RESET ENTER to set the statistics calculation method to standard linear regression and X, Y, and all other values to zero.
  2. Press 2nd DATA to select the data entry portion of the calculator’s statistical function. Once you do this X01 appears on your screen with 0 as a value.
  3. Key in 23.8 (the first X data point) and press ENTER to enter the first X variable.
  4. Press  , key in 38.6, and press ENTER to enter the first Y variable.
  5. The remaining X and Y variables may be entered by repeating Step 4.
  6. Once all the data have been entered, press 2nd STAT to select the statistical function desired, and LIN (stands for standard linear regression) should appear on the calculator screen. Then press  to obtain statistics on the data. After pressing (^)  8 times, the y-intercept (a) will be shown, 8.92, press (^)  again and the slope coefficient (b) will be shown, 1.60, and if you press (^)  one more time the correlation coefficient, 0.91, will be shown.

F I G U R E 8 A. 1 Calculating Beta Coefficients

rJ

_ Δ

Historic Realized Returns on Stock J, rJ (%)

Historic Realized Returns on the Market, rM (%)

10 20 30 a (^) J = Intercept = – 8.9% (^) r = 8.9% + 7.1% = 16%

= 10% (^) b = RiseRun = =^16 10 J = 1.

J

–10 0

10

20

30

40

Year 3

Year 4

Year 1 Year 5

= aJ + b (^) J rM + e (^) J = –8.9 + 1.6rM + eJ

r (^) J (^) _

_ _

Year 2

_

_

_

Δ

rM

_ Δ

r (^) M

_ Δ

Year (^) Market (r (^) M) Stock ( rJ) 1 23.8% 38.6% 2 (7.2) (24.7) 3 6.6 12. 4 20.5 8. 5 30.6 40. Average r¯ 14.9% 14.9% σr¯ 15.1% 26.5%

8A-2 Web Appendix 8A Calculating Beta Coefficients

figure. Similarly, the “Input X Range” prompt requires cells B2:B6, as the independent variable.

For the purposes of this example, none of the additional options are chosen, and the regression output relies upon the default selection of being displayed on an additional worksheet.

  1. Click OK to perform the indicated regression.
  2. The following is a section of the output generated from the regression of Stock J’s return on the market return:

1 2 3 4 5 6 7 8 9

10 11 12 13 14 15 16 17 18

A B C D E F G H I

Multiple R R Square Adjusted R Square Standard Error Observations

Regression Residual Total

1 3 4

-0.

15.103 0.

Intercept X Variable 1

SUMMARY OUTPUT

Regression Statistics

df

Coefficients

Standard Error -1.

t Stat

P-value -0.

Lower 95%

Upper 95% –0.

Lower 95.0%

Upper 95.0%

SS MS F Significance F

ANOVA

5

In this simple regression, the multiple R statistic is equivalent to the corre- lation coefficient obtained in the other regression procedures described. Hence, the correlation coefficient, r, is 0.91339175.

  1. In the last section of the output, the intercept of the regression line is -0.0892194, and the beta coefficient is 1.60309159. These results agree with those obtained previously with financial calculators, except that the intercept is -0.089219 instead of -8.9219. The reason for this difference is that the returns were entered as whole numbers in the calculator, but were expressed

8A-4 Web Appendix 8A Calculating Beta Coefficients

as percentages in the spreadsheet. It is simply a matter of scale and does not have a real effect on results.

  1. The remainder of the output concerns the reliability of the estimates made and is more fully explained in statistics courses. (Note that the lower and upper 95% confidence columns appear twice on the worksheet, since a different confidence level was not chosen. Had a 90% confidence level been chosen, Columns F and G would have shown the 95% confidence levels and the last two columns would have shown the 90% confidence levels. The 95% confidence level columns are the default and appear first.)

Putting it all together, you should have the following regression line:

r (^) J ¼ − 8 : 92 þ 1 :60r (^) M ρ ¼ 0 : 91

As illustrated, spreadsheet programs yield the same results as a calculator; however, the spreadsheet is more flexible and allows for a more thorough analysis. First, the file can be retained, and when new data become available, they can be added and a new beta can be calculated quite rapidly. Second, the regression output can include graphs and statistical information designed to give us an idea of how stable the beta coefficient is. In other words, while our beta was calculated to be 1.60, the “true beta” might actually be higher or lower, and the regression output can give us an idea of how large the error might be. Third, the spreadsheet can be used to calculate returns data from historical stock price and dividend information, and then the returns can be fed into the regression routine to calculate the beta coefficient. This is important, because stock market data are generally provided in the form of stock prices and dividends, making it necessary to calculate returns. This can be a big job if a number of different companies and a number of time periods are involved.

PROBLEMS

8A-1 BETA COEFFICIENTS AND RATES OF RETURN You are given the following set of data:

Historical Rates of Return ( r) Year Stock Y ( r (^) Y ) NYSE ( r (^) M ) 1 3.0%^ 4.0% 2 18.2^ 14. 3 9.1^ 19. 4 (6.0)^ (14.7) 5 (15.3)^ (26.5) 6 33.1^ 37. 7 6.1^ 23. 8 3.2^ (7.2) 9 14.8^ 6. 10 24.1^ 20. 11 18.0^ 30. Mean 9.8%^ 9.8% σr 13.8^ 19. a. Construct a scatter diagram graph (on graph paper) showing the relationship between returns on Stock Y and the market as in Figure 8A.1; then draw a freehand approximation of the regression line. What is the approximate value of the beta coefficient? (If you have a calculator with statistical functions, use it to calculate beta.)

Web Appendix 8A Calculating Beta Coefficients 8A-

a. Determine graphically the beta coefficients for Stocks A and B.

b. Graph the Security Market Line, and give its equation.

c. Calculate the required rates of return on Stocks A and B.

d. Suppose a new stock, C, with ^rC = 18% and b (^) C = 2.0, becomes available. Is this stock in equilibrium; that is, does the required rate of return on Stock C equal its expected return? Explain. If the stock is not in equilibrium, explain how equilibrium will be restored.

Web Appendix 8A Calculating Beta Coefficients 8A-