Article byWallstreetmojo Team
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

CAPM Beta is a theoretical measure of the way how a single stock moves with respect to the market, by taking correlation between the both; market represents the unsystematic risk and beta represents the systematic risk.

CAPM Beta When we invest in stock markets, how do we know that stock A is less risky than stock B. Differences can arise due to market capitalizationMarket CapitalizationMarket capitalization is the market value of a company’s outstanding shares. It is computed as the product of the total number of outstanding shares and the price of each more, revenue size, sector, growth, management, etc. Can we find a single measure that tells us which stock is riskier? The answer is YES, and we call this as CAPM Beta or Capital Asset Pricing Model Beta.

In this article, we look at the nuts and bolts of CAPM Beta –

What is the CAPM Beta?

Beta is a very important measure that is used as a key input for Discounted Cash Flow or DCF valuationsDCF ValuationsDiscounted cash flow analysis is a method of analyzing the present value of a company, investment, or cash flow by adjusting future cash flows to the time value of money. This analysis assesses the present fair value of assets, projects, or companies by taking into account many factors such as inflation, risk, and cost of capital, as well as analyzing the company's future more.

You can download this CAPM Beta Calculation Excel Template here – CAPM Beta Calculation Excel Template

Key Takeaways

  • CAPM Beta is a concept used to gauge how a specific stock moves in relation to the overall market, achieved by assessing its correlation. While the market addresses unsystematic risk, Beta quantifies systematic risk.
  • Stock risks are categorized into two types: non-systematic and systematic. Non-systematic risks can be mitigated through diversification, whereas systematic risks influence the entire market and remain unavoidable. BETA is a vital metric for measuring systematic risk.
  • Investments in gold and international companies might exhibit a negative beta due to their inverse correlation with the stock market and their limited direct ties to the domestic economy.

CAPM Beta Formula

If you have a slightest of the hint regarding DCF, then you would have heard about the Capital Asset Pricing Model (CAPMCAPMThe Capital Asset Pricing Model (CAPM) defines the expected return from a portfolio of various securities with varying degrees of risk. It also considers the volatility of a particular security in relation to the more) that calculates the Cost of EquityCost Of EquityCost of equity is the percentage of returns payable by the company to its equity shareholders on their holdings. It is a parameter for the investors to decide whether an investment is rewarding or not; else, they may shift to other opportunities with higher more as per the below Beta formula.

Cost of Equity = Risk Free Rate + Beta x Risk Premium

You are free to use this image on your website, templates, etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: CAPM Beta (

If you have not heard of Beta yet, then worry not. This article explains to you about Beta in the most basic way.

Let us take an example: when we invest in stocks, it is but human to pick stocks that have the highest possible returns. However, if one chases only returns, the other corresponding element is missed, i.e., Risk.

Actually, every stock is exposed to two types of risks.

Financial Modeling & Valuation Courses Bundle (25+ Hours Video Series)

–>> If you want to learn Financial Modeling & Valuation professionally , then do check this ​Financial Modeling & Valuation Course Bundle​ (25+ hours of video tutorials with step by step McDonald’s Financial Model). Unlock the art of financial modeling and valuation with a comprehensive course covering McDonald’s forecast methodologies, advanced valuation techniques, and financial statements.

What is Beta?

Basic Definition of Beta – Beta measures the stock risks in relation to the overall market.

Beta Values

You are free to use this image on your website, templates, etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: CAPM Beta (

In general, large companies with more predictable Financial StatementsFinancial StatementsFinancial statements are written reports prepared by a company's management to present the company's financial affairs over a given period (quarter, six monthly or yearly). These statements, which include the Balance Sheet, Income Statement, Cash Flows, and Shareholders Equity Statement, must be prepared in accordance with prescribed and standardized accounting standards to ensure uniformity in reporting at all more and profitability will have a lower beta value. For example, Energy, Utilities, and Banks, etc., all tend to have a lower beta. Most betas normally fall between 0.1 and 2.0 though negative and higher numbers are possible.

Key Determinants of Beta

Now that we understood Beta as a measure of Risk, it is important for us to also understand the sources of risks. Beta depends on a lot of factors – usually, the nature of the business, operating and financial leverages, etc.

The below diagram shows the key determinants of Beta –

Beta Determinants

You are free to use this image on your website, templates, etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: CAPM Beta (

High Beta Stocks/Sectors

Due to the uncertain economic environment, questions always remain on what is the best investment strategyInvestment StrategyInvestment strategies assist investors in determining where and how to invest based on their expected return, risk appetite, corpus amount, holding period, retirement age, industry of choice, and so more. Should I pick high CAPM Beta stocks or Low CAPM Beta Stocks? It is normally understood that cyclical stocks have high Beta and defensive sectors have low Beta.

Cyclical stocks are those whose business performance and stock performance is highly correlated with economic activities. If the economy is in recession, then these stocks exhibit poor results, and thereby stock performance takes a beating. Likewise, if the economy is on a high growth trajectory, cyclical stocksCyclical StocksA cyclical stock refers to that share whose price fluctuates with the change in overall macroeconomic conditions. Such a stock is sensitive to the various economic phases like recession, boom, expansion, contraction, trough, peak and more tend to be highly correlated and demonstrate a high growth rate in business and stock performances.

Take, for example, General Motors; its CAPM Beta is 1.43. This implies if the stock market moves up by 5%, then General Motors stock will move up by 5 x 1.43 = 7.15%.

The following sectors can be classified as cyclical sectors and tend to exhibit High Stock Betas.

  • Automobiles Sector
  • Materials Sector
  • Information Technology Sector
  • Consumer Discretionary Sector
  • Industrial Sector
  • Banking Sector

Low Beta Stocks/Sectors

Low Beta is demonstrated by stocks in the defensive sector. Defensive stocksDefensive StocksA Defensive Stock is a stock that provides steady growth and earnings to the investors in the form of dividends irrespective of the state of the economy as it has a low correlation with the overall stock market/economy and is therefore insulated from changing business more are stocks whose business activities and stock prices are not correlated with economic activities. Even if the economy is in recession, these stocks tend to show stable revenues and stock prices.  For example, PepsiCo, its stock beta is 0.78. If the stock market moves down by 5%, then Pepsico stock will only move down by 0.78×5 = 3.9%.

The following sectors can be classified as defensive sectors and tend to exhibit Low Stock Betas-

  • Consumer Staples
  • Beverages
  • HealthCare
  • Telecom
  • Utilities

CAPM Beta Calculation in Excel

Technically speaking, Beta is a measure of stock price variability in relation to the overall stock market (NYSE, NASDAQ, etc.). Beta is calculated by regressing the percentage change in stock prices versus the percentage change in the overall stock market. CAPM Beta calculation can be done very easily on excel.

Let us calculate the Beta of MakeMyTrip (MMTY) and Market Index as NASDAQ.

Step 1 – Download the Stock Prices & Index Data for the past 3 years. 

The first step is to download the stock price and Index data. For NASDAQ, download the dataset from Yahoo Finance.

NASDAQ Historical Prices Download

Likewise, download the corresponding stock price data for the MakeMyTrip example from here.

Step 2 – Sort the Dates & Adjusted Closing Prices

Once you have downloaded the data set for the two, please do the following for each of the data set-

  • Sort the dates and Adjusted Closing prices in ascending order
  • Delete Open, High, Low, Close & Volume Column. They are not required for Beta Calculations. 
Beta Calculation - Step 2
Step 3 – Prepare a single sheet of Stock Prices Data & Index Data.
Beta Calculation - Step 3
Step 4 – Calculate the Fractional Daily Return
Beta Calculation - Step 4
Step 5 – Calculate Beta – Three Methods

You can use either of the three methods to calculate Beta – 1) Variance/Covariance Method 2) SLOPE Function in excelSLOPE Function In ExcelThe Slope function returns the slope of a regression line based on the data points recognized by known _y values and known _x more 3) Data Regression

  • Variance / Covariance Method 
Beta Calculation using Variance Covariance

Using the variance-covariance method, we get the Beta as 0.9859 (Beta Coefficient)

  • SLOPE function in excel 
Beta Calculation using SLOPE Method

Using this SLOPE function method, we again get the Beta as 0.9859 (Beta Coefficient)

  • 3rd Method – Using Data Regression

For using this function in excel, you need to go to the Data Tab and select Data Analysis.Data Analysis

If you are unable to locate Data Analysis in Excel, then you need to install the Analysis ToolPak. This process is relatively easy: Go to FILE -> Options -> Add-Ins -> Analysis ToolPakAnalysis ToolPakExcel's data analysis toolpak can be used by users to perform data analysis and other important calculations. It can be manually enabled from the addins section of the files tab by clicking on manage addins, and then checking analysis more -> Go -> Check Analysis ToolPak -> OK

Select Data Analysis and click on Regression.Data Analysis - Regression

Choose the Y Input Range and X Input Range

Regression Range

Once you click OK, you get the following Summary Output

Regression Output

As noted above, you get the same answer of Beta (Beta Coefficient) in each of the methods. 

Also, note that MakeMyTrip beta is approximately closer to 1.0, this implies that MakeMyTrip stock prices have the same level of risk as to the broad NASDAQ Index.

Levered vs. Unlevered Beta

Levered Beta or Equity BetaEquity BetaEquity Beta measures the volatility of the stock to the market, i.e., how sensitive is the stock price to a change in the overall market. It compares the volatility associated with the change in prices of a security. Equity Beta is commonly referred to as levered beta, i.e., a firm's beta, which has financial more is the Beta that contains the effect of capital structure, i.e., Debt and Equity both. The beta that we calculated above is the Levered Beta.

Unlevered Beta is the Beta after removing the effects of the capital structure. As seen above, once we remove the financial leverage effect, we will be able to calculate Unlevered BetaCalculate Unlevered BetaUnlevered beta is a measure to calculate the company's volatility without debt concerning the overall market. In simple words, it is calculating the company's beta without considering the effect of debt. Unlevered beta is also known as asset beta because the firm's risk without debt is calculated just based on its more.

Unlevered Beta can be calculated using the following formula –

       Beta (Unlevered) = Beta (levered)/ (1+ (1-tax) * (Debt/Equity))

As an example, let us find out the Unlevered Beta for MakeMyTrip.

Debt to Equity RatioDebt To Equity RatioThe debt to equity ratio is a representation of the company's capital structure that determines the proportion of external liabilities to the shareholders' equity. It helps the investors determine the organization's leverage position and risk level. read more (MakeMyTrip) = 0.27

Tax Rate = 30% (assumed)

Beta (levered) = 0.9859 (from above)

       Beta (Unlevered) = 0.9859 / (1+ (1-30) * 0.27)

       Beta (Unlevered) = 0.8291

Calculate Beta of an Unlisted or Private Company

As seen earlier, Beta is a statistical measure of the variability of a company’s stock price in relation to the stock market overall. However, when we evaluate private companiesPrivate CompaniesA privately held company refers to the separate legal entity registered with SEC having a limited number of outstanding share capital and shareowners. read more (not listed), then how we should find Beta? In this case, Beta does not exist; however, we can find an IMPLIED BETA from the comparable companies analysisComparable Companies AnalysisComparable comps are nothing but identifying relative valuations like an expert to find the firm's fair value. The comparable comp process starts with identifying the comparable companies, then selecting the right valuation tools, and finally preparing a table that can provide easy inferences about the fair valuation of the industry and the more.

Implied Beta is found using the following 3 step process –

Step 1 – Find all the Listed Comparables whose Beta’s are readily available.

Please note that the Betas that you download are Levered BetasLevered BetasLevered beta measures the systematic risk of a stock that includes risk due to macroeconomic events like war, political events, recession, etc. Systematic risk is inherent to the entire market and is also known as undiversifiable more, and hence, it is important to remove the effect of capital structure. The higher amount of debt implies higher variability in earnings (Financial LeverageFinancial LeverageFinancial Leverage Ratio measures the impact of debt on the Company’s overall profitability. Moreover, high & low ratio implies high & low fixed business investment cost, respectively. read more), which in turn results in higher sensitivity to the stock prices.

Let us assume here that we want to find the Beta of a private company, let’s call this as PRIVATE. As a first step, we find all the listed peers and identify their Betas (levered)

Private Company Beta Competitors
Step 2 – Unlever the Betas 

We will use the formula discussed above to Unlever the Beta.

               Beta (Unlevered) = Beta (levered)/ (1+ (1-tax) * (Debt/Equity))

Please note that for each of the competitors, you will have to find additional information like Debt to Equity and Tax Rates. While unlevering, we will be able to remove the effect of financial leverage.

Private Company Beta Competitors - Unlevered
Step 3: Relever the Beta

We then relever the beta at an optimal capital structure of the PRIVATE company as defined by industry parameters or management expectations. In this case, ABC company is assumed to have a Debt/Equity of 0.25x and a Tax Rate of 30%.

The calculation for the relevered beta is as follows:

Relevered Beta

It is this relevered Beta that is used for calculating the Cost of EquityCalculating The Cost Of EquityCost of Equity (Ke) is what shareholders expect for investing their equity into the firm. Cost of equity = Risk free rate of return + Beta * (market rate of return - risk free rate of return). read more of the Private companies.

What Does a Negative Beta Mean?

Though in the above cases, we saw that Beta was greater than zero; however, there may be stocks that have negative betas. Theoretically, the negative beta would mean that the stock moves in the opposite direction of the overall stock market. Though these stocks are rate, they do exist. Many companies that are into gold investing can have negative betas because gold and stock markets move in the opposite direction. International companies may also have negative beta as their business may not be directly linked to the domestic economy.

If you are curious to see some examples of Negative Beta Stocks, here is the process through which you can hunt for negative beta stocks.

Step 1 – Visit Yahoo Screener
Yahoo Screener
Step 2 – Choose the Industry Filter

You may choose the sector/industry of your choice. I have picked up Gold (Basic Materials)

Yahoo Screener - Gold
Step 3 – Choose the Beta Values Minimum and Maximum
Yahoo Screener - Choose Beta values
Step 4 – Click on Find Stocks, and you will see the list below
Gold Beta List
Step 5 – Sort the Beta column from Low to High
Negative Beta List

Step 6 – Enjoy the list of Negative Betas :-)

Advantages of CAPM Beta

Disadvantages of CAPM Beta

  • “Past Performance is no guarantee of future” – This rule also applies on Beta. While we calculate beta, we take into account historical data – 1 year, 2 years or 5 years, etc. Using this historical beta may not hold true in the future.
  • Cannot accurately measure Beta for new Stocks – As we saw from above that we can calculate beta of unlisted or private companies. However, the problem lies in finding the true comparable that can provide us with an implied Beta number. Unfortunately, we do not always have the right comparable for start-ups or private companies.
  • Beta does not tell us whether the stock was more volatile during the bear phase or the bull phase. It does not distinguish between upswings or downswing movements.

CAPM Beta Video

Frequently Asked Questions (FAQs)

1. What is the relevance of CAPM Beta?

CAPM Beta’s relevance lies in its ability to quantify an asset’s systematic risk, indicating how much it tends to move in relation to the overall market. It aids investors in assessing an asset’s sensitivity to market fluctuations, allowing for more informed investment decisions and portfolio diversification strategies.

2. What are the applications of CAPM Beta?

Applications of CAPM Beta include evaluating an asset’s risk and expected return, estimating the cost of equity for valuation purposes, constructing well-balanced portfolios, and comparing assets based on their risk exposure to the market.

3. What are the assumptions of CAPM Beta?

Assumptions of CAPM Beta include efficient markets, where all relevant information is reflected in prices; investors share the same expectations; no transaction costs or taxes; a risk-free asset is available; unlimited borrowing and lending at the risk-free rate; and a single-period investment horizon. Additionally, Beta assumes that asset returns follow a linear relationship with the market and that asset-specific risks are diversifiable, leaving only systematic risk relevant for pricing.

  1. Beta Formula
  2. Stock Beta Meaning
  3. Sum of Parts Valuation

What next?

If you learned something new or enjoyed the post, please leave a comment below. Let me know what you think. Many thanks, and take care. Happy Learning!

Reader Interactions


  1. Lade says

    This is the best material for Financial management.

  2. RR says

    Thanks, well explained and written making it interesting to read

  3. Courage Hodey says

    I have enjoyed every bit of the lesson here.
    This is very insightful and beginners can rely heavily on the lessons for a full grasp of the concept.

  4. Meharsh Bajaj says


  5. Rupali Joshi says

    Amazing artical, all the related points which one can think of beta are just clearly explained.

    much helpful.

  6. Silky Kushwah says

    quite interesting!

    Enjoyed reading..


    • Dheeraj Vaidya says

      Thanks for your kind words!

  7. Hannan says

    Great article. It helped me calculate WACC for the private company I work for.

  8. Thuy says

    This is the most amazing blog I have ever seen. Thank you so much for your sharing since your sharing is so informative and is written in the order that really easy to follow.

    • Dheeraj Vaidya says

      Thanks for your kind words!

  9. vero says


  10. Kenei says

    You are a rockstar! Thank for sharing.

  11. Kenei says

    You are a rockstar! Thanks for sharing.

  12. Vijay kumar pathak says

    You are really doing a very amazing work by publishing and sharing such a informative articles..I always eagerly wait for your every next article..
    Thank you..

  13. Francisco Coca says

    Thanks for your help!!!

  14. Charles says

    Thanks a lot colleagues

  15. Kirandeep Kaur says

    This is by far the best post of explaining “Beta” in so much detail and that too with easy examples. Always enjoy learning here!

  16. Andrew says

    Excellent article, as usual!

  17. Navraj says

    Its very helpful !!

    Thanks for the knowledge sharing …

  18. Prithvi says

    Very informative, thank you very much for the explanation.

    • Dheeraj Vaidya says

      thanks Prithvi!

  19. Jamie says

    Clear and concise explanation of Beta. Thank you :)

  20. VENKATESH says

    well explained in simple steps. very informative.

      • Issifu says

        Clarity is your trump card. You have helped me greatly.
        Thank you.

  21. S.Shankar says

    it is great article I understood concept of levering and unlevering Beta easily. Thanks

  22. Mahmoud says

    many thanks! you make it very clear

    • Dheeraj Vaidya says

      My Pleasure Mahmoud!

  23. Sachin Gupta says

    Hi Dheeraj,

    This article is very helpful and the most amazing thing is the way of describing the concept of beta.

    Thnks a lot

  24. Akanksha Agrawal says

    Thanks Dheeraj Sir.Your way of explanation is Awesome.
    Helped me alot thanks very much.

  25. Jithin says

    Thank you so much for the article and the worksheet. Helped a lot to understand. Keep on writing.

    • Dheeraj says

      thanks Jithin!

  26. Gabriel says

    Great, very informative.Thank you!

  27. Terry says

    It’s a great essay to understand the Beta. Now I get the approaches to calculate beta from stock market.
    Thank you so much!
    But I have a question about beta:Suppose a statement said a corp. carried $200 million debt and has 15 million shares trading at price of $30 in TSX. It’s stock beta is 0.9. This beta is levered beta or unlevered beta?Thanks!


    • Dheeraj says

      Hi Terry,

      The stock beta that is mentioned in bloomberg and other databases is levered beta (includes the effect of debt). If you want to calculated the unlevered beta from this, then you need to apply the formula to unlever the same.


  28. Ali says

    You are soooooooooo gooood

    • Dheeraj says

      thanks Ali!

  29. MARIA SHUJA says

    thank sir u really make it easy…

    • Dheeraj says

      thanks Maria!

  30. Kola Yaqub says

    Thanks for sharing the wonderful knowledge. It is very informative and explanatory.

    I like appreciate more education on other seemingly confusing areas in finance such as fixed income, derivatives and asset beta.

    Thank you once again

    • Dheeraj says

      Hello Kola,

      Many thanks for your appreciation :-)


  31. Gaurav verma says

    Awesome brother you are doing good work. This article is very very helpful to me and many others.

    • Dheeraj says

      thank you Gaurav!

  32. Herman Tan says

    This is great Dheeraj.
    It is very clear explanation.

    • Dheeraj says

      thank you Herman :-)

  33. Vitali says

    great, Dheeraj

    • Dheeraj says

      Thank you Vitali!

  34. NIrupam Naudiyal says

    HI Dheeraj Sir,

    This is the first finance related blog that i have ever seen in my whole life which describes the complicated things with such an ease and this is really unforgettable. I am very much inspired and impressed by you and would like to work with the same dedication or more to help people in a such a great manner. Please provide your personal mail id or contact no. (if possible)so that i can connect with you and can connect with you.

    Thanks & Regards
    Nirupam Naudiyal

  35. haytham says

    thank you…I owe to you

  36. Berenice says

    Very didatic article. Thanks and congratulations!

    • Dheeraj says

      Thanks Berenice!

  37. vincent says

    I like the way you have explained finance concepts, its clear and enjoyable. Also thanks for sharing your knowledge and some data here :)

  38. Nadine says

    This is comprehensive, simple to understand and awesome! Thanks sooo much!

  39. Huron says

    Very clear explanation. Thanks!

  40. Somsubhra Mukherjee says

    Simple and very welled explained…Can you please upload module on FOREX.

    • Dheeraj says

      Thanks Somsubhra. I am looking forward to an article on Forex in the near future.

  41. msdevi says

    well explained in a simple way.

  42. Manohar says

    You explained in very lucid and simple language . Looking forward for more posts on security valuation.

  43. Ankit says

    Sir, request you to take some important FM concepts on a regular basis like minority interest and adjustments and other such important but often ignored concepts.

  44. Ankit says

    it was a great article in a way that though i learnt beta concepts during my MBA, but it was not this thorough and practical in approach. and yahoo screener was a new thing as well.

  45. sandheep says

    Your articles are always simple and interesting.
    Thank you

  46. AVGRAO says

    Sir,Ur article is excellent. Without abc knowledge in FM, this articles creates LOVE in FM. With regards

    • AVGRAO says

      excellent Sir, with regards

  47. mahendra edunoori says

    its a very important article. and i learned new things with your article. i glad to thanks to you….

  48. Neeraj says

    Your article always have new things for me to learn from

  49. Anika Kalra says

    I thought negative beta stocks are difficult to find. Your article is very comprehensive. Thanks Dheeraj

    • Wall Street Mojo says

      Thanks Anika!

Leave a Reply

Your email address will not be published. Required fields are marked *