- Last Updated: Wednesday, 06 September 2017 19:35

Perhaps the single most important measure of stock risk or volatility is a stock's beta. It's one of those at-a-glance measures that can provide serious stock analysts with insights into the movements of a particular stock relative to the overall market.

In this article, we're going to first attempt to define the concept of beta values, including some of the theory upon which it's based. Next, we're going to talk about the pros and cons of the measure, while providing insights into the correct use of beta values when analyzing a stock. Finally, we're going to finish up with a practical explanation of how to calculate beta, as well as a link to a spreadsheet that can be used to calculate these values.

Additional Resources |

The concept of beta is fairly simple; it's a measure of individual stock risk relative to the overall risk of the stock market. It's sometimes referred to as financial elasticity. The measure is just one of several values that stock analysts use to get a better feel for a stock's risk profile. As we'll see later on in our discussion, the beta value is calculated using price movements of the stock we're analyzing. Those movements are then compared to the movements of an overall market indicator, such as a market index, over the same period of time.

Beta values are fairly easy to interpret too. If the stock's price experiences movements that are greater - more volatile - than the stock market, then the beta value will be greater than 1. If a stock's price movements, or swings, are less than those of the market, then the beta value will be less than 1.

Since increased volatility of stock price means more risk to the investor, it's reasonable to expect greater returns from stocks with betas over 1. The reverse is true if a stock's beta is less than 1; expect less volatility, lower risk, and therefore lower overall returns.

During our discussions of calculating stock prices, and our follow up discussion of the capital asset pricing model, or CAPM, we explained how to calculate the expected return on an investment by examining risk-free investments, expectations of the stock market, and stock betas.

For example, by using the following CAPM formula we can calculate the expected rate of return on an investment as:

Expected Rate of Return = r = rf + B (rm - rf)

Where:

- rf = The risk-free interest rate is the interest rate the investor would expect to receive from a risk-free investment. Typically, U.S. Treasury Bills are used for U.S. dollars and German Government bills are used for the Euro.
- B = A stock beta is used to mathematically describe the relationship between the movements of an individual stock versus the market itself. Investors can use a stock's beta to measure the risk of a security versus the market.
- rm = The expected market return is the return the investor would expect to receive from a broad stock market indicator such as the S&P 500. For example, over the last 17 years or so, the S&P 500 has yielded investors an average annual return of around 8.10%.

Translating this CAPM formula into words:

*"The expected return on an investment is equal to the return on a risk-free investment plus the risk premium that's associated with the stock market itself, adjusted for the relative risk of the common stock chosen."*

Stock beta values are a key element when using the CAPM. Our online CAPM calculator allows the user to work through some examples to see how this theory works in practice.

In the next two sections, we're going to discuss the advantages and disadvantages of beta values. The outcome of this discussion should be an overall understanding of how to use this measure in practice. For example, the analyst may want to look at a stock's beta before making a purchase decision. That's an important step to take as part of any robust stock research effort.

The calculation of beta is based on extremely sound finance theory. The CAPM theory is excellent when it comes to pricing stocks, and is far easier to put into practice when compared to the Arbitrage Pricing Theory, or APT. Beta allows the investor to understand if the price of that security has been more or less volatile than the market itself, which is certainly a good variable to understand before adding any security to a portfolio.

Once we understand the theory behind beta, then it's easy to understand how emerging technology stocks typically have values greater than 1, while 100 year-old utility stocks typically have values less than 1. In fact, in July 2017 Microsoft had a beta of 1.00 while Public Service Enterprise Group had a value of 0.38. (It's nice when theory seems to work in the real world.)

We're an advocate of value investing, which includes conducting stock research that focuses on a company's fundamentals, and an understanding of financial ratios before investing in a stock. Unfortunately, when calculating any values using price movements over the past three years, it's important to remember the "past performance is no guarantee of future returns" rule applies to beta too.

Beta is calculated based on historical price movements, which may have little to do with how a company's stock is poised to move in the future. Because the measure relies on historical prices, it's not even possible to accurately calculate this measure for newly issued stocks.

The measure also doesn't tell us if the stock's movements were more volatile during bear or bull markets. It doesn't distinguish between large upswing or downswing movements. So while beta can tell the analyst something about the past risk of a security, it tells them very little about the attractiveness or the value of the investment today or in the future.

It's possible to find calculated beta values on all of the major stock reporting websites, including Yahoo Finance, MSN Money, and Google Finance. It's also possible to calculate beta using a fairly straightforward linear regression technique that's available in a spreadsheet application such as Microsoft's Excel or OpenOffice's Calc.

In fact, to calculate a stock's beta only two sets of data are needed:

- Closing stock prices for the stock being examined.
- Closing prices for the index being chosen as a proxy for the stock market.

Most of the time, values are calculated using the month-end stock price for the security, and the month end closing price of the S&P 500 Index ($INX). The formula for this metric can be written as:

Beta = Covariance (stock versus market returns) / Variance of the Stock Market

It's possible to see this calculation at work in our Stock Beta Calculation Spreadsheet. That workbook contains a table that can be used to calculate the value of beta in addition to two charts: one for the market index and a second called the Security Characteristic Line (SCL), which applies to the stock being analyzed.

Finally, our spreadsheet includes a calculation of alpha values, which is a measure of excess returns on an investment, adjusted for risk. It's commonly used to assess the performance of a portfolio manager (such as the case with a mutual fund) as it's an indicator of their ability to provide returns in excess of a benchmark such as the S&P 500 Index.

For example:

- If alpha < risk-free investment return, then the fund manager has destroyed value;
- If alpha = risk-free investment return, then the fund manager has neither created nor destroyed value; and
- If alpha > risk-free investment return, then the fund manager has created value.

About the Author - *Stock Beta and Volatility*