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

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...