Beta – Calculation of Beta, Formula of Beta (Complete Details)

Beta Meaning– Beta is a relative measure of volatility that is determined by comparing the return on a share to the return on the stock market. In easy terms, greater the volatility more risky the share and greater the Beta. If a business is impacted by the macroeconomic factors in the same way as the market is, then the business will have a Beta of one and will be expected to have returns equivalent to the marketplace. A business having a Beta of 1.2 implies that if stock market boosts by 10% the company’s share price will increase by 12% (i.e., 10% × 1.2) and if the stock market reduces by 10% the business’s share rate will decrease by 12%.

Beta Formula.png

Beta is a statistical step of volatility and is computed as the Covariance of day-to-day return on stock exchange indices and the return on day-to-day share rates of a particular company divided by the Variation of the return on daily Stock Market indices. While considering market index a broad based index like S & P 500 must be thought about.

For the companies, which are not noted in stock market, beta of the similar market might be thought about after changing it to un-geared beta and then re-gearing it according to the debt equity ratio of the company. The formula for un-gearing and tailoring beta is revealed listed below.

Ungeared Beta = Market Beta/ [1 + (1–Tax Rate) (Industry Debt Equity Ratio)]

Geared Beta = Ungeared Beta/[1 + (1 – tax rate) (Debt Equity Ratio)]

Beta Formula

What is Beta?

Beta is another popular measure of the risk of a stock or a stock portfolio. For StockTrak’s functions, we will only calculate Beta of the stocks (United States and some intl) outdoors positions.

The Beta’s of individual stocks in the portfolio build up according to their weights to develop the portfolio beta.

To calculate beta in Excel:

  • Download historic security rates for the property whose beta you want to determine.
  • Download historical security prices for the contrast benchmark.
  • Compute the percent modification duration to period for both the asset and the criteria. If using everyday information, it’s each day; weekly data, every week, etc.
  • Discover the Variance of the possession utilizing =VAR.S( all the percent modifications of the possession).
  • Discover the Covariance of asset to the standard using =COVARIANCE.S( all the percent changes of the property, all the percent modifications of the criteria).


1 photos of the "Beta – Calculation of Beta, Formula of Beta (Complete Details)"

Beta Formula.png