1. Catalog
  2. Finance
  3. Financial Markets
  4. Beta Calculation Worksheet
Beta Calculation Worksheet
  • Beta Calculation Worksheet
  • Beta Calculation Worksheet
Originally published: 02/08/2016 09:01
Publication number: ELQ-26168-1
View all versions & Certificate
certified

Beta Calculation Worksheet

Compute the Beta needed for your CAPM as to calculate the expected return of a company's share

Dheeraj Vaidya CFA FRMby Dheeraj Vaidya CFA FRM
Co-founder & CEO @ eduCBA & founder of WallStreetMojoFollow 192
13 reviews1,431 views|Start the discussion!|Bookmark download for free
financebetacapmcapital asset pricing modelregression analysisslope methodvariancecovariance formula
Description
Step by Step Excel Template to calculate the CAPM Beta (Capital Asset Pricing Model) of MakeMyTrip. You can use this template to find Beta for other companies as well.

What is a CAPM Beta?

"Beta is a measure of the volatility, or systematic risk, of a security or a portfolio in comparison to the market as a whole. Beta is used in the capital asset pricing model (CAPM), a model that calculates the expected return of an asset based on its beta and expected market returns." (Investopedia)

This Best Practice includes
1 Excel Model

Dheeraj Vaidya CFA FRM offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss


4.5 / 5 (13 votes)

please wait...