Risk and Return Calculation

4/15/2004 PROBABILITY DISTRIBUTION The probability distribution is a listing of all possible outcomes and the corresponding probability. Demand for the Probability of this company's products demand occurring Sale.com Basic Foods Strong 0.30 100% 40% Normal 0.40 15% 15% Weak 0.30 -70% -10% 1.00 EXPECTED RATE OF RETURN The expected rate of return is the rate of return that is expected to be realized from an investment. It is determined as the weighted average of the probability distribution of returns. Demand for the Probability of this company's products demand occurring Rate of Return Product Rate of Return Product Strong 0.3 100% 30% 40% 12% Normal 0.4 15% 6% 15% 6% Weak 0.3 -70% -21% -10% -3% 1.0 EXPECTED RATE OF RETURN, r hat = 15% 15% MEASURING STAND-ALONE RISK: THE STANDARD DEVIATION Demand for the Probability of this Deviation from r hat Squared deviation Sq Dev * Prob. company's products demand occurring Strong 0.3 85% 72.25% 21.68% Normal 0.4 0% 0.00% 0.00% Weak 0.3 -85% 72.25% 21.68% Sum: 43.35% Std. Dev. = Square root of sum 65.84% Sq. root can be 65.84% found in two ways Chapter 5. Tool Kit for Risk and Return Sale.com Basic Foods The relationship between risk and return is a fundamental axiom in finance. Generally speaking, it is totally logical to assume that investors are only willing to assume additional risk if they are adequately compensated with additional return. This idea is rather fundamental, but the difficulty in finance arises from interpreting the exact nature of this relationship (accepting that risk aversion differs from investor to investor). Risk and return interact to determine security prices, hence its paramount importance in finance. To calculate the standard deviation, there are a few steps. First find the differences of all the possible returns from the expected return. Second, square that difference. Third, multiply the squared number by the probability of its occurrence. Fourth, find the sum of all the weighted squares. And lastly, take the square root of that number. Let us apply this procedure to find the standard deviation 'of Sale.com's returns. Rate of Return on stock if this demand occurs Sale.comProbability of this demand occurring Strong 0.3 25% 6.25% 1.88% Normal 0.4 0% 0.00% 0.00% Weak 0.3 -25% 6.25% 1.88% 3.75% Std. Dev. = Square root of sum 19.36% Sq. root can be 19.36% found in two ways MEASURING STAND-ALONE RISK: THE COEFFICIENT OF VARIATION The coefficient of variation indicates the risk per unit of return, and is calculated by dividing the standard deviation by the expected return. Std. Dev. Expected return CV Sale.com 65.84% 15% 4.39 Basic Foods 19.36% 15% 1.29 PORTFOLIO RETURNS The expected return on a portfolio is simply a weighted average of the expected returns of the individual assets in the portfolio. Consider the following portfolio. Stock Portfolio weight Expected Return Microsoft 0.25 12.0% General Electric 0.25 11.5% Pfizer 0.25 10.0% Coca-Cola 0.25 9.5% Portfolio's Expected Return 10.75% PORTFOLIO RISK Portfolio WM Year Stock W returns Stock M returns (Equally weighted avg.) 2001 40% -10% 15% 2002 -10% 40% 15% 2003 35% -5% 15% 2004 -5% 35% 15% 2005 15% 15% 15% Average return 15% 15% 15% Standard deviation 22.64% 22.64% 0.00% Correlation Coefficient -1.00 Perfect Negative Correlation. The standard deviation of a portfolio is generally not a weighted average of individual standard deviations--usually, it is much lower than the weighted average. The portfolio's SD is a weighted average only if all the securities in it are perfectly positively correlated, which is almost never the case. In the equally rare case where the stocks in a portfolio are perfectly negatively correlated, we can create a portfolio with absolutely no risk. Such is the case for the next example of Portfolio WM, a portfolio composed equally of Stocks W and M. These two stocks are perfectly negatively correlated--when one goes up, the other goes down by the same amount. We could use Excel's correlation function to find the correlation, but when exact positive or negative correlation occurs, an error message is given. We demonstrate correlation in a later section. Basic FoodsPerfect Positive Correlation. Now suppose the stocks were perfectly positively correlated, as in the following example: Year Stock M returns Stock M' returns Portfolio MM' 2001 -10% -10% -10% 2002 40% 40% 40% 2003 -5% -5% -5% 2004 35% 35% 35% 2005 15% 15% 15% Average return 15% 15% 15% Standard deviation 22.64% 22.64% 22.64% Correlation Coefficient 1.00 With perfect positive correlation, the portfolio is exactly as risky as the individual stocks. Partial Correlation. Now suppose the stocks are positively but not perfectly so, with the following returns. What is the portfolio's expected return, standard deviation, and correlation coefficient? Year Stock W returns Stock Y returns Portfolio WY 2001 40% 28% 34% 2002 -10% 20% 5% 2003 35% 41% 38% 2004 -5% -17% -11% 2005 15% 3% 9% Average return 15% 15% 15% Standard deviation 22.64% 22.57% 20.63% Correlation coefficient 0.67 Here the portfolio is less risky than the individual stocks contained in it. THE CONCEPT OF BETA calculate betas below. Beta Graphs We found the correlation coefficient by using Excel's "CORREL" function. Click the wizard, then Statistical, then CORREL, and then use the mouse to select the ranges for stocks W and Y's returns. The correlation here is about what we would expect for two randomly selected stocks. Stocks in the same industry would tend to be more highly correlated than stocks in different industries. The beta coefficient reflects the tendency of a stock to move up and down with the market. An average-risk stock moves equally up and down with the market and has a beta of 1.0. Beta is found by regressing the stock's returns against returns on some market index. It is also useful to show graphs with individual stocks' returns on the vertical axis and market returns on the horizontal axis. The slopes of the lines represent the stocks betas. We show a graph of the illustrative stocks in the screen to the right, and we use Year rM rL rA rH 2001 10% 10% 10% 10% 2002 20% 15% 20% 30% 2003 -10% 0% -10% -30% Note: When you get the menu box on the screen, and the cursor blinking in the Y Range slot, use the mouse to select the Y range, and then click on the X range box. Then fill in the X range the same way. Returns on The Market and on Stocks L (for Low), A (for Average), and H (for High) Regression analysis is performed by following the command path: Tools => Data Analysis => Regression. This will yield the Regression input box. If Data Analysis is not an option in your Tools menu, you will have to load that program. Click on the Add-Ins option in the Tools menu. When the Add-Ins box appears, click on Analysis ToolPak and a check mark will appear next to the Analysis ToolPak. Then, click OK and you will now be able to access Data Analysis. From this point, you must designate the Y input range (stock returns) and the X input range (market returns). You can have the summary output placed in a new worksheet, or you can have it shown directly in the worksheet, as we did here. The Regression dialog box for the regression of Stock H is as follows:Regression Output of Stock H Returns SUMMARY OUTPUT Regression Statistics Beta Coefficient for Stock H = 2.00 Multiple R 1 R Square 1 Adjusted R Square 1 Standard Error 1.38778E-17 Observations 3 ANOVA df SS MS F Significance F Regression 1 0.186666667 0.186666667 9.69229E+32 2.04488E-17 Residual 1 1.92593E-34 1.92593E-34 Total 2 0.186666667 Coefficients Standard Error t Stat P-value Lower 95% Intercept -0.1 9.08514E-18 -1.1007E+16 5.78378E-17 -0.1 X Variable 1 2.00 6.42417E-17 3.11324E+16 2.04488E-17 2 Regression Output of Stock A Returns SUMMARY OUTPUT Beta Coefficient for Stock A is 1 Regression Statistics Multiple R 1 R Square 1 Adjusted R Square 1 Standard Error 0 Observations 3 ANOVA df SS MS F Significance F Regression 1 0.046666667 0.046666667 #NUM! #NUM! Residual 1 0 0 Total 2 0.046666667 Coefficients Standard Error t Stat P-value Lower 95% Intercept 0 0 65535 #NUM! 0 X Variable 1 1.00 0 65535 #NUM! 1Regression Output of Stock L Returns SUMMARY OUTPUT The beta coefficient for Stock L is .5 Regression Statistics Multiple R 1 R Square 1 Adjusted R Square 1 Standard Error 2.08167E-17 Observations 3 ANOVA df SS MS F Significance F Regression 1 0.011666667 0.011666667 2.6923E+31 1.22693E-16 Residual 1 4.33334E-34 4.33334E-34 Total 2 0.011666667 Coefficients Standard Error t Stat P-value Lower 95% Intercept 0.05 1.36277E-17 3.66899E+15 1.73513E-16 0.05 X Variable 1 0.5 9.63625E-17 5.18874E+15 1.22693E-16 0.5 CALCULATING THE BETA COEFFICIENT FOR AN ACTUAL COMPANY Now we show how to calculate beta for an actual company, General Electric. Step 1. Acquire Data Step 2. Calculate Returns Now go to the bottom of the data, row 317. Date Market Level (S&P 500 Index) Market Return GE Adjusted Stock Price GE Return April 2004 1,128.17 0.2% 30.48 -0.1% March 2004 1,126.21 -1.6% 30.52 -6.2% February 2004 1,144.94 1.2% 32.52 -2.7% January 2004 1,131.13 1.7% 33.43 8.6% December 2003 1,111.92 5.1% 30.79 8.8% November 2003 1,058.20 0.7% 28.31 -1.2% October 2003 1,050.71 5.5% 28.65 -2.7% September 2003 995.97 -1.2% 29.44 1.4% August 2003 1,008.01 1.8% 29.02 4.0% July 2003 990.31 1.6% 27.91 -0.9% June 2003 974.50 1.1% 28.15 0.6% May 2003 963.59 5.1% 27.98 -2.5% April 2003 916.92 8.1% 28.71 15.5% March 2003 848.18 0.8% 24.86 6.0% February 2003 841.15 -1.7% 23.45 4.8% January 2003 855.70 -2.7% 22.38 -5.0% December 2002 879.82 -6.0% 23.55 -9.6% We downloaded stock prices and dividends from http://finance.yahoo.com for General Electric, using its ticker symbol GE. We also downloaded data for the S&P 500 Index (^SPX), which contains 500 actively traded large stocks. For example, to download the GE data, enter its ticker symbol and click Go. then select Historical Prices from the left side of the page. After the daily prices come up, get monthly prices by entering the start date and the end date. Yahoo provides monthly prices as of the first trading day of the month. Note that these prices are "adjusted" to reflect any dividends or stock splits. Download the data by right-clicking below the data where its has "Dowload to Spreadsheet". We used the percentage change in adjusted prices (which already reflect dividends) for GE to calculate returns. We used the percentage change for the S&P 500 Index as the market return.November 2002 936.31 5.7% 26.04 7.4% October 2002 885.76 8.6% 24.24 2.5% September 2002 815.28 -11.0% 23.66 -17.7% August 2002 916.07 0.5% 28.74 -6.4% July 2002 911.62 -7.9% 30.70 10.9% June 2002 989.82 -7.2% 27.69 -6.1% May 2002 1,067.14 -0.9% 29.50 -1.3% April 2002 1,076.92 -6.1% 29.89 -15.6% March 2002 1,147.39 3.7% 35.43 -2.9% February 2002 1,106.73 -2.1% 36.47 4.1% January 2002 1,130.20 -1.6% 35.03 -7.3% December 2001 1,148.08 0.8% 37.80 4.6% November 2001 1,139.45 7.5% 36.14 5.7% October 2001 1,059.78 1.8% 34.18 -2.1% September 2001 1,040.94 -8.2% 34.92 -8.6% August 2001 1,133.58 -6.4% 38.22 -6.0% July 2001 1,211.23 -1.1% 40.65 -11.0% June 2001 1,224.38 -2.5% 45.65 0.0% May 2001 1,255.82 0.5% 45.65 1.0% April 2001 1,249.46 7.7% 45.21 15.9% March 2001 1,160.33 -6.4% 39.00 -9.6% February 2001 1,239.94 -9.2% 43.16 1.1% January 2001 1,366.01 3.5% 42.68 -4.1% December 2000 1,320.28 0.4% 44.50 -2.9% November 2000 1,314.95 -8.0% 45.85 -9.6% October 2000 1,429.40 -0.5% 50.71 -5.2% September 2000 1,436.51 -5.3% 53.49 -1.2% August 2000 1,517.68 6.1% 54.12 13.4% July 2000 1,430.83 -1.6% 47.71 -2.2% June 2000 1,454.60 2.4% 48.79 0.7% May 2000 1,420.60 -2.2% 48.45 0.4% April 2000 1,452.43 NA 48.26 NA -4.9% -8.3% 16.9% 25.2% Correlation between GE and the market. 61.0% Beta (using the SLOPE function) 0.908 Step 3. Examine the Data Step 4. Plot the Data and Calculate Beta Step 4. Interpret the Results The beta coefficient is about 0.91, as shown by the slope of the coefficient in the regression equation on the chart. The R2 indicates that about 37% of the variance in the stock return can be explained by the market. The rest of the stock's variance is due to factors other than the market. If we had done this regression for a portfolio of 50 well diversified stocks, we would have gotten an R2 of over 0.9. Using the AVERAGE function and the STDEV function, we found the average historical return and standard deviation for GE and the market. (We converted these from monthly figures to annual figures. Notice that you must multiply the monthly standard deviation by the square root of 12, and not 12, to convert it to an annual basis.) These are shown in the rows above. Notice that GE has a standard deviation about 1.5 times that of the market. We also used the CORREL function to find the correlation between GE and the market. Using the Chart Wizard, we plotted the GE returns on the y-axis and the market returns on the x-axis. We also used the menu Chart > Options to add a trend line, and to display the regression equation and R2 on the chart. The chart is shown below. THE SECURITY MARKET LINE The Security Market Line shows the relationship between a stock's beta and its expected return. Risk-free rate (Varies over time) 6% Market return (Also varies over time) 11% Required Return for a stock with beta = 0.50 8.5% Beta (Varies by company) 0.5 With the above data, we can generate a Security Market Line that will be flexible enough to allow for changes in any of the input factors. We generate a table of values for beta and expected returns, and then plot the graph as a scatter diagram. Required Return Beta 8.5% 0.00 6.0% 0.50 8.5% 1.00 11.0% 1.50 13.5% 2.00 16.0% rj = -0.0032 + 0.9084 rM R2 = 0.3725 -20% -10% 0% 10% 20% -30% -20% -10% 0% 10% 20% 30% Historic Realized Returns on the Market, rM (%) Historic Realized Returns on GE, rj(%)We will look at two potential conditions as shown in the following columns: OR Scenario 1. Inflation Increases: Scenario 2. Investors become more risk averse: Risk-free Rate 6% Risk-free Rate 6% Change in inflation 2% Old Market Return 11% Old Market Return 11% Increase in MRP 2.5% New Market Return 13% New Market Return 13.5% Beta 0.50 Beta 0.50 Required Return 10.5% Required Return 9.75% The Security Market Line shows the projected changes in expected return, due to changes in the beta coefficient. However, we can also look at the potential changes in the required return due to variation of other factors, namely the market return and risk-free rate. In other words, we can see how required returns can be influenced by changing inflation and risk aversion. The level of investor risk aversion is measured by the market risk premium (rM-rRF), which is also the slope of the SML. Hence, an increase in the market return results in an increase in the maturity risk premium, other things held constant. Security Market Line 0% 6% 12% 18%0.00 0.50 1.00 1.50 2.00 2.50 Beta Required ReturnNow, we can see how these two factors can affect a Security Market Line, by creating a data table for the required return with different beta coefficients. Beta Original Situation New Scenario 1 New Scenario 2 8.5% 10.5% 9.75% 0.00 6.00% 8.00% 6.00% 0.50 8.50% 10.50% 9.75% 1.00 11.00% 13.00% 13.50% 1.50 13.50% 15.50% 17.25% 2.00 16.00% 18.00% 21.00% The graph shows that as risk as measured by beta increases, so does the required rate of return on securities. However, the required return for any given beta varies depending on the position and slope of the SML. Required Return The SML Under Different Conditions 0% 5% 10% 15% 20% 25%0.00 0.50 1.00 1.50 2.00 Beta Required Returns Original Scenario #1 Scenario #2